Oracle Cloud Database Administrator

Position Overview:

The Senior Oracle Cloud Database Administrator is responsible for architecting, implementing, securing, and optimizing Oracle Cloud-based database solutions utilized by our corporate and municipal customers. This role includes managing Oracle Autonomous Databases, Oracle Cloud Infrastructure (OCI) DB Systems, Exadata Cloud Services, and database migrations to the cloud. The Senior Database Administrator i ensures high availability, performance tuning, automation, and compliance across mission-critical database environments. This individual will work under the guidance of the Database Manager to develop/support database solutions to support various company initiatives.

Essential Responsibilities:

• Design and implement scalable database architectures on Oracle Cloud Infrastructure (OCI).
• Manage OCI database services including Autonomous Transaction Processing (ATP‑D) and OCI GoldenGate.
• Oversee installation, configuration, patching, upgrades, and lifecycle maintenance of Oracle Databases (19c and later).
• Perform backup and recovery operations using RMAN, Data Guard, and OCI‑native tooling.
• Optimize database performance through SQL tuning, indexing strategies, execution plan analysis, and AWR/ASH diagnostics.
• Configure and maintain Oracle Data Guard, Active Data Guard, and full disaster‑recovery environments.
• Lead migrations of on‑prem Oracle databases into Oracle GovCloud using best‑practice methods.
• Manage OCI resources including compute instances, databases, storage, networking, and block/object storage.
• Develop and maintain Infrastructure‑as‑Code using Terraform and OCI Resource Manager.
• Implement high‑availability strategies, autoscaling, and load‑balancing architectures.
• Enforce database security policies including encryption, auditing, access control, and Oracle Vault key management.
• Manage user roles, privileges, authentication, and identity integration with OCI IAM and IDCS.
• Design and execute Oracle on‑prem to OCI migrations using Data Pump, Transportable Tablespaces, GoldenGate, or RMAN backup/restore.
• Implement proactive monitoring using OCI Monitoring, Oracle Enterprise Manager, and Log Analytics.
• Analyze incidents, troubleshoot complex issues, and deliver root‑cause resolutions for internal and external database applications.
• Perform database cloning with data masking from production to lower environments across on‑prem and OCI Autonomous Databases.
• Implement DDL/DML scripts in alignment with SCRUM‑based application release cycles.