SUMMARY

• Around 8 years of professional experience in Information Technology in design, development, implementation, maintenance, documentation and administration in various domains like pharmaceutical, Finance, Education and Retail industries.
• Hands on experience on Oracle (8i/9i/10g/11g) database administration, schema implementation, backup, recovery, cloning, performance monitoring and tuning as well on different platforms like Windows, Unix (RHEL, IBM AIX, Sun Solaris, HP UX).
• Experienced in maintaining databases on large Production, Testing and DEV environments.
• Expertise in installing, configuring and maintaining Standalone as well as RAC databases on various platforms and responsible for full time availability of the database.
• Planned and Implemented DR & HA oracle solutions using RAC, Data Guard, Streams and made sure that the database is always available for the users even at the critical times like failures and upgradations.
• Installed RAC setup in the production environment using Oracle Cluster - ware. Experienced in administration of RAC databases by maintaining, patching, cloning, backups and recovery.
• Implemented Dataguard and configured both the physical and logical standby database in the production environments.
• Experience in configuring, managing and monitoring Database Replication using Streams.
• Also responsible for well functioning of the database by checking and applying Patches, Upgradations thereby making the database software up-to-date. Upgraded databases 9i-10g and 10g-11g.
• Worked extensively on Oracle Migrations.
• 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 for database uptime/downtime status, and sizing issues using grid control (OEM).
• Planning and scheduling the Physical (Cold/Hot) backups as well as Logical backups.
• Played vital role in taking Full and partial backups, Incremental and Cumulative backups using Rman (Recovery Manager).
• Performed manual recovery using archived logs, RMAN backups with and without catalog.
• Experience in taking backup and performing recovery by running scripts.
• Also performed point in time recovery at times of necessity.
• Created Clone databases in Dev and Test environments using RMAN cloning procedure as well as User managed cloning.
• Configured Targets and used Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance.
• Implemented data transfer using Data Pump Export/Import utilities.
• Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Automated database periodic maintenance and activities using Korn, Shell Scripts.
• Configured Oracle on different Operating Systems for OLTP & Data Warehousing environments.
• Experienced in loading data from flat files into database tables using SQL*Loader and ETL Tools like Data Stage.
• 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 8i, Oracle 9i, Oracle 10g, Oracle 11g, Oracle RAC.

Operating Systems: Red Hat Enterprise Linux RHEL 3.x, 4.x, 5.x, Sun Solaris 5.8/5.9/5.10 , AIX 5.1, 5.2, 5.3, Windows NT/95/98/2000/XP/2003, HP UX.

Technologies: Oracle Enterprise Manager Grid Control, OEM, Datapump Import/Export, Oracle Streams, RMAN, SQL Loader, VERITAS Net Backup, Data stage.

Tools: and Utilities: PL/SQL, SQL*Plus, SQL * Loader, Stored Procedures, Triggers, UNIX Shell Scripting, TKPROF, STATSPACK, DBMS SCHEDULER, Toad, VMware, Win SCP, Putty.

PROFESSIONAL EXPERIENCE

Confidential, GA

Sr. Oracle DBA

Responsibilities:

• Installation, configuration and maintenance of Oracle 10g and 11g databases on RHEL.
• Configuration and maintenance of 4 node 11g RAC environment for the databases.
• Refresh of schemas and data from databases on Production to QA, Pre-prod and also Development environments.
• Migration of databases from RAC servers to VM template servers.
• Building VM templates and import the data from databases on old servers.
• Upgrade of the databases from 10g version to 11g version.
• Monitoring the daily backups and weekly backups using RMAN backups time to time and make scripts to schedule backups to perform through Cronjobs.
• Implemented backups using RMAN Hot and Cold backups also performed restore and recovery when there were any necessary rollbacks.
• Responsible for creating the Clone database on other server every time we create a new development environment.
• Implementation of Oracle Streams to replicate the data from the database on the other site for the Data warehouse environment for them to collect reports.
• Extensively used Datapump (Export/ Import Utility) to move the data between the databases on old and new servers using the features like REMAP of schemas/ tablespaces.
• Monitoring the oracle databases time to time, checking the users, profiles, table sizes, tablespaces, alert log files.
• Assured Daily Backups and Archiving were done accurately and consistently using RMAN.
• 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.
• Building up of schemas and check to see whether profile has been set properly and granting the necessary roles and privileges.
• 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.
• Generating AWR reports and VMstat reports for standalone as well as RAC databases while performing Load/ Performance testing in Pre-Production environment.
• Take part in Release management by deploying the codes and make necessary changes to the database and support the Testing teams while performing the QA/ CIT testing.

