SUMMARY

• More than twenty five years of experience as Oracle DBA
• In - depth knowledge of database tuning and optimization techniques.
• Experience in designing database backup and recovery plans and implementing backup/recovery, failover, and replication procedures.
• In-depth knowledge of Rman.
• Experience in planning, installing and configuring databases on UNIX, Linux and Window servers.
• Monitor databases using Oracle Enterprise Manager and generate performance metrics.
• Mange Oracle storage using ASM on EMC SAN.
• Experience in managing Oracle Applications release 11.
• Experience in managing Oracle high availability environment, RAC and Dataguard
• Experience with Oracle Golden Gate
• Extensive knowledge in writing shell scripts to help administer databases.
• Self-motivated team leader/player with excellent communication skills.
• Strong leader, ability to work with individuals at all levels
• Excellent leadership skills, five years of experience in managing developers and DBA’s as Applications Group Manager.
• Experience in SOA and web services, worked as a lead architect for Confidential Integration Manager ™ product.

TECHNICAL SKILLS

Databases: Oracle 12c/11g/10g/9i/8i/7.X, SQL Server

High Availability: RAC, CRS, Grid Infrastructure, Data Guard, Replication, ASM

Database Tools: SQL, T-SQL, SQL*Loader, Oracle Developer, Oracle Enterprise Manager, PL/SQL, Data Pump, SQL*Plus, Oracle WebDb, Rman, Data Guard, Perl, Access, oratool, bigbrother, Toad, Informatica, Erwin

Operating Systems: UNIX, Windows 2003/XP/2000, Linux

Languages: C++, C, Pascal, FORTRAN, Assembly, Shell

Business Software: Oracle Applications, Baan ERP system, Baan PDM system, Logility forecast system, Pilgrim quality system, Trutrack payroll system, EP2 (PK/PD), Watson (LIMS), Kinetica (PK/PD), Darwin (LIMS), Galileo (LIMS), SAP Basis

Utilities: Dbx, awk, sed, troff, grep

PROFESSIONAL EXPERIENCE

Confidential, Wayne, PA

Sr. Database Administrator

Responsibilities:

• Manage Oracle high availability 24/7 environment, RAC and Dataguard in SaaS environment
• Manage population health data
• Create Physical and Logical data structures for OLTP and BI databases
• Implemented and manage Goldengate as part of BI reporting project
• Upgrade Oracle databases to 12C
• Implement Oracle 12C grid
• Manage Analytics and data warehouse reporting databases.
• Designed partitioned tables for huge BI databases
• Document disaster recovery run books

Confidential

Sr. Database Administrator

Responsibilities:

• Manage Oracle high availability 24/7 environment, RAC and Dataguard in Confidential Cloud Managed Services
• Disaster recovery management in Confidential cloud infrastructure
• Refresh Oracle databases across servers
• Provide technical training on Oracle disaster recovery to the Confidential CMS global team
• Present Database backup and recovery metrics report to the management

Confidential, Norristown, PA

Sr. Oracle DBA

Responsibilities:

• Manage Oracle high availability 24/7 environment, RAC and Data guard
• Provide Oracle consulting services
• Upgraded Oracle databases to 11.2.0.3
• Installed Grid Infrastructure software as part of 11.2.0.3 upgrade
• Migrated Non ASM databases to ASM
• Document BCP procedures and recover databases as part of BCP exercise using RMAN and TSM.
• Maintain highly critical NERCCIP databases which manage electric grid.
• Manage Oracle RAC and Data guard 24/7 environments.
• Implemented Oracle RAT to test 11.2.0.3 upgrades.
• Provide technical support to business users in designing database structures.
• Implemented physical standby data guard and RAC environments
• Designed partitioned tables for huge BI databases
• Support Oracle Goldengate to replicate data into BI databases

Confidential, Radnor, PA

Sr. Database Administrator/ Oracle APPS DBA

Responsibilities:

