SUMMARY

• 12+ years of IT experience as Oracle DBA and Oracle Applications DBA of progressively responsible positions in diversified and very large production and development environments with database and Applications implementation in various platforms of Unix Flavours and Windows with a proven track record as a DBA / Database Architect.
• Extensive experience in production DBA activities including installations, patching, cloning, High Availability (Exadata, RAC, Dataguard, RMAN, Oracle Cloud Control & Grid Control, Golden Gate, Streams, SQL Server replication, SQL server log shipping, Sybase, Siebel CRM& Oracle Applications & Cloud Services of Amazon AWS, IBM BlueMix & SoftLayer).
• Expertise in Oracle RAC, ASM, Data Guard, installation, migration, patching, designing, scripting, performance tuning, database security and auditing, Oracle Internals and on Oracle E - BusinessReleases(11i and R12), Oracle databases(8.x, 8i.x, 9i.x, 10g.x, 11g.x and 12c.x), Oracle Cloud Control(12c) & Oracle Grid Control 10g.x & 11g.x).
• Creating and dropping EC2 and RDS instances on AWS Console.
• Migration of database from Inhouse to AWS premises.
• Managing and monitoring Oracle database on AWS console.
• Upgrading CPU, PIOPS and memory to the server on AWS console.
• Monitoring of IOPS,CPU and Storage on the AWS console.
• Changing parameter of database on AWS.
• Setting up alert metric on AWS instance for database alerts.
• Experience in managing, leading and mentoring junior DBAs.
• Working on Business requirement (RFPs) and preparing POC's.
• Installation of Oracle 12c (with multitenant architecture i.e. CDB and PDB) Database on Oracle Linux.
• Configuring Heat Map, Automatic Data Optimization and ILM with Oracle 12c Database.
• Installed and configured Informatica to Oracle Database server.
• Upgrade of 11gR2 to 12cR1 database, 10gR2 to 11gR2 & 9iR2 to 10gR2.
• Foolproof Database Upgrade from 11gR2 to 12cR1 using Real Application Testing(RAT).
• Configuring OEM monitoring of Exadata Database Machine.
• Post migration performance enhancement of the new 11gR2 RAC databases on Exadata.
• Installed Oracle 11i (11.5.8/11.5.9/11.5.10 ), R12 Applications E-Business suite Sun Solaris, UNIX, Red Hat Linux environments.
• Upgraded Oracle Applications from 11.5.10.2 to R12.1.1 to 12.1.3 and 11.5.10.2 to 12.2.0.
• Implemented the Shared Application Tier, PCP Setup and Load balancing setup for oracle Application 11i, R12.
• Configuration DMZ for accessing Apps server externally.
• Applied all type of patches to 11.5.9, 11.5.10, 11.5.10.2, and R12.1.3 and R12.2.4 versions of E-Business suite, Databases, IAS and 8.0.6 oracle home.
• Implemented Apps 11i and 10gAS Portal integration (Portal, OID/SSO).
• CPU /PSU patch analysis and apply on database and Application.
• Installation, upgrade and maintenance of Oracle with Web logic Server.
• Physical/Logical database design experience with Supporting DB throughout the SDLC of Application
• Adept at implementing, upgrading, and supporting Oracle Applications database administration (Oracle Apps DBA), including Modules of Human Resource Management System (HRMS), Financials, Supply chain Management(SCM), Manufacturing.
• Responsible for leading and mentoring less experienced staff.
• Cross-Platform Migration of "Oracle Database" from HP-UX to SUSE Linux 11 Platform and upgrade of it from 10R2 to 11g R2.
• Strategize and implement Oracle database RMAN and logical backup using export/import utilities
• Configured RMAN Backups using Commvault & TSM.
• Experienced in administration and design of OLAP and OLTP databases.
• Work closely with application and system administration and vendors to coordinate activities, resolve development and maintenance issues and performing application tuning issues.
• Migrated 65 physical Servers to Virtual machines on ESX 3.5 of VMWare.
• Experienced in engaging and navigating Oracle Support engineers.
• Trained on Exadata V2 and X3-2 an Oracle database machine by Oracle.
• Full cycle implementation(End-to-End) of Golden Gate & Streams including installing, configuring and troubleshooting.
• Analyzing AWR, ADDM and ASH reports to tune Oracle Databases.
• Oracle RDBMS design and developing stored procedures, packages, triggers, cursors & Functions using SQL and PL/SQL.
• Expertise in tuning of procedures, packages and SQL statements.
• Proficient in Error handling and debugging coding issues and troubleshoot production problems.
• Installation, configuration, upgradation, maintenance and administration of SQL Server2005,SQL Server 2008
• Configuring High Availability of database servers using Replication, Log Shipping, Database Mirroring for MS-SQL Server database.
• Attaching and detaching ldf and mdf file of MS-SQL server database.

