SUMMARY

• 8+ years of experience in Oracle Database Administration encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Oracle Streams.
• Installation and administration of Oracle 11g/10g/9i on OEL, RHEL, Windows, Unix and Sun Solaris in OLTP environment
• Performed Migration and Upgrade of databases to 11g and 10g
• Up gradation of databases applying patches, patch sets and critical patch updates.
• As a DBA we use to give permissions to access the LDAP databases.
• Installation and configuration of Oracle Server 11g RAC with ASM on multi node systems, 11g, 10g and 9i in different operating systems for OLTP environment on Very Large Databases(VLDB).
• Experience on Oracle 11g/ASM/RAC and up gradation of standalone databases to 11g RAC environment
• Configuration of Automatic Storage Management (ASM)
• Configuration and Management of Data Guard on RHEL, OEL and Windows.
• Extensive experience with Database Cloning and Refreshing pre - prod/dev databases with prod/pre-prod databases.
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
• Regular database synchronization for test database environments through automation.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 11g/10g/9i.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, data pump export/import.
• Migrating the databases from one platform to another platform.
• Implementation of Flashback Technology
• Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate issues.
• Extensive experience using SQL* Loader, External Tables and Oracle Application Express for data loading.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Monitoring and Optimization of database performance through database tuning, system tuning and application tuning.
• Experience in SQL Tuning, Optimization, cost based optimization and Hints
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.
• Proficient in INDEX REBUILDING and INDEX TUNING
• Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
• Experience working with Database Resource Management
• Working experience in creating materialized views.
• Proficient in writing PL/SQL Procedures, Functions and Triggers.
• Experience using Erwin as a Data Modeling tool & Designing the ETL processes
• 24*7 on-call production database support and maintenance including remote database support
• Assisting in implementation of change control process in production.
• Ability to work in a team as well as to take individual responsibility.

TECHNICAL SKILLS

Databases: Oracle 11g, Oracle 10g, Oracle 9i.

Oracle Products: Oracle10g (Grid Control), OEM(Oracle Enterprise Manager), RMAN,SQL *Loader,Import and Export, DATA PUMP, ASM

Programming Languages: SQL, PL/SQL, C#, C, C++

Operating systems: OEL, RHEL, Sun Solaris, Windows XP Professional, Windows 2003 Professional

Other Tools: INFORMATICA, TOAD, Erwin, Putty, Oracle Streams, AutoSys, Golden gate

PROFESSIONAL EXPERIENCE

Confidential, Omaha, Nebraska

Oracle DBA

Responsibilities:

• Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.2 on 3 node RAC environment
• Oracle Grid Control 11g Installation and Configuration.
• Installed and configured Oracle database on windows server 2003 and 2008 platform.
• Experience in PL SQL and Oracle 11g LDAP
• Configuration of Physical Standby database for maximum performance mode - Oracle Data Guard
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software in various environments.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities
• Performed rolling patch upgrades on RAC environment for bug fixing
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import
• Daily incremental backup and weekly full backup of databases using RMAN
• Involved in migration of applications of the clients.
• Loading data into database tables using SQL *Loader
• Implemented Materialized views, database links
• Regular database management on 10g and 11g OEM
• Working Knowledge of installation and configuration of GOLDENGATE in Unix environment
• Done Installation and configuration of golden gate on 11g database for the replication.
• Implemented Bi-Directional replication in golden gate from target to source and source to target.
• Resolving the conflicts between the target and source database.
• Configuring parameters for DDL support in golden gate replication
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Table space monitoring, Performance monitoring and tuning for performance improvement
• Creating batch files and automating the tasks
• Granting roles and privileges to end users
• Managing, troubleshooting and resolving oracle database and application issues.
• Daily healthcheck up of the database using TKPROF, AWR, ADDM.
• Monitoring alert log/system log.
• Managing Database Locks and blocking sessions
• Defragmentation of tables and indexes for improved performance and efficiency.

Environment: Oracle 10g, 11g, SQL, PL/SQL, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, ASM, HTML

Confidential, Atlanta, Georgia

Oracle DBA

Responsibilities:

