Database Administrator II

Are you ready to take the next step in your career? Discover why NCDIT is the ideal destination for your professional growth -Why Work for NCDIT.We currently have an opening for a Database Administrator II (Flexible/Hybrid)The position is designated Statutory Exempt and is exempt from the

State Human Resources Act. This position may be eligible for hybrid remote work in accordance with state policy and the agencys remote work program but does require weekly onsite workThe Database Administrator II is responsible for serving as the primary Oracle and SQL Server Enterprise DBA.  This is a critical role within the Applications and Database Development group and is responsible for maintaining the integrity, design, and security of multiple databases serving data to DEQ applications.

 This role is also critical in the transition to cloud technologies, and the agencys digital transformation efforts. Duties include, but are not limited, to:Serves as the primary lesion to the Central DIT Database team and partners closely with this group in the overall administration of Oracle and SQL Server Databases instances.  This includes ongoing and planned upgrades, patches, and migrations, in addition to ensuring secure access to the databases.

 Coordinate the setting up of new databases and maintain existing databases ensuring that the databases function properly and align with the organizations needs Performs data modeling analysis by maintaining, enhancing, and streamlining the data models as the requirements are identified throughout the agencys multiple projects.  Constantly works to keep data organized and ready for data analysts to mine and applications to access Partners with agency application developers and execute tasks related to application development Serves as the backup to the primary DB2 Database administrator Create and maintain comprehensive documentation for database systems, including design specifications, operational procedures, and security guidelines Assesses customer needs, develops technical solutions to increase program operating efficiency, and adapts to new requirements, as necessary Identifies opportunities for integration points with other core technology platformsAbout the Division The IT Division of the North Carolina Department of Environmental Quality (DEQ) leads IT professionals in supporting the departments mission. The division develops IT strategic plans, policies, and programs that align with business strategies, integrates security controls and best practices, and manages a complex portfolio of over 100 applications.

It also implements short and long-term IT goals, assesses new technologies, and plans IT roadmaps and architecture. The division is responsible for creating and implementing solutions for the departments business needs, including the design and development of internet, intranet, server-based, and cloud applications. Additionally, it provides training, troubleshooting, and recommendations for new or upgraded systems.

The IT Division ensures day-to-day support for applications, websites, and other IT services such as desktop support, LAN/WAN, hosting, and printers. About the OrganizationThe N.C. Department of Information Technology (NCDIT)serves as the Technology Center for the State of NC.

Services that NCDIT provides reach a client base of state and local government agencies, as well as schools, colleges and universities. NCDITs mission is to enable trusted business-driven solutions that meet the needs of North Carolinians. NCDIT provides technology services to state agencies and is charged with closing the digital divide by expanding availability of broadband services and promoting the adoption of affordable, high-speed internet.As NCDITs services reach North Carolina residents from all backgrounds, we believe that our workforce should reflect the demographics of the state.

The workforce is our most valuable asset to recognize, understand and meet the IT needs of our constituents across North Carolina. Our agencys culture is derived through the implementation of thoughtful, practical, innovative and data-driven strategies. We are an Employment

First state, ensuring that people with disabilities have equal opportunities to succeed in the state government workplace (Executive Order 92). NCDIT supports recent executive orders to address pay equity for women (Executive

Order 93), establish paid parental leave for birth, adoption, and foster care (Executive Order 95), and implement fair chance policies (Executive Order 158).

NCDIT also has several initiatives designed to help past and current military personnel and their spouses find rewarding careers with us. Join a team that welcomes, values, respects and supports all members of our work community. If you have student loans, becoming a state employee includes eligibility for the Public Service Loan Forgiveness Program.

Visit www.studentaid.gov to learn more.

The following Management Preferences are not required, but applicants that possess these skills are preferred:Working knowledge of Azure SQL or other cloud-based database technologiesWorking knowledge of creating, implementing, and maintaining Azure Pipelines and other migration tools that standardize and streamline the flow of data from all source systemsWorking knowledge with the other core technology platform components used within DEQ including Microsoft Azure Services and the Power Platform

