Summary:

• 7+ Years of experience in Oracle Data Base Administrator worked on Linux (RedHat Linux, Oracle Enterprise Linux), Unix (HP-UX, Sun Solaris, IBM AIX) and windows platforms, which involves Designing, Installing, Migrating, Updating, Configuring, Exporting, Importing, Backup, Recovery, Monitoring and Tuning the Databases
• Extensive Experience, Performance Tuning, Backups, Recoveries, RMAN backups.
• Excellent experience in providing 24/7 Production support
• Experience in supporting Oracle Databases 8i/9i/10g RAC/11g RAC
• Experience in Installation, configuration of Oracle RAC and Standby Database (Active Data Guard) for High Availability, Disaster Recovery and Reporting purpose. Installed, configured and maintained RAC and single instance databases. Migrated single instance databases to multimode RAC environment for high availability and load balancing.
• Experience in applying critical patches and patch sets whenever required.
• Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.
• Experience in writing complex SQL Queries, created materialized views.
• Extensive experience in developing SQL, PL/SQL Stored Procedures, Functions, Packages and Triggers.
• Experience in UNIX shell scripting.
• Creating users, assigning Roles, Grants and creating profiles and password management.
• Good experience in data warehousing, data modeling, database management.
• Good Experienced in database performance tuning, query optimization, data integrity and statistics
• Excellent working knowledge in logical backups, Hot/Cold Backup, RMAN (Incremental backups), Recovery and Cloning of databases.
• Shell Scripting, Partitioning, Indexes, Data modeling, Logical and Physical database design.
• Experience in Data warehousing and Extraction Transformation Loading (ETL).
• Experience in Database Security and Auditing.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, Tuning by Indexes, SQL Tuning.
• Involved in Tuning process as SQL Profiling, SQL Access Advisor, SQL Tuning sets.
• Identifying bottlenecks, lock contentions , deadlocks from the Automatic Workload Repository (AWR ) reports and performing self tuning purposes from the views and recommendation by Automatic Database Diagnostic Monitor (ADDM)
• Implemented Export and Import using original Export/Import method and Data pump in Oracle 11g Databases.
• Successfully implementing failover / switchover standby databases
• Experience in replication and integration of database objects between databases using Oracle Streams, Golden Gate.
• Excellent writing and Communications skills, Critical Thinking Skills, leadership qualities and Expert level manageability skills and Team leader abilities dedicated to any work environment.

TECHNICAL SKILLS

Operating Systems : UNIX (HP-UX, Sun Solaris, IBM AIX), Linux (RedHat Linux, Oracle Enterprise Linux), Windows
Databases : Oracle 8i/9i/10g RAC/11g RAC, MS Access, SQL Server
Tools : SQL*Loader, SQL *Plus, OEM/GridControl, RMAN, ASM, DBCA, DBUA, Data Pump, Toad, Data Guard, Export / Import, TOAD, SQL Developer, Golden Gate. ERWIN
Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR/ADDM/ASH
Languages : SQL, PL/SQL, C, C++, UNIX Shell Scripting, Perl scripting, JAVA, PHP, XML, HTML,

EDUCATION

Bachelor of Engineering

PROFESSIONAL EXPERIENCE

Client : Confidential, Herndon, VA
Duration : July 2010 - present
Role : Senior Oracle DBA

• 24 X 7 Production database administration, support
• Installation, Configuration and Administration of Oracle 11g RAC and Oracle 10g RAC.
• Implementation of High Availability solutions with Oracle 11g RAC, 10g RAC, Standby Database (Active Data Guard), Replication.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Maintenance and monitoring of oracle 11g/10g databases
• Involved in Upgrade/Migration of the oracle databases from Oracle 10g to Oracle
• Involved in migrating databases from Windows to Linux, HP-UX to IBM AIX.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases
• Creating users, assigning Roles, Grants and creating profiles and password management.
• Involved in PL/SQL coding using cursors, triggers, stored procedures, functions and packages.
• Assisted developers in tuning SQL statements in the applications.
• Written Shell Scripts for backups, cloning and custom monitoring.
• Export and Import Operations using Data Pump.
• Experience in UNIX shell scripting
• Management of Users, Roles and Privileges.
• Performing Backup/Recovery of all the Oracle databases using RMAN involving both hot and cold backups.
• Creation of database links from different oracle and SQL server databases for data loading.
• Performance monitoring and tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR, ASH, ADDM
• Partitioning of large tables for better performance and manageability..
• Managed the existing databases by applying new required release modification to existing database structure and applied new Oracle patches as required.
• Maintain Physical Standby database and performing switchover/failover when required.
• Replicating the tables, schemas and database using the replicating tool Golden Gate.

Environment: Oracle 11g RAC, 10g RAC, 9i, RedHat Linux, HP-UX, IBM AIX, Windows, SQL Developer, OEM/GridControl, TOAD, RMAN, ASM, DataPump, Golden Gate, ERWIN.
Client : Confidential, Irving, Texas
Duration : December 2008 - June 2010
Role : Oracle DBA

