EXECUTIVE SUMMARY :

• Over 7+ years of experience in Oracle database administration, oracle internet directory, oracle discoverer administration with primary proficiency in installing, upgrading and configuring of multiple Oracle Enterprise Edition 8i/9i/10g/11g databases in UNIX (Solaris, AIX and HP-UX), Linux (Redhat, SuSe, ubuntu) and Windows (NT, 2003 and XP).
• Upgraded oracle databases from 8i to 9i, 10g to 11g and 10g RAC to 11g RAC.
• Adept in Database Administration activities such as patch installs, cloning, backup and recovery of mission critical databases, performance tuning, script development (UNIX shell scripting).
• Experience of performance tuning of various aspects of the database using utilities like tkprof, explain plan, Statspack, AWR, 10046 SQL trace, 10053 Oracle optimizer trace, SQL profiles, SQL outlines, SQL baselines, ADDM. Proactive monitoring to improve the areas in application and database using 10g OEM.
• Performed Backup and Recovery using RMAN and written shell scripts for scheduled online backups.
• Experience in basic and advance replication using Oracle Streams, oracle golden gate.
• Expertise in Installation, maintenance, upgradation, administration, backup and recovery of RAC Oracle Databases.
• Extensive experience in implementing Quarterly security patches.
• Proficient in implementing and maintaining Database Security (Users, Roles, Privileges), space management (logical structures such as tablespaces and rollback segments) and auditing of users.
• Experience in using 10g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.
• Proficient in SQL, PLSQL, Stored Procedures, Functions and Database Triggers.
• Proficiency in standby database (Data guard) installation, configuration, maintenance, and administration for disaster recovery on 10g/11g RAC.
• Export and Import of database objects to copy from Development database to Production database as well as copy the export dump file to tape which can act as a backup.
• Adept in RMAN backups, hot backups and logical backups.
• Adept in effective troubleshooting of problems encountered on a daily basis in production & development database environments along with the problems encountered in performance monitoring.
• Experience in different scenarios of OLTP and handling very large databases.
• Expertises in SQL query optimization.
• Experience in a wide variety of environments like SUN SOLARIS, IBM AIX, HP-UX, RHEL, and Windows 9x/NT/2000/XP.
• Adept in data modeling, Physical and Logical Database design, partitioning of tables and indexes, management of schemas.
• Excellent System Administration skills such as user, system & group management, system updates, performance monitoring, backup/recovery, disk & storage management.
• Exceptional communication and interpersonal skills. Ability to work efficiently as a part of the team and individually. Possessing excellent developmental and analytical skills.
• Proven ability to combine project and staff management with technical expertise to consistently exceed corporate goals.

EDUCATION:

• B.E in Computer Science & Engineering.

CERTIFICATIONS:

• Oracle Certified Associate (OCA)
• IZ0-007 Introduction to Oracle 9i SQL
• IZ0-147 Program with PL/SQL

TECHNICAL SUMMARY:

RDBMS:

Oracle 11g,10g,9i,8i, MS-Access

Tuning Tools:

Tkprof, 10046 SQL trace , 10053 Oracle optimizer trace , SQL profiles ,SQL outlines, SQL baselines., Statspack, AWR, ADDM

Tools & Utilities:

SQL* Loader, RMAN,EXP,IMP, expdp, impdp, TOAD, Oracle Enterprise Manager, OAM

Operating Systems:

UNIX, Sun Solaris 8,9,10,11 AIX 5.1,5.2,5.3,6.1,7.1 HP-UX 10.x,11.x, Windows 2000/XP, Red Hat Linux 9

Data Modeling & ETL:

Rational Rose, UML 2.0, Visio 2003, Erwin 4.0, Informatica 5.1

Languages:

SQL, PL/SQL programming, Unix Shell Scripting, Java, HTML, J2EE

Web Technologies:

HTML, XML, Dreamweaver, Flash, AJAX,XHTML

GUI:

VB 9.0, Developer 2000 Forms 5.0/6i/9i/10g, Reports 3.0/6i/9i/10g

Network Concepts:

TCP/IP, FTP, HTTP

Applications:

MS-Office, Eclipse, VMware, JBuilder, Net Beans, MS Project 2003

Hardware/Storage:

IBM TSM, VERITAS NetBackup7.0, NetApp, HP Omniback

WORK EXPERIENCE:

CLIENT : Confidential,
WESTWOOD, MA
ROLE : ORACLE CORE DBA/APPS DBA
DURATION : OCT-11 TO Till Date
ENVIRONMENT : Oracle 9i Solaris 5.8, Oracle Apps 11.5.10.2, Windows XP,
SQL*Plus, SQL * Loader, OEM, PL/SQL Developer,
Import, Export, Toad

Responsibilities:

