Senior Application Database Administrator

Texas Municipal Retirement System

Austin (TX)

Hybrid

USD 130,000 - 170,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Hybrid work opportunities
Health insurance
12 paid holidays
Modern, centrally located Austin офис

Job summary

Texas Municipal Retirement System in Austin, TX seeks a Senior Application Database Administrator with deep Oracle expertise to design schemas, code complex PL/SQL, and drive performance improvements. You will set standards for data security, query performance, and data modeling while collaborating closely with IS stakeholders and software teams.

The role involves mentoring staff, supporting application upgrades, and participating in on-call coverage.

Qualifications

  • Bachelor’s degree in CIS, computer science, engineering, MIS, mathematics or related field.
  • Minimum of 6 years of hands-on Oracle database experience, including at least 2 years writing and tuning production PL/SQL.
  • Demonstrated experience leading database design and performance work across multiple concurrent application releases.

Responsibilities

  • Architect and maintain Oracle schemas, tables, indexes, partitions, views, materialized views, sequences, types and packages.
  • Review and approve data model changes prior to implementation.
  • Write, optimize, and maintain complex PL/SQL for core application logic and high-volume batch processing.
  • Lead database upgrades, patches, and migration script authoring and rollback planning.
  • Define and enforce PL/SQL standards, testing, and code reviews.
  • Manage optimization of statistics, indexing, and partitioning strategies.
  • Ensure data security controls including encryption and access auditing.

Skills

Oracle database design
PL/SQL development
SQL performance tuning
Data modeling
Database security controls
Mentoring / leadership
Agile development

Education

Bachelor’s degree in CIS / computer science / engineering / MIS / mathematics
Oracle Certified Professional (optional)

Tools

Oracle Enterprise Manager
SQL Developer
Data Pump

Job description

Job Details: Job Location: Texas Municipal Retirement System - Austin, TX 78731, Position Type: Full Time, Salary Range: $130,000.00 - $170,000.00 Salary/year,

Job Summary

The Senior Application Database Administrator is an expert in Oracle database design, PL/SQL development, and application to database performance tuning. This role serves as the technical authority for the data layer supporting TMRS business applications, setting standards for schema design, database code quality, query performance, and data security. This role will work within the IS Department and will also work very closely with Business stakeholders, Software Engineers, Business Analysts, Infrastructure Database Administrators, Information Security, and other IS Department teams.

Key Responsibilities
  • Expert understanding of Oracle database design; architect and maintain schemas, tables, indexes, partitions, views, materialized views, sequences, types, and packages supporting enterprise applications.
  • Serve as design authority for the application data layer; review and approve data model and schema changes proposed by development teams prior to implementation.
  • Write, optimize, and maintain complex PL/SQL including packages, stored procedures, functions, and triggers supporting core application logic and high-volume batch processing.
  • Establish and enforce PL/SQL coding, exception handling, and unit testing standards; lead peer code review for all database logic entering production.
  • Diagnose and remediate complex performance problems using AWR, ASH, ADDM, SQL Monitor, execution plan analysis, and SQL plan management.
  • Own optimizer statistics, indexing, and partitioning strategy across application databases; establish and publish performance baselines for critical batch and transactional workloads.
  • Lead the database components of application upgrades, vendor patches, and major releases, including migration script authoring, validation, and rollback planning.
  • Design and support data movement processes including replication, Data Pump, ETL, environment refreshes, and masking of member data in non-production environments.
  • Define and implement database security controls including least-privilege roles, profiles, grants, auditing, encryption, and redaction of sensitive member data.
  • Partner with Infrastructure Database Administrators on capacity planning, high availability, backup and recovery validation, and disaster recovery testing.
  • Mentor mid-level and junior staff and developers on SQL efficiency, data modeling, and Oracle features; serve as the escalation point for database incidents.
  • Work with Business Analysts to estimate and architect solutions.
  • Investigate new technologies and assess their viability and usefulness in current and future projects.
  • Improve process, performance, and security of developed applications and integrations.
  • Produce and maintain data models, data dictionaries, and runbooks, and supply evidence supporting internal audit, SOC 1, and state security control requirements.
  • Contribute new viewpoints and strategies to stimulate growth.
  • Agile development experience is a plus.
  • Ability to use and integrate approved AI solutions.
  • After hours support as needed, including participation in an on-call rotation supporting 24/7 availability.
  • Other duties as assigned
  • Follow all applicable policies and procedures including all security policies.
