Database Administrator

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

Explore a World of Opportunity with the State of Georgia! We are the force that drives Georgia! Georgia State Government is a large enterprise, composed of various agencies and entities with a common goal to improve the lives of Georgia's more than 10 million citizens! Join Team Georgia and impact lives everyday while receiving a robust benefits package designed for every stage of your career!

Job Title: Database Administrator

Agency: Department of Community Affairs

Compensation Details: $56,310.72-73,677.24

Make a difference and join the DCA Team! DCA gives employees more to do than merely make a living.

We are serious about helping Georgia's families live more abundantly with a greater sense of hope and achievement. If public service, a great environment, and the desire to enrich the lives of others motivate you to do your best work, you should consider joining the DCA Team.

OUR MISSION

To help build strong, vibrant communities.

OUR VISION

For Georgians of today and tomorrow to have the opportunity to live and work in thriving communities.

OUR CULTURE

DCA is dedicated to helping build strong, vibrant communities. We are a diverse team of highly competent and committed professionals who strive to help people and communities thrive through technical expertise, innovative thinking and a passion for making a difference. Team members are at their best when collaborating and supporting each other as they perform challenging and dynamic work. We are serious about helping Georgia's families live more abundantly with a greater sense of hope and achievement. If public service and the desire to enrich the lives of others motivates you to do your best work, you should consider joining the DCA Team.

GENERAL DESCRIPTION

The Georgia Department of Community Affairs (DCA) is a state organization dedicated to helping build strong, vibrant communities through the development of safe, decent and affordable housing. DCA offers a fast pace, challenging and dynamic environment that requires attention to detail, pride in quality of work, and the ability to work as a versatile team player. We are a diverse team of highly competent and committed professionals who strive to help people and communities thrive through technical expertise, innovative thinking and a passion for making a difference. Team members are at their best when collaborating and supporting each other as they perform challenging and dynamic work.

JOB DESCRIPTION

Under general supervision, supports the administration, maintenance, monitoring, and security of agency databases, data warehouses, and data lakes used to support critical business applications and reporting. Assists with the design, implementation, and maintenance of database environments and works with application developers, business analysts, data analysts, and agency staff to ensure data is stored, maintained, and accessible in a reliable and secure manner. This position will assist with the deployment and ongoing support of data warehouse and data lake solutions. Responsibilities include assisting with the onboarding of data from various agency applications and systems, developing and maintaining data integration processes, monitoring data quality, and supporting the preparation of data for reporting and analytics. The position will work closely with members of the Application Team and other IT staff to troubleshoot database and application issues, perform routine database maintenance, monitor system performance, and assist with database upgrades, migrations, backups, and recoveries.

KEY RESPONSIBILITES

• Assist with the administration and maintenance of agency databases, data warehouses, and data lakes.
• Support the installation, configuration, upgrades, and maintenance of database management systems.
• Monitor database availability, performance, capacity, and overall health.
• Assist with troubleshooting database-related issues affecting agency applications and users.
• Work with application developers and analysts to support database design, data structures, queries, and integrations.
• Assist with developing and maintaining SQL queries, stored procedures, views, and other database objects.
• Support the integration of data from multiple agency applications and systems into centralized data storage environments.
• Assist with data extraction, transformation, and loading (ETL/ELT) processes.
• Monitor data integration processes and investigate errors or failed data loads.
• Assist with data validation and quality checks to identify missing, inaccurate, duplicate, or inconsistent data.
• Support the preparation and organization of data for reporting, dashboards, and analytics.
• Assist with database backup, recovery, and disaster recovery activities.
• Assist with database security, including user access, permissions, authentication, and appropriate handling of sensitive agency information.
• Follow agency data governance, security, privacy, and records-management requirements.
• Maintain technical documentation for databases, data integrations, processes, and configurations.
• Assist with database migrations and application upgrades.
• Work with vendors and third-party application providers to troubleshoot database and application issues when needed.
• Participate in testing of database changes, application releases, integrations, and data-related enhancements.
• Assist with identifying opportunities to improve database performance, reliability, automation, and data accessibility.
• Respond to assigned service requests, incidents, and application support issues within established service levels.
• Participate in projects involving new applications, system integrations, cloud services, data warehouse/lake implementations, and modernization initiatives.
• Perform other related duties as assigned.