• Support VWR business systems
• Manage Oracle Applications release 11, upgrading, patching, cloning and day to day operational issues.
• Provide technical support to Oracle applications end users.
• Manage 140 Oracle servers including Oracle 10g and 11g with RAC and ASM
• Manage and Coordinate release management windows
• Project lead for GXS enterprise gateway system
• Work with AT&T hosting environment and make sure all the SLA’s are met and coordinate with AT&T for all the change/ release windows.
• Project lead for VWR SOX compliance systems.
• Basis support for SAP implementation.
• Mange Oracle databases on different platforms (UNIX, Linux and Windows) in a 7X24 environment.
• Monitor and tune Oracle databases using Oracle Enterprise Manager.
• Plan and manage Oracle storage requirements. Oracle ASM is implemented on EMC SAN.
• Plan and document Oracle backup procedures, manage yearly disaster recovery exercise. Rman and litespeed for compression are used for backing up databases.
• Generate database performance metrics from OEM and take necessary actions.
• Provide technical support to developers for creating an optimized code.
• Managed high availability environment, data guard, replication and ASM mirroring.

Confidential, Philadelphia, PA

Senior/Lead Database Administrator

Responsibilities:

• Lead and provide technical direction to the application development team and service people in a global company.
• Lead architect for Confidential Integration Manager ™ software, Darwin ™ LIMS software and EP Series ™ software.
• Manage multiple projects in a matrix development environment.
• Prioritize development work and provide weekly status reports to the management.
• Provide visibility of the projects to the management by posting them on the Microsoft project server.
• Other responsibilities included Oracle 10g/9i/8i database administration for EP2 (PK/PD), Watson (LIMS), Galileo and Darwin (LIMS) systems.
• Database administration tasks include proactive database tuning, managing tablespaces, objects, database backups using Rman, monitoring database using Enterprise Manager and SQL tuning.
• Managing Standby databases using data guard. Documented disaster recovery plans.
• Database performance monitoring by using perfstat reports, Oracle ADDM and AWR.
• As per the requirements of FDA all database and system changes are logged and recorded.
• Provide support to client databases, advising and helping them to apply Oracle patches and upgrade databases.
• Visit client sites for database setup, help them to install, upgrade and tune their databases.
• Designed and developed database audit triggers to support FDA CFR part 11 features of the software. These triggers capture old value and new value of each field and store them in a table. They also capture electronic signatures at the record level modifications or inserts.
• Created workflows using Informatica to migrate data from old LIMS system to Darwin and Sample Manager LIMS systems.
• All development and production versions of Oracle scripts are maintained in Erwin and Oracle designer.
• Creating database install scripts to the clients
• Interacting with the clients and helping them to install oracle databases on different platforms
• Resolving Client database issues and provide technical support to them over the phone.
• Writing database triggers, procedures, functions and packages for the application development team.
• Designed a dynamic data model for Darwin PharmaLims product. The objects in the schema can be modified or new ones can be added at the install time. Database packages are written to maintain the schema objects and dynamically generate triggers for auditing.

Confidential, Richmond, VA

Independent Contractor

Responsibilities:

• Worked as a part time independent contractor to maintain the company Oracle database server located in Philadelphia city. These responsibilities were carried out during the night and on the weekend.
• Responsible for Security, Backup (Rman), Recovery, day to day monitoring and tuning of the database.
• Responsible for the administration of Sun Solaris Enterprise server.
• Responsible for modifying or developing data models (logical and physical) and PL/SQL programming.

Confidential, Philadelphia, PA

Senior/Lead Database Administrator

Responsibilities:

• Responsibilities included Oracle 8I database administration, which supports a 7X24 Internet site.
• Writing database triggers, procedures, functions and packages for the application development team.
• Coordinating with the users and helping them in providing reports.
• Designing logical and physical database structures.
• Database tuning and monitoring, help to increase the response time on the web site.
• Database backup and security.