SUMMARY

• 11 Years of experience in IT with Financial/Banking/ Pharmaceuticals Domain/Data warehouse Environment involving Oracle Installation, Database configuration and Administration, Unix System level Admin, Backup and Recovery, Tuning, Database Migrations, Stand by database setup, and troubleshooting of various Oracle Products/versions on different UNIX platforms covering Sun Solaris, Linux, AIX, HP - UX and Tru64.
• Extensive experience in database architecture designing, implementation and administration including installation, upgradation, backup and recovery, testing, implementation, QA, performance tuning, migration and support.
• Strong exposure in Installing / configuring / maintaining RAC, Datagaurd, Physical / Logical Standby environments.
• Experience with large databases up to 8TB
• Strong configuration and troubleshooting skills in ASM.
• Good experience in Performance/SQL Tuning reading statspack/awr reports, analyzing the Execution Plans.
• Expertise in Unix/OS level monitoring such as Memory usage, CPU and I/O usage.
• Experience in working with Production as well as Development environments.
• Strong experience in Database migration and up-gradation in various platforms. Done several Database patch-set installations as well in one-off patch installation using opatch.
• Expertise in SQL (DDL and DML), PL/SQL, functions, triggers and packages.
• Installation of Grid Control for new and existing databases.
• Setting up the Oracle Management Services and Agents.
• Expertise in Shell scripting.
• Establish basic security settings, understand basic HW configuration
• Configuration and Setup of High Availability Dataguard in 10g for replication.
• Performs database backup and recovery using Recovery Manager (RMAN)
• Downsizing and defragmenting the Very Large Databases by export / import, cloning them using RMAN Duplicate features and then upgrading them to Oracle 10g.
• Solid expertise in third party supporting software likes TOAD, Foglight.
• Performs data loading/extraction using Oracle utilities such as export/import, Data Pump, SQL*Loader
• Configures Oracle Enterprise Management Agent (MA) to be accessible via OEM Grid Control
• Support application teams/customers for any issues with oracle database systems.
• Analyzing the logs (alert) and trace (process/user) files to diagnose the problem
• Experience in working with Oracle product support using metalink to resolve critical issues.
• Cloning/Refreshing databases from production for development, testing purpose.
• Expertise in OEM grid control for monitoring database systems and scheduling backup jobs
• Willing to learn and support new technologies.

TECHNICAL SKILLS

HARDWARE: SUN Sparc servers, HP servers, Legacy Compaq, IBM AIX Machines, Pentium & Solaris based PC's

OPERATING SYSTEMS: SUN Solaris, HP-UX, AIX, Linux and WINDOWS 2000/2003

LANGUAGES: SQL, PL/SQL, UNIX Shell Scripting

DATABASES / TOOLS: ORACLE 8.x/9i/10g/11g, Recovery Manager (RMAN), Real Applications Cluster (RAC), VERITAS Backup, Developer 2000, SQL Loader, TOAD, Oracle Enterprise Manager

WEB TOOLS: HTML, Dreamweaver.

PROFESSIONAL EXPERIENCE

Confidential - Charlotte, NC

Sr. Oracle Database Administrator

Responsibilities:

• Installation and configuration of Oracle 11g/10g databases.
• Upgraded 30+ Oracle databases from 10.2.0.4 to 11.2.0.3.
• Backup and recovery - Database backups using RMAN.
• Given day to day general support to the users for DEV and SIT environments.
• Created and maintained the documentation for the all upgrades and other database related issues.
• Administering, monitoring, and troubleshooting the databases performance
• Applied CPU/PSU (Bug fixes) and other TNS security patches.
• Restore databases from one server to other from RMAN backups or by using exp/imp or datapump (expdp/impdp)
• Expertise in using oracle utilities like export, import, and OEM Grid Control.
• Worked with Weblogic team and configured TNS port connections, stop and start the web services
• Every day code deployments for DEV and SIT environments and solving deployment issues.
• Tuned SQL queries using TKPROF and EXPLAIN Plan.
• Developed UNIX shell Scripts for backups, monthly maintenance tasks.
• Worked with third party tools such as Quest Toad.

Environment: UNIX platforms: Sun Solaris 5.10, Database Versions: Oracle 10g/11g.

Confidential - Irving, TX

Sr. Oracle Database Administrator

Responsibilities:

• Working remotely and administering databases.
• Installation and configuration of Oracle 11g/10g databases.
• Migrating oracle databases from different flavours of UNIX to IBM-AIX platforms.
• Backup and recovery - RMAN backups, every day HOT and daily incremental for most of the databases, very few of them having cold backups.
• Extensive experience in RMAN recovery testing, RAC and standalone database.
• Upgrading oracle databases from 8i, 9 to 10g and 11g version.
• Re-creation/rebuild indexes.
• Administering, monitoring, and troubleshooting the databases performance
• Upgrade and migration the databases from 8i/9i to 10g, apply CPU/VTM/PSU (Bug fixes)
• Restore databases from one server to other from RMAN backups or by using exp/imp or datapump (expdp/impdp)
• Expertise in using oracle utilities like export, import, and expdp, impdp.
• Tuned SQL queries using TKPROF and EXPLAIN Plan.
• Developed UNIX shell Scripts for backups, monthly maintenance tasks.
• Work with third party tools such as Quest Toad and Quest Foglight.