REQUIRED KNOWLEDGE, SKILLS, AND ABILITIES

• Working knowledge of relational database concepts and database management systems.
• Basic to intermediate knowledge of SQL and the ability to create and modify queries.
• Understanding of database tables, relationships, indexes, views, stored procedures, and data types.
• Understanding of data integration and ETL/ELT concepts.
• Ability to troubleshoot database and application-related issues.
• Basic understanding of database security, user access, permissions, and data protection.
• Ability to analyze data and identify inconsistencies or potential data quality issues.
• Ability to document technical processes and communicate technical information to both technical and non-technical staff.
• Ability to work collaboratively with application developers, analysts, infrastructure staff, vendors, and business users.
• Ability to manage multiple assignments and prioritize work based on business needs.
• Strong analytical, problem-solving, organizational, and communication skills.

PREFERRED EXPERIENCE

• Experience with Microsoft SQL Server or another enterprise relational database platform.
• Experience writing SQL queries.
• Experience supporting enterprise applications or application development teams.
• Experience with data warehouses, data lakes, or cloud-based data platforms, specifically Snowflake.
• Experience with ETL/ELT tools or data integration technologies.
• Experience with Microsoft Azure, Microsoft Fabric, Azure SQL, or related cloud data services.
• Familiarity with Power BI or other business intelligence/reporting tools.
• Familiarity with data governance, data quality, and information security practices.
• Experience working in a government or regulated environment is a plus.

WORK ENVIRONMENT

This position works as a member of the Application Team and collaborates with Infrastructure, Security, Data/Analytics, business units, vendors, and other IT staff. The position may participate in application implementations, system upgrades, data migrations, and other technology projects. This job has no direct reports.

ADDITIONAL JOB DESCRIPTION

• High school diploma/GED and four (4) years of experience in support of an operating system, database management system or a related field; or two (2) years of experience at the lower level Database Administrator 3 (ITP032) or position equivalent.

WORKING CONDITIONS

• This position is currently designated as a hybrid (part in-office and part remote/telework) position.
• This position is full-time (40 hours per week) and may require occasional overtime.
• Local periodic travel may be required.

PHYSICAL / SENSORY REQUIREMENTS

• Work is principally stationary, but the person in this position needs to occasionally move about inside the office to access file cabinets, office machinery, etc., and constantly operate a computer and other office equipment.
• Must be able to remain in a stationary position 50% of the time.
• Must be able to perform office‑related duties.
• Must be able to operate office equipment.
• Must be able to establish and maintain effective working relationships with employees, tenants, and community agencies and other entities that provide services.
• Must be able to perform essential job functions, with or without reasonable accommodation.
• Must be able to perform essential job functions in an environment that will sometimes include increased levels of work‑related stress.
• Must maintain punctuality and attendance as scheduled.

NOTE: All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, age, disability, protected veteran status, or any other characteristic protected by law.

All qualified applicants will be considered but may not necessarily receive an interview.

If you need accommodation for an interview, please contact the Human Resources Office at (404) 679‑4845.

This position is subject to close at any time once a satisfactory applicant pool has been identified.

This job posting may close at any time upon gaining a sufficient applicant pool from which to select a qualified candidate.

Hiring is contingent upon satisfactory results of employment verification, background, criminal records investigation and motor vehicle reports.

This job description does not constitute an employment agreement between the employer and the employee and is subject to change by the employer as the needs of the business and requirement of the job change.

DCA is an Equal Opportunity Employer.

State of Georgia does not discriminate based on race, color, national origin, sex, religion, age, disability, or other protected categories in employment or the provision of services.

Qualified applicants may request reasonable accommodation when needed during the application and/or screening process by contacting the appropriate agency Human Resources department.

Georgia State Government is a large enterprise, composed of various entities with a common goal to improve the lives of Georgia's 10 million citizens. With nearly 62,000 employees, we are one of the single largest employer in the state. Public service opportunities stretch across the state as employees live and work in all 159 counties. From traditional fields such as accounting, nursing, and engineering to unique fields like forestry and natural resources management, Georgia state government provides a world of opportunity.