Objective

To obtain a challenging position in Database Administration that utilizes my skills to contribute to the company’s success.

Profile

Over Seven plus year of expertise in Real Application Clusters (RAC), CRS resource management and Cluster management. Extensive performance tuning experience, specializing in instance tuning. Expert in Database management and Storage management. Expertise includes:

• OS: Experienced with multiple platform like AIX, Linux, HP-UX , Solaris and Open VMS
• CRS: Extensive experience in Installing, upgrading, patching and troubleshooting
• CRS resource management: Experienced in Adding/Deleting/Relocating Instances, DB, listener, node apps, Services
• Managing OCR and Vote disk backup
• Clusters: Experienced with managing HACMP on AIX, Service Guard for HP-UX and Clusterware on Linux
• Migration: Expert in Migrating database from 9.2.0.5 to 10.2.0.3 and 10.1.0.5 to 10.2.0.3 on all platforms using Golden Gate software.
• Golden Gate: Experienced on Golden Gate 9/10/11 version in configuring extract and replicate process and troubleshooting.
• RDBMS: 9i/10g /11g - Extensive experience in Installing, upgrading, patching and troubleshooting
• Database creation: Experienced with RAC database and standalone database
• Database Restore: Experienced in using Exp/Imp and RMAN for building standby database, Reporting Database, PITR, Platform Migration
• Backup and Recovery: Experienced in using Export/Import, RMAN with MML VERITAS Netbackup, EMC Networker
• Disaster Recovery: Experienced with Dataguard setup, physical and Logical standby database creation
• Storage management: Experienced with LVM (RAW device) and ASM
• Character set conversion.
• 24/7 On-Cal Production Support.
• GRID: Installing OEM agents and managing databases using GRID Control
• Managing:
• Proactive Health Check and Alert Monitoring
• Growth Trending and planning for Capacity (LVs, VGs and Memory)
• Planning LVs, VGs, SGA, UNDO, IO and REDO log size
• Creating “Change Requests” and Service Requests” internally for any Production change and also raising Oracle OneStop SRs and General SRs.
• Knowledge in Oracle 11i/12Apps DBA, Basic Architecture of Apps, Installation, Cloning Oracle Home, database and Application, Migration, applying patches.

Professional Certifications

• OCA 10g certification : Administration I
• OCP 10g certification : Administration II

Expert IT Skills

Database Systems : Oracle 8i, Oracle 9i, Oracle 10g and Oracle 11g database administration and management.
Languages : C, C++, HTML, SQL, PL/SQL, Shell scripting
Operating Systems : HP/UX v2/v3, Solaris 9, AIX 5.3, RHEL 4.x/5.x, Open VMS 7.3/8.3, Citrix 4.x
Platform : HP RX servers, HP blade server, Alpha servers, IBM blade servers, IBM power series, Solaris, HP
Storage XP and EVA
Tools/Utilities : OEM, GoldenGate, Toad, NMON, OSW, RDA, Prowatcher, Remedy, Siebel Navigator, Erwin,Visio

Education

Bachelor of Engineering in Instrumentation.

Employment History

Confidential,Denver,CO June 11 – till date
Role : Sr Database Adminstrator

Oracle DBA supporting their infrastructure environment for mission crital Tier-I database associated with Application related to Billing and Revenue System. Cordinate with different product owners to accomplish projects with new installations/configurations/bug fix patches, involve with offshore to escalate off peak task and primary dba for in-house application with responsibility of Dev,QA,POC and Prod databases

• Installation of Oracle 11g Clusterware and upgradation of 10g RAC database in Test and Prod environments.
• Intensive research for upgradation of current voting disk, ocr ,asm metadata
• Providing process for schema, QA database refresh and coordinating with offshores
• Resolve issues related to rac node reboot / instance evictions by applying PSU, bug fix patchsets
• Written pl/sql code to upload bulk insert jobs related to business objects for telecom circuits, commercial customers and bill revenues
• Improve rman backup shells to keep Dataguard in syn with primary
• Troubleshoot databases, provide reports on the database health check,capacity plan follow up and recommendations
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance
• Diagnose and resolve performance, connectivity, security and database corruption,node eviction issues in a critical production environment
• Responsible for Oracle Cluster configuration add/delete node-instance , service configuration with scalability and ASM diskgroup configuration
• Architect their Replication environment with partner systems using Goldengate and resolve issues related to lag, process abends, bug fixing.

