SUMMARY

• Over 6 years of experience as Oracle DBA in large Production Environments on Oracle 9i, 10g and 11g.
• Worked on all flavors of UNIX including Solaris, Confidential - AIX, HP-UX and Linux. Experience in installation and configuration Oracle databases 9i, 10g. 11g. Experience in fundamentals and advanced replication with Golden Gate software including troubleshooting, installation and configuration..
• Experience on Backup and Recovery using RMAN on 9i, 10g. Experience in data transfer utilities like SQL*loader, Data pump and import/export. Experience in logical and physical data and handing table with large partitions. Performed upgradation of databases from Oracle 9i to Oracle 10g.
• Experience in configuration of storage of Oracle databases on Automatic Storage Management (ASM).
• Tuned Oracle databases for optimum performance using Explain Plan, Auto trace, TKPROF and Statspack utility, and Automatic Workload repository (AWR), and Automatic database diagnostic monitoring (ADDM). Experience in startup and shutdown of databases, monitoring table space growth, analyzing tables and indexes, trimming the alert log files, monitoring backup logs.
• Experience in implementing physical standby databases (Data guard).
• Extensive experience in database patching and database cloning. Experience in writing shell scripts and scheduling jobs using Cron jobs and DBMS scheduler. Extensive work experience in VLDB environment (Very large database) and in providing (24*7) production support.
• Additional responsibilities have been Interaction/Communication with Oracle for Technical Support and raising TAR’s (Technical Assistance request), handling day to day problems, assisting developers and other users in writing complex queries. Participated in project meetings to provide primary PDBA feedback before, during or post implementation of new databases.
• Pursued proactive Analytical approach to troubleshooting and problem solving.

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, 11g

DB Management Tools: Oracle Enterprise Manager-Database Control, Grid Control, RAC and Dataguard, Streams Replication, ASM, Import/Export, Datapump,SQL*Loader, Statspack, AWR, ADDM, Oracle Scheduler, TKPROF,Shell script, RMAN, Toad, Cron jobs, WISE Oracle Tuning Pack.

Operating System: Windows 98/NT/2000, RHEL AS 3.0, 4.0, Sun Solaris 5.9/.10, HP-UX 11.0, AIX 5.3.

Languages: C, C++, Java, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Oracle DBA

Responsibilities:

• Successfully upgraded Oracle 10g R2 (10.2.0.4) to Oracle 11g R2 (11.2.0.1).
• Supported installation and setup of Oracle Clusters and RAC database. Automated various DBA tasks including creating databases, binaries installation and backups using shell scripts. Performed database Backup/Recovery using RMAN, Import/Export, Hot/Cold backups and Datapump tools.
• Used RMAN for Archived Databases, scheduled backups using incremental, complete & full backup strategies based on database purposes. Handled complete & incomplete recovery in case of database failure.
• Sizing the SGA, Database buffers, Shared SQL area, and log buffer based on the requirements.
• Performed logical backup using export/import and data pump (remote export) utilities.
• Performed daily incremental backup and full weekly backups during the weekends. Wrote UNIX shell scripts to perform backup & schedule it on Crontab. Performed manual database creation for development and testing environments. Responsible for creating hot backup and recovery scripts and plans.
• Implemented backup/recovery and database monitoring strategies using Unix Shell scripts and Oracle enterprise manager (OEM)

Environment: Oracle 9i, 10g-RAC-ASM R2,11g, Oracle GlodenGate, Oracle Enterprise Manager, Oracle Grid control, RHEL, HP-Itanium,, Confidential -AIX, DATAGUARD, PL/SQL, TOAD and SQL *Plus

Confidential, Houston, TX

Oracle Database Administrator

Responsibilities:

• High Availability and Disaster recovery setup using DataGuard and physical standby databases.
• Utilized OEM Grid Control to manage tablespaces, indexes, sessions, schemas & monitor instance locks, long running queries, listeners, free space, and extent growth.
• Created database objects, maintained production environment and applied schema level cluster.
• Performed database transfer using SQL*Loader, Import/Export and Datapump.
• Worked with data replication mechanisms like Oracle Golden Gate and tested Oracle Golden Gate on Linux. Performed backup and recovery of Oracle 10g RAC databases & tuned it for optimal performance.
• Supported the migration of Oracle datafiles to ASM file system. Written shell scripts on Unix/Linux environment related to DBA tasks. Monitored performance of the queries using Explain Plan, TKPROF, STATSPACK reports. Assisted the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace and SQL Tuning Advisor.

Environment: Oracle 9i/10g, OEM (Oracle Enterprise Manager) Grid Control, RAC and DataGuard, ASM, SQL *PLUS, PL/SQL, Sun Solaris 8,9,10, RHEL, Confidential AIX, RMAN, OEM, Statspack, TKPROF, Erwin.

Confidential, Utica, NY

Oracle DBA

Responsibilities:

• Supported different Databases like Production and Development environments. Performed upgradation of databases from Oracle 9i to Oracle 10g on Sun Solaris. Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
• Created physical standby database, worked with data guard to provide Disaster Recovery. Planned, tested & implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDMP and OS methods.
• Responsible for network configuration and involved in a Client - Server environment using TNSNames, LISTENER, Net Configuration Assistant and other configuration files. Created and Managed users, user profiles, tablespaces, datafiles, archive log. Customized UNIX shell scripts to automate routine DBA tasks of taking backups, exports, space usage monitoring and others.

Environment: OEM Grid Control, Oracle 9i, 10g RAC, Solaris 7, RMAN, SQL*Loader, Import & Export, Datapump, Data guard, RMAN, AWR, ADDM, Statspack, ASM, TOAD 7.4, Shell scripting, Data warehouse, AIX 4.3.

Confidential, NJ

Oracle DBA

Responsibilities:

• Created Unix shell scripts for automating Materialized views refresh and maintained Patch/Patchset Management. Maintained control files, online redo logs, archive logs, and Flash recovery area.
• Conducted daily routine checks on alert logs and trace files.
• Performed Backup and Recovery with export and import for non archive databases.
• Worked on performance and tuning on SQL queries wherever it is required. Involved in strategy and planning for Data migration from SQL Server to Oracle 10g. Generate and view status/error message reports during the migration. Managing tablespaces, user profiles, indexes, and storage parameters.
• Used transportable tablespaces for Migration of Data from one Solaris to Linux & AIX to Linux.
• Create/Maintain Indexes, Partitioned Tables, Views, and Sequences & Synonyms.
• Responsible to provide 24 x 7 database administrative activities over different database servers.

Environment: Oracle9i/10g, Oracle Enterprise Linux, Business Objects, SQL Server2000, SQL developer

Confidential, Mahwah, NJ

Oracle production DBA

Responsibilities:

• Installed and maintained Oracle 9i for development, testing and production purposes
• Installing and loading new patches necessary for Oracle and other applications relevant to Oracle
• Managed and resolved design issues during development. Moved database Schema changes to stage or production. Created and maintained UNIX scripts for Oracle maintenance and statistics
• Created stored procedures and triggers using PL/SQL for database managing utilizing TOAD developing environment. Created tables, views, index, partitioned tables, and cluster table
• Tune application with EXPLAIN PLAN. Configure databases for adequate performance and availability
• Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database
• Tuned parameters for a large monthly SQL* Loader job resulting in reduction of operation time. Implemented backup/recovery & database monitoring strategies using Unix Shell scripts & Oracle enterprise manager (OEM).

Environment: Oracle 9i, SQL, PLSQL, Sun Solaris, Win-NT/2000, OEM, STATSPACK, SQL*Loader, ERWIN.