• Upgraded oracle database from 9.2.0.8 to 11.2.0.2 on AIX.
• Involved in Cloning and patching of oracle database 9.2.0.8 and oracle applications 11.5.10 from production to test.
• Upgraded oracle applications technology stack from ATG RUP 5 to ATG AUP 7 and

developer home from patch set level 17 to 19 and applied some module level MLR patches to bring the application to minimum level supported by oracle.

• Deployed jinitiator with java plugin on oracle application EBS 11.5.10.2.
• Responsible for trouble shooting on issues related to EBS and custom applications during various stages of upgrade.
• Responsible for configuration and implementation of backup and recovery using RMAN and user managed backups.
• Setup and configured network TCP/IP on AIX servers including RPC connectivity for NFS. Created mount points for Server directories, and mounted these directories on the Servers
• Monitor data dictionaries, alert log file, trace files, maintain control file, online redo log files and data files. Manage tables & indexes and maintain data integrity
• Provided Database Administration support (24x7) for various production and non-production databases.

CLIENT : Confidential,STAMFORD, ct
ROLE : ORACLE DBA
DURATION : JAN –10 TO SEP-11
ENVIRONMENT : Oracle 11g RHEL5, IBM AIX 5.3, Windows XP,
SQL*Plus, SQL * Loader, OEM, PL/SQL Developer,
Import, Export, Toad.
Responsibilities:

• Responsible for Installation of 11g database on 2 nodes RAC, Grid Infrastructure with ASM file systems.
• Expert in effective troubleshooting of those problems encountered on a daily basis in production & development database environments along with the problems encountered in performance monitoring.
• Provided Database Administration support (24x7) for 3TB production oracle 11g Databases.
• Responsible for installation, creation of 11g RAC databases for Development and user acceptance test.

• Responsible for Upgrading the Database from 10.2.0.3 to 11.1.0.6.Configured ASM file system and administering ASM Instances and Disk Groups in RAC.
• Responsible for SQL query tuning, optimization. Performance tuning using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.
• Responsible for undo rollback management. Created database objects, users, roles and profiles
• Responsible for implementing Load Balancing in RAC Database.
• Implemented Fast Connection Failover and Transparent Application Failover for ensuring Database High Availability. Created and Managed Services using DBCA.
• Excellent in depth understanding of Oracle automatic Undo Management.
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• Updated development databases by using import/export and SQL loader utilities.
• Responsible for monitoring Oracle database activities using Oracle Enterprise Manager.
• Responsible for configuration and implementation of backup and recovery using RMAN.
• Installed and configured Recovery Manager Catalog Database.
• Configuration of Oracle golden gate for replication between two databases.
• Responsible for automation of startup and shutdown on all production and development databases.
• Involved in migrating database from RHEL 4.2 to Aix 5.3
• Involved in scheduling transaction log backups and notifications.
• Involved in export and import of database objects in order to copy them from one database to another & copying the export dump file to tape.

Extensively used LVM on both AIX and RHEL, created VGs, LVs, Filesystems and disk mirroring.
Setup and configured network TCP/IP on LINUX and AIX servers including RPC connectivity for NFS. Created mount points for Server directories, and mounted these directories on the Servers.

• Responsible for User Acceptance testing and supporting the end users by resolving problems faced by them.

CLIENT : Confidential,FINDLAY, OH
ROLE : ORACLE DBA
DURATION : MAR –08 TO DEC -09
ENVIRONMENT : Oracle 10g, Red Hat Linux 4.x, Toad, Spotlight, Foglight,
SQL*Plus, SQL*Loader, OEM, PL/SQL Developer,
Import/Export, Forms 4.5/5.0, Reports 2.5/3.0

Responsibilities:

• Responsible for installation and creation of workstation databases for production development and user acceptance testing.
• Upgraded the database from 9.2.0.4 to 11.1.0.6 and applied patches when required.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, Statspack, Explain plan and SQL*Trace.
• Reorganization of segments (tables, indexes) to release space and increase the performance.
• Partition of tables and indexes to increase the performance.
• Populated staging tables with data using SQLLDR and PL/SQL.
• Created database objects, users, roles and profiles.
• An active member of the backup and recovery team and was responsible for configuration and implementation of backup and recovery using RMAN. Installed and configured Recovery Manager.
• Configuration of Oracle streams for replication between two databases.
• Responsible for monitoring Oracle database activities using Oracle Enterprise Manager. Hence responsible for setup and configuration of OEM.
• Involved in Data refresh from production to test and development.
• Involved in export and import of database objects in order to copy them from one database to another & copying the export dump file to tape.
• Responsible for User Acceptance testing and supporting the end users by resolving problems faced by them.
• Experience in recovering the database in case of failure (Complete/Incomplete recovery)
• Wrote scripts for database maintenance activities such as monitoring the growth rate of tablespaces and extents.

