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