Description

Responsibilities

Enterprise Database Administration

• Manage, monitor, and support Oracle database environments (11g through 23c) across OCI, AWS (EC2/RDS for Oracle), and on-prem platforms.
• Administer multi-tenant architectures (CDB/PDB), RAC, and Data Guard configurations.
• Ensure database uptime, availability, and performance meet enterprise SLAs.

Cloud & Hybrid Architecture

• Design and manage Oracle deployments in OCI (Autonomous DB, Exadata Cloud Service, DB Systems).
• Support Oracle databases running in AWS (EC2-hosted Oracle, RDS Oracle where applicable).
• Implement hybrid connectivity strategies (VPN, FastConnect, Direct Connect).
• Lead cloud migration and modernization initiatives (lift-and-shift, re-platforming).

Performance & Capacity Management

• Proactively monitor performance using AWR, ASH, OEM, and cloud-native tools.
• Tune SQL, PL/SQL, and database configurations for optimal performance.
• Forecast capacity and storage growth across environments.

Backup, Recovery & High Availability

• Implement and manage RMAN backup strategies across hybrid environments.
• Maintain and test disaster recovery solutions (Data Guard, Active Data Guard).
• Ensure RPO/RTO targets are met and validated regularly.

Security & Compliance

• Enforce database security standards including encryption (TDE), patching, and access controls.
• Partner with security and compliance teams to support audits and regulatory requirements.
• Implement least-privilege access and database activity monitoring.

Automation & DevOps Enablement

• Develop automation using Shell, Python, Ansible, Terraform, or OCI Resource Manager.
• Integrate database operations into CI/CD pipelines.
• Standardize provisioning, patching, and configuration management.

AI Tool Integration

• Proficiency in managing AI-powered database features and other LLM.

Data Governance & Quality Enablement

• Support enterprise data initiatives including data cataloging, lineage, and quality controls.
• Ensure database environments align with governance standards and metadata management practices.
• Collaborate with data engineering and analytics teams to optimize data accessibility.

Operational Excellence

• Provide 24/7 support as part of an on-call rotation.
• Troubleshoot complex incidents and perform root cause analysis.
• Maintain documentation, runbooks, and SOPs for database operations.
• Proven ability to lead projects, work both independently and in a team environment, take ownership of projects from the beginning to the finish line.
• Able to prioritize tasks and make adjustment as needed.

Qualifications

• Multiple years of hands-on enterprise Oracle database support.
• Strong SQL and PL/SQL background.
• Good command of Linux Operating system (Redhat or Oracle) and Shell scripting.
• Deep understanding of ORACLE database concepts, including process, memory, storage, ASM management, DR and Cloud infrastructure.

Required Skills

• Strong SQL and PL/SQL background.
• Good command of Linux Operating system (Redhat or Oracle) and Shell scripting

Key Skills

Education

Bachelor's degree