SUMMARY:

• Over 22 years of Experience in IT industry, out of which 15 Years as Oracle DBA (9i/10g/11g/12c), 7+ Years Oracle APPS DBA 11i/R12.x and 7+ Years Sybase (15.7/16)DBA Primarily in Production and Development environment, played different roles like Data Architect, Production/Development DBA and Unix System Administrator.
• As APPS DBA install, configure, maintain, administrating, upgrade, quarterly patching, quarterly password change, on - call support and tune for EBS 11i/R12 applications.
• Analyze EBS and database infrastructure to ensure compliance with Security standards.
• Rapid cloning of EBS databases.
• Configured EBS 12.2 with logical host configuration procedure.
• Perform EBS R12 Database reorganizations to improve performance, Gather statistics using shell scripts.
• Adding printers, profiles and user administration.
• Strong knowledge of EBS applications architecture, configuration, and troubleshooting.
• Implementing Transparent Data Encryption both at tablespace and table column level, network encryption
• Implementing 10g/11g/12c Grid control, installing agents on AIX and Linux servers.
• Implementing 10g/11G/12c RAC on Solaris 10/AIX 7.1/OEL 6.5 using ASM.
• Experienced in setting up dataguard to single instance and RAC databases.
• Maintain database standards, procedures, security, high availability, disaster recovery, backup and recovery, storage, and archiving procedures.
• Backup/Recover of Oracle databases.
• Maintain production databases sizing from 10 GB to 70TB
• Configure and administer 12c multi-tenant database.
• Configuring / maintaining Materialized views.
• Experience in Oracle Enterprise Manager (OEM), Grid control 12c & DB Express .
• Install and configure 10g/11g/12.x Oracle Internet Directory.
• Installation and Administration of OBIEE 12c BI publisher.
• Experience in Database design, Functional design, ERD and Physical Design
• Perform database reorganizations to improve performance and ensure maximum database uptime.
• Expertise in handling Very Large Database (VLDB) and OLTP environment.
• Creating databases on Amazon AWS EC2 servers
• Experience in Programming skill using SQL*PLUS, PL/SQL, Unix Shell Scripts.
• Implementation of Golden Gate 11/12 (for both Migration and replication)
• Installation/Administration and Upgrade of Mysql 5.x databases.
• Installation/Administration and Upgrade of MS Sql Server 2012/2014 databases.
• Configuring unidirectional and Bidirectional replication using Goldengate.
• Troubleshoot and resolve issues related to Extract/Replicat in Goldengate 11/12.
• Creation /Administration/Backup and restoring Oracle databases on Amazon RDS.
• Setting alerts in Amazon RDS for oracle events and monitoring.
• Experience in Installation, Configuration & re-configuration of Oracle and Sybase for Large Database on Unix O.S.
• Experience in working with Financial Institution, Railways & Telecommunication industry.

TECHNICAL SKILLS:

Operating Systems: AIX 5.3L,HP-Unix (10.2,11), Sun Solaris (2.7,2.8,2.10),Linux RHEL6,Windows 2008

RDBMS: Oracle 7.x/8.0/8i/9i/10g/11g/12c,EBS 11i/R12.x, Sybase 11.x/12.5,Mysql 5.1/5.6, MSSql Server 2000/2012/2014/2016 , Teradata 14/15.

Application Servers: Oracle 9i/10g application Server

Tools: Oracle Grid Control 12c/11g/10g,Oracle Internet Directory, Golden Gate 11/12,EMC DD Boost, Avamar.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr .Oracle APPS DBA

Environment: HP ProLiant BL660c Oracle 12c. EMC Networker. Postgress 9.x/10. AWS RDS EBS R12.2.x

Responsibilities:

