Hybrid Database Administrator – Data Warehousing & Lakes

State of Georgia; United States; Hybrid; USD 56,000 - 74,000; Full time

Job summary

The Georgia Department of Community Affairs (DCA) is seeking a Database Administrator to support the administration, maintenance, monitoring, and security of agency databases, data warehouses, and data lakes. The role requires collaboration with developers, analysts, and staff to ensure data reliability and secure access.

This position involves deploying and supporting data warehouse and data lake solutions, onboarding data from various applications, and ensuring data quality for reporting and

Qualifications

• High school diploma or GED with four years of relevant IT experience in database administration.
• Experience with relational databases, SQL, and data integration concepts.
• Ability to troubleshoot and support enterprise applications.

Responsibilities

• Assist with the administration and maintenance of agency databases, data warehouses, and data lakes.
• Monitor database availability, performance, capacity, and overall health.
• Develop and maintain SQL queries, stored procedures, views, and other database objects.
• Support the integration of data from multiple agency applications and systems.
• Assist with data extraction, transformation, and loading (ETL/ELT) processes.
• Monitor data integration processes and investigate errors or failed data loads.

Skills

Relational DB concepts

SQL queries

Data integration

Data quality

Database security

Troubleshooting

Education

High school diploma/GED

Tools

SQL Server

Power BI

Snowflake

Azure SQL

Job description

The Georgia Department of Community Affairs (DCA) is seeking a Database Administrator to support the administration, maintenance, monitoring, and security of agency databases, data warehouses, and data lakes. The role requires collaboration with developers, analysts, and staff to ensure data reliability and secure access.

This position involves deploying and supporting data warehouse and data lake solutions, onboarding data from various applications, and ensuring data quality for reporting and