• Installed and Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 10g to 11g
• Maintenance of around 20 databases combined on all the production, development and testing environments.
• Install and configured Oracle databases on windows server 2003 and 2008 platform.
• 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.
• 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 Data pump 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.
• 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.
• Responsible for migration of databases.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL; UNIX Shell Scripts for backups.
• Worked with Data pump to take the logical backups of databases.
• Experienced in performing Point in time recovery using RMAN.
• Involved in designing logical and physical data models using Erwin.
• Working Experience with Latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace.
• 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.
• 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, OEM, Oracle 10g RAC, TOAD, Erwin, STATSPACK, EXPLAINPLAN

Confidential, Richmond, VA

Oracle DBA

Responsibilities:

• Installed and implemented 2 node 10g RAC on RHEL/UNIX and worked on ASM features of Oracle.
• Configured ASM disk groups to store Data files, redo log files, and control files.
• ASM Management using RAC utilities like SRVCTL, OCRCHECK, OCRDUMP and CRSCTL.
• Used RMAN to Migrate the Non-ASM Database to ASM Database.
• Installation, Configuration and Maintenance of Oracle RDBMS software.
• Performed up gradation of Oracle 10g databases to Oracle 11g using patches.
• Installation, Configuration and Maintenance of Logical/Physical standby databases in Data guard.
• Data refresh from Production to Test and Development environments using RMAN duplicate database.
• Up gradation of databases applying patches, patch sets and critical patch updates.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.
• Performance tuning and debugging SQL/PL SQL involved in Application development.
• Designed optimal architecture for database environment.
• Diagnosed and Performance tuning of highly update intensive applications.
• Mentor Development and QA team needs.
• Design and Developed Web applications and Content Management Systems.
• Upgraded Oracle 9.2.0 / 10.2.0 to Oracle 11.2.0.

Environment: Oracle 9i, 10g, 11gR1, Oracle Enterprise Linux 4.5/5.4, UNIX, ERWIN, OEM 10g (grid)

Confidential, Branchville, NJ

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle software 10g version.
• Created databases, allocated system storage and planned future storage requirements for the database.
• Installed Oracle and related tools, upgraded the database and applied patches as and when required.
• Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
• Configured the Data guard for switchover and failover and thereby providing high availability.
• Coordinated operating system setup/upgrades and infrastructure troubleshooting in partnership with system administrators.
• Implemented Recovery Manager (RMAN) Recovery Catalog performed Complete and Incomplete recovery.
• Performed Hot Backups and maintained database availability to support non-stop Business operations.
• Implemented Cloning to migrate data from PROD to Test and Dev databases.
• Performed Capacity planning and storage management.
• Estimation of database growth and analysis.
• Reorganization of tables and rebuilding of indexes.
• Maintained a disaster recovery site and planned and instituted disaster recovery process.
• Coordination with the team and ORACLE Support for troubleshooting the database issues.
• Developed UNIX Shell scripts to backup and recover the Oracle databases.
• Modified shell scripts for backup and recovery, Imported and exported procedure, implementing transportable table spaces.
• Worked as a team member to provide 24x7 on-call production database support.

Environment: Oracle 9i/10g, LINUX, Windows 2003 server, OEM, Shell Scripting, PL/SQL

Confidential

Oracle Developer/DBA

Responsibilities:

• Involved in fine tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT features.
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Involved in optimizing SQL statements using Indexes and Hints.
• Made use of the REF CURSORS in stored procedures for report generation.
• Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers.
• Involved in writing complex SQL statements.
• Developed backup and recovery strategies, batch processing, performance monitoring, log maintenance and automating functions wherever possible.
• Co-ordinated with System administrators, application developers for various activities.
• Maintained database security by managing users roles, privileges. Implemented new security rules via roles as per the company policies.
• Tuned the performance of the SQL’s using TkProf and Statspack reports.
• Performed security management and accessibility control by managing OS and Password file authentication, creating profiles, privileges and roles.

Environment: PL/SQL, Oracle 10g, TOAD, SQL PLUS, PL/SQL Developer, HP-UX 11.0