Senior Application Database Administrator
About The Position
The Senior Application Database Administrator is the technical authority for the data layer supporting TMRS business applications. The role requires expertise in Oracle database design, PL/SQL development, and application-to-database performance tuning, and sets standards for schema design, database code quality, query performance, and data security. The administrator works within the IS Department and closely with business stakeholders, software engineers, business analysts, infrastructure database administrators, Information Security, and other IS teams. The position leads database design and performance work across application releases, develops and maintains complex PL/SQL, supports application upgrades and data movement, defines database security controls, and partners with infrastructure teams on capacity, availability, backup, recovery, and disaster recovery. It also mentors staff and developers, supports database incidents, maintains documentation and audit evidence, and contributes to process, performance, and security improvements. After-hours support may be needed, including participation in an on-call rotation supporting 24/7 availability. The role is based in Austin, Texas, with hybrid work opportunities.
Requirements
- Bachelor’s degree in CIS, computer science, engineering, MIS, mathematics, or a related field.
- At least 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.
- Experience administering Oracle databases and developing PL/SQL, including packages, procedures, functions, triggers, bulk processing, and dynamic SQL.
- Experience with SQL performance tuning, including AWR, ASH, ADDM, execution plans, and SQL plan baselines.
- Experience with data modeling, partitioning, and index strategy for high-volume applications.
- Experience with Oracle Enterprise Manager, SQL Developer, and Data Pump.
- Experience with database security controls, including roles, profiles, auditing, encryption, and data redaction.
- Demonstrated experience leading database design and performance work across multiple concurrent application releases.
- Ability to perform sedentary work, exerting up to 10 pounds of force, and perform essential job functions safely and successfully consistent with applicable standards.
Nice To Haves
- Agile development experience.
- Oracle Certified Professional certification as a Database Administrator or PL/SQL Developer.
- Experience with Oracle Data Guard, Advanced Security, or Oracle APEX.
- Experience with database DevOps tools such as Liquibase, Flyway, or Redgate, Git-based version control, and CI/CD pipelines.
- Experience scripting in Bash, PowerShell, or Python for automation.
- Experience in a public sector, pension administration, or financial services data environment.
- Experience with Oracle Cloud Infrastructure, Azure, or AWS database services.
- Linux and Windows server administration experience.
Responsibilities
- Architect and maintain Oracle schemas, tables, indexes, partitions, views, materialized views, sequences, types, and packages for enterprise applications.
- Serve as design authority for the application data layer and review and approve development teams’ data model and schema changes before implementation.
- Write, optimize, and maintain complex PL/SQL packages, stored procedures, functions, and triggers supporting application logic and high-volume batch processing.
- Establish and enforce PL/SQL coding, exception-handling, and unit-testing standards, and lead peer code reviews for database logic entering production.
- Diagnose and remediate performance problems using AWR, ASH, ADDM, SQL Monitor, execution plan analysis, and SQL plan management.
- Own optimizer statistics, indexing, and partitioning strategies, and establish and publish performance baselines for critical workloads.
- Lead database components of application upgrades, vendor patches, and major releases, including migration scripts, validation, and rollback planning.
- Design and support data movement processes, including replication, Data Pump, ETL, environment refreshes, and masking 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, and serve as an escalation point for database incidents.
- Work with Business Analysts to estimate and architect solutions.
- Investigate new technologies and assess their viability and usefulness for current and future projects.
- Improve the process, performance, and security of developed applications and integrations.
- Produce and maintain data models, data dictionaries, and runbooks, and provide evidence for internal audit, SOC 1, and state security control requirements.
- Contribute new viewpoints and strategies to stimulate growth.
- Use and integrate approved AI solutions.
- Provide after-hours support as needed, including participation in an on-call rotation supporting 24/7 availability.
- Perform other duties as assigned and follow applicable policies and procedures, including security policies.
Benefits
- Participation in the 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