CLIENT : Confidential,CLEARWATER, FL
ROLE : ORACLE DBA
DURATION : JULY –06 TO JAN -08
ENVIRONMENT : Oracle 9i/10g, SQL, RMAN, OEM, SQL* Plus, Oradebug,
Statspack, tkprof, Export / Import, Toad, UNIX,
Sun Solaris8

Responsibilities:

• Responsible for Installation, administration and upgrade of Oracle RAC 9i/10g & Oracle 9i/10g production and development databases and provided 24*7 support.
• Upgraded single instance 9.2.0.8 Database to 10.1.0.2, 10.2.0.2 RAC database
• Responsible for tuning SQL queries.
• Responsible for implementing cold/hot/logical backup procedures using shell scripting and also using RMAN. Developing, testing & implementing strong backup and recovery strategy. Also responsible for monitoring backups.
• Responsible for installing and maintaining the standby database.
• Applied patches whenever necessary by downloading them from Metalink.
• Responsible for developing stored procedures, functions and database triggers.
• Ensuring high availability using VERITAS Clusterware.
• Dealt with copying database objects from one database to another database using export.
• Expertises in performance tuning using TKPROF, EXPLAIN PLAN, Statspack etc. Materialized views are used to enhance performance, tables and indexes are partitioned
• Participated in physical and logical data modeling and design of the database.
• Efficiently handled day to day production problems and user security.
• Rebuilt indexes for better performance of Oracle database
• Cloning of database for development and test environments.
• Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.
• Involved in remote database maintenance.
• Responsible for setting up of oracle client server environment
• Responsible for defining user roles administration, schema management, space management activities like adding datafiles, resizing datafiles and creating tablespaces etc.
• Involved in developing functional and technical documents, also involved in UAT.
• Responsible for setup and configuration of OEM providing proactive alerts.
• Configuration of listeners using NETCA and starting and stopping the listeners.
• Developed PL/SQL stored procedures, database triggers and packages. Assisted developers in writing PL/SQL procedures.

CLIENT : Confidential,MINNEAPOLIS, MN
ROLE : ORACLE DBA
DURATION : DEC -04 TO JUNE -06
ENVIRONMENT : Oracle 8i, 9i, SQL, Statspack, HP UX, Trace Analyzer,
Ms Excel, Java

Responsibilities:

• Responsible for Installation, administration and upgrade of Oracle RAC 9i/10g & Oracle 9i/10g production and development databases
• Upgraded the database from 9.2.0.6 to 10.2.0.2.Also migrated the database using migration utility and export/import tools.
• Upgraded single instance 9i Database to 10gR1,10gR2 RAC database
• Held Primary DBA position and worked in coordination with the database management team. Actively involved in designing and supporting web applications database for MetLife.
• Responsible for developing PL SQL stored procedures and functions.
• Involved in database migration from single instance to RAC using database upgrade assistant and export/import.
• Responsible for setting up hot and cold backup and testing all backup and recovery scenarios.
• Performed security management by creating users, granting/revoking roles and privileges.
• Responsible for database space management and monitoring the database growth using shell scripts.
• Used SQL trace to assess the efficiency of the SQL statements.
• Involved in database replication using Oracle streams
• Responsible for tuning SQL queries and using joins and indexes effectively for query optimization.
• Responsible for reviewing documentation, installation and upgrade plans.
• Worked as a part of the team in implementing disaster recovery using Oracle 8i standby database.
• Did redo log management by resizing existing redo log members and creating new redo log members as and when required.
• Responsible for instance management and editing the initialization parameter file.
• Converted flat files to database files using SQLLoader.
• Developed PL SQL functions and cursors for various calculations in the application.
• Responsible for cloning the oracle database from production to development and test environments.

CLIENT : Confidential,INDIA
ROLE : ORACLE DEVELOPER
DURATION : OCT -03 TO NOV-04
ENVIRONMENT : Oracle 8i, SQL*PLUS, PL/SQL, Java, JSP, Reports 2.5, Toad

Responsibilities:

• Wrote Event Triggers, PL/SQL Program Units for Reports for Client Validations.
• Wrote generic PL/SQL code modules (PL/SQL Libraries) for Reports to handle data manipulations on client.
• Wrote Database procedures, Packages, functions to handle data manipulations and Computations on the Server.
• Designed and developed the web – based application using Java Servlets and JDBC concepts and JavaScript. Also consists of various metrics developed using Java Applets.
• Created custom reports like customer details, Premium due based on the entered period.
• Designed and developed Oracle Monthly Reports.
• Involved in writing Unix Shell scripts for automation.
• Responsible for technical support of Sentori product.
• Used FTP to transfer dump files from production server to testing server.