• Oracle 12c user Installation/Administration.
• Quarterly CPU patching.
• Monitoring Database performance using Grid control 13c.
• Configured backups using Networker.
• Oracle Administration/Backup and Restore.
• Archive data and DB maintenance.
• Upgrading OEM 13c agents.
• Setting alerts for monitoring Oracle database events.
• Upgrading databases on AWS rds environments.
• Installation backup and recovery on AWS rds.
• Installation and Administration of Postgress 8/9.
• Upgrading Postgres databases.
• Tuning Postgress and maintenance of databases to remove fragmentation.
• Tuning auto vaccum process in Postgres.
• Configured EBS 12.2 with logical host configuration procedure.
• Installed and configured Oracle Applications R12.1/12.2 for Dev, Test, UAT, and Prod instances. Created DR using Data guard for EBS R12.x.
• Tuning PL/SQL programs by using DBMS PROFILER/SQL Profiles and Sql Plan Management.
• Install, configure 12.x Oracle Internet Directory for oracle netservices.

Confidential, Philadelphia, PA

Sr. Oracle APPS DBA

Environment: Dell Poweredge R620, Oracle 12c., EMC Avamar

Responsibilities:

• Oracle 12c user Installation/Administration.
• Quarterly CPU patching.
• Monitoring Database performance using Grid control 13c.
• Configured backups using Avamar.
• Oracle Administration/Backup and Restore.
• Archive data and DB maintenance.
• Setting alerts for monitoring Oracle database events.
• Setting up corporate databases in Amazon RDS.
• Doing POC for moving data between oracle and saleforce.
• Installation/configuration/Adminitration of Postgres 9.6 Database.
• User Administation in Postgres database using roles.
• Configure backup and assess proper backup strategies for Postgres database.
• Installed and configured Oracle Applications 12.1/12.2 for Dev, Test, UAT, and Prod instances.Created DR using Data guard for EBS R12.x.
• Postgres instance tuning for better performance.
• Installation and Administration of OBIEE 12c BI publisher.
• Creating users and managing roles as per the project guidelines.
• Cloning Postgres database from PROD to lower environments for testing and patching.
• Install, configure 12.x Oracle Internet Directory for oracle netservices.
• Tuning PL/SQL programs by using DBMS PROFILER/SQL Profiles and Sql Plan Management.

Confidential, Washington, DC

Sr. Oracle DBA

Environment: IBM Mainframe S/390x. Oracle 11g/12c. Tivoli Server Manager

Responsibilities:

• Oracle 11g/12c user Administration.
• Quarterly CPU patching.
• Monitoring Database performance using Grid control 13c.
• Configured Golden gate from oracle to Teradata for reporting purposes.
• Troubleshoot and fix Golden gate extract and replicat process.
• Oracle Administration/Backup and Restore.
• Archive data and DB maintenance.
• Created databases/backup/tuning on Amazon RDS on EC2.
• Setting alerts for monitoring Oracle database using event notification services.
• Install create and Maintain EBS 11i/R12.x and cloning using Rapid clone and administrating concurrent managers as Apps DBA.
• Oracle 12c user Administration,Quarterly CPU patching.
• Golden gate Administartion and troubleshooting.
• Supporting DB deployments using Octopus.
• Oracle Adnistration/Backup and Restore.
• Troubleshooting CSM slow performance.
• Troubleshooting RMAN backups.
• Supported 130 databases.
• Configuring golden gate using macros for consistency across evironments. troubleshooting Extract/Relicat processes.
• Upgrading goldengate from 11 to 12.

Confidential

Environment: AIX 7.1. SUSE 11.1. Oracle 11G/11i/12c,Teradata 14.0,Mysql Enterprise 5.1/5.6, Websphere 7.0, Veritas 7.0,Super Cluster T5-8, EMC DD Boost 5.4.2. P740, IBM V7000 SAN,Teradata 670c,Exadata X3-2,X4-2, EMC Data Domain 5.4.2.Amazon RDS, OID 10/11g

Responsibilities:

