GAURAV PATIL

Championed continuous improvement efforts
across all aspects of the database
environment, promoting a culture of
excellence among team members.

Works on multiple database engines such as
ORACLE , MYSQL ,PostgreSQL & MS SQL Server

Performance Tuning ,Capacity planning ,RAC
Patching & DR setup

Served as a mentor for junior DBAs, fostering
professional growth within the team.

Established effective disaster recovery
strategies, safeguarding critical business data
from potential loss or corruption incidents.

Providing L3 Support

Key role : Cloud DBA
Handling Cloud databases such as ORACLE , MYSQL Aurora ,PostgreSQL Aurora
Handling complex performance issues
Cost optimization ,Performance tunning on AWS RDS
Handling ORACLE database 12c to 19c upgrades by Autoupgarde ,Grid upgrade and DB patching
Familiarity with Cloud technologies such as RDS, DynamoDB, IAM, EC2, S3, AWS CLI
Experience with DevOps - configuration management (Ansible), GIT, Infrastructure as Code (Terraform) &
containers (Docker)
Good in Unix shell scripting, SQL and PL-SQL ,Performs automation on DB level
Experience with database migrations for Operational Support Systems (OSS) database migrations and Oracle to
open-source databases.
Works on OCI databases

Key Role : DBA - SME for performance tuning

I am part of the ORACLE ACS Team
Works on L3 performance issues, query tuning & optimization
Analyze DB waits , AWR , ASH ,SQLT reports
Perform database defragmentation
Troubleshoot DB wait events ,works on SQL profile and plan fix,

Review SQL query plans
Works on PL -SQL as per requirement , create DB objects like tables, views , triggers ,procedures etc
RAC installation
Performs database patching, upgrades
Worked on MIRA recovery ,recover from service on standby databases
worked on 19c latest features like Automatic indexing ,Autoupgarde
Did grid and database upgrade from 12c to 19c by using autoupgarde
Provides ORACLE database product support,pefroms bug fixes
Works on RCA preparation and take precuationary action in order to avoid issues
Manages communication with stakeholders,Invloves into project planning & implementation

Key Role : DBA , On-premises to Cloud migration,Hybrid DBA (ORACLE, MYSQL Aurora , MS SQL, PostgreSQL &
AWS )
Migrated 750+ databases from on-premises to AWS RDS Cloud
Designed Cloud databases and worked on migration methods
DMS and SCT tools used
Migrated DB flavors like ORACLE , MS SQL , MYSQL ,PostgreSQL databases to AWS RDS
Worked on Databases migration service ,Export -Import & MYSQL dump , MS SQL backup method for migrating
to Cloud
Performance tuning when database migrated to cloud and necessary optimization
Configure monitoring & monitor AWS RDS databases from CloudWatch , Performance insight tool
Contributed to reducing the cost on RDS like snapshot deletion ,instance class migration and multitenant
migration
Manage MY SQL Aurora Cloud Native databases, RDS -ORACLE , MS SQL
Installation and Managing cluster -Reader and Writer Node
Amazon Web services and AWS Infrastructure setup knowledge
Virtualization, Networking and Storage knowledge
AWS Management Console and AWS Account hands on
IAM , EC2 , EBS , VPC ,S3 -Have good knowledge and hands on
Deploying AWS RDS databases ,Maintaining database snapshots ,performs point in time restore
Backtrack ,Snapshot administration performed
Check plans ,blocking in PostgreSQL DB
Cluster setup on MYSQL & PostgreSQL (Aurora)
Experience with data migration strategies and moving large scale production systems either in on-premise or
data center environments or migration to cloud scenarios
Devops- L1 Skills
Knowledge on GIT ,GITHUB
Knowledge on Ansible , Terraform (Database deployments ),Knowledge of containerization platforms like Docker
and containers

Client : Telecom , UK
Key Role: Performance tuning expert & DBA
Monitored & supported and performed critical 24x7 duty on production databases
Report analysis AWR , ASH , ADDM , SQLT report
Analyze the explain plans and works on tuning the explain plans
Baseline ,SQL profiling ,Fixing query plan , SQL query tuning, query optimization
Performance checks after database upgrades from 11g , 12c to 18c /19 C
Suggest table partitions , Identify Data Skewness
Worked on optimal Index creation ,Table and Index defragmentation
Worked on stats gather on tables /partition so the query should use an optimal plan
Troubleshooting complex performance issues

Client : Telecom , Europe
Key Role : CORE ORACLE DBA
Worked on physical standby setup (Dataguard )
Logical backups EXPDP,IMPDP(Export and Import)
Managing environments, RMAN backups, refreshes, recoveries, and secure connectivity to peripheral systems
Plan & implementation of backup and recovery of the Oracle database
Managing availability, scalability, and usability (performance) through effective capacity and hardware
management
Implement Oracle database environment according to the project requirement and Oracle service pattern
offerings, including High Availability and Disaster Recovery options

Client : Banking & Wind turbine manufacturer (India)

Key Role : ORACLE & MS SQL DBA
Install, create patch, maintain and monitor Oracle databases
Create and maintain SQL and PL/SQL queries and shell scripts
Monitor, and verify backups and perform ad-hoc backups
Provide maintenance support for database systems.
Perform routine security and authentication measures
Database tuning and troubleshooting
Manage SQL Server databases- 2012, 2014, 2016
Software installation and Maintenance, MS SQL Always on
Database management including backups, recovery, and maintenance
Create, modify, and optimize SQL Server Agent jobs and maintenance plans.