Database Administrator Advanced

Oracle + Postgres
UNITED STATES
October 12, 2026
Full Time
Apply Now

Job Description

Company: State of Tennessee (Department of Transportation)
Location: Nashville, TN
Workplace Type: Nashville, TN
Employment Type: Full-Time
Pay / Compensation: $5,703.00 – $7,399.00 Monthly ($68,436.00 – $88,788.00 Annually)

About the Role

The Database Administrator Advanced role designs, administers, secures, and optimizes enterprise database systems for the State of Tennessee. This position is in the IT Division – Enterprise Support Services – Infrastructure/Operations Section within the Department of Transportation (Davidson County).

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.

What You’ll Do / Key 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.

Requirements & 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.
  • Core Competencies: Manages Ambiguity, Manages Complexity, Tech Savvy, Global Perspective, Decision Quality.
  • Required Skills: Active Learning and Listening, Judgment and Decision Making, Operations Analysis, Critical Thinking, Systems Analysis.
  • Required 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.

Additional Information

  • Opening Date/Time: 10/06/2026 12:00 AM Central Time
  • Closing Date/Time: 10/19/2026 11:59 PM Central Time
  • Location Detail: Department of Transportation, Davidson County
  • For More Information, Visit The Link Below: TDOT Information Technology Division Document

Related Jobs