TECHNICAL SKILLS

Operating Systems: LINUX, HP-UX, AIX, SUN SOLARIS & Windows

Oracle Tools/Utilities: RMAN, ASM, OEM Grid/Cloud Control 10g/11g/12c and 13c, Active Dataguard, Snapshot Standby Database, SQL Developer, Shareplex and Golden Gate, Grid, SQL * Plus, TOAD, SQL*Loader, TKPROF, IMPORT - EXPORT, Expdp-Impdp, RMAN, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH, ORAChk, OSWatcher, DBV, Nagios, Fog Light, Cloud Watch & Korn Shell Scripting, Top, SAR, VMSTAT & IOSTAT, TRACERT, NETCAT, IPERF.

RDBMS: ORACLE 12c/11gR2/11gR1/10gR2/10gR1/9i/8i

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential, MI

Responsibilities:

• Supporting Several different types FORD Applications.
• Redesigning process from Traditional Database practise Oracle Advance Concepts.
• Patching Oracle and GRID Binaries using Opatch Utilities.
• Installed and Configured Oracle 12c Cloud Control Agents to 12c Cloud Crontrol OMS.
• Productionizing databases and Helping Application Team in Go live Process.
• Testing RMAN Backups and configuring them to TSM as the Part Productionizing.
• Configuring Database Servers as per standards of FORD.
• Complete Performance Testing of Oracle Databases.
• Cross Platform Migration of Databases from HP-UX to SUSE Linux 11 SP2.
• Creating Oracle Schemas as per Application requirements.
• Configured Active Data Guard as a part of Productionizing.
• Extensively Upgraded Oracle databases from 11.2.0.4 to 12.1.0.2
• Extensive Usage of Oracle Data Pump and EXP and IMP as needed to for Cross Platform Migration Process.

Database Administrator

Confidential

Responsibilities:

• Interacting with the customer to understand their requirements and their Technical queries.
• Building Servers Pertaining to Oracle, SAP, Hyperion and Oracle EBS on LINUX and IBM AIX.
• Installing Oracle RDBMS and GRID Binaries 11.2.0.4 & 12.1.0.2 in Silent and GUI Mode for Oracle Restart and RAC environments.
• Applied APR2016PSU, JUL2016PSU and OJVM Patches to ORACLE, EBS and SAP Binaries.
• Patching Oracle and GRID Binaries using Opatch Utilities.
• Patching SAP Oracle and GRID Binaries using OPatch and MOPatch Utilities.
• Patching Oracle EBS using Adpatch Utilities.
• Installed and Configured Oracle 12c Cloud Control Agents to 12c Cloud Crontrol OMS.
• Productionizing databases and Helping Application Team in Go live Process.
• Testing RMAN Backups and configuring them to TSM as the Part Productionizing.
• Configuring Database Servers as per CVS standards.
• Scheduling Monitoring and House Keeping scripts in ControlM and Crontab.
• Complete Performance Testing of Oracle Databases.
• Migrating Databases from Omnicare Premises to CVS DataCentre.
• Cross Platform Migration of Databases from HP-UX to Oracle Enterprise Linux OS.
• Creating Oracle Schemas as per Application requirements.
• Configured Active Data Guard as a part of Productionizing.
• Upgraded Oracle databases from 11.2.0.4 to 12.1.0.2
• Extensive Usage of Oracle Data Pump and EXP and IMP as needed to for Cross Platform Migration Process.

