SUMMARY

• 11+ 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 such as 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, MySQL, Sybase, Siebel CRM& Oracle Applications).
• Confidential Cúram Application & Administration Support.
• Integrating the Exadata environment with OEM for monitoring
• 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.
• Worked on Oracle Applications upgrade from 11.5.10.2 to R12.1.1 to 12.1.3 for Confidential and 11.5.10.2 to 12.2.0 for Arrowood.
• 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).
• 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.
• Worked on install, upgrade and maintenance of Oracle with Web logic Server.
• Managing internal databases, from physical and logical on designing, planning and testing stages through implementation, Go live and support Phases.
• Working on Business requirement (RFPs) and preparing POC's.
• 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.
• 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), Applications System/Database configuration, patching, cloning, migration and upgrades.
• Cross-Platform Migration of "Oracle Database" from HP-UX to SUSE Linux 11 Platform and upgrade of it from 10R2 to 11g R2.
• Hands-on experience in planning & designing Oracle backups and recovery strategies like RMAN, export/import -logical and physical backup, dump- load.
• Worked on Backup Tools Commvault & TSM.
• Worked on different types of storage structures (SAN/NAS).
• Expert in installation and design many types of database production systems including OLTP and OLAP data warehouses.
• Work closely with application and system administration and vendors to coordinate activities, resolve development and maintenance issues and performing application tuning issues, Expertise in installation, database configuration & creation, capacity planning & sizing, backup and recovery Strategies, Performance Tuning. Good experience in interacting with Oracle support.
• Trained on Exadata V2 and X3-2 an Oracle database machine by Oracle.
• Applying Patches like interim patches (bug fixing patches), security patches using Opatch utility. Involved in 2node/3node RAC implementation/maintenance including installing clusterware, ASM and creating new databases.
• Audit user activity to ensure integrity and performance of the database.
• 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.
• Installation of Oracle 12c (with multitenant architecture i.e. CDB and PDB) Database on Oracle Linux.
• Upgrade of 11.2.0.4.0 to 12cR1 database, 10.2.0.5 to 11gR2 & 9.2.0.6 to 10gR2.
• Converting Non-CDB 12c database to 12c Multitenant Architecture (CDB and PDB).
• Solid experience in administration of Oracle 11gR2 RAC (3 Nodes and 4 Nodes) and 10gR2 RAC (2 Nodes) on Linux and Sun Solaris.
• Experience in replication using Golden gate & Streams & materialized views.
• Full cycle implementation(End-to-End) of Golden Gate & Streams including installing, configuring and troubleshooting.
• RMAN, Cold & Hot backup and Recovery (complete & Incomplete)
• Creation of Active Standby database using RMAN Duplicate (manual backup and active database).
• Cloning of Oracle Database using RMAN Duplicate (Manual Backup and Active Database).
• Implemented Oracle Patches CPU and PSU on the Compliance Databases Device.
• Proficient in Oracle database administration activities such as upgrades, patches, TAR support.
• Cloning, backup and recovery, performance tuning, and documentation.
• Analyzing AWR, ADDM and ASH reports.
• Good exposure on High Availability Concepts (RAC, Standby).
• Good experience in applying PSU patches on databases and Clusterware.
• Re-organization of tables using EXPDP and IMPDP.
• Extensive experience in Oracle RDBMS design and developing stored procedures, packages, triggers, cursors using SQL and PL/SQL.
• Expertise in tuning of procedures, packages and SQL statements.
• Used Advanced PLSQL concepts, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Proficient in Error handling and debugging coding issues and troubleshoot production problems.
• Installation and migration MS-SQL Server database.
• Installation, configuration, upgradation, maintenance and administration of SQL Server2005,SQL Server 2008
• SQL Server upgrade from version 2008 to 2012.
• Good experience in using DBCC.
• Configuring High Availability of database servers using Replication, Log Shipping, Database Mirroring for MS-SQL Server database.
• Taking backup and checking maintenance jobs of MS-SQL Server databases.
• Attaching and detaching ldf and mdf file of MS-SQL server database.
• Installation and migration of MySQL and Maria database.
• Configured Master-Slave, Master-Master replication in MySQL and Maria database.
• Proactive monitoring, identifying areas that need to be improved in the application and database using EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, and 10g, 11G, 12C OEM Grid/Cloud Monitoring.
• Creating and dropping EC2 and RDS instances on AWS Console.
• Migration of database from Inhouse to AWS premises.
• Upgrading CPU, PIOPS and memory to the server on AWS console.
• Managing and monitoring Oracle database on AWS console.
• Monitoring of IOPS,CPU and Storage on the AWS console.
• Changing parameter of database on AWS.
• Creating manual snapshot just before any changes.
• Checking alert log file os database on AWS consle.
• Killing session of RDS instance using rdsadmin.
• Adding and deleting logfile, datafile and tempfiles.
• Setting up alert metric on AWS instance for database alerts.
• Proven ability of providing production support for 24X7 on multiple databases.

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 & Korn Shell Scripting

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

