State of Tennessee
DATABASE ADMINISTRATOR-ADVANCED
State of Tennessee - Nashville, Tennessee, United States, 37247
Work at State of Tennessee
Overview
- View job
Overview
Job Information
State of Tennessee Job Information
Opening Date/Time 08/07/2025 12:00AM Central Time Closing Date/Time 08/20/2025 11:59PM Central Time Salary (Monthly) $5,591.00 - $7,253.00 Salary (Annually) $67,092.00 - $87,036.00 Job Type Full-Time City, State Location Nashville, TN Department Finance and Administration 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
Opening Date/Time 08/07/2025 12:00AM Central Time Closing Date/Time 08/20/2025 11:59PM Central Time Salary (Monthly) $5,591.00 - $7,253.00 Salary (Annually) $67,092.00 - $87,036.00 Job Type Full-Time City, State Location Nashville, TN Department Finance and Administration 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