Junior SQL Server/Postgresql DBA

Title: Junior SQL Server/Postgresql DBA - Onsite
Location: Raleigh, NC, United States
Length: Long term
Restriction: W2 or C2C

Description:

Interview Type: r In Person Very long term project initial PO for 1 year, expect to go for 4+ years Onsite

Short Description:

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

job Description:

This is an onsite position.

About the State Auditors 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 highperformance 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 onpremises, hybrid and cloudbased 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 cloudbased and hybrid relational and nonrelational 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 cloudbased 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 databaserelated 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 Masters degree is a plus.
3+ years of experience in database administration, with a strong focus on cloudbased 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 cloudbased 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 problemsolving skills and ability to work both independently and collaboratively.
Excellent attention to detail and the ability to manage multiple projects simultaneously.

Required Skills:

Experience in database administration, with a strong focus on cloudbased database solutions. 3 Years
Proficiency in SQL, PostgreSQL, MySQL, or Microsoft SQL Server in cloud environments. 3 Years
Experience with cloud database management platforms, specifically Azure. 3 Years
Experience and understanding of Databricks, data lakes and/or data warehouse. 3 Years
Strong understanding of database security, encryption, and access control in cloud environments. 3 Years
Knowledge of ETL (Extract, Transform, Load) processes and cloudbased data warehousing solutions. 3 Years
Familiarity with cloud automation tools such as Terraform or AKS (Azure Kubernetes Service). 3 Years
Experience with scripting languages such as Python or PowerShell for cloud automation. 3 Years
Excellent attention to detail and the ability to manage multiple projects simultaneously.