Senior Oracle 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. Knowledg...