RUPESH TANNIR

Sr.Oracle Exadata DBA | Oracle Exadata | ExaCC | ExaCS |

Senior Oracle Exadata DBA with extensive expertise in administering complex Oracle database environments across investment banking and critical banking applications. Achievements include successfully leading database upgrades and migrations from Oracle 11g/12c to 19c, managing over 100 production databases with 99.99% availability, and excelling in proactive performance monitoring and troubleshooting. Dedicated to delivering high-quality database solutions that enhance operational efficiency and application performance. Recognized for strong leadership in infrastructure migration and database management initiatives.

Mumbai, MH 400008
0
Skills
0
Certifications
Work Experience
Sr.Exadata DBA
UBS (Velloni)Mumbai, India
Dec 2024 — Present
  • Administer Oracle databases supporting Investment Banking, Wealth Management, and Group Functions applications
  • Lead Oracle database upgrade and migration activities from Oracle 11g/12c to Oracle 19c environments
  • Successfully migrate Oracle databases between RHEL 7 and RHEL 8 platforms
  • Execute database decommissioning activities through manual and automated processes
  • Manage Oracle RAC and Data Guard environments ensuring high availability and business continuity
  • Perform Data Guard Switchover and Switchback activities during planned DR drills
  • Collaborate with application teams to ensure successful migration and deployment activities
  • Perform proactive performance tuning using AWR, ASH, SQL Monitor, and Execution Plans
  • Cell Disk Creation and Management : Worked on cell disk creation and management within the Oracle Exadata infrastructure. Explored storage configuration and cell disk management operations to support efficient storage utilization.
  • ExaScale Infrastructure Provisioning: Worked on ExaScale infrastructure provisioning and configuration workflows. Gained hands-on exposure to provisioning processes and the underlying Exadata infrastructure architecture.
  • Flash Cache Disk Management: Configured and managed Flash Cache components in the Oracle Exadata environment. Explored flash cache management and its role in optimizing database I/O performance.
  • Bastion Tunnel Configuration and Management : Configured and managed bastion tunnels to establish secure access to cloud resources. Worked with secure connectivity mechanisms for accessing and administering cloud infrastructure.
  • Oracle Autonomous Database Management and Connectivity: Worked on Oracle Autonomous Database provisioning, configuration, and management. Configured database connectivity and explored secure connection methods for accessing Autonomous Database instances.
Senior Oracle DBA
Citi Bank (Wipro)Mumbai
May 2023 — Dec 2024
  • Manage 100+ production Oracle databases supporting critical banking applications with 99.99% availability
  • Perform proactive monitoring and troubleshooting of database performance issues
  • Analyze blocking sessions, locking issues, and long-running SQL queries
  • Conduct schema statistics gathering and performance optimization activities
  • Diagnose performance bottlenecks using AWR, ASH, ADDM, and SQL execution plans, reducing query response times by up to 40%
  • Successfully execute quarterly PSU/RU patching activities across production and non-production environments with zero unplanned downtime
  • Manage tablespace growth, undo management, and ASM disk group issues
  • Perform RMAN backup and recovery operations for critical production systems
  • Support database migrations, code deployments, and production releases
  • Utilize Oracle Enterprise Manager (OEM) for monitoring and administration
Senior Oracle DBA
UBS (Wipro)Mumbai, India
May 2022 — May 2023
  • Serve as SME for Infrastructure Migration Services (IMS)
  • Perform Oracle database upgrades from 11g to 12c and 19c
  • Manage database installations, decommissioning, export/import, and cloning activities
  • Deliver database recovery solutions for development and testing environments
  • Administer user accounts, roles, profiles, and security privileges
  • Work closely with global application teams during migration projects
  • Support enterprise-wide Oracle database administration and maintenance
L1 Oracle DBA
Clover InfoTech Pvt LtdMumbai
Feb 2019 — May 2022
  • Install and configure Oracle 10g, 11g, and 12c databases with ASM
  • Administer Oracle RAC environments for high availability applications
  • Perform database monitoring using OEM Grid Control and TOAD
  • Manage tablespaces, memory structures, redo logs, and alert logs
  • Execute database migrations from Oracle 11g to 12c environments
  • Implement backup and recovery strategies using RMAN, EXP, and IMP
  • Manage database security through user, role, and privilege administration
  • Provide database cloning and recovery solutions for development teams
Support Engineer L1
National Payments Corporation of India (NPCI)Mumbai
Jul 2014 — Dec 2016
  • Monitor production transaction systems and banking network connectivity
  • Generate CPU and disk utilization reports for infrastructure monitoring
  • Support DR drill activities and production support operations
  • Execute SQL queries for transaction monitoring and reporting
  • Coordinate with operations teams to resolve production incidents
Skills
Oracle RACOracle Data GuardActive Data GuardASMSwitchover / SwitchbackRMANAWR ReportsASH AnalysisADDM ReportsSQL Execution Plan AnalysisSQL TuningOEM Performance MonitoringDatabase Upgrade (11g to 12c/19c)Cross-Version Database MigrationDatabase DecommissioningOracle Enterprise Manager (OEM)EXAccEXAcsExadata AdministrationBackup SolutionsPatch ManagementIncident ManagementTeam LeadershipClient Communication
Education
Bachelor of Commerce
Mumbai University
Jan 2009 — Apr 2012
Certifications
Oracle Database 11g Administrator Certified Professional
Oracle Cloud Infrastructure Foundations Associate
Oracle Autonomous Database Cloud Specialist
Last updated 12 hours agoMade with freecv.org