SUMMARY
Over 9 years experience as ORACLE DBA (8i/9i/10g/11g) on different Operating systems including: AIX, Linux, Red Hat Enterprise Linux, Unix-AIX, HP-UX, Sun Solaris (5.6/5.7/5.8/5.9) and Windows 2000/NT/XP.

• Support of Oracle 9i, 10g and 11g, SQL Server, and DB2 Databases on AIX, HPUX, LINUX, and Windows platforms.
• Responsible for providing database support and performance tuning on both an online-transactional and online-analytical processing environment.
• Developed rules and standards for the access and maintenance of shared data resources using Oracle.
• Designed technologically advanced solutions to meet customer\'s mission, objectives, and requirements.
• Improved automation, operation stability, and performance by researching new features and functionality with each release.
• Ensured database configurations comply with published standards.
• Developed transaction logging and backup/recovery facilities.
• Participated in defining and implementing data security and logical to physical database mapping and table parameters.
• Created database schemas and sub-schemas and Work with application development teams to ensure efficient data access in application programs and to review test benchmarks and statistics.
• Reviewed overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirements.
• Assisted in technical support in the definition and resolution of database problems.
• Tuned and improved application SQL code, database configuration parameters and system disk configurations.
• Acted as the primary interface between the Critical Systems team and the middleware/DBAteam.
• Provided complete documentation on developed recommendations and solutions.
• Provided technical assistance to IT support staff.

PROFESSIONAL SUMMARY

Confidential Jan 2011-Present 
Role – Sr Oracle DBA

Responsibilities:

• Working and troubleshooting all kinds of technical issues related to SAMS CLUB databases and Online Customer Orders Management System.
• Provide 24x7 on call Support for Remedy issues and tickets and interact with Off-Shore teams and drills in India.
• Handle all aspects of ORACLE RAC clusters and Data Guard and maintain a High Availability Architecture with preferably zero downtimes.
• Handle and troubleshoot all aspects of Oracle Enterprise Manager Grid Control and Agents.
• Interacting with Client DBA team and teams in Brisbane, CA to work on Production issues and database refresh.
• Activities and testing and switching over of existing DATAGUARD physical standby databases.
• Working on a migration plan to upgrade database applications from 10g to 11g platform.

Environment: Oracle 10g R2, 11g R1,RAC,DATAGUARD, ASM, Red Hat Enterprise Linux, Windows XP/Server 2000, UNIX Shell Scripts and Perl Scripts, Tivoli Manager, VERITAS NET BACKUP,TOAD, ORACLE SQL DEVELOPER 2.1, Tkprof and SQL*Net/Net8.

Confidential Aug 2010- Jan 2011
Sr Oracle DBA

Responsibilities:

• Configured optimal Oracle 10g/11g RAC architecture and Golden Gate Replication.
• Performance Tuning for Oracle Real Application Clusters (RAC).
• Prepared plans for upgrading of all critical Production Databases from 10g to 11g on Linux and ACTIVE ACTIVE DATAGUARD implementation with RAC.
• Interacting with Vendor support to resolve issues
• Worked on changing NLS Character sets
• Resolution of production issues which included interacting with Oracle Support as we as Metal ink Usage.

Environment: Oracle 10g R2, 11g R1,RAC,DATAGUARD, ASM, GOLDENGATE, Red Hat Enterprise Linux Windows Server 2000, UNIX Shell Scripts, VERITAS NET BACKUP,TOAD, Tkprof and SQL*Net/Net8

Confidential. May 2010-July 2010
Sr Oracle DBA

Responsibilities:

• Installation, upgrading and maintenances of Oracle databases on Linux and Windows platforms.
• Performed upgrades with the team and upgraded all machines from Oracle 9i to Oracle 11g.
• Administered Oracle 9i and infrastructure support using Oracle OEM and Oracle 11g OEM.
• Responsible to test and implement the new features of Oracle 11g including: working on aspects of Database Replay, partitioning, Transaction Management, SQL Performance Analyzer, etc.
• Explored and worked on innovative new features of Oracle 11g in terms of Automatic Health Monitor, Automatic Diagnostic Repository and other resiliency features
• Provided system support for both development and 24/7 production environment.
• Strong and extensive use of DDL and DML tools. Maintained database schemas and dictionaries.

Environment: Oracle 9i/11g, AIX 4.3/5L, Sun Solaris (SUNOS 5.9), Toad, WINDOWS NT/2000, RMAN, ERWIN 3.2, SQL*Plus, UNIX Shell Scripting, SQL*LOADER, Oracle OEM.

Confidential Apr 2008 – Apr 2010
Los Angeles, CA 
Sr Oracle DBA

Responsibilities:

• Installation, upgrading and maintenances of Oracle databases on Linux and Windows platforms.
• Performed upgrades with the team and upgraded all machines from Oracle 10g to Oracle 11g.
• Responsible to test and implement the new features of Oracle 11g including: working on aspects of Database Replay, partitioning, Transaction Management, SQL Performance Analyzer, etc.
• Explored and worked on innovative new features of Oracle 11g in terms of Automatic Health Monitor, Automatic Diagnostic Repository and other resiliency features.
• Backup of database using Logical and Physical (hot and cold) procedures and also RMAN.
• Configured optimal Oracle 9i/10g RAC architecture.
• Performance Tuning for Oracle Real Application Clusters (RAC).
• Performed database monitoring, capacity planning and performance tuning.
• Managed database security. Create and assign appropriate roles and privileges to users depending on the user activity.
• Performed logical design, modeling, E-R diagram activities using Data Modeling Tools, normalization, indexing, foreign key, and constraints.
• Implemented and tested backup strategies.
• Ran scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation, etc.