• AIX 7.1. SUSE 11.1.
• Upgraded 11g to 12C on AIX/Linux platforms.
• Implemented Oracle Golden Gate Unidirectional for reporting purposes.
• Troubleshoot and fix Golden gate extract and replicat process.
• Teradata User Administration/Backup and Restore.
• Copy objects across the schemas in Teradata.
• Backup & Recovery of Teradata Database using ABU.
• Mysql 5.x Installation / Upgrade, Administration, Monitoring and Backup & Recovery.
• Configuring RMAN backups for Development /staging databases using Veritas Net backup 6.0/7.0.
• Configure/Maintain Data Guard for DR.
• Install, configure 10g/11g Oracle Internet Directory for oracle netservices.
• Configure 12c Grid control for monitoring the DB and setting alerts.
• Applying Oracle CPU patches.
• Tuning PL SQL programs by using DBMS PROFILER/SQL Profiles and Sql Plan Management.
• Installed and configured Oracle Applications 11.5. for Dev, Test, UAT, and Prod instances.
• Created DR using Data guard for EBS 11i.
• Mysql database creation/Backup and restore operations.
• Monitoring Mysql databases with Mysql enterprise Monitoring.
• Tuning Mysql DB parameters to resolve performance issues.
• Implementing Transperant Data Encryption both at tablespace and table column level, network encryption.
• Configure and administer 12c multi-tenant database.
• Created databases on Amazon RDS.
• Using RMAN with OSB to backup and restore databases on AWS.
• Subscribing to RDS events and monitoring.
• Install Postgress Databases 8.3 for internal application.
• Migrated Postgres database from 8.3 to 9.6 across all environments.
• Configure backup and assess proper backup strategies for Postgres database.
• Postgres instance tuning for better performance.
• Install create and Maintain EBS 11i/R12.x and cloning using Rapid clone and administrating concurrent managers as Apps DBA.
• Creating users and managing roles as per the project guidelines.
• Cloning Postgres database from PROD to lower environments for testing and patching.

Confidential

Environment: Solaris 10.Sun Cluster 3.1/3.3,Oracle Clusterware. Oracle 12c/11G/10G/9i,EBS 11i/R12.x, Websphere 5.0.2, Net Backup 6.0/7.0. EMC DMX 3/4, Sun V240,M9000/M5000/M3000.

Responsibilities:

• Migrated 10g Grid Control to 11g from solaris to Suse Linux.
• Installed 11gR2 RAC on M9000 running 3.3 Sun Cluster.
• Upgrading 10gR2 RAC database to 11gR2 RAC.
• Monitoring and Maintaining 10g RAC on Sun Cluster 3.1.
• Configuring RMAN backups for RAC Production/Development/staging databases using Veritas Net backup 6.0/7.0.
• Applying Oracle CPU patches.
• Apply CRS Bundle patches.
• Data Movement using Transportable Tablespaces.
• Tune block level parameters to reduce contention across the nodes.
• Verifying RMAN Backups, tune backups to keep backup duration under 5 hours.
• Tuning PL SQL programs by using DBMS PROFILER.
• Migrate RAC database to DMX 4.
• Tuning RAC instances using ASH,ADDM.
• Creating SQL profiles to tune sql queries.
• Install and configure EBS 11.5/R12.0
• Cloning EBS test environments using Rapid clone.
• Monitoring OAM to monitor Apps tier.
• Supported Oracle APPS 11i with 11gR2 for day to day activities. installation / administration of Postgresql 9.1 database including backup/recovery and performance tuning.

Systems Analyst

Confidential, Washington, DC

Environment: AIX 5.3L.Oracle 8i/9i/10G, Websphere 5.0.2, Informatica 7.x.IBM LPARs.

Responsibilities:

