PROFESSIONAL SUMMARY:

• Over 6 years of IT experience as an Oracle Database Administrator providing 24/7 production and development support of Oracle 11g RAC, 10g RAC, 9i.
• Installations of Oracle 11g RAC, 10g RAC, 9i, 8i on Sun Solaris/Red Hat Linux, Oracle Enterprise Linux/HP - UX/IBM-AIX/Windows platforms and creating databases.
• Installing and configuring ASM for the RAC storage implementation.
• Proficient in Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning.
• Experience in query optimization, cloning, patches, up gradation, migration, troubleshooting, TAR support, space management and UNIX Shell Scripting.
• Configured Oracle 11g database instance running across two oracle RAC nodes on Red Hat Linux AS 4 Server.
• Installation, maintenance and tuning of RAC Applications. Used rapid install and other Oracle Application maintenance utilities like OEM.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Excellence in Performance Tuning using STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, AWR, ADDM.
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and OEM Grid Control.
• Extensive experience Real application Clusters (RAC), ASM, RMAN, Data Guard and maintain Standby database.
• Have implemented ORACLE STREAMS, standby databases supported by DATAGUARD physical standby database.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.
• Implemented and delivered core edge technologies of Oracle 10g (Streams, EM Grid Control, and RAC).
• Configured Shareplex.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Proficient in using various database Utilities like EXPORT/IMPORT, Datapump, TOAD.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL loader, External Tables and PL/SQL.
• Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities.)
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Experience with cloning production database to refresh development and test environments (including RMAN Cloning).
• Good knowledge of configuration of 10g Grid Control, Data Guard on Disaster Recovery (DR) sites.
• Worked with both onshore and offshore model and coordinated onshore issues with offshore team
• Configured and Administered STREAMS and GOLDEN GATE.
• 24*7 production database support with Support to developers & end-users.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies
• Strong interpersonal and communication skills.

TECHNICAL SKILLS:

DBMS & RDBMS: Oracle 8i, Oracle 9i, Oracle10g RAC, Oracle 11g RAC, MS - Access.

Tuning & Monitoring Tools: Oracle 10g RAC, Oracle 11g RAC, ASM, Streams, Data Guard, Grid Control (OEM), Tkprof, Statspack, AWR, ADDM, ASSM

Operating Systems: Solaris 9/10, Linux RHAT 3/4/5, HP-UX 10.x/11.x,AIX 5.2/5.3, Microsoft Windows 2000/2003/2005

Tools & Utilities: Oracle SQL Developer,PL/SQL Developer, TOAD, RMAN, Export/Import, EXPDP/IMPDP, SQL Loader, Shareplex

Programming Languages: C, C++, ASP.Net, XML, HTML, DHTML, CSS, Java

Backup Tools: Veritas NetBackup, RMAN

MS Office Tools: Excel, Word, PowerPoint, Outlook

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Oracle DBA

Responsibilities:

• Installation, configuration, maintenance and tuning of Oracle 10g and 11g on RHEL 5.0, 5.5, 5.7 &IBM-AIX 6.1.
• Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.1.0.7) on IBM-AIX nodes.
• Involved in Installation and configuration of Oracle 10g RAC using Clusterware and ASM.
• Successfully Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.
• Installation, configuration, maintenance of 4 node RAC on Oracle 10g.
• Configured and installed RPM’s on servers using Red Hat Enterprise Linux.
• 24x7 remote support and on call Database support for Database developers & end-users.
• Experienced in the installation of Oracle Grid Control in Server (OMS-Oracle management Server) and installing the Agents in all the production, test and development databases and configuring them.
• Experienced in Design, implementation and generating documentation of Oracle 11g DataGuard on both physical standby databases in high availability mode.
• Configured and implemented replication using SharePlex.
• Implemented Data guard, creating both Logical and Physical Standby databases in 11g RAC environment for the Production databases.
• Writing and Modifying UNIX shell scripts to manage Oracle environments and for Backend Oracle Processes.
• Installed Oracle Streams as an enhancement for the Client’s DW method and monitored Streams Issues using Grid Control.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM, ASH 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).
• Creating & Managing Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performance tuning and diagnosing DBMS and individual Production databases.
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Creating and Scheduling Oracle Backend Process Jobs in Crontab.
• Cloning & Duplicating databases using scripts as well as RMAN.
• Expertise in recovering the database.
• Replicated data using Oracle GoldenGate, SharePlex and import/export.
• Performed Complete Recovery, Data File Recovery, Incomplete Recovery.
• Experienced in Privileges, Roles, Auditing, Profiling, Authentication.
• Implemented Veritas, Netbackup using RMAN (Recovery Manager) as a media management layer.
• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Implemented OffShore Coordination jobs ensuring proper communication from project decisions.
• Coordinated with Offshore Support to resolve the production, development and design related issues and communication on daily basis