Environment: Oracle 9i, 10g RAC, Red Hat Enterprise Linux Advanced Server, Windows Server 2000, UNIX Shell Scripts, Toad, and SQL*Net/Net8.

Confidential Apr 2007 –Mar 2008
Sr Oracle DBA

Responsibilities:

• Set up and maintained Oracle disaster recovery site using DATAGUARD.
• Performed performance tuning by using Oracle utilities like Stats Pack, Tkprof for addressing performance bottlenecks.
• Utilized RMAN for backup and recovery strategy.
• Performed database tuning by using various tools like: Oracle Enterprise Manager and STATSPACK.
• Performed daily monitoring of Oracle instances using Oracle Enterprise Manager, TOAD, users, tablespaces, memory structures, rollback segments, logs, and alert.
• SQL Tuning using explain plan, TKPROF with SQL trace and SQL Tuning Advisor.
• Installed and configured 10g Enterprise Manager and Grid Control.
• Established database backup/recovery strategy for different databases.
• Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
• Setup and support of Oracle replication (replication and conflict solution).
• Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• Developed Shell scripts to monitor the storage usage and object status for daily job.

Environment: Oracle 9i /10g, HP-UX 10.2/11.0,SUNOS 5.8, Windows NT 4.0, Windows Server 2000, Erwin 4.14, Unix Shell Scripts, TOAD and SQL*Net/Net8.

Confidential May 2006-Mar 2007 

Oracle DBA

Responsibilities:

• Administered all database installation, creation, modification, and tuning issues of Oracle.
• Database Security Administration involved: creation of users and management of their roles and privileges.
• Configured databases using latest features of Oracle 9i like Undo-Tablespace, Locally Managed Tablespace, and Sorting Parameters.
• Experience with installing/configuring and maintaining Oracle 9i Real Application Cluster Database for high availability, scalability and performance which included: determining the Cluster architecture, choosing the best MPP RAC servers and hardware and configuring the raw disks for Oracle RAC.
• Analyzed the database to allow Oracle optimizer to choose best plan in executing the queries.
• Implemented Oracle Replication to enable database fail over in the event of system or database crash.
• Database activities included: allocation and maintenance of Rollback Segments, Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.
• Experienced in using utilities like Export/Import and SQL Loader.

Environment: Oracle 9i/10g RAC, Linux Cent OS, SUNOS 5.7, WINDOWS NT/2000, RMAN, SQL*Plus, SQL*LOADER, Oracle OEM, Import/Export Data pump, STATSPACK.

Confidential. Apr 2005 – Feb 2006
Oracle DBA

Responsibilities:

• Performed Database performance tuning and monitoring.
• Designed and implemented security policies.
• Utilized Oracle Export and Import utilities to perform logical database backup and recovery, move Oracle data from one machine, database or schemas to another and to detect database corruption.
• Controlled and monitored user access to the database.
• Used File Transfer Protocol to transfer files from one location to another on local disks and across the Internet.
• Created schemas with partitioned external tables for a production environment using SQL Plus.
• Administered Oracle 9i and infrastructure support using Oracle OEM.
• Configured and used Oracle Log miner and Oracle Flash Back for minor recovery of the objects.
• Populated Oracle tables with data from external and non- Oracle files using SQL*Loader utility.

Environment: Oracle 9i/10g, AIX 4.3/5L, Sun Solaris (SUNOS 5.9), Toad, Oracle OEM, RMAN WINDOWS NT/2000, ERWIN 3.2, SQL*Plus, UNIX Shell Scripting, SQL*LOADER

Confidential Feb 2003 – Mar 2005
Oracle DBA

Responsibilities:

• Responsible for Oracle 8i logical and physical databases design, implementation and maintenance on UNIX.
• Installed, upgraded and patched Oracle software. Set up brand new machines including Oracle software installation.
• Migrated and upgraded databases from version 7 to 8i.
• Developed some UNIX Shell scripts to automate database operation and database monitoring.
• Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery.
• Installation and configuration of Statspack and analysis of Statspack performance report and subsequent tuning of production databases.

Environment: ORACLE 8.0/8i, HP-UX, Sun Solaris (SUNOS 5.6) RS 6000, ODBC, TOAD, SQL
*PLUS, RMAN, Shell Scripts, Korn Scripts.

Confidential Aug 2001-Jan 2003 

Junior Oracle DBA

Responsibilities:

• Installed and maintained Oracle 9.x/8.x for development, testing and production purposes.
• Implemented database refresh with the hot backup using DUPLICATE or full export
• Used EXPORT/IMPORT to do table level and full database defragmentation.
• Worked extensively on database sizing, rollback segments and queries.
• 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. Worked with SQL queries in the Oracle database.
• Oracle installations/upgrades/backup and recovery.
• Configured databases for adequate performance and availability.
• Helped developer to install Oracle Client, troubleshot and established the connection to Oracle database.
• Implemented backup/recovery and database monitoring strategies using Unix Shell scripts and Oracle enterprise manager (OEM).

Environment: Oracle 8.x, 9i, SQL, Sun Solaris, Windows NT/2000, OEM, Statspack, Rman, ftp, SQL*Loader, ERWIN.

CERTIFICATIONS: Sun Certified Java Programmer (SCJP), OCP 9i/10g.

EDUCATIONAL QUALIFICATIONS
MS Computer Science 
MCA (Masters in Computer Applications 
Bachelors in English Honors