DATABASE ADMINISTRATOR-ADVANCED - 08072025-70245

Job Information

LOCATION OF (1) POSITION(S) TO BE FILLED: DEPARTMENT OF FINANCE & ADMINISTRATION, BUSINESS SOLUTIONS DELIVERY DIVISION, DAVIDSON COUNTY

This position supports Safety and Homeland Security.

This position is designed as Hybrid.

This position requires CJIS fingerprint background check.

Qualifications

Education and Experience: Bachelor's degree and two years of experience in database management, design, or programming. Graduate work in database modeling or tuning may substitute for up to two years of experience. Relevant experience may substitute for education up to four years.

Overview

Under general supervision, the Database Administrator - Advanced designs, implements, and maintains complex database systems, ensuring availability, security, and performance across enterprise platforms. This role includes leading tuning initiatives, managing advanced disaster recovery procedures, and supporting large-scale deployments under general supervision. This class differs from Database Administrator-Intermediate in that an incumbent of the latter learns to implement or revise databases. This class differs from Database Administrator-Lead in that an incumbent of the latter is responsible for leading or supervising other database administrators in implementing methods, techniques, and standards for data, and performs complex database management work.

Responsibilities

1. Implements and monitors advanced backup/recovery strategies including hot backups and point-in-time recovery.
2. Performs infrastructure and SQL tuning to optimize database performance across enterprise environments.
3. Executes migrations, upgrades, and patching procedures; develops change scripts for DML and DDL changes.
4. Supports disaster recovery testing and documentation, and leads recovery operations as required.
5. Designs and maintains logical and physical data models for OLTP systems.
6. Monitors system logs, capacity trends, and performance alerts; develops automated monitoring scripts.
7. Develops and supports complex SQL, PL/SQL, or TSQL routines for business processes.
8. Manages database security, including roles, audits, and firewall configurations.
9. Collaborates with developers, business analysts, and infrastructure teams to ensure system integrity.
10. Documents database operations and procedures, including handoffs for operational readiness.
11. Designs, develops, and implements Extract, Transform, and Load jobs to efficiently migrate data from one system to another.

Competencies (KSA's)

Competencies:
1. Manages Ambiguity
2. Manages Complexity
3. Tech Savvy
4. Global Perspective
5. Decision Quality

Knowledges:
N/A

Skills:
1. Active Learning and Listening
2. Judgment and Decision Making
3. Operations Analysis
4. Critical Thinking
5. Systems Analysis

Abilities:
1. Written Comprehension
2. Deductive Reasoning
3. Information Ordering
4. Inductive Reasoning

Tools & Equipment

1. Database Systems (Oracle, SQL Server, MySQL, PostgreSQL)
2. Monitoring and Backup Tools
3. Shell Scripting Tools
4. Microsoft Office Suite
5. Enterprise Management Utilities