Oracle GUI and APPS: Oracle Application Server EBS R12 & 11i, Oracle Application Server 10g(R1 and R2), Developer Suite 10g & Oracle Discoverer 10g

Office Tools: MS-Office, Putty, Winscp, VNC Viewer, XManager, Xming

PROFESSIONAL EXPERIENCE

Senior Database Administrator

Confidential, RI

Responsibilities:

• Interacting with the customer to understand their requirements and their Technical queries.
• Confidential Cúram Application & Administration Support.
• Building Servers Pertaining to Oracle, SAP, Hyperion and Oracle EBS on LINUX and Confidential 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.

Database Tower Lead

Confidential, New York

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.

Senior Database Engineer

Confidential, Charlotte

Responsibilities:

• Interacting with the customer to understand their requirements and their Technical queries.
• Installation of Oracle Apps R12 (single/dual node) on Oracle Enterprise Linux 5.0.
• To check Oracle Application services like Form Server, Report Server, Concurrent Manager to ensure availability at specific scheduled times and generating reports.
• Maintaining the Oracle Applications using ad utilities such as adadmin, ad patch, ad controller etc.
• Applying Database/Application Patches using Opatch and ad patch utilities.
• Cloning the applications for test purpose using Rapid Clone.
• Changing the oracle users, apps passwords using FNDCPASS utility.
• Refreshing / Cloning the Test and Development database as per user’s request.
• Creating users assigning responsibilities, concurrent managers, concurrent requests etc as a sysadmin task.
• Managing concurrent manager activities.
• Backup and Recovery management of Application and Database.
• General DBA tasks such as managing table spaces, control files, redo files, and data files.
• Installation of Oracle Software Products
• Creation of Databases
• Migration of database from HP-UX 11.11 to SUSE Linux SP2 Platform
• Cloning of Oracle Databases via RMAN
• Total Number of Instances Production, Development & Test is 150+ running on Linux, HP-UX, Windows & Solaris Platform
• Resolutions to IMACs(Tickets) assigned to DBAs
• Monitoring & resolving Backup issues
• Oracle 10.2.0.5 Database Cross Platform Migration HP-UX to SUSE Linux and Upgradation from 10.2.0.5 to 11.2.0.4 cross platform.
• Cloned the production database for test/dev using Hot Backup Technology.
• Database cloning and renaming the database using control file.
• Day-to-Day activities of DBA such as maintaining control files redo log files, data files.
• Upgraded the database from 9.2.0.4 to 9.2.0.7, 9.2.0.7 to 10.2.0.5 & 10.2.0.5 to 11.2.0.4
• Checking Alert Log file for errors and taking necessary actions to rectify.
• Handling SQL Server databases.
• Installation, configuration, maintenance and administration of SQL Server2005, SQL Server 2008 and SQL Server 2014.
• Upgrading SQL Server from version 2008 to 2012.
• Configuring High Availability of database servers using replication, log shipping, database mirroring for MS-SQL Server database.
• Purging of MS-SQL Server database tables using BCP and rename table method.
• Taking backup and checking maintenance jobs of MS-SQL Server databases.
• Attaching and detaching ldf and mdf file of MS SQL Server database.
• Performance analysis of MS SQL Server database using Foglight tool.
• Monitoring of MS SQL Server using Fog light tool.
• Creating and dropping EC2 and RDS instances on AWS Console.
• Migration of database from Inhouse to AWS server.
• Upgrading CPU, PIOPS and memory to the server on AWS console.
• Managing and monitoring Oracle database on AWS console.
• Monitoring of IOPS,CPU and Storage on the AWS console.
• Changing parameter of database on AWS.
• Creating manual snapshot just before any changes.
• Checking alert log file os database on AWS console.
• Killing session of RDS instance using rdsadmin.
• Adding and deleting logfile, datafile and tempfiles.
• Setting up alert metric on AWS instance for database alerts.

