SUMMARY

• 7 years of professional experience in Information Technology in design, development, implementation, maintenance, documentation and administration in various domains like pharmaceutical, Finance, and Insurance industries.
• Hands on experience on Oracle (8i/9i/10g RAC/11g RAC) database administration, schema implementation, backup, recovery, cloning, performance monitoring and tuning on different platforms like Windows, Unix /Linux (IBM AIX, Sun Solaris, HP - UX).
• Experienced in maintaining databases on large Production environments.
• Expertise in installing, configuring and maintaining Standalone as well as RAC databases on various platforms and responsible for 24x7 availability of the database. .
• Experience in Installation and administrations of Oracle 10g RAC, 11g RAC.
• Implemented Dataguard and configured both the physical and logical standby database in the production environments.
• Also responsible for well functioning of the database by Checking and Applying Patch set and Interim patches, Upgradations there by making the database software up-to-date. Upgraded databases from 8i to 9i, 9i to 10g and 10g to 11g.
• Worked extensively on Oracle Migrations. Migrated database from Windows to Linux, HP-UX to AIX.
• Proficient in using Recovery manager (RMAN), Flash-Back Technology, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM).
• Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.
• Developed database monitoring/health check alert scripts
• Experience in using OEM/Grid Control
• Planning and scheduling the Physical (Cold/Hot) backups, Logical backups and RMAN incremental backups.
• Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN (Recovery Manager).
• Experience in taking backup and performing recovery.
• Experience in performing point in time recovery at times of necessity.
• Created Clone databases in Dev and Test environments using RMAN cloning procedure as well as User manual cloning.
• Implemented data transfer using Data Pump, Export/Import utilities.
• Experience in Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analysing security problems.
• Extensive Experience in writing Stored Procedures, Functions, Triggers and packages using PL/SQL.
• Configured Oracle on different Operating Systems for OLTP & Data Warehousing environments.
• Experienced in loading data from flat files into database tables using SQL*Loader, ETL Tools and External Tables.
• Excellent communication skills, with strong troubleshooting, and problem solving ability.
• Worked as a team member to provide 24x7 on call production database support.

TECHNICAL SKILLS

Database: Oracle 7.3, Oracle 8i, Oracle 9i, Oracle 10g RAC, Oracle 11g RAC.

Operating Systems: Red Hat Enterprise Linux RHEL 4.x, 5.x, Sun Solaris 8,10, AIX 5.3,6.1,HP-UX 10.x,11.x, Windows NT/XP/2000/2003,HP-UX 10.x,11.x.

Technologies: OEM/Grid Control, Data pump Import/Export, Oracle Streams, GlodenGate, RMAN, ASM, SQL*Loader, Oracle Data Integrator, Erwin, Data stage.

Tools: and Utilities: PL/SQL, SQL*Plus, SQL * Loader, Stored Procedures, Triggers, UNIX Shell Scripting, TKPROF, STATSPACK, AWR, Toad, VMware

PROFESSIONAL EXPERIENCE

Confidential, CA

Senior Oracle DBA

Responsibilities:

• 24x7 production database and applications support
• Installation, configuration and maintenance of Oracle 10g and 11g databases.
• Implementation multi node RAC on Oracle 10g and Oracle 11g.
• Involved in construction of DR sites for all the Production databases.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Monitoring Day-Day Backups, Log’s.
• Successfully implemented Backup & Recovery using RMAN, Conventional Hot and Cold backups.
• Managing backup strategy for all production databases.
• Taking the RMAN incremental (Differential & Cumulative) backups.
• Extensive experience in recovery.
• Cloning of Databases from Production to Development and Test.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases.
• Installed GlodenGate, upgraded from 10 to 10.4
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Implemented DRP (Disaster recovery plan) for critical databases.
• Provided instance level performance monitoring and tuning for Wait Events, Sessions, Physical and Logical IO and Memory Usage.
• Worked extensively on Performance tuning of Queries
• 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, TKPROF, AWR and ADDM.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Involvement in space management, rectification of lock problems, managed quotas.
• Created database objects like Tables, Indexes, Views, and DB Links etc.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Setup and implementation of Oracle Financial Analyzer.
• Conducted time to time analysis and monitoring of the software and hardware requirements and act accordingly.

Environment: Oracle 9i/10gR2 RAC/11g R2 RAC, Red Hat LINUX, Solaris 10, HP-UX, Windows 2003, MS, SQL Server 2000/2005/2008, OEM/Grid Control, AWR/ADDM, RDBMS, SQL, PL/SQL.

Confidential, Milwaukee, WI

Oracle DBA

Responsibilities:

• 24*7 Production Database Administration Support
• Installation, configuration and support of Oracle RAC and Standby Databases (Active Data Guard) for High Availability and Disaster Recovery.
• Cloned/Refreshed Oracle Databases for development and testing
• Upgraded databases from Oracle 9i to 10g, Oracle 10g to 11g.
• Performance monitoring and tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM.
• 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.
• Provided instance level performance monitoring and tuning, Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Backup and recovery, Cold backups, hot backups, Logical backups, RMAN backups (Full, Incremental Backups, Differential, Cumulative Backups).
• Implemented Standby Databases with high availability and performance configurations and participated in Switchover and Fail over tests
• Monitoring Day-Day Backups, Log’s.
• Successfully implemented Backup & Recovery solutions using RMAN (Full, Incremental Backups, Differential, and Cumulative Backups).
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Database cloning for development, testing from production
• Responsible for capacity planning, database security, recovery planning and installing patches
• Writing Stored Procedure, Functions, Trigger and packages using PL/SQL.
• Installed and configured Gloden Gate
• Replication using Materialized Views, Oracle Streams and Gloden Gate.
• Partitioned large tables for better performance and manageability
• Migrating databases from Windows to Linux, Sun Solaris to IBM AIX.
• Experience in Logical Database Design, Physical Database designAcc

