Chetan Yadav

Chetan Yadav --Linkedin : https://www.linkedin.com/in/chetanyadavvds/ LINKEDIN Top Database Administration Voice Summary: Seasoned Oracle Database Administrator (DBA) and Product Support Consultant with 12+ years of experience. Proficient in Oracle DB admin across diverse platforms (Windows, Linux, AIX), expert in areas like GoldenGate, ASM, RMAN, Upgrades, Migration, Data Guard, High Availability, Oracle Enterprise Manager (OEM) , RAC , AWS, EC2, S3, RDS, Cross plate form migration , CloudWatch . Project planning and quality management specialist, skilled in report development, adept at resolving complex technical challenges while ensuring business needs are met. Education: ❖ B.E. in Computers from RGPV, Bhopal, 2007 Certifications: ❖ ❖ ❖ ❖ OCA and OCP in 9i OCP in 10g OCE SQL Oracle Cloud Database Migration and Integration 2021 Certified Specialist ❖ ❖ ❖ ❖ ❖ Oracle Autonomous Database Cloud 2021 Certified Specialist OCI 2021 Certified Architect Associate OCI Foundations 2021 Certified Associate OCI 2023 AI Certified Foundations Associate OCI 2023 Certified Foundations Associate Work Experience: Manager| Capgemini| July 23 – Till now ❖ Capacity planning ❖ Conduct in-depth database assessments, identifying ❖ Discovery Report dependencies and crafting migration roadmaps. ❖ Proficiently plan and execute migrations from Oracle 11g/12c ❖ Optimize performance, monitor real-time performance, to 19c, managing timelines, resources, and risks. and troubleshoot to maintain database efficiency. Senior Consultant | Nityo InfoTech Pvt Ltd (Wipro) | Nov'22 – July 23 ❖ ❖ ❖ ❖ ❖ ❖ ❖ Designing and implementing database solutions Planning and executing database upgrades and migrations Performance tuning and optimization Backup and recovery planning Monitoring and troubleshooting Capacity planning Collaboration with other IT teams ❖ ❖ ❖ Documentation and knowledge transfer Migration execution: Conventional Data Pump Export and Import, Transportable Tablespaces, Data Guard Migration (PDB or Non-CDB) Patches and upgrades Senior Oracle DBA | Lensoft Pvt. Ltd. (HCL India) | Oct'21 - Nov'22 ❖ ❖ ❖ Migration Oracle MAA: (Oracle RAC & Oracle Data Guard) Cross platform migration (Aix to Linux) ❖ ❖ ❖ Non-PDB to PDB migration (11g to 19 c) Migration with Datapump , GG, Dataguard Capacity planning ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ Discovery Report Executing operational procedures and support Documentation and knowledge transfer Assisting Application Support Team in developing database architectures and coding standards Node and Cluster management in Oracle Real Application cluster. Managing ASM Instance Administer ASM disk groups, adding or removing disks as needed. Explored and utilized Oracle Enterprise Manager (OEM) for centralized management, enhancing monitoring capabilities. Team Leader | CLOVER INFOTECH | Sept'21 - Oct'21 Managed CRS Services Set up and configure EC2 instances. Create and deploy storage using S3. Establish and configure RDS services for MySQL and Oracle. ❖ Migrate from on-premises Oracle to AWS. ❖ Utilize CloudWatch for monitoring. ❖ Create and mount volumes for EC2 instances. ❖ Cloning and re-building of databases from production to other environments. ❖ Database Backup and Recovery and Implemented Backup strategy (RMAN) for Production and other database ❖ ❖ ❖ ❖ Monitoring Backup jobs Creating database links with other databases Schema Refreshment Uploaded the data between the databases using Export and Import Data pump Utilities. Sr. Consultant | TENET TECHNOLOGIES PVT LTD | Apr'15 - Aug'21 ❖ ❖ ❖ ❖ ❖ ❖ ❖ ❖ Setting up blackout using (OEM) Oracle Enterprise Manager ❖ setup, configuration, monitoring, and maintenance of Oracle Clusterware (CRS) Upgrade and Migration Automated procedures for generating statistics Maintenance and administration of Oracle 11g ,12c Tablespace management. RMAN restoration and cloning Created users as per client requirements Monitored RAC environment and scheduled proactive scripts. Technical Analyst | Oracle India Pvt. Ltd. | Jul'12 - Mar'15 ❖ ❖ ❖ ❖ ❖ Upgraded databases from 10g to 11g on RHEL ❖ Restored and recovered databases using RMAN for migration from 10g to 11g ❖ Reviewed pre and post activities for maintenance or service window activities ❖ Collaborated with team members ❖ Monitoring ASM Implemented backup and recovery procedures using RMAN Upgraded database binaries using patch sets and interim patches Conducted UNIX shell scripting as required Provided 24/7 production support and maintenance activities Oracle DBA/PeopleSoft | SOAIT Solutions | May’10 - Jun’12 ❖ Oracle On Demand, Bengaluru | Technical Analyst (Quality Control) o Technology Used: E-Business Suite (EBS), Peoplesoft, OBIEE, Oracle DB o Reviewed pre and post activities for maintenance or service window activities Languages Known: - English - Hindi Date of Birth: 1st September 1984 o ❖ Performed trend analysis of defects and implemented corrective actions Shoppers Stop, Bengaluru | Peoplesoft DBA o Project Title: ShopperApp