Qualifications
Education & Experience
Hands-on experience with
  • Oracle Database 19c or later, administration and development
  • PL/SQL (packages, procedures, functions, triggers, bulk processing, dynamic SQL)
  • SQL performance tuning (AWR, ASH, ADDM, execution plans, SQL plan baselines)
  • Data modeling, partitioning, and index strategy for high-volume applications
  • Oracle Enterprise Manager, SQL Developer, and Data Pump
  • Database security controls (roles, profiles, auditing, encryption, data redaction)
Required
  • Bachelor’s degree in CIS, computer science, engineering, MIS, mathematics or related field and a minimum of 6 years of hands‑on Oracle database experience, including at least 2 years writing and tuning production PL/SQL.
  • Demonstrated experience leading database design and performance work across multiple concurrent application releases.
Preferred
  • Oracle Certified Professional (Database Administrator or PL/SQL Developer)
  • Oracle Data Guard, Advanced Security, or Oracle APEX
  • Database DevOps tooling (Liquibase, Flyway, or Redgate) with Git‑based version control and CI/CD pipelines
  • Scripting in Bash, PowerShell or Python for automation
  • Public sector, pension administration, or financial services data environment
  • Oracle Cloud Infrastructure, Azure, or AWS database services
  • Linux and Windows server administration
Physical Requirements

Sedentary work: Exerting up to 10 pounds of force. Ability to perform the essential job functions safely and successfully consistent with federal, state, and local standards.

TMRS Overview

Texas Municipal Retirement System (TMRS) is a trusted partner to more than 945 cities across Texas, providing retirement, disability, and survivor benefits to over 260,000 public servants and their families. We are proud to be recognized as an example of fiduciary excellence through our management of more than $52 billion in Trust Fund assets.

At TMRS, every role supports our mission: providing secure lifetime income to our members. Our work gives back to communities across Texas, and we take pride in doing it with integrity, accountability, and a commitment to excellence.

Compensation and Benefits
  • Starting base salary (based on experience and qualifications)
  • Participation in TMRS pension plan, with a 2:1 organization match
  • Optional participation in a 457(b) deferred compensation plan
  • Medical, dental, and vision insurance at no cost to employees
  • Hybrid work opportunities; 12 paid holidays; generous leave
  • Modern, centrally located Austin office

TMRS is an Equal Opportunity Employer.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Software Engineer (SR)
Software Engineer (SR)

Texas-Municipal-Retirement-System • Austin (TX)

Hybrid
USD 110,000 - 150,000
Hybrid work opportunities
Onsite presence three days a week
Medical, dental, vision insurance
Senior Data Engineer
Senior Data Engineer

Texas-Municipal-Retirement-System • Austin (TX)

Hybrid
USD 120,000 - 180,000
Hybrid work opportunities
12 paid holidays
Generous leave
Oracle Database Administrator (Austin)
Oracle Database Administrator (Austin)

State of Texas • Austin (TX)

On-site
USD 95,000 - 128,000
Family friendly workplace
Competitive salary
Retirement plan
+3
Member Service Center Analyst
Member Service Center Analyst

TEXAS MUNICIPAL RETIREMENT SYSTEM • Austin (TX)

Hybrid
USD 59,000 - 60,000
Medical insurance
Dental insurance
Vision insurance
+3
Risk Management Application Administrator
Risk Management Application Administrator

Texas Association of School Boards Inc • Austin (TX)

On-site
USD 61,000 - 94,000
Risk Management Application Administrator
Risk Management Application Administrator

Tx Assoc Of School Boa • Austin (TX)

On-site
USD 61,000 - 94,000
Onsite daycare
Onsite gym
Wellness program
+3
Portfolio Manager - Private Credit
Portfolio Manager - Private Credit

TEXAS MUNICIPAL RETIREMENT SYSTEM • Austin (TX)

On-site
USD 85,000 - 115,000
Competitive pay based on experience
Participation in TMRS pension plan with 2:1 organization match
Medical, dental, and vision insurance at no cost to employees
+2
Senior Oracle DB Architect & Performance Lead (Hybrid)
Senior Oracle DB Architect & Performance Lead (Hybrid)

Texas Municipal Retirement System • Austin (TX)

Hybrid
USD 130,000 - 170,000
Hybrid work opportunities
Health insurance
12 paid holidays
+1
AI/ML Data Engineering Intern (Summer 2026)
AI/ML Data Engineering Intern (Summer 2026)

TSABAA • Austin (TX)

Hybrid
USD 32,000 - 34,000
On-site work
Mentoring
Training opportunities
Application Developer Senior
Application Developer Senior

Teacher Retirement System of Texas • Austin (TX)

On-site
USD 108,000 - 135,000