Apr 2016 – Dec 2020 · 4 yrs 8 mos · Mumbai

• Migrated databases of E commerce customer from db2 luw 10.5 to Oracle 12c RDS in cloud through sql developer
• Migrated Dev/Qa/Prod DB2 UDB databases in phases with total duration of 3 months.
• Worked on Oracle cloud infrastructure (OCI second gen) and deployed databases in it.
• Worked on Autonomous databases for some pilot projects .
• Working on Planning of database migrations from 12c to 19c through autoupgrade mechanism.
• Deployed and Provisioned databases on AWS RDS and Oracle cloud Infrastructure .
• Extensively used security groups and VPC and secured databases in AWS cloud
• Used compartments and VCNS and deployed second gen Oracle cloud databases.
• SME for handling optimization and performance tuning of Oracle databases on 12.
• Managing all application releases and getting sign off from business
• Migrated database from 11.2.0.4 to 12c CDB.
• Unplugged and plugged PDBs into other CDBs.
• Migrated on prem database to AWS cloud through AWS DMS service and export import .
• Completed Mini project with webserver on public subnet and database on private subnet and established connection between them .
• Capacity planning of all databases and servers and helping customers in cost reduction .
• OEM 13c used extensively for Tuning databases.
• Removed unwanted indexes through index monitoring and thus resulting in business benefit by saving space on disk
• Optimized reports and jobs through indexing and query restructuring.
• Well aware and good understanding of AWS services like S3 ,SNS and all other managed services.
• Automated database refreshes through db packages like dbms_datapump and procedure .
• Monthly service improvement programm given to customer as part of value addition.
• Documenting best practices as part of database releases.
• Partly involved in Windows admin tasks like application deployment.
• Implemented MySQL on docker in AWS cloud.
• Mongo db installation and administration .

Aug 2008 – Nov 2010 · 2 yrs 3 mos

• Working as Oracle DBA for patni computers
• Project:-Metlife Insurance.
• Handling 350 databases on AIX 5.3 and managing standby databases..
• OEM,dataguard,Rman,upgrades,patches,refreshes,sql tuning,DR tests, monitoring schedule jobs etc. were prime responsibilities

Feb 2007 – Apr 2008 · 1 yr 2 mos

• Working on intranet portal KMS and delivering reports of Billing
• Tools used:-Toad for Oracle ,Database administration and sql querry tuning.