Senior Oracle Database Administrator

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.

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.

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.); Successful completion of the Nlets fingerprinting background assessment; 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; 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; This position is not eligible for sponsorship now or in the future.

Nice to have

Knowledge of SQL Server, PostgreSQL, and MySQL