What are the responsibilities and job description for the ONSITE Database Administrator- Senior position at TECHNOCRAFT SOLUTIONS?
Job Details
****This is an on-site position.
About the State Auditor's Office
The Office of the State Auditor of North Carolina isdedicated to ensuring transparency, accountability, and efficiency ingovernment operations. Our mission is to conduct audits, evaluations, andinvestigations that improve the performance and integrity of state agencies. Weare seeking a skilled Database Administrator with significant cloud experienceto manage and optimize our on premise, cloud-based and hybrid databaseinfrastructure, ensuring secure, efficient, and high-performance databasesystems to support audit functions, data analysis and agency operations.
Position Overview
The Database Administrator (DBA) will be responsible for thedesign, implementation, maintenance, and security of on-premises, hybrid and cloud-baseddatabase systems that store and manage critical government data. This roleinvolves optimizing database performance, ensuring data integrity, andcollaborating with data analysts, auditors, and IT to support agency operations.The ideal candidate will have extensive experience with cloud databasesolutions and migrations.
Key Responsibilities
- Optimize database performance, storage, indexing, and query execution in cloud environments.
- Develop and maintain cloud-based backup and disaster recovery strategies.
- Work closely with data analysts and IT teams to ensure seamless data availability and integration in cloud environments.
- Automate cloud database processes and improve data management workflows.
- Lead cloud migration projects and optimize cloud storage and computing costs.
- Bachelor's degree in Computer Science, Information Technology, or a related field. A Master's degree is a plus.
- Proficiency in SQL, PostgreSQL, MySQL, or Microsoft SQL Server in cloud environments.
- Experience and understanding of Databricks, data lakes and/or data warehouse.
- Knowledge of ETL (Extract, Transform, Load) processes and cloud-based data warehousing solutions.
- Experience with scripting languages such as Python or PowerShell for cloud automation.
- Excellent attention to detail and the ability to manage multiple projects simultaneously.
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 | 0 |