Senior Database Administrator

Verra Mobility•Mesa, AZ

30d•Hybrid

About The Position

The Senior Oracle Database Administrator (Sr. DBA) is responsible for maintaining and optimizing databases for corporate and municipal clients. This role works under the Database Manager and collaborates with cross-functional teams to deliver secure, scalable database solutions. The position involves designing and implementing database architecture on Exadata and Oracle Cloud Infrastructure (OCI), managing Oracle resources, and overseeing database installations, configurations, patching, upgrades, and maintenance. Key responsibilities include backup and recovery, performance tuning, configuring disaster recovery environments, migrating on-premises databases to Oracle Gov Cloud, and developing Infrastructure as Code. The role also focuses on implementing high availability strategies, enforcing security policies, managing user access, leading migrations to OCI, managing the OEM environment, troubleshooting issues, and performing database cloning. Automation of tasks using various scripting languages is essential, along with a basic understanding of other database systems. The Sr. DBA will also assess and suggest process improvements, promote adherence to standards, and foster learning within the DBA team, setting a professional example.

Requirements

BA in Computer Science or the equivalent combination of education, training, and experience
8+ years of Oracle database administration experience, with a focus on both on-prem SQL Server and Oracle Cloud Infrastructure (OCI).
3+ years of Oracle cloud Infrastructure (OCI) experience.
Ability to own and manage tasks and/or projects with minimal direction
Ability to successfully troubleshoot issues/provide solutions with minimal direction
Ability to learn new technologies/applications with minimal direction
‘Can do’ attitude towards solving problems and completing tasks
Capable of researching and resolving issues with technologies outside of core competency
Experience in Oracle RAC, ASM, Exadata (on-prem or cloud), Active Data Guard, Performance tuning, RMAN, OCI Goldengate Replication.
Strong knowledge of Linux OS administration.
Strong scripting skills such as OCI CLI, Python, Shell scripting, Perl, etc.
Backup and all facets of recovery (simple restore, point in time recovery, etc.)
Strong technical and interpersonal skills with the ability to work with minimal supervision within a global staffing environment.
Proven analytical/problem solving skills irrespective of database technology.
Ability to adapt in a dynamic environment.
Ability to effectively communicate with technical staff (applications development and technical services) and management.
Keen attention to detail.
Willing to support operations in a 24X7 environment, ensuring uptime and responsiveness.
Ability to learn new technologies/applications with minimal direction.
Extensive experience working in a team-oriented, collaborative environment.
Must be locally located and comfortable working a 3 days in office hybrid model and 2 days remote.

Nice To Haves

Knowledge of SQL Server, PostgreSQL, and MySQL are preferred.

Responsibilities

Design and implement database architecture on Exadata systems (X4-X10) and Oracle Cloud Infrastructure (OCI).
Manage Oracle resources on Exadata systems, Autonomous Transaction Processing (ATP-D), and OCI Goldengate.
Oversee installation, configuration, patching, upgrades, and maintenance of Oracle databases (19c or later).
Perform backup and recovery using RMAN, Data Guard, and OCI-native tools.
Optimize performance, including SQL tuning, indexing strategies, execution plan analysis, and AWR/ASH reports.
Configure and maintain Oracle Active Data Guard and disaster recovery environments.
Perform duties related to migrating on-prem Oracle databases into the Oracle Gov Cloud infrastructure.
Develop and maintain Infrastructure as Code (IaC) using Terraform/Resource Manager.
Implement high availability strategies, autoscaling, and load balancing.
Enforce database security policies like encryption, auditing, access control, and vault key management.
Manage user roles, privileges, authentication, and identity integration both On-prem and OCI (OCI IAM / IDCS).
Lead on-premises Oracle DB migrations to OCI using Data Pump / Transportable Tablespaces, GoldenGate, RMAN backup/restore workflows.
Manage OEM environment including patching, upgrades etc.
Analyze incidents, troubleshoot issues, and implement root-cause fixes, resolve issues with external and internally developed database applications.
Perform database cloning operations from production to test and development environments on on-prem and OCI autonomous databases.
Implement DDL/DML scripts in support of SCRUM application release cycles.
Automate recurring tasks through a combination of SQL, PL/SQL, or scripting languages such as Perl, Bash, OCI CLI, Python, etc.
Basic knowledge and logical understanding of other databases like PostgreSQL, MySQL, MSSQL, Mongo databases etc.
Assess and suggest opportunities for application and process improvement.
Promote adherence to departmental/software development standards.
Promote learning, understanding, and the general enablement of the DBA team.
Set a professional example for the team through model behavior, superior performance, and proper attendance.
Managing Transparent Data Encryption (TDE) for both data at rest and data in transit.