Senior Database Administrator

Verra Mobility
Mesa, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Mesa, United States of America

Tech stack

Application Release Automation
User Authentication
Bash
Command-Line Interface
Cloud Computing
Databases
Data Manipulation Languages
Database Applications
Database Security
Oracle Data Guard
Disaster Recovery
Perl
Oracle Exadata
Identity and Access Management
Python
Key Management
PostgreSQL
Microsoft SQL Server
MongoDB
MySQL
Oracle
Oracle Applications
Oracle Rac
Performance Tuning
Scrum
Recovery Manager (RMAN)
Shell Script
Software Engineering
Vault (Revision Control System)
PL-SQL
SQL Databases
Backup and Restore
Transaction Processing (Computing)
Scripting (Bash/Python/Go/Ruby)
Load Balancing
Autoscaling
System Availability
Database Optimization
Information Technology
Terraform
Oracle Cloud Infrastructure
Sql Tuning
Oracledb

Job description

Senior Oracle Database Administrator (Sr. DBA) plays a critical role in maintaining and optimizing the databases that support our corporate and municipal clients. This position operates under the guidance of the Database Manager and collaborates closely with cross-functional teams to deliver robust, secure, and scalable database solutions aligned with company initiatives., * 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-SQL tuning, indexing strategies, execution plan analysis, 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, 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.

Requirements

Do you have experience in Technical troubleshooting support?, Do you have a Bachelor's degree?, * 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.
  • Knowledge of SQL Server, PostgreSQL, and MySQL are preferred.
  • 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.)

Personal Skills and Attributes

  • Capable to research and resolve issues with technologies outside of core competency.
  • 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.

About the company

Verra Mobility Values An ideal candidate for this role naturally works in alignment with the Verra Mobility Core Values: * Own It. We focus on high performance and drive toward breakthrough outcomes. Our employees ensure accountability, optimize and align work, focus on the customer, and cultivate innovation. * Do What's Right. We champion integrity and good character. Our team members model ethical behavior, demonstrate good judgment and are courageous. * Choose Courage Over Comfort. We lean into the conversations, decisions and actions that move the business forward, even when they feel uncomfortable. We challenge assumptions, address issues early and prioritize progress over ease. * Win Together. We believe in growing and inspiring people together. We seek people who collaborate, value differences, think and act globally, foster an engaging work environment, and recognize and develop others.

Apply for this position