Environment: Oracle 11g/10g RAC, Oracle BRM, Goldengate 11.1, OEM, PL/SQL, Pegasys, OBIEE, AIX,
Sun Solaris,Linux.

Confidential,Pheonix,AZ Dec 10 – May ‘11
Role : Sr Database Adminstrator

Confidential,supported their brokerage and banking production databases. Design migration process cross platform prototyping, architect ETL repository for business objects related to stipulation, partner calendars

• Installation, configuration and upgradation of Oracle 10g to 11g-rel2 RAC database.
• Working on different CORE applications with automated database objects scripts deployment in different environments, providing support to fine tune process, supporting different application groups for problem resolution with root cause analysis, performance tuning on queries with alternate solutions depends on application requirements.
• Supported tests, performance analysis in very rapid application deployment cycle with timeframe decided by different application groups.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Troubleshoot databases, provide reports on the database health check,capacity plan follow up and recommendations
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance
• Install/configure Oracle Goldengate 11.1 for bi-directional replication and resolve conflicts with coding parameters
• Responsible for monitoring and estimating the size of the database & growth, and configuring the database accordingly
• Diagnose and resolve performance, connectivity, security and database corruption,node eviction issues in a critical production environment
• Responsible for Oracle Cluster configuration add/delete node-instance , service configuration with scalability
• Architect their Replication environment with Reference DB hubs with implementation of Goldengate and conversion of Streams, DBMotto processes
• Architect their Replication environment with Reference DB hubs with implementation of Goldengate and conversion of Streams, DBMotto processes
• Strong ability with UNIX shell scripting to automate tasks and also in crontab and dbms_scheduler for scheduling jobs

Environment: Oracle 11g RAC, Oracle 10g, River charles, Goldengate 11.1, PL/SQL, Websphere ,Toad, Lombardi,
AIX, Sun Solaris,Linux.

Confidential,PA Jan 2009 – Nov 10
Role : Sr Database Adminstrator

AmeriGas Propane is a provider of gas cylinder to Retails / Commercial / Merchants and I am responsible for their Oracle Databases. There were many development projects which were going on, as a result of ever growing demand of new databases in the organization, the development projects were more client based, which included all the client related information as well as investment data, other tasks also included supporting production databases.

• Installation, configuration and maintenance of Oracle 11g RAC database.
• Reviewing of database design document, providing conceptual and logical data model and translating into physical database
• Have worked as Data modular building complex logical data models using sophisticated modeling techniques and tools like Erwin ( Erwin 7.2 7.1) and Visio.
• Installation and creation of Oracle 9i databases on Production and Test Solaris servers. Responsible for upgrade & migrating databases from 9i to 10g, applying patches. Refresh test database from production using Recovery Manager (RMAN).
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Troubleshoot databases, provide reports on the database health check, follow up and recommendations
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance
• Install/configure Oracle Goldengate 10.4 for bi-directional replication and resolve conflicts with coding parameters
• Responsible for monitoring and estimating the size of the database & growth, and configuring the database accordingly
• Responsible configuring listeners for network connectivity and security.
• Diagnose and resolve performance, connectivity, security and database corruption issues in a critical production environment
• Responsible for taking regular backups including cold / hot backups, Export / Import of database, using RMAN, and recovery in case of disasters
• Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs and various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), move Archive Logs to different mount point when Archive Destination is full and Resync RMAN catalog
• Responsible for Load and Performance testing of the database servers and application servers, analysis and documentation of results
• Creation and maintenance of stand by database by using oracle high availability method Oracle Data Guard
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues
• Strong ability with UNIX shell scripting to automate tasks and also in crontab and dbms_scheduler for scheduling jobs

Environment: Oracle 11g RAC, Oracle 10g RAC, SAP 4.6c, Weblogic10g, Goldengate 10.4, SQL Server2005, OEM
Grid,Erwin, Visio.

Confidential,Kansas City,MO Nov 2006 – Dec 2008
Role : Sr Database Adminstrator

Confidential, is the leading supplier of healthcare information technology solutions that optimize clinical and financial outcomes. Around the world, health organizations ranging from single-doctor practices to entire countries turn to Cerner (NASDAQ: CERN) for our powerful yet intuitive solutions. Cerner offers clients a dedicated focus on healthcare, an end-to-end solution and service portfolio, and proven market leadership