Environment: Oracle 11g/10g, Red Hat Enterprise Linux 5.x, Solaris, OEM, Oracle 10g, 11g RAC, Dataguard, Streams, TOAD, STATSPACK, EXPLAINPLAN, Weblogic.

Confidential, NJ

Senior Oracle DBA

Responsibilities:

• Installation, configuration and maintenance of Oracle 10g and 11g database on RHEL.
• 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.
• Responsible for setup and implementation of Two node RAC on Oracle 10g and 11g.
• Also added an extra 3rd node for minimizing the downtime and maximizing the availability and also achieving load balancing by minimizing the interconnect traffic.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Managing backup strategy for all production databases (at least triple redundancy and least double redundancy for all development databases).
• Taking the RMAN incremental and cumulative backups.
• Scheduling the databases backup using Cron tab and VERITAS net backup.
• Extensive experience in RMAN recovery in RAC and stand alone database.
• Recovered huge Database (1 Terabyte) when UNDO table space got corrupted in Real Application Cluster (RAC).
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of upgradation and migration.
• Replicated database using Oracle Streams.
• 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 using Streams.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of 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.
• Always monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redologs, Archived Redologs and Alerts.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Involvement in space management, rectification of lock problems, managed quotas.
• Configuration of Listener and Net Service names using NETCA and NETMGR.
• Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Cloned schemas, objects and data on new server 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.
• Conducted time to time analysis and monitoring of the software and hardware requirements and act accordingly.

Environment: Oracle 11g/10g, Oracle RAC, Dataguard, Linux RHEL 4 and 5, Windows, HP UX 11i, TOAD, VERITAS, OEM, ERWIN 7.2, SQL, PL/SQL, TKPROF, Weblogic, EXPLAIN PLAN, Datastage.

Continental, IL

Senior Oracle DBA

Responsibilities:

• Installed and Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 9i to 10g version.
• Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Configured Oracle 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 using RMAN.
• Extensive use of Oracle Datapump Exports/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 (Advanced Replication) for high availability.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Performed automated backups and scheduling using scripting.
• Responsible for migration of databases.
• Also migrated data from Oracle to SQLserver, Sybase, etc., for testing, reporting and analysis requirements.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL; UNIX Shell Scripts for backups.
• Worked with Datapump to take the logical backups of databases.
• 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, TNS names etc.,
• Created indexes to facilitate easy user interface implementation and tuning.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• 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/9i, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, HP UX 11i, OEM, Oracle 10g RAC, Sybase, TOAD, Erwin, STATSPACK, EXPLAINPLAN, IBM Datastage, C++, Weblogic, SQL Server 2005.

Confidential

Oracle Developer/DBA

Responsibilities:

• Installed and configured Oracle RDBMS on LINUX and Windows environments.
• Responsible in applying the patches from time to time to make the database software up-to-date.
• Creation of new tablespaces, adding and modifying datafiles in order to resolve Disk Contention Issues.
• Performing backups and recoveries using RMAN/Conventional Hot backups.
• 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 weekly basis.
• Maintained control files, log file, data files, table spaces and rollback segments.
• Creation of database users, monitoring the roles and granting/revoking the privileges on the database objects like tables, indexes, etc.,
• Tuning, troubleshooting, monitoring and optimizing database performance.
• 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.
• Worked closely with senior DBA to understand the business and technical requirements.
• Performed complex SQL query tuning, index reorganization.
• Involved in documenting the entire system architecture and data flow.

Environment: Oracle 9i/8i, Linux, Windows 98/NT/2000, TOAD, Database Export/Import tools/Utilities.