Database Administrator

This opening is in the department of Planning & Sustainability.

Essential Functions:  

The following duties are normal for this position. The omission of specific statements of the duties does not exclude them from the classification if the work is similar, related, or a logical assignment for this classification. Other duties may be required and assigned. 

Develops plans and requirements for new systems and enhancements; translates requirements into physical database structures; develops, designs and reviews data models; consults with application development teams; performs routine audits of database inventory; surveys and audits the enterprise network; meets with users and project managers to gather requirements for new systems and projects; and coordinates with infrastructure technicians to monitor and adjust storage and infrastructure related resources. 

Monitors the state of County databases; evaluates performance, capacity and reliability of databases; runs scripts to capture database bottlenecks and poorly performing reports and queries; manages disk space for database systems; runs scripts to optimize indexes and check database integrity; implements efficiency improvements where needed; adjusts resource usage as needed; and analyzes database code written by developers to assess impact on the database system and application performance. 

Installs, configures, and maintains database management software, including upgrades, patches, and third-party tools; performs database backup and database recovery; and schedules routine restoration of sample backup files to test file integrity. 

Maintains user and data security; adds users and user groups; assigns users to database sources; determines appropriate levels of data access; connects users to requested database; ensures data security through standard server security best practices; and monitors and upgrades database server security during maintenance activities. 

Selects or assists in the selection of new database management and application systems; analyzes  systems design, feasibility, cost, impact, hardware specifications, data conversion functions, and reduction of redundant data; reviews configuration and deployment plans for performance, maintainability, scalability, and conformance to architectural standards; and makes appropriate recommendations. 

Develops or validates deployment scripts for database software changes; deploys databases and database changes in testing, training, preproduction, and production environments; writes stored procedures, functions, triggers, and batch jobs in the database 

Maintains an awareness of new applications, technologies, technical methods, trends, and advances in the profession; reviews professional publications, technical manuals, and websites to increase knowledge of network operations; and attends conferences, workshops, and training sessions as appropriate. 

Minimum Qualifications: 

Bachelor's Degree in Computer Science, Management Information Systems, or related field required; five years of progressively responsible experience in database administration and design in a large-scale information technology environment; or any equivalent combination of education, training, and experience which provides the requisite knowledge, skills, and abilities for this job. 

Specific License or Certification Required:  Must possess and maintain a valid Georgia driver’s license.