Delivery Operations Manager

Confidential

Responsibilities:

• 24*7 Production Oracle Database support (size up to 30TB) and maintenance including supporting advance configurations such as Oracle ASM, Oracle RAC, Active Data Guard and Snapshot Standby databases, etc.
• Managing complete production support for all the Production and Non Production Database systems.
• Managing and providing support for multiple databases in 24x7 production environment (from few 100 GBs to 40 of TB in size).
• Providing support to all the ERP systems (Oracle E-Business Suite).
• Worked on Oracle Applications upgrade from 11.5.10.2 to R12.1.1 to 12.1.3.
• Implemented the Shared Application Tier, PCP Setup and Load balancing setup for oracle Application 11i, R12.
• Applied all type of patches to 11.5.9, 11.5.10, 11.5.10.2, and R12.1.3 and R12.2.4 versions of E-Business suite, Databases, IAS and 8.0.6 oracle home.
• Worked on the automation of Apps cloning from single node to single-node and Multi-node to single-node using the shell scripting and Perl scripting.
• CPU /PSU patch analysis and apply on database and Application
• Upgrade of 11.2.0.4.0 to 12cR1 of SONY MUSIC DATABASES.
• Administration of Oracle 11gR2 RAC (3 Nodes and 5 Nodes) databases.
• Converting Single instance to RAC database and RAC database to Single instance.
• Creation of standby and RAC databases.
• Administration of Oracle Active Data Guard Standby and Snapshot databases.
• Created Active Standby Database using RMAN Duplicate
• Cloning of Oracle 11gR2 Database using RMAN Duplicate
• Converted Physical Standby Database to SnapShot Standby Database and Vice Versa.
• Monitoring more than 100 servers on Grid.
• Monitoring Exadata database and machine alerts on OEM.
• Evaluating overall performance of your computer systems and providing recommendations for improving performance.
• Monitor and maintain critical hardware information for the database machine.
• Monitor and address database machine alerts.
• For Oracle Exadata, New database instance creation, Backup and recovery procedures implementation, Database administration, Performance tuning of the database.
• Configuring / CACHING large FACT and small dimension tables on EXADATA FLASH CACHE.
• Backup and Restore / Recovery of large databases on Exadata X3-2 using RMAN, allocate parallel channels on Oracle ZFS backup storage devices.
• Tuning Large Oracle database 12 TB on Exadata X3-2 system using AWR / ADDM / ASH.
• Migration of database from in-house to RDS AWS instance on Amazon Cloud.
• Installation and upgrade of Oracle Clusterware and rdbms binaries.
• Patching Grid Clusterware home and database home on quarterly basis.
• Cloning and refresh of database and creating Korn Shell Script to automate the same.
• Resolving daily routine alert error (cloning and refresh issues, space issue, network alerts, managing backups and their alerts, database ORA errors.)
• Weekly and monthly maintenance application and databases.
• Documentation of the procedure for resolving issues or any other major changes to the system.
• Technical support for OBIEE and ETL.
• Implementation Oracle EBS R12 for Advance Supply Chain Management (ASCP).
• Pre-Patch Analysis and Patching of EBS using adpatch utility.
• Configuring replication of tables, schema using Golden gate .
• Using Oracle Golden Gate Tool for Replicating Data to Reporting Database.
• Monitoring and fixing replication issues in Golden gate.
• Adding and dropping Disk from ASM.
• Planned and implemented Disaster Recovery solutions using Oracle Standby database/Dataguard.
• Analyzing AWR, ASH and ADDM reports for resolving DB performance issues.
• Reorganization of tables using EXPDP and IMPDP.
• Application of bug fixes patches as per suggestions from Oracle.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues—helping to transform business requirements into environment specific databases.
• Closely worked with Oracle support in identifying some long standing issues. Also extensively used Oracle Metalink.
• Helped build extensive documentation for all Oracle related administration.
• Managing and Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on Linux 5.9.
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Migration and upgradation of MySQL databases.