• Managing an offshore team of five DBA’s at Chennai and coordinating the regular DBA activities.
• Migration of database from 8.1.7.4 to 9.2.0.8.
• Applying Critical patch updates to all databases.
• Setting up and maintaining Standby by Instances for all the Production servers.
• Implemented Oracle 10G RAC (4 Node Cluster).
• Migration project of from 9.2.0.6 to 10.2.0.3.
• Monitoring growth of tables and estimating future space.
• Tuning of SQL statements and improving the response time of queries.
• Refresh the test database on need basis from the production database, for the purpose development and testing.
• Install and configure oracle CMAN for routing connections through a centralized server.
• Implemented Cold and Hot backup procedures Using RMAN for all Oracle databases.
• Automated administrative tasks using UNIX shell scripting.
• Configuring ASM and migrating database from ASM to File system and vice versa.
• Implementing Replication server for Sybase database.
• Refreshing the test and dev instances with Sybase Production data.

Confidential, Atlanta

Environment: Sun Fire E6500,Sun OS 5.8, Oracle 8.1.7.4, BO’s WebI 2.7.2, Iplanet 6.0.2, Brio, Informatica.

Responsibilities:

• DBA Lead for a offshore team of 10 and coordination with onsite team in Atlanta,GA.
• Upgrading Oracle 8.1.6 server to Oracle 8.1.7.4 on Sun Solaris 5.8.
• Performing database administrative jobs using 10g Enterprise Manager.
• Implemented procedures for calculating database growth.
• Implemented database alerts.
• Identified and resolved the disk subsystem problems.
• Creation of data marts in production by calculating the volumetrics from test database.
• Monitor index growth in the data marts and implement pre and post session scripts in informatica to drop and re-create those indexes to improve the load performance.
• Resolved oracle performance issues involving disk I/O, CPU usage.
• Tuning of SQL statements and improving the response time of queries.
• Refresh the test database on need basis from the production database, for the purpose development and testing.
• Implemented Cold and Hot backup procedures for all Oracle databases.
• Automated Backup procedures using UNIX shell scripting.
• Tuning the Application and Database using oracle utilities TKPROF and EXPLAN PLAN.
• Documentation & presentation of the project.
• Troubleshoot app.-related issues and supporting offshore team.
• Volumetric estimations for the creation of new tablespace for data marts.
• Performance tuning of loads at informatica level.
• Rectifying rollback segment errors by setting Informatica parameters.

Confidential

Sr. Customer support Engineer

Environment: HP-UX 10.20, 11.00,Sybase ASE 11.9.2.4.,Oracle 8.1.7, 8.1.5, 8.1.6.,Kenan Billing Application (Arbor OM/BP).,Fraud Management System., HP N class (RP 7400), L class (RP 5400), K class servers (K 9000). HP Storage Area Network (VA 7400). HP Sure Store Tape Library.

Responsibilities:

• Reducing severe lock contention on the server due to inappropriate usage of tempdb and indexes.
• Preventing Lock contentions due to use of cursors was reduced by declaring the cursors intent, replacing the or and in lists with union and union all clauses and by keeping cursors open across transactions.
• Contention in tempdb was caused due to frequent creating and dropping of permanent tables in tempdb and their indexes. Hence hash tables were created in the beginning of the procedures and dropping them was eliminated. This solved the contention over the system tables in tempdb.
• Also larger caches were configured and pool size of 16k was made use of to reduce physical I/O thus improving the response time of queries on tables with clustered indexes, which used table scans and returned a large range of values.
• All stored procedures critical to the application were performance tuned to speed up the selects, Inserts and updates.
• Prevention of locks from being held for a longer duration and the transaction log from getting suspended.
• Automated night backups for oracle databases. Configured Oracle gateway for Sybase for migration purpose.

Confidential

Database consultant

Environment: Sun Solaris 2.8,Oracle 8.1.7,Forms 6i,Report 6i,Windows 98. Sun E250 Server

Responsibilities:

• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export / Import utilities).
• Sizing the database for future growth.
• Creation of Table spaces, Storage Allocation/De-allocation, Table/Index (with free list groups), Rollback Segments, Constraints, Roles & Privileges.
• Maintaining a Test & Development Databases.
• Configuring RMAN on Sun Solaris
• Reorganization of the database to remove fragmentation.
• Tuning & Monitoring the Database Performance.