Database Administrator II (Temporary)

State of North Carolina

3d • Hybrid

About The Position

To provide a solid Human Resource management foundation, responsible oversight, and creative solutions through a collaborative approach with all stakeholders to maximize the potential of our greatest asset – OUR EMPLOYEES. This is a temporary position and there are no leave or retirement benefits offered with this position. Temporary employees who work an annual average of 30 or more hours per week may be eligible for health insurance coverage under the High Deductible Health Plan (HDHP). For more information on Health Benefits offered visit www.shpnc.org. Visit www.nctemporarysolutions.com for employment information. Note: Permanent and time-limited NC State Government employees must separate from their permanent or time-limited position in order to work in a temporary position. All temporary employees are limited to one NC State Government temporary assignment at a time. Individuals hired into a temporary State job must be fully qualified for the job. OSHR supports the Governor's Job Ready initiative and seeks to expand a temporary skill set to enhance their qualifications for State government and private sector jobs. Exposure to an agency's culture, process, procedures, and potential learning opportunities can provide valuable experience to those who may seek permanent employment with the state. This temporary position is located at 2 S. Salisbury Street in Raleigh, NC - Wake County with the Secretary of State. Job Order Hourly Rate of Pay: $55.00 (Based on education and/or years of relevant work experience reflected on the application). Effective July 1, 2025, candidates now meet the minimum qualifications of a position if they have the minimum education and experience listed from the class specification. The Knowledge, Skills, and Abilities listed within this vacancy announcement will be used only as management preferences and will be used to screen for the most qualified pool of applicants. Management Preferences: Senior Database Administrator The North Carolina Department of the Secretary of State (NCSOS) is seeking a qualified and detail-oriented Database Administrator (DBA) to support ongoing data quality and system optimization initiatives. This role is responsible for leading data cleansing efforts, enhancing table structures, and designing and maintaining data relationships to ensure data integrity, consistency, and performance. The selected candidate will evaluate existing database environments, identify inconsistencies or redundancies, normalize schemas, and implement best practices in relational database design. Strong SQL expertise, analytical thinking, and attention to detail are essential for success in this position. This role requires effective collaboration with development and IT teams to strengthen overall data reliability and support organizational objectives. Candidates who are committed to maintaining high standards of data governance and performance are encouraged to apply. This position will be based in the Raleigh, North Carolina area and is expected to work on-site and/or in a hybrid capacity in accordance with agency policies. This is a temporary position with an anticipated duration of up to two (2) years. This position is a temporary assignment administered through OSHR Temporary Solutions. Temporary Solutions employees are subject to assignment duration limits and required break-in-service periods. Individuals who have completed a Temporary Solutions assignment and reached the maximum duration must have a minimum 31-day consecutive calendar break before beginning another Temporary Solutions assignment. Senior-level knowledge of enterprise database architecture, including advanced relational design, normalization, indexing strategies, unique identifier frameworks, and enforcement of referential integrity to support scalable, secure, and high-availability systems. Expertise in diagnosing and resolving complex performance issues through advanced SQL tuning, query plan analysis, optimization of large-scale unions and updating statements, and implementation of best practices to support high-volume transactional and analytical workloads. Lead data quality initiatives, including resolving duplicate and conflicting identifiers, standardizing address and reference data, consolidating redundant tables, and establishing long-term data governance and cleanup strategies. Advanced experience designing, overseeing, and optimizing ETL processes and data warehouse integrations in collaboration with developers, and business stakeholders to ensure consistent, reliable data delivery for dashboards, reporting, and analytics platforms. Ability to design and enforce complex data relationships across transactional and analytical systems, define foreign keys or logical mappings, implement indexing strategies, and evolve schemas to support new business requirements without compromising data integrity or performance.

Requirements

• 7+ years of hands-on experience as a Database Administrator in production environments
• Advanced expertise in relational database systems (e.g., SQL Server, Oracle, PostgreSQL, MySQL)
• Strong proficiency in SQL, performance tuning, query optimization, and indexing strategies
• Extensive experience with data modeling, table design, normalization, and enforcing referential integrity (foreign keys, constraints)
• Proven ability to lead data cleaning, migration, and schema refactoring initiatives
• Experience with database security, access control, auditing, and compliance best practices
• 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.

Nice To Haves

• Master’s degree in IT or Data Management (preferred)
• Microsoft Certified: Azure Database Administrator Associate
• Oracle Certified Professional (OCP) for Oracle DB environments
• AWS Certified Database – Specialty for cloud database expertise
• Microsoft Certified Solutions Expert (MCSE) in Data Management and Analytics
• PostgreSQL or MySQL Professional Certifications (depending on environment)
• ITIL Foundation (for process and governance knowledge)

Responsibilities

• Lead data cleansing efforts
• Enhance table structures
• Design and maintain data relationships to ensure data integrity, consistency, and performance.
• Evaluate existing database environments, identify inconsistencies or redundancies, normalize schemas, and implement best practices in relational database design.
• Diagnosing and resolving complex performance issues through advanced SQL tuning, query plan analysis, optimization of large-scale unions and updating statements, and implementation of best practices to support high-volume transactional and analytical workloads.
• Lead data quality initiatives, including resolving duplicate and conflicting identifiers, standardizing address and reference data, consolidating redundant tables, and establishing long-term data governance and cleanup strategies.
• Designing, overseeing, and optimizing ETL processes and data warehouse integrations in collaboration with developers, and business stakeholders to ensure consistent, reliable data delivery for dashboards, reporting, and analytics platforms.
• Design and enforce complex data relationships across transactional and analytical systems, define foreign keys or logical mappings, implement indexing strategies, and evolve schemas to support new business requirements without compromising data integrity or performance.

What This Job Offers

• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees