Name: Varun Mehta
Professional Summary:
- Working in database administration having 15+ years of experience in Oracle technologies currently administering Oracle 19c/12c/11g/10g/9i Databases, RAC Database, ASM and RMAN, Disaster Recovery (Data Guard), Goldengate.
- Oracle Certified Professional (OCP) DBA in Oracle10g
- Well, exposed to Oracle Core DBA responsibilities and working in 24x7 production support and implementation project.
- Performed installation of Database 19c/12c/11gR2/10gr2/9i on multiple Linux flavors, Solaris, AIX and on Windows platform.
- Performed Disaster Recovery (DR)/ Data Guard setup 10g/11g/12c/19c.
- Having experience working on Cloud Technologies such as AWS, Azure & OCI.
- Performed database upgrade.
- Migrated Databases from NON-ASM to ASM.
- Fully involved in 12c and 11gR2 RAC (Real Application cluster) implementation project and fully conversant with RAC Database services.
- Performed OEM grid installation and configuration and OEM Agent installation.
- Managing and Administrating databases 12c/11gR2/10gR2
- Troubleshoot Oracle database performance issues using diagnostic and performance tools.
- Oracle Database Patching – On Standalone Server, RAC Database Server and onStandby.
- Configuring and scheduling RMAN backup, cold backup, and export backup.
- Performed extensive patching (both DB and Applications), applied CPU patches, Family Packs, Patch sets and one-off patches.
- Working with diagnostic tools including AWR, ADDM, trace/tkprof, Explain plan, VMware, and Toad.
- A people manager with good communication, analytical, organizational and relationship management skills, with expertise in interfacing with international project teams for successful execution of projects.
Education:
Degree
University
M.Tech Software Systems
WILP B.I.T.S Pilani
B.E Computer science.
Maharishi Dayanand University, Rohtak
Certifications:
OCP (Oracle Certified Professional) 10G
Experience:
Organization
Designation
Duration
BrizSolution Technology, Pvt. Ltd.
Lead DBA
Jan 2021 - Current
Tech Mahindra Ltd.
Lead DBA
Dec 2019 –Jan2021
Oracle India Pvt. Ltd.
Senior Advanced Support Engineer
Oct 2018 – Dec 2019
Tech Mahindra Ltd.
System Analyst
Oct 2012 - Oct 2018
Wipro Infotech
Engineer – Database Administration.
Dec 2010 - Feb 2012
Technical Skills:
Hardware
RAC, Oracle Clusterware
Operating Systems
Unix, Linux, Solaris, HP-UNIX, Windows, AIX
Languages
C, Shell Scripting.
Databases
Oracle, SQL Server, MySQL
GUI
OEM
Web Related
HTML
Tools & Utilities
Putty, Webex, Winscp, 7 ZIP
Domain Knowledge
Oracle Database Administration
Trainings:
S No:#
Title
Location
Organized by
Duration
1.
Oracle Grid Infrastructure 11g: Manage Clusterware and ASM Ed 3 PRV
Pune
Oracle University
1 Week
Current Project Profile:
- Client Name: Ascension Health Alliance
- Role: Senior DBA
Contribution:
- Manage and track day to day team activities
- SLA adherence and tracking for respective tracks
- Managing Oracle Database on Cloud (AWS, OCI & Azure) and On-prem servers.
- Customer handling and communication
- Manage shifts and roster
- Track and execute continuous improvement initiatives (like value portal)
- Knowledge Management
- Innovation
- Performance Management (goal setting/team feedback)
- Team’s adherence to company policies/compliance:
- Engagement in company/projects initiatives
- Thought Leadership
- People Management
- Team Building
- Conflict Resolution