Oracle Database Administration Role
Job Description:
The primary function of this role is to oversee the daily operations and maintenance of Oracle databases hosted on AWS, ensuring they operate at peak performance levels. This includes administering shutdowns, restarts, patching, log cleanup, backup/recovery, and performance tuning.
Key Responsibilities:
* Administer and maintain Oracle databases across various AWS environments (RDS and/or EC2).
* Perform routine database tasks such as shutdowns, restarts, patching, log cleanup, backup/recovery, and performance tuning to ensure optimal database functioning.
* Implement secure communication protocols between applications and databases using SSL/TLS encryption.
* Configure and manage RMAN for backup, restore, and disaster recovery operations, including data migration activities in non-production and production environments.
* Support replication efforts using Oracle GoldenGate (OGG) for one-time data loads and real-time replication.
* Monitor and optimize database performance, making necessary adjustments to improve overall efficiency.
* Manage replication between primary and standby databases using Data Guard or GoldenGate.
Requirements:
* Possess strong hands-on experience with Oracle Database administration (12c, 19c or higher).
* Experience managing Oracle databases on AWS, including both RDS and EC2.
* Proficiency in utilizing Oracle GoldenGate for data replication.
* Operational knowledge of RMAN for backup, recovery, and configuration.
* Proven skills in database performance tuning and troubleshooting.
* Familiarity with Data Guard and GoldenGate for database replication, with a focus on active-passive setups and role definitions.
* Ability to configure Fast-Start Failover (FSFO) and monitor Data Guard status.
* Proficient in proactive monitoring using OEM or custom scripts.
* Experience performing failover procedures and validating application connectivity post-failover.
* Knowledge of implementing SSL/TLS for secure database connections.
* Scripting skills (e.g., Shell, Bash, Python) for automating routine tasks.
* Solid understanding of networking, storage, and security within cloud environments.
* Nice to have: Experience with CI/CD and Infrastructure-as-Code tools.
Documentation & Governance:
* Ability to review and contribute to LLDs, runbooks, and solution documentation.
* Experience auditing and validating third-party or vendor deliverables.
* Familiarity with OATS and DOATs processes in large enterprise environments.