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 AdministratorAgency:Department of Community AffairsJob Requisition ID:JR0000006998Shift:Not Applicable (United States of America)Compensation Details:$56,View phone number on click.appcast.io,677.24Job 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 MISSIONTo help build strong, vibrant communities.OUR VISIONFor Georgians of today and tomorrow to have the opportunity to live and work in thriving communities.OUR CULTUREDCA 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 DESCRIPTIONThe 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 DESCRIPTIONUnder 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 RESPONSIBILITESAssist 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 ABILITIESWorking 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 EXPERIENCEExperience 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 ENVIRONMENTThis 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 DESCRIPTIONHigh 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.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. Due to the large volume of submissions received by this office, information concerning application and/or interview status cannot be provided. Selected applicants will be contacted for next steps in the interview process. Applicants who are not selected will not receive notification. This position is subject to close at any time once a satisfactory applicant pool has been identified.DCA is an Equal Opportunity Employer. If you need accommodation for an interview, please contact the Human Resources Office at (404) 679-4845Hiring 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. This job posting may close at any time upon gaining a sufficient applicant pool from which to select a qualified candidate.All duties and responsibilities listed are considered to be essential job functions and requirements and are subject to possible modification to reasonably accommodate individuals with disabilities. Marginal functions of the position (those that are incidental to the performance of the job duties) have not been included. However, the omission of specific statements of duties does not exclude them from the position if the work is similar, related, or logical assignment to the position.Minimum Qualifications:High school diploma/GED and three (3) 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 2 (ITP031) or position equivalent.Equal Employment Opportunity EmployerThe 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. #J-18808-Ljbffr State of Georgia