Hands-on experience in Oracle 11g, 12c, 19c, Oracle RAC, ASM, RMAN, Data Guard, Grid Infrastructure, OEM, Oracle Restart, and SQL Performance Tuning. Proficient in database backup & recovery strategies, disaster recovery planning, user and security management, tablespace administration, database upgrades, patching (RU/PSU), Data Pump, GoldenGate basics, and automation using Shell scripting.
Experienced in resolving production incidents, performing root cause analysis (RCA), supporting 24x7 production environments, implementing database best practices, capacity planning, and coordinating with application, infrastructure, and network teams to ensure maximum database availability and performance.
Key Responsibilities :
• Installed and configured Oracle Database, Grid Infrastructure, RAC, and ASM.
• Managed production, development, testing, and DR databases.
• Performed database backup, restore, recovery, and disaster recovery testing using RMAN.
• Administered Oracle RAC, ASM, and Data Guard environments.
• Performed quarterly patching using OPatch and applied Release Updates (RU).
• Monitored database health, availability, and performance using OEM, AWR, ASH, and ADDM reports.
• Tuned SQL queries and optimized database performance.
• Managed users, roles, profiles, and database security.
• Performed database cloning, migration, upgrades, and refresh activities.
• Resolved critical production issues within SLA and prepared RCA reports.
• Worked closely with application, system, storage, and network teams during deployments and maintenance.
• Supported 24×7 production environments with on-call support.
Core Expertise :
• Oracle Database Administration (11g, 12c, 19c)
• Oracle RAC Administration
• Oracle ASM Administration
• Oracle Grid Infrastructure
• Oracle Data Guard Administration
• Oracle RMAN Backup & Recovery
• Database Installation & Configuration
• Database Cloning (RMAN & Active Database Duplication)
• Database Migration & Upgrade
• Oracle Performance Tuning (SQL & Database)
• AWR, ASH, ADDM Report Analysis
• Execution Plan Analysis
• SQL Tuning Advisor & SQL Profiles
• Oracle Enterprise Manager (OEM)
• User, Role & Privilege Management
• Tablespace & Datafile Management
• Listener & TNS Administration
• Patching (RU, PSU, OPatch)
• Database Security (TDE, Auditing, Password Policies)
• Oracle Data Pump (Export/Import)
• Shell Scripting
• Linux Administration (RHEL/OEL)
• Production Support (24×7)
• Incident, Change & Problem Management
• Root Cause Analysis (RCA)
• High Availability & Disaster Recovery
Available for immediate interview and willing to relocate.
Mohammad Naasir Ansari
+918830818188