Job Title: Senior Consultant | (OCI + Oracle DBA) | Mumbai - BNG | Oracle
Key Responsibilities:
🔧 OCI Cloud Operations
- Design and manage OCI infrastructure including compute, storage, networking, and database services.
- Provision, configure, and monitor Oracle Cloud services (e.g., Autonomous DB, DB Systems, Object Storage, VCNs, Load Balancers).
- Implement OCI-native security best practices: compartments, IAM policies, encryption, etc.
- Create automation scripts for infrastructure provisioning using Terraform or OCI CLI.
- Optimize cost, performance, and scalability of OCI resources.
🛠️ Oracle Database Administration
- Install, configure, and upgrade Oracle databases in cloud and hybrid environments.
- Perform backup/recovery operations using RMAN, Data Pump, and Oracle Recovery Manager.
- Monitor and tune performance of Oracle databases (memory, I/O, SQL tuning).
- Manage High Availability (HA) and Disaster Recovery (DR) setups using RAC, Data Guard, GoldenGate.
- Patch databases and perform regular maintenance and health checks.
⚙️ DevOps & Automation
- Automate database provisioning and deployment pipelines using scripting (Shell, Python) and CI/CD tools.
- Support Infrastructure as Code (IaC) and cloud-native automation workflows.
- Develop and manage monitoring/alerting systems for proactive issue resolution.
🔒 Security & Compliance
- Implement database security: user management, auditing, encryption, and access controls.
- Ensure compliance with internal policies and external regulations (e.g., GDPR, SOX).
- Assist in cloud security reviews and audits.
📊 Collaboration & Documentation
- Collaborate with DevOps, Cloud Architects, Application Developers, and Security teams.
- Document architecture designs, SOPs, and change management procedures.
- Provide mentoring to junior team members and support on-call rotations as needed.
Qualifications:
- Bachelor's degree in Computer Science, Information Systems, or related field.
- 5+ years of experience as an Oracle DBA, with at least 2–3 years on Oracle Cloud Infrastructure (OCI).
- Deep experience with Oracle 12c/19c/21c databases.
- Strong skills in SQL, PL/SQL, RMAN, and Oracle Enterprise Manager (OEM).
- Solid knowledge of OCI services: DBaaS, Autonomous Database, Compute, Networking, IAM, Monitoring.
- Experience with Oracle RAC, Data Guard, ASM, and Partitioning.
- Familiarity with Terraform, Ansible, or OCI Resource Manager for automation.
- Understanding of modern DevOps/CI-CD practices and tools.
- Knowledge of Linux/Unix OS for system-level tuning and troubleshooting.
- Excellent troubleshooting, documentation, and communication skills.
Preferred Certifications:
- ✅ Oracle Certified Professional (OCP) – Oracle DBA
- ✅ Oracle Cloud Infrastructure (OCI) Certified Architect / Operations Associate