Database Administrator- Senior

The Database Administrator (DBA) will be responsible for the design, implementation, maintenance, and security of on-premises, hybrid and cloud-based database systems that store and manage critical government data.

About the State Auditor's Office

• The Office of the State Auditor of North Carolina is dedicated to ensuring transparency, accountability, and efficiency in government operations.
• Our mission is to conduct audits, evaluations, and investigations that improve the performance and integrity of state agencies.
• We are seeking a skilled Database Administrator with significant cloud experience to manage and optimize our on premise, cloud-based and hybrid database infrastructure, ensuring secure, efficient, and high-performance database systems to support audit functions, data analysis and agency operations.

Position Overview

• The Database Administrator (DBA) will be responsible for the design, implementation, maintenance, and security of on-premises, hybrid and cloud-based database systems that store and manage critical government data.
• This role involves optimizing database performance, ensuring data integrity, and collaborating with data analysts, auditors, and IT to support agency operations.
• The ideal candidate will have extensive experience with cloud database solutions and migrations.

Key Responsibilities

• Design, implement, and maintain cloud-based and hybrid relational and non-relational database systems.
• Optimize database performance, storage, indexing, and query execution in cloud environments.
• Ensure database security, encryption, and compliance with state and federal regulations for on premises, hybrid and cloud platforms.
• Develop and maintain cloud-based backup and disaster recovery strategies.
• Manage user access controls and roles within cloud database systems.
• Work closely with data analysts and IT teams to ensure seamless data availability and integration in cloud environments.
• Troubleshoot and resolve database-related issues, including performance tuning.
• Automate cloud database processes and improve data management workflows.
• Monitor cloud database performance and proactively identify areas for improvement.
• Lead cloud migration projects and optimize cloud storage and computing costs.
• Stay current with industry trends and advancements in cloud database technologies.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field. A Master's degree is a plus.
• 3 years of experience in database administration, with a strong focus on cloud-based database solutions.
• Proficiency in SQL, PostgreSQL, MySQL, or Microsoft SQL Server in cloud environments.
• Experience with cloud database management platforms, specifically Azure.
• Experience and understanding of Databricks, data lakes and/or data warehouse.
• Strong understanding of database security, encryption, and access control in cloud environments.
• Knowledge of ETL (Extract, Transform, Load) processes and cloud-based data warehousing solutions.
• Familiarity with cloud automation tools such as Terraform or AKS (Azure Kubernetes Service).
• Experience with scripting languages such as Python or PowerShell for cloud automation.
• Strong problem-solving skills and ability to work both independently and collaboratively.
• Excellent attention to detail and the ability to manage multiple projects simultaneously.