• 24 X 7 Production database administration, support
• Installation, Configuration and Administration of Oracle 10g RAC.
• Implementation of High Availability solutions with Oracle 10g RAC, Standby Database (Data Guard), Replication.
• Provide day-to-day Database support that includes monitoring, troubleshooting, and performance tuning of database environments.
• Upgrade/Migration of Databases from Oracle 9i to 10g, Oracle 10g to 11g
• Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.
• Cloning/Data Refresh from production environment to setup test and development environments.
• Performed databasecloningto setup test and development database
• Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.
• Involved in developing logical and physical modeling of the database using Erwin
• Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
• Creating and sizing of database objects (tablespaces, tables, and indexes).
• Database Backup and crash/Recovery.
• Good Programming Skills in SQL, PL/SQL, UNIX Shell Scripting.
• Setup backup and recovery procedures using RMAN. Performed hot and cold backups using RMAN.
• Performed block recovery using RMAN. Performed backup validations using RMAN.
• Performance monitoring and tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR, ASH, ADDM
• Partitioning of large tables for better performance and manageability..
• Tuning of I/O includes separating data files and redoing log files on different locations, separating of data files and index files on different locations, reducing disk contentions
• Partitioning strategies for very large tables. Partitioned large objects to improve the query performance and manageability
• Experience in installing Oracle patches. Applying critical patches whenever required
• Actively involved in Backup Management of Disaster Crash recovery supporting 24x7 assurances.

Environment: Oracle 11g, 10g RAC, 9i, RedHat Linux, Sun Solaris, IBM AIX, Windows, SQL Developer, OEM/GridControl, TOAD, RMAN, ASM, DataPump, ERWIN
Client : Confidential, Coppell, TX
Duration : May 2007 - November 2008
Role : Oracle DBA

• 2x7 Production database administration support
• Installation, Configuration and Administration of Oracle 10g RAC.
• Implementation of High Availability solutions with Oracle 10g RAC, Standby Database (Data Guard), Replication.
• Provide day-to-day Database support that includes monitoring, troubleshooting, and performance tuning of database environments.
• Upgrade/Migration of Databases from Oracle 8i,9i to 10g
• Worked closely with users in understanding the requirements and coordinated between the users and the development team.
• Involved in writing and executing stored procedures, functions, packages and triggers.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS
• Create table spaces, tables, and users for custom applications.
• Security administration such as privileges, roles and assigning passwords on the tables, stored procedures, and Firing triggers and constraints objects depending on role.
• Proficient in all DBA responsibilities such as Instance tuning, user management, space management, and monitoring.
• Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
• Hands on experience in UNIX shell scripting.
• Implementing range, list partitions, hash partitions.
• Creating and refreshing materialized views.
• Loaded data using SQL*Loader
• Created and running the shell scripts to run the Processes at time schedule according to business rules.
• Performed full database recovery as well as incomplete recovery using Tablespace Point in Time Recovery (TSPITR).
• Migrated databases from Windows to Linux.
• Performed Point-In-Time Recovery.
• Cloned databases using RMAN Duplicate and cold & hot backups.
• Performed Backup and Recoveries using RMAN
• Performance monitoring and tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR, ASH, ADDM
• Partitioning of large tables for better performance and manageability.

Environment: 10g RAC, 9i, Sun Solaris, RedHat Linux, HP-UX, Windows, SQL Developer, OEM/GridControl, TOAD, RMAN, ASM, DataPump, ERWIN
Client : Confidential
Duration : December 2005 - April 2007
Role : Oracle DBA

• Maintaining production, development & test databases and applications.
• Upgraded database from Oracle 9i to Oracle 10g.
• Design normalized logical database models (ERDs) to support application development, and create physical objects within the Oracle database.
• Describe and explain how programs should access data in Oracle databases to application developers.
• Troubleshoot and resolve database problems.
• Installation of Oracle Database and Oracle products.
• Implementing Backup/Recovery Strategies.
• Wrote PL/SQL procedures, functions and triggers for insert, update, and delete transactions.
• Created the indexes to optimize the performance of the data retrieval process.
• Conceptual data modeling; logical and physical data modeling.
• Involved in cloning the databases and Patching.
• Good understanding in data modeling, entity-relationship modeling.
• Database Tuning using init parameters, optimizing rollback segments, redo log configuration, and I/O distribution.
• Scheduling jobs through Oracle job Scheduler.
• Monitoring diskspace usage at the OS level and tablespace level.
• Performance monitoring and tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR, ASH, ADDM
• Analyzing workload of group and recommend improvements. Continually enhances the Group’s skills around client satisfaction

Environment: 10g RAC, 9i,8i, IBM AIX, Sun Solaris, RedHat Linux, Windows, OEM/GridControl, TOAD, RMAN, ASM, DataPump, ERWIN
Client : Confidential
Duration : July 2004 - December 2005
Role : Oracle DBA/Developer

• Installed and configured Oracle 9i and 10g databases.
• Creation of tables, indexes, constraints, procedures, functions and packages based on the design.
• Implemented triggers to enforce integrity constraints.
• UNIX Shell scripting to simplify the day to day activities.
• Worked in development of PL/SQL Packages, Stored procedures, Triggers.
• Created and running the shell scripts to run the Processes at time schedule according to business rules.
• Security administration such as privileges, roles and assigning passwords on the tables, stored procedures, and Firing triggers and constraints objects depending on role.
• Creating & Maintaining Tablespaces.
• Cloned database for development needs.
• Maintain user security.
• Refresh/Cloning of Database for development, testing
• Performing various test recovery scenarios at database, tablespace, datafile levels
• Monitoring and Management of database users
• Diagnose and troubleshoot Database problems and failures
• Create and maintain Operating System user accounts.

Environment: 10g, 9i,8i, IBM AIX, Sun Solaris, RedHat Linux, Windows, OEM/GridControl, TOAD, RMAN, ASM, DataPump