Database Administrator and Oracle Applications Administrator

Confidential, Plantation, FL

Responsibilities:

• Handling more than 300+ databases including Production, Pre-production, Acceptance and Development boxes.
• Installation 10g Oracle and Migrated oracle databases from 9i to 10g on UNIX and Windows platform.
• Installation of Database security patches.
• Installing Oracle 11g Grid Agents and Configuring it to OMS.
• Refreshing Production Database of Streams environment to Acceptance and Development.
• Involved in the server migration activities.
• Administrating and trouble shooting of oracle10g standby databases.
• Performing periodical Backup, Restoration and recovery using RMAN
• Database Restoring from Production to Test and Development Database using RMAN and performing Point in time Recovery (Cancel based, Change based, Time based and TSPITR).
• Monitoring databases space requirements and adding spaces to required tablesapces.
• Managing tablespaces, data files, redo logs, tables and other segments.
• Managing Users, Privileges and Roles.
• Collecting the database statistics using statspack, explain plan, tkprof.
• Performance tuning resource monitoring (Disk Space Utilization CPU etc).
• Day-to-day business database support and management of the production DB.
• Support activities that include areas like Task Management, Incident Management and Change Management.
• Handling Alert tickets and the severity tickets with incident tracking tools Open Pursuit.
• Close interaction with the business and Tech Groups across the region and globally to ensure issues are resolved in stipulated time as per the Database Management standards.
• Co-ordination with the team to meet the SLA between vendor and client.

Database Administrator and Oracle Applications Administrator

Confidential

Responsibilities:

• Handling more than 500+ databases including Production, Pre-production, Acceptance and Development boxes.
• Installation 10g Oracle and Migrated oracle databases from 9i to 10g on UNIX and Windows platform.
• Installation of Database security patches.
• Installing Oracle Client of version 10.2.0.* and higher, OEM, 10g Grid Agents.
• Streams Implementations
• Refreshing Production Database of Streams environment to Acceptance and Development.
• Involved in the server migration activities.
• Administrating and trouble shooting of oracle10g standby databases.
• Performing periodical Backup, Restoration and recovery using RMAN
• Database Restoring from Production to Test and Development Database using RMAN and performing Point in time Recovery (Cancel based, Change based, Time based and TSPITR).
• Monitoring databases space requirements and adding spaces to required tablesapces.
• Managing tablespaces, data files, redo logs, tables and other segments.
• Managing Users, Privileges and Roles.
• Collecting the database statistics using statspack, explain plan, tkprof.
• Performance tuning resource monitoring (Disk Space Utilization CPU etc).
• Day-to-day business database support and management of the production DB.
• Support activities that include areas like Task Management, Incident Management and Change Management.
• Handling Alert tickets and the severity tickets with incident tracking tools Remedy.
• Close interaction with the business and Tech Groups across the region and globally to ensure issues are resolved in stipulated time as per the Database Management standards.
• Co-ordination with the team to meet the SLA between vendor and client.

Database Administrator

Confidential

Responsibilities:

• Interacting with the customer to understand their requirements and their Technical queries.
• Performing general health checks.
• Maintaining the Oracle Applications using ad utilities such as adadmin, ad patch, ad controller etc.
• Applying Database/Application Patches.
• Cloning the applications for test purpose using Rapid Clone.
• Changing the oracle users, apps passwords using FNDCPASS utility.
• Refreshing database as per user’s request.
• Creating users assigning responsibilities, concurrent managers, concurrent requests etc as sysadmin task.
• Performed General trouble shootings.
• Backup and Recovery management of Application and Database.
• General DBA tasks such as managing table spaces, control files, redo files, and data files.
• Collecting the database statistics using statspack, explain plan, tkprof, AWR.
• Handling the severity issues which is impacting the service.