Purpose of Classification:

The purpose of this classification is to plan and design relational databases and monitor database performance.

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.

Supplemental Information

Vacancy is for a database administrator/architect. Microsoft Azure experience is preferred.

The following questions must be answered and submitted as a separate attachment along with your resume. Failure to answer these questions may disqualify you for consideration for this position.

1) How many years of experience do you have as a Database Administrator?

2) Do you have Azure Engineer Associate Certification?

3) Do you have Azure Solutions Architect Expert Certification?