Pramod Yadav

About Pramod Yadav

Administration of 2-Node 11g R2 RAC with ASM on Exadata(OEL). Administration of 8-Node 11g R2 RAC with ASM on HP-UX. Administration of 3-Node 11g R2 Extended RAC with ASM on Rhel 6.6 Administration of 11g R2 Active-Active standby Databases. Implementation and configuration of Oracle Golden Gate to replicate the data for reporting purpose. Administration of Oracle Goldengate veridata for comparison and Sync of data before migration. Managing 24X7 critical production databases for optimum performance. Implementation and management of 11g R2 Grid control to monitor databases Creating table spaces, user maintenance, and database security imposition by creating and granting roles and privileges, performance tuning, database refresh. Managing Oracle security and Oracle network tools; handling the tuning of SQL statements and stored procedures and supporting for Oracle toolsets and utilities like SQL*Plus. Managing and administering the ASM storage at Database and ASM instance level. Scheduling scripts and procedures through Oracle jobs and crontab and schedulers over HP-UX and solaris. Archiving Production data to their respective Data Warehouse Servers using Copy from and Data pump. RMAN backup, recovery and cloning. Upgrade oracle 10g to 11g primay database and respective standby database OEM and grid control. Generated AWR, ADDM reports for performance monitoring. Golden Gate Installation, Monitoring and Migration of Databases through Golden Gate. Weekly and monthly activities like run segment advisor and rebuilding index and archiving of data. Coordinating with Oracle Technical Support (Metalink) for Sev. 1 TARs, bug fixes. Working in mature production environments handling 24x7 supports.

Experience

1. Database Engineer Ii

   Amazon Web Services (AWS)

   Aug 2024 — Present · IN, US

Education

• Motivational Pathway

  MCA, Computer Application

  2006 — 2009