Sher khan

• Reduced priority incident resolution time from 1 hour to 35 minutes; brought overall average resolution time down from
14 hours to 4 hours
• Played a key role in migrating on-prem Oracle workloads to cloud (OCI/AWS), ensuring minimal downtime and zero data
loss
• Designed and implemented proactive monitoring and alerting systems using OEM, shell scripts, and third-party tools —
significantly improving uptime and SLA adherence
• Led a small team of DBAs in a 24x7 environment, mentoring junior staff, reviewing critical changes, and ensuring
compliance with change management processes
• Spearheaded the clean-up of legacy objects and unused schemas, improving database performance and reducing storage
usage by 20%
• Conducted multiple disaster recovery drills and ensured business continuity through thorough documentation and
runbook preparation
• Collaborated with cross-functional teams (Dev, Infra, App Support) to optimize slow-running queries and implement
indexing strategies that improved performance by up to 50%
• Implemented partitioning, data archival, and purging strategies for large-volume tables to enhance performance and
maintain compliance

Role:
• Installation & Configuration of Oracle database on Local System and Remote System.
• Involved in the process of Upgradation/Migration from Greenplum to SYBASE IQ.
• Continuously monitoring and updating the Backup & Recovery strategy and also monitoring scheduled jobs of backup and
restore procedure for database.
• Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for various categories of User
Support
• Implemented database refresh and troubleshooting orphaned users
• Monitoring database Server agent jobs/maintenance plans
• Co-coordinating with Development, Test and Support teams for server wide issues. Running the scripts send from development
team and troubleshooting any minor issues in the code, solving deadlock issues by discussing with Application team

Role:
• Installation & Configuration of Oracle Database 9i/10g.
• Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for various categories of User
Support
• Implemented database refresh and troubleshooting orphaned users
• Monitoring SQL Server agent jobs/maintenance plans
• Co-coordinating with Development, Test and Support teams for server wide issues. Running the scripts send from development
team and troubleshooting any minor issues in the code, solving deadlock issues by discussing with Application team

Role:
• Installation & Configuration of Oracle Databases on Linux Platform
• Managing the roles and privileges.
• Killing unwanted user sessions or processes
• Archive log destination Monitoring.
• Database Backup and recovery.
• Supported the senior DBA in regular activities.