Senior Application Database Administration
About The Position
The Senior Application Database Administration is the technical authority for the data layer supporting TMRS business applications. The role leads Oracle database design, PL/SQL development, and application-to-database performance tuning, establishing standards for schema design, database code quality, query performance, and data security. It 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; supports upgrades, vendor patches, and major releases; and develops and maintains data movement processes and database security controls. It also partners on capacity planning, availability, backup and recovery, and disaster recovery testing; mentors staff and developers; investigates new technologies; and maintains data models, data dictionaries, and runbooks. After-hours support may be required, including participation in an on-call rotation supporting 24/7 availability.
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.
- At least 2 years writing and tuning production PL/SQL.
- Hands-on experience with Oracle Database 19c or later, including administration and PL/SQL development.
- Experience with PL/SQL packages, procedures, functions, triggers, bulk processing, and dynamic SQL.
- SQL performance-tuning experience with 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 to perform essential job functions safely and successfully consistent with federal, state, and local standards.
Nice To Haves
- Agile development experience.
- Oracle Certified Professional certification in Database Administration or PL/SQL Development.
- Experience with Oracle Data Guard, Advanced Security, or Oracle APEX.
- Experience with database DevOps tooling such as Liquibase, Flyway, or Redgate, with Git-based version control and CI/CD pipelines.
- Scripting experience 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’ proposed data model and schema changes before implementation.
- Write, optimize, and maintain complex PL/SQL packages, stored procedures, functions, and triggers for application logic and high-volume batch processing.
- Establish and enforce PL/SQL coding, exception-handling, and unit-testing standards; lead peer reviews of database logic entering production.
- Diagnose and remediate database performance problems using AWR, ASH, ADDM, SQL Monitor, execution plan analysis, and SQL plan management.
- Own optimizer statistics, indexing, and partitioning strategies across application databases, and publish performance baselines for critical batch and transactional workloads.
- Lead database components of application upgrades, vendor patches, and major releases, including migration scripts, validation, and rollback planning.
- Design and support 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 an escalation point for database incidents.
- Work with Business Analysts to estimate and architect solutions.
- Investigate new technologies and assess their 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