Environment: Oracle 10g and 11g, TOAD 9.0, Oracle Grid Control, Oracle Enterprise Manager, RMAN, RAC, DataGuard, GoldenGate, SharePlex, ASM, SCP/SFTP, Erwin 4.0, TKPROF, Explain plan, AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader, T-SQL, SQL Server 2005, AIX 5.2/5.3 and Red Hat Linux 5.0

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle 11g R2 on Linux also Upgraded from Oracle 10g to 11g
• Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Very good Knowledge on 11g New Features.
• Configured Oracle Data guard 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 uses of Oracle Data pump Exports/Imports utility for moving data among the servers.
• Involved in configuration of Golden Gate
• 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 RMAN, Hot backups, Cold backups and Logical backups.
• Performed automated backups and scheduling using scripting.
• Experienced in dealing with Query execution plan, SQL trace, TKprof.
• Used Data pump to perform schema/table refreshes
• 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, 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 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.
• Worked with offshore team to transfer any outstanding issues as per the schedule.

Environment: Oracle 11g/10g,HP-UX UNIX RHEL 5.x, ASM 10.2.0.4, CRS 10.2.0.4, OEM (Grid Control), RMAN, RAC and Data Guard, Explain Plan, Oracle Support, SQL Developer, Data Pump, Toad, VERITAS Net Backup. Golden Gate

Confidential, Cincinnati, OH

Sr. Oracle DBA

Responsibilities:

• Performing day-to-day activities such as creating users, roles, schemas, tables, views, indexes and running scripts given by the clients
• Creating and Maintenance of the Oracle databases on different servers.
• Installed and implemented 2 node 10g RAC on RHEL and worked on ASM features of Oracle.
• Installation, Configuration and Maintenance of Oracle RDBMS software.
• Performed upgradation of Oracle 10g databases to Oracle 11g using patches.
• Installation, Configuration and Maintenance of Logical/Physical standby databases in Dataguard.
• Installation, Configuration and Maintenance of Oracle Grid Control.
• Configured VERITAS clustering for the test environment.
• Setup of Jobs using the Oracle Grid.
• Setup of Cold Backup of test/development databases through RMAN for weekly maintenance.
• Data refresh from Production to Test and Development environments using RMAN duplicate database.
• Daily checkup of the database using STATSPACK, AWR and ADDM.
• Involved in migration of applications of the clients.
• Automating the routine DBA tasks through cron.
• Worked on uploading large batch of transaction data using batch processing technique.
• Implemented Oracle Streams and GoldenGate for data replication and synchronization.
• Loading the data into database with SQL*Loader and External Tables.
• Supported different databases like Production, Testing, Staging and Training.
• Granted permissions to end users according to their level of access to database objects.
• Performing Maintenance activities like converting Non-Partitioned tables into Partitioned tables.
• Monitoring the database daily activities through the Grid.
• Monitoring alert log/system log.

Environment: Oracle 10g, RAC, SQL, PL/SQL, Oracle Grid Control, TOAD, Oracle Enterprise Manager, SQL*Loader, Sun Solaris, Red Hat Enterprise Linux, Unix, AIX.

Confidential

Jr. Oracle DBA

Responsibilities:

• Provided Primary architectural and administrative support for new projects
• Installed Oracle 9i and 10g, RAC database on HP-UX 11.0, Red hat 4.x
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage
• Performance Tuning i.e., Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Monitored Streams environment using various tools like OEM Console.
• Oracle Grid Control Management Server Installation
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same
• Devised & Implemented backup strategies using hot, cold and exports based on the business requirements
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer
• Trouble shooting various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, instance, memory, OS and java calls
• Developed UNIX shell scripts to perform the above tasks efficiently
• Worked as a member of production DBA team in perfect coordination with seniors and team members.

Environment: Oracle 10g/9i, Sun Solaris, HP-Unix, UNIX, Linux 4.0., RMAN, DBCA, DataGuard, EXPLAIN PLAN Cloning, OEM, STATSPACK, and TKPROF, Toad, PL/SQL.

Confidential

Jr. Oracle DBA

Responsibilities:

• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Responsible for installing, upgrading and configuring the Oracle server.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Responsible for optimizing the queries and application tuning.
• Implement Hot, Cold and Logical backup plans.
• Designed backup and recovery procedures for OLTP system
• Enhanced the performance of the company’s Oracle environment by providing advanced performance tuning and coding standards.
• Use TOAD tool to access the database
• Used PL/SQL developer to create PL/SQL Procedures
• Testing PL/SQL procedures against the test cases.

Environment: Windows 98/NT / 2000, HP-UX, AIX, Oracle 9i, TOAD, Database Tools/Utilities, Oracle Enterpris6e Manager (OEM).