Professional Summary:

A hands-on, skilled and proficient 7 + years of experience in Oracle Database Administration with broad-based expertise in the areas of database administration, Real Application Clusters (RAC), Data guard, data replication, Oracle applications, application server administration, backup and recovery, data migration, production support, installation, configuration, upgrades, patches, Cloning, performance tuning, maintenance and documentation of Oracle 11g, 10g, 9i, 8i databases on Unix and Windows platform.

• Expertise in Installation, configuration, maintenance of Oracle 8i, 9i,10g and11g in UNIX(HP-UX, AIX, Linux), Windows environment and administration of Oracle 10g RAC,11g RAC, Standby Databases (Data Guard) for High Availability and Disaster Recovery purpose.
• Performed Up gradation of 8i, 9i databases to 10g, 9i and 10g databases to 11g.
• Installed, configured and maintained ASM enabled RAC and single instance databases.
• Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Experience in installing Oracle patches, Migration of database across different platforms and Cloning/Data Refresh from production environment to setup test and development environments.
• Skilled experience in applying CPU/PSU, One-Off / Interim Patches using OPatch utility and Patch set using Universal Installer.
• Experience in setting up Data Guard technologies for Disaster Recovery.
• Configured, installed and maintained OEM Grid Control.
• Designed and development of backup and recovery procedures using user managed backups (hot, cold), Recovery Manager backup (RMAN) and using Logical backup ( Exp/ Imp , Data pump).
• Expertise in Cloning of databases using RMAN with VERITAS Net Backup.
• Experience in replication using Oracle Streams, Materialized views and experience in using OEM, TOAD and Database Migrations using transportable table spaces, benchmarking using load testing tools.
• Extensive experience in Performance Tuning of the database (Memory Tuning, I/O Tuning, Tuning Contentions) using STATSPACK, MTTR,TKPROF, EXPLAIN PLAN, SQL TRACE, AWR, ADDM, SQL Tuning, ASMM,ASH and OEM Grid Control.
• Experience in administering SQL Server 2005/2008.
• Proficient in implementation, maintenance of Database Security (Users, Roles, Privileges), space management of logical structures and auditing of users.
• Development experience in creating Procedures, Packages, Table partitioning, Functions, Triggers and other database objects using SQL, PL/SQL.
• Proficient in Shell Scripting and developed UNIX shell scripts.
• Automated many common tasks using cron utility including Backups, exports and imports, archiving old records and verification of such processes.
• Worked on different types of storage structures (SAN/NAS).
• Ability to work on an own initiative and a very good team player along with excellent verbal and written communication skills.
• Worked with a team to provide 24x7 on-call production database support.

EDUCATION:

Bachelor’s Degree in Engineering( Computer Science)

CERTIFICATION:

Oracle Certified Professional 10g (OCP)

TECHNICAL SKILLS:

Red Hat Linux 4.x, 5.x, AIX 5.x,6.x, Sun Solaris 8/9/10, HP-UX 11.x

Databases:

Oracle 11G, 10G, 9i, 8i, SQL Server 2003, 2005, 2008.

DBA Tools/Utilities:

RMAN, RAC, OEM, TOAD, AWR, Data Pump, SQL*Loader, OEM Grid Control, STATSPACK, AWR, ADDM, ASH, TKPROF, EXPLAIN PLAN,NETCA, DBCA, ASMCMD, SRVCTL, OCR CONFIG, VERITAS.

Languages:

C, C++, C#, SQL, PL/SQL, T-SQL, UNIX Shell Scripting, PERL Scripting

Web Tools:

XML, HTML, JavaScript, VB 6.0.

PROFESSIONAL EXPERIENCE

Confidential,Lakeland, FL Mar 10 – Till date
Role: Sr. Oracle Database Administrator

Responsibilities:

• Installation/Configuring and Implementing Oracle Real Application Cluster Database which includes determining the Cluster architecture choosing the best MPP RAC servers and hardware configuring the raw disks for Oracle RAC.
• Implemented Physical Standby database using Data Guard in ORACLE9i/10g.
• Upgraded Oracle Database from 9i to 10g, 10g to 11g.
• Migration of the database from HP-UX to IBM AIX, Windows to Linux.
• Install and test upgrades and patches. Assess risk/benefit factors in database software upgrade and patches. Perform major Oracle version and release upgrade, apply patches / bug fixes
• Applied security related CPU/PSU and One-off patches using Opatch utility.
• Installed ASM environment and migrated database from non ASM to ASM
• Configured and maintained Oracle Streams for replications of data between remote databases.
• Carry out database migration to new servers, data centers at different locations.
• Tuning of Shared Pool, Library Cache, and Data Dictionary Cache.
• Extensive performance tuning experience, SQL Tuning, Database/Instance Tuning and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR
• (Stats pack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM) Grid Control.
• Configured and installed Oracle Enterprise Manager (OEM) Grid Control.
• Performed and monitored Hot and cold database backups and implemented backup and recovery using RMAN.
• Cloning of the database from Production to the Test and Development environments using RMAN and conventional methods.
• Used Export/Import, Data Pump Utilities to move the data between different databases and for backups.
• Generated performance reports and Daily health checkup of the database using utilities like AWR, Stats pack and ADDM to gather performance statistics.
• Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators.
• Identified and tuned poor SQL statements using EXPLAIN PLAN, SQL TRACE and TKPROF, Analyzed tables, indexes for improving the performance of the Query.
• Worked on SQL* Loader to load data from flat files, Checking for Row Migration and Chaining on Highly used transaction tables.
• Created DB links across databases and Solved Database connectivity issues by continuously monitoring the status of the listeners and instances.
• Scheduled jobs in the database using CRON Jobs and DBMS_JOBS.
• Implemented backup for production database. Simulated few possible crucial recovery scenarios using the current available backups to check the effectiveness of the backup plans and also to get a rough estimate of the recovery time involved.
• Automated shell scripts and scheduled batch jobs.
• Checked alert logs and background trace files on daily basis and resolved problems.
• Served as a member of 24-hour on call support staff.

Environment: Oracle 11g/10g RAC on HP-UX, RHEL, SUN SOLARIS, RAID, Import/Export, OEM, SQL* LOADER, RMAN, STATSPACK, EXPLAIN PLAN, TKPROF, JDBC, SQL, PL/SQL and Windows NT/2000.

Confidential,NJ Jun 08 – Feb 10
Role: Sr. Oracle DBA

Responsibilities:

• Installed RAC setup in the production environment using Oracle Cluster-ware. Experienced in administration of RAC databases by maintaining, patching, cloning, backups and recovery.
• Applied database patches using Opatch utility & worked on conversion from single node to Multi Node RAC.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
• Expertise on upgrading and patching of CRS, ASM and Oracle RDBMS.
• 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 up gradation and migration.
• Implemented DRP (Disaster recovery plan) for critical databases using Streams.
• Replicated Oracle Databases using Logical Standby, Streams and Golden Gate and utilized Oracle Streams to capture, propagate and apply the transfer of data, transactions and events within managed databases.
• Expertise in Monitoring Database Activities using Oracle Enterprise Manager Console (OEM) Grid Control and data dictionary views.
• Planning and scheduling the Physical (Cold/Hot) backups as well as Logical backups and 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.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO, Memory Usage and worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Statistics.
• Cloning of databases using Recovery Manager (RMAN).
• Implemented account security, object security and system level security of a database.
• Maintained space management, network management & user management.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges permissions to appropriate groups with role-based security.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, monitoring and optimizing database performance.
• Optimized SQL, PL/SQL code and performance tuning using AWR, TKPROF and EXPLAIN PLAN & STATSPACK.
• Created UNIX shell scripts to monitor databases and extract data from various sources such as SQL Server and Oracle.

Environment: Oracle 11g/10g/9i, Red Hat Enterprise Linux 4.x and 5.x, RHEL, Oracle 10g RAC, SQL Server 2005

Confidential,Weston, MA Jul 06 – May 08
Role: Oracle DBA

Responsibilities:

• Installed and Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 9i to 10g version using Opatch.
• Maintenance of around 200 databases combined on all the production, development and testing environments.
• Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Configured Oracle Data guard for Oracle Disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
• Extensively used Oracle Data pump Exports/Imports utility for moving data.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Configured, implemented Oracle Streams (Advanced Replication) for high availability and
• 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.
• Responsible for migration of databases which included migration of data from Oracle to SQL Server, reporting and analysis requirements.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL, UNIX Shell Scripts for backups.
• Experienced in performing Point in time recovery using RMAN.
• 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.,
• Working Experience with Latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace and Query Builder.
• 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.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• 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 10g/9i, Red Hat Enterprise Linux , AIX, OEM, Oracle 10g RAC,RMAN, OEM, TOAD, Oracle Application server, Windows 2003 Server

Confidential,INDIA Jan 04 – May 06
Role: Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 9i software on UNIX and Windows platforms.
• Planned and implemented upgrades from 9i to 10g version.
• Implemented Oracle Enterprise Manager (OEM) for Database.
• Adjusted data models when necessary under direction of data architects.
• Responsible for tasks like taking Cold backups on weekly basis and Cumulative backups, Partial backups and Full Hot backups daily.
• Implemented and maintained Database security.
• Created / Altered / Dropped Users as and when required and administer their respective quotas and profiles.
• Knowledge in Data warehousing and implementation and supported as Oracle Database administrator in Data warehouse projects.
• Writing PL/SQL stored procedures and functions for data operations team and suggesting developers to write proper query to get optimal performance.

Environment: Oracle 9i/10g, LINUX, Windows 2000, Solaris 2.6, SQL server, Shell Scripting, PL/SQL.