Job description

Job ID: NC- 761423 Onsite/Local Azure SQL Server Admin/DBA (15+) with PostgreSQL, MySQL, Databricks/Lakes/warehouse, encryption, ETL, Terraform/AKS/Kubernetes, Python/PowerShell experience Location: Raleigh, NC (Office of the State Auditor TIMS Te) Duration: 6 Months Position: 1 Skills: Experience in database administration, with a strong focus on cloud-based database solutions. Required 3 Years Proficiency in SQL, PostgreSQL, MySQL, or Microsoft SQL Server in cloud environments. Required 3 Years Experience with cloud database management platforms, specifically Azure. Required 3 Years Experience and understanding of Databricks, data lakes and/or data warehouse. Required 3 Years Strong understanding of database security, encryption, and access control in cloud environments. Required 3 Years Knowledge of ETL (Extract, Transform, Load) processes and cloud-based data warehousing solutions. Required 3 Years Familiarity with cloud automation tools such as Terraform or AKS (Azure Kubernetes Service). Required 3 Years Experience with scripting languages such as Python or PowerShell for cloud automation. Required 3 Years Excellent attention to detail and the ability to manage multiple projects simultaneously. Required DESCRIPTION: 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.

Requirements