Email: acqlvn@r.postjobfree.com

Mobile No: 513-***-****

Ganapathy Packrisamy(Samy)

Senior Certified Oracle DBA

Summary:

15+ years of experience in Oracle Database design, administration, support, upgrade and migration. Expertise in Installation, configuration and administration of Oracle 9i, 10g, 11g,12c RAC database and standby database on various environment like Solaris, Linux, HP, IBM AIX and Windows.

Expertise in database migration, applying patches, db capacity planning, backup strategy planning and tuning of critical database environment and good experience in RMAN Utility.

Experience in Oracle database upgrade and migration, 24X7 production support, implementation and administration of Oracle databases (8i, 9i, 10g, 11g and 12c) on various environment Sun Solaris, Linux Red Hat advanced server, HP and windows.

Experience in Data Guard setup and RAC DG setup and FSFO configuration.

Experience in 11g, 12c RAC setup and RAC patching and RAC upgrades.

Experience in hardware capacity planning, Oracle upgradation, Data migration, Replication, Oracle failsafe, database/application server performance tuning and Backup strategy planning.

Experience in Database performance tuning and optimization, Database cloning / overlay to recover lost objects.

Experience in Disaster Recovery Drills and Quarterly recovery test to perform to validate the backups on tape

Experience in RMAN backup and recovery implementation

Experience in ORACLE 12c and 11g OEM Grid control implementation and configuration, Agent installations and configuration.

Experience in implementing ORACLE STREAMS(uni-directional and bi-directional )and managed Operational, Historical and reporting databases

Experience in implementing ORACLE REPLICATION(Multi-master replication )

Experience in Database replication using SNAPSHOTS, MATERIALIZED VIEWS and advanced replication methods.

Experience in implementing ORACLE STREAMS(uni-directional and bi-directional )and managed Operational, Historical and reporting databases

Experience in ORACLE GOLDEN GATE, DIRECTOR and VERIDATA installation and configuration

Experience in MS SQL Server 2005/2008 in Production, QA and Development environments and Good knowledge on SQL Server 2012/2014.

Experience in Weblogic server 6.x,7.x and 10.x installation and configuration and troubleshooting issues.

Involved Oracle Fusion Middleware Products Oracle 11g Identity & Access Manager implementation & Administration and integrated Oracle Access Manager (SSO) with Ebiz.

Experience in patch implementation on various environment.

Education & Certifications:

Bachelors in Computer Science

Oracle 9i/10g/11g OCP Certification

RAC Administration Certification from ORACLE

Technical Skills:

Databases

Oracle 12c,11g, 10g,9i, 8i, 8.x, 7.x, 6.0 MS SQL Server 2005 and 2008

Languages

C, C++, Java and J2EE

Application server

Oracle 9iAS Release 2, Websphere MQ, Web logic, iPlanet

Tools and Utilities

OEM 2.2, Forms6i, Reports6i, SQL*Loader, Oracle Workflow, Oracle PL/SQL, Designer 6i,Developer/2000,Discoverer 3.1(Administration & User) Visual Basic 5.0

ERP Applications & Tools

Oracle Applications – 11i, 11.0.3,12.0.6, 12.1.1

ETL Tools

Informatica (Power Mart & Power Center)

Decision Support Tools

Business Objects, Brio, Web Intelligence and Apache

Web Technologies

Weblogic, IBM Websphere MQ

Fusion Middleware

IDM, OIM, OAM, SOA, OBIEE and SSO

Replication

Golden Gate, Streams and Oracle Advanced Replication

Hardware

Sun Fire V880, Sun Ultra Enterprise 3500, Sun Ultra Enterprise 250/450, Acer Altros19000 DDE Org Supermax RISC Plus IBM, Dell 6600, Compaq Proliants, Compaq DL580, IBM Netfinity

Operating Systems

Sun SPARC Solaris 2.x, Linux Red Hat Advanced server, HP-UNIX, IBM AIX Unix Windows 2000 advanced server,Windows XP, Windows 2003 and Windows 2008

Professional Experience:

Procter & Gamble, Cincinnati, OH Sept 2013 – Present

GDS Product Support

This project is called Global Design Services Support Team and manages over 50 Databases. GDS is a smart system for design management which allows integrating equipment design with a documentation repository. In addition, it provides tools for version management and makes accurate documentation globally accessible.

Responsibilities

Implemented and supporting N-way schema level replication using Oracle Streams

Troubleshooting the database issues in Production, Test and development databases

Software Installation and applied required patches.

Creation of databases for Production and Test servers, backup configuration and implementing daily admin scripts.

Configured RMAN backup for all production servers.

Implemented backup strategy for regular online backups on production databases.

Created 11g standby database using RMAN and configured dataguard with real time log apply.

Experienced in Database replication using SNAPSHOTS, MATERIALIZED VIEWS and advanced replication methods.

Perform Quarterly recovery test to perform to validate the backups on tape.

