More Related Content
What's hot (20)
Viewers also liked (8)
Similar to CV_Rishi_Gupta (20)
CV_Rishi_Gupta
- 1. Rishi Gupta e-mail: itsmezrg@gmail.com Cell: +91-8276882818 _____________________________________________________________________ Experience Summary: A highly result oriented Skilled Oracle certified Associate having 6 years of IT experience as Oracle Applications 11i/R12 DBA on Multi-Terabyte database environments on multiple platforms. As an Oracle Apps DBA, I have worked on Oracle E-Business Suite (11i,R12), Oracle Database 8i,9i,10g/11g/12c, Oracle Weblogic server, Oracle Enterprise Manager, Oracle Transport Management, BPEL (SOA Suite). I have 3 and half years of experience in support-cum-enhancement projects with activities like cloning, patching, trouble-shooting day-to-day issues, administration of EBS,etc Also I have 1 year and 10 months of experience in implementation project (upgrade of oracle database from 10g to 11g, Application upgrade to R12.2.5, platform migration, data center migration etc). Areas: Oracle EBS Administration: Applications: 1. Oracle E-Business Suite(11i,R12) 2. Oracle Enterprise Manager(10g,12c) Oracle Database Administration: Applications: 1. Oracle Database (10g,11g) 2. Upgrade of Oracle DB from 10g to 11g Oracle SOA Suite Administration Oracle Discoverer administration Oracle Transportation Management(OTM) Administration Oracle Weblogic Administration OEM 12c Installation and administration Hudson and SVN configuration and Administration for Code migration TECHNICAL SKILL: Operating Systems: HP-UX, Linux, Windows. RDBMS: Oracle 9i, Oracle 10g RAC, Oracle 11g RAC. ERP: Oracle E-Business Suite 11.5.10, R12. Languages: SQL, PL/SQL, C, UNIX Shell Scripting. Tools: RMAN, OEM 12c, SQL*PLUS, SQL*Loader, TOAD, Tuning Tools: TKPROF, EXPLAIN PLAN Projects: • Oracle Application Technical Support DBA (EBS APPS DBA) and OEM support, Johnson Control Inc. • Oracle DBA Support for Non EBS Databases, Johnson & Johnson Services • Initial learning program (ILP),TCS. 1
- 2. Rishi Gupta e-mail: itsmezrg@gmail.com Cell: +91-8276882818 Title PHOENIX PROJECT Organization TATA CONSULTANCY SERVICES Client JOHNSON CONTROL INC. Location KOLKATA, INDIA Period MAY-2016 – Till Date Role EBS APPS DBA Description The objective of this project was to move existing EBS system from HP-UX to Linux (RHEL 7.2) platform along with upgrading the DB from 11g to 12c and application from 11i to R12.2.5.So summarily, this project involved platform migration from HP-UX to Linux, Database upgrade to 12c and application upgrade to 12.2.5. It also includes few stand-alone DB upgrade from 11g to 12c. These DBs are our Loading DBs and were running on the same servers and are associated with the EBS system. Responsibilities 1) New server build(pre-requisite check and validation) 2) Build Stage Area for Oracle Application Installer and Binary Installations 3) DB upgrade from 11g to 12c (DB Migration) 4) Upgrade Application to R12.2 5) Upgrade Application to 12.2.5 6) Installing OEM agents and on the new servers and discovering and Configuring alerts for the new instances/services and servers on OEM. 7) Design Hudson job for the new instances for code deployments 8) Assist and suggest changes to custom programs/scripts based on platform changes. Operating system: Oracle Enterprise Linux,HPUX Special Software: Project Details: Title ESMM AE Separation Organization TATA CONSULTANCY SERVICES Client JOHNSON CONTROL INC. Location KOLKATA, INDIA Period DEC2015 – APRIL -2016 Role EBS APPS DBA Description ESMM AE Separation. Datacenter Migration from BDC to MDC Platform Migration from HP-UX to LINUX Upgrade from 10.2.0.5 to 11.2.0.4 Cluster Services Responsibilities Datacenter Migration from BDC to MDC Migration of Oracle EBS 11i from HP-UX to REDHAT LINUX. Database Upgrade -10.2.0.5 to 11.2.0.4 Operating system: Oracle Enterprise Linux,HPUX Special Software: 2
- 3. Rishi Gupta e-mail: itsmezrg@gmail.com Cell: +91-8276882818 Title PROJECT RADIO for Johnson Control Inc. Organization TATA CONSULTANCY SERVICES Client JOHNSON CONTROL INC. Location KOLKATA, INDIA Period SEP2014 – NOV2015 Role EBS APPS DBA Description GWS Split Project : Platform Migration from HP-UX to LINUX Upgrade from 10.2.0.5 to 11.2.0.4 Responsibilities Migration of Oracle EBS 11i from HP-UX to REDHAT LINUX. Database Upgrade -10.2.0.5 to 11.2.0.4 And 11.2.0.3 to 11.2.0.4 Application Upgrade to RUP7 Post Migration Hyper care Support. Operating system: Oracle Enterprise Linux,HPUX Special Software: Title Oracle Application Technical Support DBA (EBS APPS DBA), Johnson Control Inc. Organization TATA CONSULTANCY SERVICES Client Johnson Control Inc. Location KOLKATA, INDIA Period AUG2012 - SEPT2014 Role EBS APPS DBA Description Support of 53 EBS databases and their monitoring using OEM 12c Responsibilities • Cloning of oracle application 11i instance with Rapid Clone. • Application of patch using ad patch. • Oracle Application System administration (Managing concurrent process, Creation of User, Responsibility, registration of new application, Monitoring user activity) . • Regular Database backup activity. • Handling space management and performance issues. • Watching file system and space related problems. Managing table spaces, Managing data files • Production support (24*7 pager support). • Writing shell scripts for database and applications Monitoring • AD utilities • Work-flow setup and monitoring • Printer setup and monitoring • Data edit perform 3
- 4. Rishi Gupta e-mail: itsmezrg@gmail.com Cell: +91-8276882818 • OMS patch installation • Customization of OEM alert forwarded to HP-OMU message • Creation of incident rules, metric extension(host based and SQL based),group creation, Template creation Operating system: Linux Special Software: Oracle Application 11.5.10.2, OEM 12c Title Oracle DBA Support for Johnson & Johnson Services Organization TATA CONSULTANCY SERVICES Client Johnson & Johnson Healtcare Location KOLKATA, INDIA Period MAY2011 – JUL 2012 Role Member Oracle DBA operation Responsibilities • Oracle Database administration of Production database, test database and development database. • Daily database health check and monitoring of existing system Data Archival, RMAN backup • Cloning database from Production servers to development servers. • Security patches applied in Production and Non production databases. • Periodic refreshing of the production data through export/ import and Expdp/Impdp. • Used the standby database for doing different operations like taking backups. • Manages data guard(Physical and local Standby) • Taking the Cold and Hot backup of the database regularly • SQL tuning using Explain plan, TKPROF and instance tuning. • Gathering statistics of schema, tables and databases. • Usage of Partition tables and their maintenance for performance enhancement • Troubleshooting Space Management Issues. • Created new user accounts, profiles, roles and assigned them to different users • Monitoring the test database as well as the production database • Created and managed table spaces monitored the data files, space, resizing and adding new data files etc. • Doing Database Reorganization regularly to remove row migrations and fragmentation. • Automation of routine activities like health checks and post refresh checks using shell scripting. • Job Scheduling (cron and DBMS_JOBS) Triggering of alerts when jobs fail or are incomplete. • Database Upgrade, Patch/Patch set Installation. • AS10g application bounce and administration. • Active member in DR test Setup Primary Database and Standby Database and Snapshot standby database, Testing using different Data Protection Modes,Operational Recovery Strategy for Database Switchover and fail 4
- 5. Rishi Gupta e-mail: itsmezrg@gmail.com Cell: +91-8276882818 over Production support. 24*7 pager and production support Operating system: HP- UX B11.11, Linux Title Initial learning program (ILP), TCS Organization TATA CONSULTANCY SERVICES Location Kolkata ,India Period JAN2011-APR2011 Role Trainee Description Given training on different programming languages and database concepts Responsibilities • Training on different programming languages like Dr School, C, C++. • Training on different database concepts. • Using above concepts prepared a project on bus ticket reservation system. Qualifications: Degree and Date Institute CGPA Percentage B.Tech in Electronics and Instrumentation Engineering, May 2010 Dr B.C.Roy Engineering College 8.10 81.00% 5
- 6. Rishi Gupta e-mail: itsmezrg@gmail.com Cell: +91-8276882818 Personal Details • Date of Birth • 21-Jan-1988 • Nationality • Indian • Address • Maatushree, Near Zila School, New Bishunpur, P/S- B-Polytechnic, Dhanbad, Jharkhand, 828310 • Phone • 8276882818 • Pan Card • AVIPG9884D Passport Details Name as on passport Relationship Passport Number Date of Issue Expiry Date Place of Issue Rishi Kant Gupta Self J4280390 03-Mar-2011 02-03-2021 Ranchi 6
- 7. Rishi Gupta e-mail: itsmezrg@gmail.com Cell: +91-8276882818 Personal Details • Date of Birth • 21-Jan-1988 • Nationality • Indian • Address • Maatushree, Near Zila School, New Bishunpur, P/S- B-Polytechnic, Dhanbad, Jharkhand, 828310 • Phone • 8276882818 • Pan Card • AVIPG9884D Passport Details Name as on passport Relationship Passport Number Date of Issue Expiry Date Place of Issue Rishi Kant Gupta Self J4280390 03-Mar-2011 02-03-2021 Ranchi 6