Senior Consultant | (Oci + Oracle Dba) | Delhi | Oracle

Senior Consultant | (OCI + Oracle DBA) | Delhi | Oracle

• Job requisition ID : 114166
• Location: Delhi
• Entity: Deloitte Touche Tohmatsu India LLP

The team

Enterprise technology must do much more than keep the wheels turning; it is the engine that drives functional excellence and the enabler of innovation and long-term growth. Learn more about ET&P

Key Responsibilities

• Manage and administer Oracle databases across on-premises and OCI environments.

• Perform database installation, configuration, upgrades, patching, backup, recovery, and performance tuning.

• Design and manage Oracle databases on OCI, including appropriate compute, storage, networking, and database services.

• Work with OCI services such as OCI Compute, Object Storage, VCN, Load Balancer, IAM, Monitoring, Logging, and related services.

• Support database migration and modernization initiatives from on-premises to OCI.

• Develop and optimize SQL, PL/SQL procedures, functions, packages, triggers, and queries.

• Perform SQL and database performance tuning using execution plans, indexing, partitioning, and other optimization techniques.

• Implement and manage high availability and disaster recovery solutions such as RAC, Data Guard, and backup/recovery strategies.

• Monitor database health, capacity, performance, and availability and proactively resolve issues.

• Implement database security, access controls, encryption, auditing, and compliance requirements.

• Automate routine DBA activities using Shell scripting, Python, or OCI automation tools.

• Troubleshoot production issues and participate in incident, problem, and change management processes.

• Collaborate with application, data engineering, cloud, and infrastructure teams to support end-to-end solutions.

• Prepare technical documentation, operational procedures, and database architecture/design documents.

Required Technical Skills

Oracle Database

• Oracle Database 12c/19c/21c

• SQL and PL/SQL

• Performance tuning and troubleshooting

• Backup and recovery

• RMAN

• Oracle RAC

• Data Guard

• Partitioning and indexing

• Database security and access management

OCI

• OCI Compute

• OCI Autonomous Database

• OCI Base/Exadata Database Services

• OCI Object Storage

• VCN and networking fundamentals

• IAM

• Monitoring and Logging

• OCI Vault / Key Management

• OCI CLI

Development & Automation

• Strong SQL/PLSQL development skills

• Shell scripting

• Python scripting is desirable

• Git / CI-CD exposure is an advantage