Database Administrator

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
Job Requisition ID:
JR0000006998
Shift:
Not Applicable (United States of America)
Compensation Details:
$56,310.72-73,677.24
Job Description:
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 (TRAVEL, HOURS, ENVIRONMENT)
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.
Mu