Database Administrator II

Agency
Department of Information Technology

Division
Chief Deputy SCIO

Job Classification Title
Database Administrator II (NS)

Position Number

Grade
DT10

About Us
The 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. NCDIT's 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.

Description Of Work
Salary Range: $84,353-126,529

Are you ready to take the next step in your career?

We currently have an opening for a Database Administrator II

This position may be eligible for hybrid remote work in accordance with state policy and the agency's remote work program but does require weekly onsite work

The position is designated Statutory Exempt and is exempt from the State Human Resources Act.

The 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 agency's 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 organization's needs
• Performs data modeling analysis by maintaining, enhancing, and streamlining the data models as the requirements are identified throughout the agency's 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 platforms

The IT Division of the North Carolina Department of Environmental Quality (DEQ) leads IT professionals in supporting the department's 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 department's 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.

Knowledge Skills And Abilities/Management Preferences
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 technologies
• Working knowledge of creating, implementing, and maintaining Azure Pipelines and other migration tools that standardize and streamline the flow of data from all source systems
• Working knowledge with the other core technology platform components used within DEQ including Microsoft Azure Services and the Power Platform

Discover why NCDIT is the ideal destination for your professional growth - Why Work for NCDIT

Minimum Education And Experience
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.

Bachelor's 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 system;

or

Associate 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 system;

or

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.

EEO Statement
The State of North Carolina is an Equal Employment Opportunity Employer and dedicated to providing employees with a work environment free from all forms of unlawful employment discrimination, harassment, or retaliation. The state provides reasonable accommodation to employees and applicants with disabilities; known limitations related to pregnancy, childbirth, or related medical conditions; and for religious beliefs, observances, and practices.

Recruiter
Tajia Brown

Recruiter Email