DATABASE ADMINISTRATOR - ADVANCED - 10062026-81457

Job Information

State of Tennessee Job Information

Opening Date/Time10/06/2026 12:00AM Central TimeClosing Date/Time10/19/2026 11:59PM Central TimeSalary (Monthly)$5,703.00 - $7,399.00Salary (Annually)$68,436.00 - $88,788.00Job TypeFull-TimeCity, State LocationNashville, TNDepartmentTransportation

LOCATION OF (1) POSITION(S) TO BE FILLED: DEPARTMENT OF TRANSPORTATION, DAVIDSON COUNTY

This position is in the IT Division - Enterprise Support Services - Infrastructure/Operations Section.

For more information, visit the link below:

https://www.tdot.tn.gov/PublicDocuments/hr/Information_Technology_Division_Enterprise_Support_Services_Infrastructer_Operations_Database_Ad.pdf

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

The Database Administrator Advanced role designs, administers, secures, and optimizes enterprise database systems for the State of Tennessee.

This role supports high availability, integrity, performance, scalability, and compliance across production, development, testing, and disaster recovery environments. It involves database architecture and design; administration of relational database platforms; and the use of SQL, PL/SQL, T SQL, and other scripting to support critical enterprise applications.

The position handles database tuning, optimization, capacity planning, and data modeling, along with data integration, ETL processes, reporting, and warehousing. It manages database upgrades, migrations, patching, conversions, and deployments while maintaining strong backup, recovery, replication, high availability, and failover processes. Responsibilities also include working across operating systems, networking, storage, cloud environments, monitoring tools, and ensuring alignment with state technology policies, cybersecurity standards, and applicable regulations.

This role involves analyzing and resolving complex database and infrastructure issues, developing and testing disaster recovery solutions, and implementing changes with minimal service interruption. It includes creating clear technical documentation, communicating effectively with both technical and non-technical stakeholders, and providing technical guidance to database teams, developers, and infrastructure staff.

The Advanced Database Administrator manages multiple priorities, works independently or collaboratively, and consistently meets deadlines in a dynamic enterprise environment.

Responsibilities

• Design, install, configure, administer, and maintain enterprise database systems to support statewide applications and services.

• Develop and maintain logical and physical data models for online transaction processing systems and other enterprise solutions.

• Monitor database availability, performance, capacity, scalability, system logs, and alerts, ensuring stable and efficient operations.

• Perform SQL, PL/SQL, T SQL, infrastructure, indexing, and configuration tuning to optimize database performance.

• Develop advanced database procedures, functions, packages, scripts, monitoring utilities, and automation processes.

• Implement backup, recovery, replication, high availability, and disaster recovery solutions, including hot backups and point in time recovery.

• Participate in disaster recovery testing and lead recovery operations when needed.

• Plan and execute database upgrades, patches, migrations, conversions, consolidations, and deployments across environments.

• Develop and review DML and DDL change scripts to support application enhancements and system updates.

• Design and implement Extract, Transform, and Load (ETL) processes for data migration and integration.

• Support reporting, data warehousing, analytics, and enterprise data initiatives.

• Manage database security, including roles, permissions, access controls, encryption, auditing, firewall configurations, and data protection requirements.

• Troubleshoot complex database, application, performance, connectivity, storage, operating system, and infrastructure issues.

• Collaborate with developers, business analysts, cybersecurity teams, infrastructure personnel, vendors, and agency stakeholders.

• Develop and maintain database standards, procedures, technical documentation, recovery plans, and operational runbooks.

• Perform capacity planning and recommend improvements to database architecture, storage, networking, cloud platforms, and enterprise applications.

• Participate in modernization, cloud migration, automation, standardization, and continuous improvement initiatives.

• Provide technical guidance, mentoring, and knowledge transfer to database administrators and IT staff.

• Manage multiple assignments and priorities while meeting deadlines and service level expectations.

• Perform other related duties as assigned.

Competencies (KSA's)

Competencies:

• Manages Ambiguity

• Manages Complexity

• Tech Savvy

• Global Perspective

• Decision Quality

Skills:

• Active Learning and Listening

• Judgment and Decision Making

• Operations Analysis

• Critical Thinking

• Systems Analysis

Abilities:

• Written Comprehension

• Deductive Reasoning

• Information Ordering

• Inductive Reasoning

Tools & Equipment

• Database Systems (Oracle, SQL Server, MySQL, PostgreSQL)

• Monitoring and Backup Tools

• Shell Scripting Tools

• Microsoft Office Suite

• Enterprise Management Utilities