Senior Database Administrator

Position Overview:

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.

Essential 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—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.

Qualifications: 

• 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 wor