NCOSA - Database Administrator- Senior ()

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

Skill Required / Desired Amount of Experience 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