Some state job postings say you can qualify by an ‘equivalent combination of education and experience. If that language appears below, then you may qualify through EITHER years of education OR years of directly related experience, OR a combination of both. See the Education and Experience Equivalency Guide for details. Bachelors degree in computer science or an IT related field or a related curriculum from an appropriately accredited institution and three years of progressive experience in programming and applications analysis including the design and maintenance of an integrated database systemORAssociate degree in computer science or an IT related field or a related curriculum from an appropriately accredited institution and four years of progressive experience in programming and applications analysis including the design and maintenance of an integrated database systemOR High School or

General Educational Development (GED) diploma and seven years of relevant experience in programming and applications analysis including the design and maintenance of an integrated database system; or an equivalent combination of education and experience.

TheNorth Carolina Department of Information Technology (DIT)is an

Equal Opportunity Employerwho embraces an

Employment Firstphilosophy which consists of complying with all federal laws, state laws and Executive Orders.  NCDIT uses the

Merit-Based Recruitment and Selection Planto fill posted positions.  Hiring salary will be based on relevant qualifications, internal equity, and budgetary considerations pertinent to the advertised position.The Department of Information Technology will not accept "See Resume" or inserted text resumes in lieu of all work experience and education completed on the application.Employment at NCDIT is contingent upon a satisfactory background check.Applicants seeking

Veterans Preferencemust attach a DD form 214, Certificate of Release or Discharge from Active Duty, along with your application.Applicants seeking

National Guard Preferencemust attach a NGB 23A (RPAS) if you are a current member of the NC National Guard in good standing. If you are a former member of the NC National Guard who served for at least 6 years and was discharged under honorable conditions, you must attach either a DD256 or NGB 22. Applicants applying for positions that require specific coursework, must upload and attach a copy of the transcript with their application. Applicants with relevant professional certifications to the posted job must attach proof of active certification along with the information in the “Certificates and Licenses” section.

If applicants earned college credit hours but did not complete a degree program, they must attach an official transcript to each application to receive credit for this education. If applicants earned a foreign degree, foreign degrees require an official evaluation for U.S. equivalency, and must be submitted to Human Resources for verification. There are several organizations that perform this specialized service, feel free to use any service of your choosing.

The National Association of Credential Evaluation Services (NACES) has several options on their website that can provide credential verification:https://www.naces.org/membersHYBRID/FLEXIBLE WORK SCHEDULES:At NCDIT, we are dedicated to fostering a collaborative and flexible work environment, offering a hybrid remote work option for positions that are conducive to remote flexibility. If you do not currently reside within a reasonable commuting distance of the assigned duty station, new hires are granted up to 120 days from their start date to relocate. This relocation ensures the ability to work onsite multiple days per week.

If youre eager to contribute to a dynamic workplace, we encourage you to apply!   COMPENSATION & BENEFITS:The state of North Carolina offers excellent comprehensive benefits. Employees can participate in health insurance options, standard and supplemental retirement plans, and the NCFlex program (numerous high-quality, low-cost benefits on a pre-tax basis).

Employees also receive paid vacation, sick, and community service leave.  In addition, paid parental leave is available to eligible employees.   Some highlights include:The best funded pension plan/retirement system in the nation according to Moodys Investors ServiceTwelve (12) holidays/year

Fourteen (14) vacation days/year which increase as length of service increases and accumulate year-to-year

Twelve (12) sick days/year which are cumulative indefinitely Longevity pay lump sum payout yearly based on length of service401K, 457, and 403(b) plans

Learn more about employee perks/benefits:To apply for this position, please click the "Apply" link above (on the Government Jobs website) or visithttps://www.governmentjobs.com/Applications/Index/northcarolinato complete an on-line application. Due to the volume of applications received, we are unable to provide information regarding the status of your application over the phone. To check the status of your application, please log in to your account and click "Application Status."  If you are selected for an interview, you will be contacted by management.

 If you are no longer under consideration, you will receive an email notification.  If there are any questions about this posting other than your application status, please contact:NCDIT Human ResourcesYori ***************@nc.gov

For technical issues with your application, please call the GovernmentJobs.com Applicant Support Help Line at 855-524-5627. 

Information :

• Company : North Carolina - North Carolina Government
• Position : Database Administrator II
• Location : Wake County, NC
• Country : US