Manish Kumar Email and Phone Number

Database administrator activities

Responsibilities as a Lead:Maintaining shift roster for DBA TeamWorking on escalated Database ticketsResponsibilities as a DBA my role includes:Managing Oracle Exadata X4-2 1/8-Machine with Oracle 11g RAC setup, Active Data Guard (Standby Database) , Oracle Restart , OEM 12c and number of single instance databaseHandling multiple RAC infrastructures including, Oracle 10.2.0.4 RAC and 11.2.0.3/11.2.0.4 RAC setup on Oracle Exadata X4-2 server, IBM-AIX and Solaris servers• Participated for pre sales, proposals, effort estimations, project plan activities.• Well-prepared with the necessary equipment, training, and experience to get the job done.• Excellent Client relation building skills. • Experience in working with US and UK clients.• An effective communicator with relationship management skills and ability to relate to people at any level of business and management.• Excellent in building team and keeping them motivated • Hands on experience on Oracle Apps and Database administration.• Experience of various applications on UNIX (Solaris/Red hat) and Win environment• End to End Implementation of Oracle Apps R11i and R12 on different platforms.• Upgradation of Oracle Application from 11i to R12 on Linux and windows environments.• Upgradation of 9i and 10g databases on various platforms• End to End Implementation of Oracle Application Server 10g, FMW11g (OID,SSO, Portal)• Implementation of Oracle Enterprise Content Server.• Implementation of Oracle database Vault, Label Security and Audit Vault.• Good knowledge in using Apps Utilities (patch, adadmin. Cloning etc)• Outstanding organizational, communication & presentation skills• A team player with exceptionally good organizational, analytical, training, troubleshooting, and interpersonal communication skills Specialties: Oracle Apps Implementation and upgradation. pre sales, proposals, effort estimations, project plan activities

I have worked As Freelancer - DBA Support / Corporate trainer for many organization as an Oracle DBA Trainer.1) SQL Star2) AKS Computer Pvt Ltd.3) Ducat 4) Karrox Technologies LimitedTechnology : Oracle Apps(11i, R12) implementation, upgradation, migration, Ad utility, Any type of patch/cloning, Oracle DBA, Oracle RAC/GRID, ASM, RMAN(Backup and Recovery Solutions), Patch/clone.

Oracle Apps DBA Roles & Responsibilities :-  Worked as Oracle APPS DBA managed databases and application and working in onsite -offshore support model.. Handle process improvement, task completion & client interaction for Managed Service Customers Part of team upgrading ebiz 11.5.10.2 to R12.1.3 with database 10.2.0.4 to 11.2.0.3 Migrated PROD database Unix to Linux appreciated by SPOT light Award. Provided technical support by troubleshooting and resolving database and application problems. Troubleshooting Apache , Forms, Concurrent , Workflow issues Worked on Patching, Cloning process and Ad-Utilities Worked with Middleware team (SOA, BPEL and B2B as configured with RAC PROD with ASM) to get execute RFC in downtime window. Re-configured SSO for non-PROD instance if SSO issue comes after clone. Preparing client specific documents for streamlining the procedure. Execute data-fix and discoverer request from development team. Cloning Database using hot backup.  Installation and Maintenance of Oracle 10g and 11g RAC Database Validate Dataguard sync with PROD databases , recover till real time if not in sync. Automate Workflow mailer service through shell script. Conduct/Initiate Conference Calls over the data-fix migration over monthly downtime in PROD. Track all the incident/change tickets & ensure that problems are duly taken up/resolved by team. Provided24X7 supports on a critical production environment and non-prod .

DBA Roles & Responsibilities:-  Successfully upgraded database 10.2.0.3 to 11.1.0.7 Successfully upgraded 11.5.10.2 apps to R12.1.1  R12.1.3 Setup 32bit and 64 bit OS Linux server to meet client requirement. Successfully Migrated database (11.1.0.7) and application (R12.1.3) from RHEL4 32-bit to RHEL4 64-bit . Resolve post setup issue and handover the system to Development team.  Support multiple instances (Production, Test, QA and Development ) of Oracle EBS 12 & 11i and RAC 10g with ASM. Provided technical support by troubleshooting and resolving database and application problems. Perform backup and recovery procedures using RMAN and Database refresh using RMAN backup.  Prepared client specific documents for streamlining the procedure. Execute data-fix request from Quality team to work on RFC. Analyzing and apply opatch and adpatch. Installation and Maintenance of Oracle 11g RAC Database Rebuilding indexes. Sanity Check for PROD and Standby database and rebuild standby database. Involved in Creation of RFC’s with Oracle-On-Demand. Providing 24X7 supports on a critical production environment and non-prod . Review and distribute new service request into team to handle the queue as per severity status. Worked on Service request of severity p2,p3,p4 over the global. Initiated/Conducted OWC session-Conferences with Customers. Analyze and rectifying databases and application issues and provide the solution with action . Provided steps for upgrading 11i/R12 with databases. Documented any issue if bug and created internal SR with development team.

DBA Roles & Responsibilities Worked as Oracle APPS DBA managed databases of multiple clients across global. Production and non-PROD support for 21 US clients. Analyzing and rectifying production databases issues and backup failures.  Performed Database refresh. Performed various transition activities like installing oracle configuring grids and agents Managed issue tickets for production database.  Cloning of Oracle Applications R12 from Muti Node to Single Node with RAC to NON-RAC and RAC to RAC.Clone with RMAN Duplicate Daily Reports Generation Related to Oracle DBA Activities. Daily DBA Sanity Health Checks  Assisting clients with Installation 11g/10g, Cloning, Upgrades, Migration and Patching. Everyday clone from production (Hot backup/Cold backup, RMAN). RMAN backups and restore Understood of Stats Pack , TKPROF and AWR Reports Create SR with Oracle for any kind of bugs encountered Involved in Creation of RFC’s with Oracle-On-Demand. Monitor database through OEMFew Important Projects Done NLS Implementation on 11.5.10.2 : Implemented Simplified Chinese language on 11.5.10.2. Platform used was Red Hat 5 Developer patchset upgrade from patchset16 to patchset19 RUP7 patching on 11.5.10.2 Characterset Conversion: Performed characterset conversion on 11.5.10.2 Vision instance having 9.2.0.6 database from US7ASCII to UTF8. For this full DB exp/imp strategy was used

 Takes the Backup of Exchange Server, Network Server with Tape engine on tapes and transfer the backup to remote location Mumbai,Chennai. Generated User Reports, Statements and Customer reports using Oracle SQL & PL/SQL Worked with EM Grid to monitor performance of production databases. Reproducing customer issues internally and Interaction with customers for faster resolution. Worked on managing archive area of archiving, unlocking the accounts of users etc, Resolving issue occurred in Session locking around SOP and monitoring of production database. Performed DBA Health Checks.