SUMMARY

• Experienced in maintaining large Production, UAT, QA, SIT and DEV environments.
• Expertise in installing, configuring and maintaining Standalone and RAC databases on various platforms.
• Extensive Ability to Communicate and Co - ordinate Complex,Technical information with different teams
• Documenting technical specifications of Databases.
• Planned and Implemented DR & High Availability oracle solutions using Data Guard.
• Proficiency using Flash-Back Recovery, Automatic Storage Manager(ASM) & Automatic Database Diagnostic Manager(ADDM).
• Tuned the database at various levels such as Application Tuning, Memory Tuning, SQL Tuning and Database Contention, I/O Tuning by using TKPROF, Explain Plan, SQL Trace, UTLSTAT, Stats Pack, AWR and ADDM.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control(OEM)..
• Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups.
• Implemented data transfer using Export/Import utilities and Data Pump.
• Automated database periodic maintenance and activities using Korn, Perl Shell Scripts.
• Extensive Experience writing Stored Procedure, Functions, Trigger and packages using PL/SQL.
• Designed and developed PL/SQL scripts to monitor instances locks, long running queries, listener, free space, extents growth, etc.
• Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Worked extensively on Oracle Version Upgradation, Migrations and Patching..
• Used Repository manager to build Repository and managed Very Large Scale Databases (VLSD).
• Configured Oracle on different Operating Systems for OLTP and Data Warehousing environments.
• Assisted in designing conceptual, Logical and physical data models using Erwin, Pl/Sql Programming, Shell Scripts.
• Excellent communication skills, with strong troubleshooting, and problem solving ability.
• Worked as a team member to provide 24x7 on call support production database support.

TECHNICAL SKILLS

Database: Oracle 9i, Oracle 10g, Oracle 11g, Oracle Rac (10g & 11g), SQL Server, MySQL.

Technologies and Tools: Oracle Enterprise Manager Grid Control, Export, Import, Data Pump, RMAN, SQL Loader, Log Miner, ERwin 4 Data Modeler, PL/SQL, Putty.

Operating Systems: UNIX, Linux, Sun Solaris 8/9/10, AIX 5.6/6.1, HP-UX10.x/11x,Tru64Unix,WindowsNT/95/98/2000/XP/2003

Utilities: SQL*Plus, SQL * Net, SQL, PL/SQL, Import/Export, Stored Procedures, Triggers, UNIX Shell Scripting, Oracle

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Oracle DBA

Responsibilities:

• Involved Extensively in the EMERALD Data Centre Migration.
• Co-ordinated with different Application Management Team regarding migration approach, Dependencies and planned accordingly.
• Proposed Migration methods Based on the dependencies involved at the Application Level.
• Gathered Server and Database configuration information and proposed Requirements for the New Data Centre.
• Co-ordinated with the OFF-SHORE team and provided the required Inputs.
• Gathered technical requirements in accordance to Application team and Database team.
• Documented technical specifications of Databases on various servers.
• Successfully upgraded Production and Test databases from Oracle 9i (9.2.0.8) to Oracle 10g (10.2.0.3) on IBM-AIX nodes.
• Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.1.0.7) on IBM-AIX nodes.
• Installation, configuration, maintenance and tuning of Oracle 11g and 10g .
• 24x7 remote support and on call Database support for Database developers & end-users.
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Creating and Scheduling Oracle Backend Process Jobs in Crontab.
• Installed a new Rman catalog database and successfully registered more than 100 databases.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• Cloning & duplicating databases using scripts as well as RMAN.
• Monitoring the database storage and day-to-day activities.
• Performed all aspects of Database Administration including Installs, Upgrades, Patches Backup /recovery, Monitoring,Export/Imports.

Environment: Oracle 11g/10g/9i, RAC, AIX 5.6/6.1, HP-UX 11.1/11.23, Solaris 9/10, TOAD, SQL, PL/SQL,STATSPACK,AWR, EXPLAINPLAN.

Confidential, Buffalo, NY

Oracle DBA

Responsibilities:

• Managing more than 120 production, test and development instances in 24*7environment.
• Administering ORACLE Databases 10g (10.2.0.4), 11g (11.1.0.7) with over 5 TB in size.
• Involved in Installation of 11gR2 with ASM, Grid Control and Database upgrade from Oracle 9i to Oracle 11gR2 and applied patches as required.
• Setup of High Availability of the database using ASM enabled RAC for 10g/11gR2.
• Involved in 24x7 on-call support for 800GB 2 Node Production RAC database.
• Involved in construction of DR sites for all the Production environments.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Extensive experience in RMAN recovery testing, RAC and stand alone database
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests
• Monitoring Day-Day Backups, Log’s & recovering them as per the requirement. Utilized LOG MINER Technology & applied Application Database Transactions on other Databases.
• Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.

Environment: Oracle 11g/10g, RAC, Data Guard, UNIX, Solaris 10, TOAD, OEM, SQL, PL/SQL, TKPROF, EXPLAIN PLAN.

Confidential

Oracle DBA

Responsibilities:

• Involved in administering over 60 Oracle instances.
• Successfully upgraded Oracle 10g(10.2.0.3) to Oracle 11g(11.2.0.1).
• Installed Oracle Dataguard for Oracle Disaster recovery, High Availability and data protection.
• Installed and setup 10g Oracle Enterprise Manager Grid Control (10.2.0.3) and Mass Agent Deployment on several hosts.
• Implemented Oracle Database 10g two node Real Application Cluster (RAC) on a Linux system
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL and UNIX Shell Scripts for backups.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL, PL/SQL statements, reorganize database objects and design indexes to improve response of queries.
• Created PL/SQL, SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.
• Working Experience with Latest TOAD 9.6 having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Audit Objects.
• Implemented Oracle database backup & recovery solutions using RMAN and Exports/Imports.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created user accounts, roles and granting access permissions to the database..
• Extensive Responsible in configuring and backing up database using RMAN for hot backups, cold backups and logical backups
• Performed automated backups and scheduling using Perl scripting.
• Involved in designing logical & and physical data models using power designer.

Environment: Oracle 11g/10g,Oracle 10gRAC, Data Guard, Linux 4.x, AIX 6.1, OEM, PL/SQL, TOAD, Erwin, STATSPACK,AWR, EXPLAINPLAN.