Environment: Oracle 11g RAC/10g RAC/Oracle 9i, Data Guard, Sun Solaris, IBM AIX, HP-UX, Red hat LinuxRMAN, ASM, SQL*Loader, Data Pump, Gloden Gate, TOAD, OEM/Grid Control, SQL, PL/SQL, TKPROFEXPLAIN PLAN, AWR

Confidential, Irving, TX

Oracle DBA

Responsibilities:

• 24x7 production database and applications support
• Installed and Configured Oracle 10g RAC and 11g RAC databases
• Upgraded Oracle databases from 9i to 10g and 10g to 11g version.
• Maintenance of around 200 databases combined on all the production, development and testing environments.
• Configured Oracle Standby Databases (Dataguard) for Oracle Disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions.
• Extensive use of Oracle Data pumps Exp/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Configured and implemented Oracle Streams.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Implemented downstream capture at the destination database using Oracle Streams.
• Responsible in configuring and backing up database using Hot backups, Cold backups, Logical backups and RMAN incremental backups
• Performed automated backups and scheduling using scripting.
• Responsible for migration of databases.
• Written PL/SQL functions, stored procedures, packages and triggers
• Worked with Data pump to take the logical backups of databases.
• Experienced in performing Point in time recovery.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases, DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(Network Configuration Assistant) for creating a Client-Server environment using Listener, tnsnames etc.,
• Used Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Involved in gathering requirements from end users.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Estimate growth of database size by detail analysis of the company’s future policies and generating reports for the management to act in advance.

Environment: Oracle 11g/10g, Oracle 11g RAC, Oracle 10g RAC, Dataguard, RedHat Linux, HP-UX, Sun Solaris, IBM AIX, Windows, TOAD, Grid Control, ERWIN, SQL, PL/SQL.

Confidential

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 9i, 10g software
• Installed and configured Oracle 10g RAC
• Upgraded databases from 8i to 9i, 8i, 9i to 10g. Applied CPU and PSU patches
• Adjusted data models when necessary under direction of data architects.
• Implemented Oracle Dataguard in order to achieve the high availability of the database by maintaining the Standby database.
• Used Recovery Manager (RMAN) and Created recovery catalog on separate server.
• Responsible for backups and recoveries
• Assured Daily Backups and Archiving were done accurately and consistently.
• Implemented and maintained Database security.
• Created / Altered / Dropped Users as and when required and administer their respective quotas and profiles.
• Cloned the database using RMAN to migrate data from PROD to UAT/QA/SIT and Dev databases.
• Implemented shell scripts for backup and recovery
• Restoration of dropped tables using Flashback technology.
• Created Database Links and Snapshots (Materialized views).
• Performed Hot Backups and maintained database availability to support non-stop Business operations.
• Developed UNIX shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Optimized SQL, PL/SQL code and performance tuning using AWR, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM
• Knowledge in Data warehousing and implementation and supported as Oracle Database administrator in Data warehouse projects.
• As a member of the analyzing and designing team, the responsibilities were to understand the application requirements and build up system specifications.
• Writing PL/SQL stored procedures and functions for data operations team and suggesting developers to write proper query to get optimal performance.

Environment: Oracle 10g/9i/8i, Oracle 10g RAC, Dataguard, RedHat Linux, Sun Solaris, TOAD, Grid Control, ERWIN, SQL, PL/SQL.,SQL*LOADER

Confidential

Oracle Developer/DBA

Responsibilities:

• Installed and configured Oracle 8i, 9i, 10g.
• Performed Database Upgradations from 7.3, 8i to 9i, 9i to 10g.
• Responsible in applying the patches from time to time to make the database software up-to-date.
• Involved in analysis of market risk and claims data.
• Creation of new Tablespaces, adding and modifying data files in order to resolve Disk Contention Issues.
• Performing backups and recoveries.
• Designed and implemented appropriate backup and recovery procedures to meet the business requirements.
• Responsible for automatic backups for performing hot backups on a daily basis and cold backups on a monthly basis.
• Maintained control files, log file, data files, table spaces and rollback segments.
• Creation of database users, granting/revoking the privileges
• Tuning, troubleshooting, monitoring and optimizing database performance.
• Worked closely with senior DBA to understand the business and technical requirements.
• Designed database tables, implementing referential integrity.
• Developed triggers which internally called procedures and functions.
• Performed complex SQL query tuning, index reorganization.
• Involved in all phases of the software development life cycle.
• Designed and developed various UNIX Shell, PL/SQL and SQL scripts
• Involved in documenting the entire system architecture and data flow.

Environment: Oracle 10g/9i/8i/7.3 RedHat Linux, Sun Solaris, HP-UX, SQL, PL/SQL,Sun Solaris 5.8/5.9/5.10, Oracle RDBMS 9i (9.0.2)/10G(10.2.0.2), 9iAS & 10gAS, OEM, OAM, RMAN, ASM, Data Pump, Data Guard.