Cloned/Duplicated databases using RMAN backups whenever required by business.

Done the database/schema refreshes from production databases to test/development servers.

Upgraded databases from 11G(11.2.0.4) to 12C (12.1.0.2) including upgrades for Production, Dev and Test databases on Linux servers

Worked on performance tuning for Prod database when required.

Installed and configured OID for the OAM Implementation.

Environment: Oracle 10g, 11g and 12c databases on Linux Red Hat advanced server, Windows servers.

Chevron, Houston, TX Sept 2008 – Jun 2013

BBST Product Support

This project is called Base Business Support Team and manages over 800 Databases. Manage Oracle databases in 24x7 (OLTP & Data Warehouse) environments. Working in Critical Production and Development environment, involved in creating database, backup and recovery using RMAN, Clone/Duplicate database, Create and Manage Data guard database, Manage RAC and ASM database, Upgrade/Migrate database from 8i/9i/10G to 10G/11G, Export/Import, Tuning database, Apply Oracle CPU Patch/Bug fix Patch and manage the databases with day-to-day activities on UNIX-Sun Solaris, HP-UNIX and Linux environment.

Responsibilities:

ORACLE:

Extensive knowledge of Oracle Database Administration in Oracle 8i/9i/10G/11G and Managing Oracle Databases in 24x7 (OLTP & Data Warehouse) environment, working in Production, Development and Data Warehouse environment.

Extensive knowledge in database upgrade from Oracle 8i to 9i, 9i to 10G, 10x to 10y, 9i to 11G and 10G to 11G, 11G to 12C including upgrades for Production, Development, Dataguard, RAC and ASM databases.

Extensive knowledge on database backup and recovery using RMAN. Design and implement of database backup strategy and performed backup and recovery using RMAN for production and development including the Dataguard, RAC and ASM databases.

Extensive knowledge of taking logical backup for database/schema/tables using export/import, and expdp/impdp utility.

Migrate oracle databases successfully into cross platform operating system using export/import, expdp/impdp utility.

Implemented uni-directional schema level replication using Oracle Streams and troubleshooting the capture and apply issues.

Experienced in Oracle Golden Gate installation, configuration and troubleshooting the gg issues.

Experienced in Oracle Golden Gate Veridata and Director Installation and configuration.

Experienced in management and database administration of Oracle database applications on Exadata platforms

Create and maintain oracle Dataguard database with physical standby using RMAN for the critical and production database. Monitor and manage effectively the Dataguard, RAC and ASM databases.

Perform switchover or failover for Dataguard database whenever is required. Troubleshoot dataguard database related issues/failures.

Clone/Duplicate production database into Test/Development database using RMAN including Dataguard, RAC and ASM databases.

Restore and recover successfully production databases in Dataguard, RAC and ASM environment using RMAN. Convert successfully oracle databases from ASM to Non-ASM and Non-ASM to ASM database using RMAN.

Perform Disaster recovery test frequently as per customer requirement using RMAN for the critical production databases. Restore and recover the critical production databases with in the stipulated time at DR site.

Plan and Implement backup strategy using Hot, Archive log, Cold and Export based on the business requirements.

Performance Tuning, Monitor all database status including CPU, Memory, I/O, Space Management. Tune database memory by increase db cache size, shared pool size, pga aggregate target and also increase SGA.

Performance tuning analyzes and maintains statistics for the database using DBMS_STATS utility. Tune SQL for better performance by using explain plan and create indexes wherever necessary.

Experienced in using Explain Plan, Tkprof, STATSPACK, AWR and ADDM utilities to fine tune SQL execution plans. Modify init parameters to improve database performance.

Involved the database Capacity Planning for the future business growth requirement and suggest the input value to customer

Provide 24*7 database support to customer and ensure database administration on production, testing and development databases. Monitor and manage space for archive log, data files and table spaces.

Estimate space requirement, create required table spaces, data files and tempfiles. Checking alert log files trace files and analyze and fix the issues to avoid the impact on system performance.

Applying Oracle Quarterly CPU Patch, Bug fix Patch periodically for the development and production servers, and also apply patches on Dataguard, RAC and ASM databases.

Manage Offshore and Onsite DBA Services including management of client work activities, understanding overall client and business deliverables.

Activity Status Monitoring and delivery.

Participated in preparing Service Level Agreements and ensure Compliance.

Preparation and review of Call, Task Trackers and Metrics in correspondence to SLA Adherence and preparation of causal analysis and action plans on SLA deviation.

Prepare and Review Process documents for process improvements including ensure compliance with all laid down processes and procedures by all team members.

Team Management, Team Performance Management and Training plan.

MS SQL Server

Installing and Configuring of MS SQL 2005 /2008

Setting up and maintaining Log shipping.

Backup user databases and perform database restore and run consistency checks from SQL Server and application

Scheduling of maintenance Jobs (Daily, Weekly, Monthly) As per the as client request

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support

Backup verification.(Daily and Weekly)