I was responsible for more than 35 clients and 120+ complex database running on Oracle 9i, Oracle10g and Oracle 11g ranging from 100Gb to 20Tb with 1600 concurrent session. Providing fulltime production support where duties include all aspects of Oracle database administration including performance tuning, Oracle installation/upgrades, Database maintenance and Troubleshooting, CRS installation/upgrades, Database restore/recovery, Creating standby database and Database migration.

Worked and created workplans to implement as Cerner Standards. Some them to name are :

• To upgrade CRS/RDBMS/ASM from 10.2.0.3 to 11.1.0.7
• Moving Database from RAW LVs to ASM from 10.2.0.3 to 11.1.0.7 on AIX and HP-UX.
• Migrated database from 9.2.0.5 to 10.2.0.3 and 10.1.0.5 to 10.2.0.3 on all platforms using Golden Gate software.
• Migration of databases was from OpenVMS to aix /hp-ux and redhat using Goldengate 9.1 with zero downtime
• Setting Diagwait parameter/CSS MISSCOUNT value to 60sec
• Configuring/Setting HugePages on Linux
• Setting OS memory parameters like SHMMAX, SHMALL, page_steal_method and VMM configurations.
• Creation of Oracle Databases and Dev, UAT refresh using Datapump , Shell Script
• Configuration of AWR, ADDM and explain plan to monitor DB performance

Environment: Oracle 10g RAC, AIX4.7, Goldengate 9.1, SQL Server2000, Websphere

Confidential,India Dec 2004 – Aug 2006
Role : Oracle DBA

Project Scope: Project’s included building; maintaining and testing databases, involved in the entire development life cycle right from development to production, other tasks included were supporting and tuning oracle applications.

Responsibilities:

• Creation of the Test and Production Oracle 8i/9i databases.
• Maintenance and support of the Oracle Applications and Oracle Databases.
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Resolving Oracle listener and TNS names problems by using Net Manager and Oracle Net Configuration assistant.
• Database Administration and Planning including logical design, physical design, backup & recovery.
• Developing a backup and recovery strategy and tested several recovery scenarios.
• Perform ongoing database administration, maintenance, troubleshooting, tuning, installation, backup/ recovery.
• Management of table spaces for different users by granting quota on Default & Temporary tables paces.
• Implemented Tivoli Storage Manager for RMAN.
• Managing Application user profiles and managing concurrent managers, concurrent processing, load balancing etc.
• Creation of rollback segments and planning application activities accordingly to enhance system performance.
• Migrated database from Windows operating system to HP-UNIX server.
• Copying databases, monitoring system performance, SGA tuning, rollback segments, space usage.
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using UNIX Shell scripting. Implemented Basic Replication using materialized views.
• Estimated Storage capacity for database objects.
• Monitored the growth of the database objects for capacity planning.
• Export and Import of database objects to copy from one database to another database.
• Database security, job scheduling and documentation.

Environment: Oracle 8i/9.2,HP-UX, RH Linux, Sun Solaris, AIX, DB Studio, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, Rman, Tkprof, Stastpack, SQL Loader, Windows NT/2000

Confidential,Hyderabad, India July 2003 – Nov 2004

I got trained on Oracle version 9i/10g for 6 months and started working as lab instructor to train all the new associates and helping them to resolve issues. Responsibilities include:

• Configuring and Installing Oracle Software (Oracle 8i/9i) on Solaris 9, RHEL 4 and HP-UX V1 platforms.
• Worked on Hardware Platforms like SUNFIRE V20z, HP Proliant G3 and HP 9000
• Setting up the platforms for Oracle installation.
• Experience in implementing various backup and recovery Strategies (RMAN, HOT BACKUP, TSPITR).
• Creation of users with appropriate privileges and profiles.
• Table space Management, Data file & Log file Management.
• Worked with Heterogeneous tools like OEM, Export/import, SQL * Loader, Data Pump
• Collecting Statistics (STATS PACK, AWR and ADDM)
• Database Cloning using RMAN and binary cloning.
• Dataguard setup - Configuring Dataguard, testing and demonstrating switchover and failover.
• Knowledge in implementing multi master Replication and oracle Streams.