Deepak Kumar Ojha

Achieved 99.99% availability for financial systems, directly supporting annual revenue of US$623.01 million. Oracle Database Administrator with strong skills in database management, middleware implementation, and performance enhancement. Expertise in backup and recovery, Oracle architecture, and technology roadmap development. Proven track record in vendor management, cloud migration, and driving innovation initiatives to improve organizational efficiency.

• Managing Oracle Database operations in UNIX/Linux, Solaris, HP-UX, and AIX environments, including installation, creation, configuration, and troubleshooting of databases, instances, data files, control files, redo log files, tablespaces, segments, and indexes.
• Installing, configuring, and administering Oracle Identity Directory (OID) (Version: 11.1.1.7.0).
• Patching and upgrading Oracle databases (9i, 10g, 11g, 12c, 19c).
• Migrating Oracle databases and applications from Solaris 10 and Windows to Linux 7.9.
• Installing critical patch updates (CPU patches) for Oracle environments.
• Configuring and managing Oracle Data Guard for disaster recovery.
• Installing and managing Oracle RAC (Real Application Clusters) databases.
• Installing Oracle Discoverer in Oracle Apps environments and ensuring connectivity.
• Administering Oracle E-Business Suite (11i and R12) environments, including patching, cloning, and concurrent manager administration.
• Performing database cloning, sizing, patching, instance management, backup/recovery, and troubleshooting.
• Configuring and monitoring crontab jobs for database health checks and performance metrics (e.g., tablespace size, memory usage, schema object analysis, and more).
• Monitoring and analysing database performance using dynamic views, alert logs, and trace files.
• Managing database backup and recovery strategies using RMAN, Data Pump, Export/Import, and SQL Loader.
• Conducting SQL query tuning using tools like Explain Plan, Auto Trace, SQL Trace, and managing Linux system administration tasks.
• Troubleshooting Oracle client connectivity issues and performing database performance tuning through OEM and other Oracle tools (e.g., Stats pack, Oracle Streams).
• Writing and maintaining UNIX Perl/Shell scripts to automate job creation and scheduling, as well as DB scripting tasks.
• Developing and managing Oracle PL/SQL packages, functions, procedures, triggers, and custom views.
• Administering database security, including user management, profiles, roles, and security audits.

Awards

• Technical Excellence Award: For the architects and engineers and solving most complex problems at SRF Ltd.
• Beacon Award for Transformational Leadership at Filix Consulting Pvt. Ltd.

Accomplishment.

• Successfully executed 7 implementations, 7 upgrades, and 5 support projects, delivering complex solutions with a strong track record.
• Managed Oracle Database and EBS migration from Windows to Linux 8, ensuring seamless transition with minimal downtime.
• Led Oracle EBS upgrade from 12.1.1 to 12.2.12 and Database upgrade from 11.2.0.2 to 19.19.0.0.
• Executed a large-scale upgrade initiative, migrating 50+ critical databases from legacy Oracle 11g/12c to the modern 19c platform.