Senior Oracle DB Architect & Performance Lead (Hybrid)

Texas-Municipal-Retirement-System; Austin (TX); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Texas Municipal Retirement System in Austin, TX is seeking a Senior Application Database Administrator with deep Oracle expertise to design, implement, and optimize our data layer across enterprise applications. You will establish standards for schema design, code quality, and data security, and partner with IS colleagues and business stakeholders to deliver high-volume batch processing efficiently.

Responsibilities include leading database design decisions, writing PL/SQL, tuning performance,

Qualifications

• 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.
• Hands-on experience with Oracle Database 19c or later, administration and development.
• Demonstate strong PL/SQL development and performance tuning skills.
• Experience leading database design and performance work across multiple concurrent releases.
• Knowledge of Oracle Enterprise Manager, SQL Developer, Data Pump, and database security controls.

Responsibilities

• Architect and maintain schemas, tables, indexes, partitions, views, materialized views, sequences, types, and packages supporting enterprise applications.
• Write, optimize, and maintain complex PL/SQL including packages, stored procedures, functions, and triggers supporting core application logic and high-volume batch processing.
• Lead code reviews and enforce PL/SQL coding standards; review data model changes prior to implementation.
• Diagnose performance problems using AWR, ASH, ADDM, SQL Monitor, and execution plan analysis.
• Own optimizer statistics, indexing, and partitioning strategy; publish performance baselines for workloads.
• Design and support data movement processes including replication, Data Pump, ETL, environment refreshes, and masking in non-production environments.
• Mentor mid-level and junior staff; participate in upgrades, patches, rollback planning; collaborate with stakeholders.

Skills

Oracle DBA

PL/SQL development

Performance tuning

Data modeling

SQL optimization

Team mentoring

Education

Bachelor's degree in CIS/CS/Engineering/MIS

Tools

Oracle Enterprise Manager

SQL Developer

Data Pump

Liquibase / Flyway / Redgate

Git-based version control / CI/CD

Job description

Texas Municipal Retirement System in Austin, TX is seeking a Senior Application Database Administrator with deep Oracle expertise to design, implement, and optimize our data layer across enterprise applications. You will establish standards for schema design, code quality, and data security, and partner with IS colleagues and business stakeholders to deliver high-volume batch processing efficiently.

Responsibilities include leading database design decisions, writing PL/SQL, tuning performance,