SUMMARY

• Overall 3 plus years of experience as Oracle DBA on 9i, 10g, and 11g database servers with ASM and Standalone systems.
• Oracle Backup and Recovery (Cold backup / Hot backup / RMAN backup).
• Backups, Database Recovery, taking Logical Backups (with Export/Import).
• Proficient in Oracle RDBMS - including SQL, PL/SQL and all areas of database Administration.
• Experience monitoring Oracle RDBMS availability, database exports, tablespaces, and extents reports.
• Automated Storage Management (ASM) for 10g databases.
• Installation and setting up Grid Control.
• Worked in transactional Pharmaceutical, Finance and Medical Industries.
• Comfortable with both command-line and GUI interface.
• Installation, up gradation, configuration, administration and maintenance of very large Oracle data bases on different Unix OS-Sun Solaris, AIX, HP-UX, Linux and also on Windows 2000/NT/XP servers.
• Database admin for database ranging from 100GB to 1.5TB.
• On-call support and 24x7 DBA for production environment.
• Migrate and upgrade and maintained Oracle databases (10g, 9i)
• Implemented Backups & Recovery procedures and RECOVERY strategies for hot and cold Backups.
• Good experience of database Backup and Recovery using RMAN.
• Strong experience in OEM (Oracle Enterprise Manager), Oracle Data Guard, SQL* Net, SQL Loader and SQL*PLUS, STATSPACK, Explain Plan and TOAD.
• Proficient in writing UNIX Shell scripts to automate business process and daily backup.
• Experience in Application tuning using session trace file and TKPROF utility.
• Hardworking, dedicated and result oriented with good interpersonal and communication skills.
• Extensive experience in supporting multiple production databases running 24 x 7 mission-critical / OLTP applications demanding high availability and increased performance
• Monitoring of key tables to collect statistics on row-chaining/migration and implement methods to avoid redundancy thus eliminating performance bottle-necks.

TECHNICAL SKILLS

Operating System/Tools: AIX, HP-UX, SUN Solaris, LINUX, Windows 2000/NT/XP, UNIX shell script, PERL. Redhat Linux, Novell 2.2, MS DOS.

RDBMS: Oracle 11g, 10g, 9i

Languages: C, SQL, PLSQL, UNIX, HTML, Shell ScriptVisual Basics, PL/SQL

Tools: Oracle Enterprise Manager (OEM), OracleOracle Utilities, export, import, DBVerify, SQL loader, statspack, Grid-control, Database control, RMAN, Toad, Exceed

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Oracles DBA support for major Pharmaceutical and Rental Company 24/7 Oracle Support.
• Applied CPU patches on several Databases for various clients based on CPU assessment and oracle version compatibility.
• Completed onsite Disaster Recovery successfully within given timeframe.
• Installed OEM agent on 30 plus databases and did successful testing.
• Implemented import and export through traditional as well as using Data Pump and automated exports through Cronjobs for major transportation client.
• Monitored and configured backups to run successfully through Tivoli Storage Manger.
• Exposure to logical standy database and functionality.
• Created and maintain users, roles and privileges.
• Upgraded Critical Production Database from Oracle 9i to 10g r 2.
• Part of Knowledge Transfer team in collecting and making documentation for routine Oracle Procedures from legacy DBA.
• Created backups through RMAN and configured RMAN catalogue. Scheduling databases based on criticality.
• Created partition tables for non-partition tables successfully and implemented it on several Production Databases.
• Oncall support during Server upgrades and troubleshooting incase of any Databases issues.
• Monthly Database Refreshes from Production to Test Environments for Medical client.
• Worked and monitored RAC Databases and has some exposure to RAC functionality.
• Created Tablespaces and maintained Datafiles ranging from resizing datafiles and adding new datafiles as per the client standards for regular file system and ASM
• Installation and creation of new Databases on Linux servers with the latest Oracle version 11gr2
• Adding new partition tables and dropping old partition tables on a bimonthly basis for few Datawarehouse Databases.
• Performed Database Healthchecks on regular basis every month.

Environment: PL/SQL, SQL, SQL*Plus, Oracle 9i, 10g, 11g; AIX, Linux, Solaris, HPUX, OEM

Confidential, MO

Oracle DBA

Responsibilities:

• Primary DBA for 1.2 TB database for 24/7 support.
• Worked on OLTP and DATA WAREHOUSE.
• Created multiple databases for Development and Testing.
• Served as part of a 9 member DBA team which was involved in the maintenance of the Oracle 9i/10g database for the Production as well as the development environments.
• Actively involved in designing/Testing of Disaster Crash recovery.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g.
• Performance Monitoring and Tuning of Oracle Application Servers using Statspack, TKPROF, and OEM for tuning on 9i and on 10g using SQL access manager, SQL tuning manager.
• Performed database cloning/exp/imp to setup identical databases in the production and development environments.
• Created and maintain users, roles and privileges.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Perform Backup and Recovery thru RMAN.
• Applied Quarterly CPU (CRITICAL PATCH UPDATES) on all databases.
• Performed Export/Import through Data Pump.
• Used Grid Control for Monitoring 40+ database.
• Provided technical troubleshooting and give consultation to development teams.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Initiated Cronjobs to review alert logs and dump files to check for any ORA- errors.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.

Environment: PL/SQL, SQL, SQL*Plus, Oracle 9i, 10g, 11g; AIX, Linux, TOAD, OEM, SQL Developer and SQL navigator

Confidential

Jr. Oracle DBA

Responsibilities:

• Assisted in Configuration and Management of ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Worked with Senior DBA and learnt database refresh and managed Development and test environments.
• Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
• Worked as assistant in Migration of system and applications from Oracle 9i to 10g, 10g to 11g using Database
• Create multiple 11g databases on RHEL5 in development.
• Learnt to Schedule backup in 11g using db console.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g
• Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Constant monitoring of database space and space management
• Exposure to Setting up Oracle Standby Data Guard.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Learnt to improve the performance by Using the Hints, Indexes, Explain Plan
• Devised an efficient backup and recovery strategy and implemented it in line with Business requirements (SQL Backtrack and RMAN)
• Automating the backup processes using shell scripts. Performing recovery in cases of system crashes.
• Export and Import of User, Tables and Database using exp/imp and Data Pump. Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.
• Installed, Migrated configured and tested Oracle 11g databases in various environments.
• Worked as primary on-call DBA.

Environment: PL/SQL, SQL, SQL*Plus, Oracle 9i, 10g, Sun Solaris Unix, Linux Windows XP, Oracle Forms 10g, Oracle Reports 10g, Oracle Developer