SALARY RANGE (Grade 14A) CSA311: $87,293.31/yr. -- $130,530.11/yr (Commensurate with experience)

GENERAL STATEMENT OF DUTIES

The Office of the State Auditor (OSA) operates within a hybrid data environment that includes both on-premises Microsoft SQL Server and Azure Government (GCC) cloud services. The Database Administrator (DBA) plays a key role in securely operating, optimizing, and evolving these platforms. This position supports the full lifecycle of data management across on-premises and cloud systems, aligns operations with data governance and DevOps best practices, and collaborates closely with architecture and security teams to deliver reliable, cost-effective, and compliant data services.

The DBA serves as a technical consultant to development teams, maintains and enhances mission critical databases, and ensures the integrity, performance, and availability of OSA’s data assets across internally developed applications, third-party systems, and data warehouse solutions

SUPERVISION RECEIVED

Receives supervision and direction from the Assistant Director of IT, Development, and Special Projects

SUPERVISION EXERCISED

Provides technical supervision over 1-3 contract personnel on an as needed or by project basis

DUTIES AND RESPONSIBILITIES

·         Install, patch, upgrade, secure, and manage MS SQL Server database hosts, including Azure-related database technologies.

·         Maintain an accurate inventory of all servers, databases, and Azure data services; ensure lifecycle management and adherence to naming conventions and organizational standards.

·         Create new and maintain existing PowerShell and DOS scripts used to monitor database availability and health.

·         Troubleshoot database issues, recovery, and resolve SQL Server errors and failures.

·         Provide high availability, performance tuning, and proactive maintenance for new and existing databases.

·         Assist OSA IT employees charged with managing storage for on-premises and Azure database-related services, including monitoring utilization, organizing storage layout, and supporting archival and data retention processes.

·         Assist OSA developers with performing ad hoc data loading and data manipulation tasks as needed.

·         Maintain and improve backup and recovery strategies, ensuring systems meet OSA business continuity and disaster recovery requirements.

·         Administer and enhance database security configurations, including encryption at rest and in transit, firewall rules, and vulnerability remediation.

·         Manage database access control mechanisms, implement RBAC, and maintain service or managed identities in alignment with OSA security policies.

·         Configure and administer SQL Server Auditing across all databases.

·         Create, schedule, and monitor SQL Server Agent jobs and other automated processes supporting applications, data exchanges, and ETL/ELT workloads.

·         Administration and deployment of ETL processes and data pipelines powered by SQL Server, SSIS, Azure Data Factory, or GitHub Actions.

·         Manage database schemas, indexes, constraints, and related metadata to optimize application performance and maintain integrity.

·         Provide guidance to development teams on database standards, conventions, and be