Environment: All UNIX platforms: AIX, Sun Solaris 5.8/5.10, HP-UX and Windows, Oracle 8i/9i/10g/11g.

Confidential - Milpitas, CA

Sr. Oracle Database Administrator

Responsibilities:

• DBA team which was involved in the maintenance and giving 24/7 support of the Oracle 9i/10g/11g databases for the Production as well as the development environments.
• Installation and configuration of Oracle 11g/10g RAC databases with ASM on new servers. upgradation from 8i and 9i versions to 10.2.0.4
• Upgradation from 10g versions to 11g.
• Administering and monitoring the databases using OEM Grid Control.
• Running AWR, ASH and ADDM report as part of diagnosis.
• Installation of 10g agents for OEM grid control.
• Apply CPU patches (Bug fixes) and ensure that all the SOX requirements are met.
• Daily data refreshes using expdp/impdp.
• Configured standby database using Oracle DataGuard for Data Replication.
• Daily Backups using RMAN and co-ordinating with Storage team for regular backup issues.
• Cloning and refreshing the UAT and development databases using RMAN.
• Performance issue tracking and solution making using Statspack. Explain plan used to diagnose the long running queries, sql tuning applied if it required.
• Develop UNIX shell Scripts for backups, monthly maintenance tasks.
• Giving on-going support to Development/QA/End users on 24/7 basis.
• Solving the regular performance issues includes releasing the locks and query tuning.
• Perform Space Management & Troubleshooting the database issues.
• Change request Procedure followed to do changes in the production database and document the changes for the reference.

Environment: All UNIX platforms: Sun Solaris 5.10, HP-UX/Tru64, Linux, Windows 2003, Oracle 9i/10g/11g RAC, OID, OEM, RMAN

Confidential - Cambridge, MA

Sr. Oracle Database Administrator

Responsibilities:

• Installation and configuration of Oracle 10g databases
• Backup and recovery - RMAN backups, every day HOT and daily incremental for most of the databases, very few of them having cold backups.
• High availability database configuration and maintenance using HP Service guard failover, Dataguard (standby databases).
• Administering and monitoring the databases using OEM Grid Control.
• Install OMS and agents for OEM grid control.
• Upgrading the Grid databases from 10.1.0.4 to 10.2.x.x.
• Upgrade and migration the databases from 8i/9i to 10g, apply CPU/VTM/PSU patches and ensure that all the SOX requirements are met.
• Restore databases from one server to other from RMAN backups or by using exp/imp or datapump (expdp/impdp)
• Expertise in using oracle utilities like export, import, and expdp, impdp.
• Respond to alerts in a timely fashion that are generated by both OEM Grid control and Foglight (a monitoring tool from quest)
• Tuned SQL queries using TKPROF and EXPLAIN Plan, Oracle Partitioning and Indexing.
• Monitoring using OEM and examine Statspack/AWR/ADDM reports.
• Create and maintain users, roles and privileges.
• Develop UNIX shell Scripts for backups, monthly maintenance tasks.
• Work with third party tools such as Quest Toad and Quest Foglight
• Write pl/sql procedures as per the requirement.
• Work with the backup team to resolve all the backup issues, co-ordinate for Netbackup upgrades/maintenance tasks.
• Maintain the ticket queue by working on tickets and get the work done.
• Capacity planning and space management, tablespace reorganization.

Environment: All UNIX platforms: Sun Solaris 5.8/5.10, HP-UX/Tru64, AIX, Compaq Tru64, Windows 2003, Oracle 8i/9i/10g, OID, OEM, FOGLIGHT

Confidential - NY

Sr. Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle enterprise databases on sun Solaris boxes for production, development and staging databases.
• Upgraded Oracle home from 8i/9i to 10g.
• Logical Backups by Exports & Imports.
• Planning for backup and recovery of database information (Using RMAN, Logical Backup & Recovery)
• Installed Oracle 10g RAC on cluster environment.
• Involved in design and testing, maintenance of high availability systems like creating and maintaining standby production RAC databases.
• Upgrading Oracle databases to latest version and patch levels
• Involved in the routine DBA activities like DB monitoring, System monitoring, tuning database objects by properly sizing the tables/indexes for extents management, backups to tapes and recovery when required.
• Database refresh and cloning
• Creating Roles and managing users by granting them system privileges object privileges and context privileges.
• Involved in UNIX Administration like granting user privileges and security aspects.

Environment: Sun Solaris, Oracle9i/10g, IMP / EXP and OEM

Confidential

Data Center Administrator

Responsibilities:

• Installation, configuration and upgrading of Oracle server software and related products
• Maintaining archived data on tape
• Backing up and restoring the database
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Perform database tuning and performance monitoring
• Perform general technical trouble shooting and give consultation to development teams.
• Creating primary objects (tables, views, indexes) once application developers have designed an application.
• Work as part of a team and provide 7x24 supports.
• Offering assistance to developers in optimizing their applications, queries, etc.
• Install of Legato Networker 5.x and 6.1, jukebox
• Install and support of third party server applications including iPlanet, BEA Weblogic.
• Bouncing the web services as per user requests.
• Involving in BCV cut to replica of data from production to UAT/COB databases.
• Troubleshooting the daily system related problems reported by users accessing to the servers and analyze performance problems & recommend actions to alleviate problems.