Monitor SQL Server services status, Application log, Jobs, SQL Server Logs, Dead locks/Blocking

Monitoring of Disk space where physical databases are stored

Creation of Jobs & Maintenance Plans

Monitoring Production server issues, troubleshooting and resolving the incidents.

Maintaining server and database level user security privileges.

Setting up and Monitoring Backup jobs.

Environment: Oracle 8i, 9i, 10g, 11g and Oracle 10g and 11g RAC databases on Sun Solaris, Linux Red Hat advanced server, HP and windows servers. Sun Cluster HA oracle 11g databases and 11g Enterprise Manager Grid control and Oracle Golden Gate 11.1.1.0, Golden Gate Director and veridata on 11g databases, MS SQL Server 2005, 2008 on Windows Server 2003 and 2008

IFC – World Bank, Washington DC, Jun’06- Aug’08

Database Production Support

International Finance Corporation (IFC) is the financial division of World Bank organization and providing them with financial data for funding various projects. This project involves maintaining, monitoring all the production, stage, test and development database servers. The objective of this project is to provide 24x7 production supports for 120+ Databases hosted in AIX, Linux and Windows Environments. The business units log their Database requests/problems in CBI Release DBA/SA systems, which are allocated to DBA as Ticket or Service Request. In addition to that LSR Load Monitoring services, DB Health Check Services, DBA Request services and Production Support/ DR sync. This is an Onsite-Offshore model.

Responsibilities:

Database services and troubleshooting the issues in Production, Test and development database servers.

Oracle Software Installation and applied required patches.

Creation of databases for Production and Test servers, backup configuration and implementing daily admin scripts and adding databases to the OID servers.

Upgrade database 9i to 10g versions.

Installed oracle OMS Grid server and configured agent on all database to monitor the databases from central console, number of databases monitored using grid around 150.

Agents were pushed from central OMS server.

Configured RMAN backup for all production servers to tape using Galaxy utility.

Implemented backup strategy for regular online/offline backups on production databases.

Created 10g and 9i standby database using RMAN and configured dataguard with real time log apply.

Implemented uni-directional and bi-directional schema level replication using Oracle Streams.

Experienced in Database replication using SNAPSHOTS, MATERIALIZED VIEWS and advanced replication methods.

10g RAC Implementation in development and test environments.(Linux platform)

Perform Quarterly recovery test to perform to validate the backups on tape.

Plan and perform recovery for Disaster Recovery Drill.

Cloned/Duplicated databases using RMAN backups whenever required by business.

Done the database/schema refreshes from production databases to test/development servers.

Worked on performance tuning for Prod database when required.

Provided support for onsite/offshore project developers and created and compiled objects based on the need.

Implemented the security standards for all the production databases.

Database health check for all production Database using shell scripts was done.

Installed and configured weblogic 6.x/7.x for supporting java based applications.

Applied patch for 8x/9x/10g oracle versions in UNIX and windows platform.

Automated shell scripts to do DB health check, logical/hot backup, standby sync and refresh objects based on user request.

Monitoring the request queue and work allocation to team members.

Preparation of consolidated Weekly/Monthly Lotus notes based Status report

Monitoring and reviewing the SLA based work allocation on monthly basis

Weekly on-call meeting with Onsite Team for Project updates.

Preparation of RCA (Root Cause Analysis) report for identifying and correcting the exception if any.

Updation of Requirement specifications document.

Mentoring the technical knowledge project wise to team members.

Preparation of project plan and implementation for new projects.

Environment: Oracle 8i, 9i, 10g on AIX 5L, Linux RHEL4, Windows 2000 servers. Oracle 10g Grid control on AIX servers. Physical standby databases on 10g databases and Oracle streams on 10g databases Tools: OEM, Toad. Informatica (Power Mart & Power Center) and Brio reports

Applied Materials, Santa Clara, CA Dec’02 –May’06

Database Support

Responsibilities:

Database support to customer base and troubleshooting issues in production, Test and Development environments.

Developing scripts for monitoring the databases regularly and to send alert pages/mails to DBA team.

Handling Technical Change Controls as per the requirements like applying upgrade patches, database upgrades and implementing audit recommendations.

Periodic database health checkup and reviews with the application teams.

Coordinating with data center in setting up backups for new databases and in periodic backup validation.

Capacity planning for future storage requirements for the primary databases.

Development/QA Database Refreshes from Production databases.

Health check on databases using Statspack

Migrating and upgrading to oracle 9.2.*, 10g.

Modifying and enhancing shell scripts for cloning and database backups

Interacting with the development team for various support activities.

Database Performance Reviews with the Application teams.

Implemented ORACLE Advanced REPLICATION(Multi-master replication )

Table Re-organization and Index rebuilding.

Environment: Oracle 8i,9i,10g on HP UX- E9000/800, Sun Solaris 2.8, Linux 3.0.34, Windows 2000 servers and replication on 8i and 9i databases.

Contact this candidate