SUMMARY:

• Over 6 years of experience in System Analysis, Design, Development and Administration of Oracle 8i/9i/10g/11g Databases.
• Experience in Installation, Configuration, patching, upgrades and Maintenance of Oracle Databases.
• Experience with RAC installation and configuration on both 10g and 11g environments.
• Experience with RMAN, OEM Grid Control, Oracle Automatic Storage Management (ASM), Data Warehousing, Oracle Data Guard, Oracle Streams, Golden Gate, Oracle Data pump.
• Experience in Database Cloning from production to test and development databases.
• Experience in Upgrading Databases from 8i to 9i, 9i to 10g, 10g to 11g.
• Experience in cross-platform database migrations from Sun Solaris to IBM AIX and Windows to Linux.
• Expertise in Configuring, managing and troubleshooting data replication.
• Experience Golden Gate installation, configuration and administration.
• Experience in Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Active Session History (ASH).
• Proficiency with Tuning the SGA, Monitoring and Detecting Locks.
• Experience in Materialized views.
• Experience in Replication using Materialized Views, Streams and GoldenGate.
• Experience in managing large Multi-terabyte Oracle databases.
• Applying PSU/CPU patches, Oracle patches, Release upgrades, ONE-OFF patches.
• Expertise includes Data Analysis, Data Modeling using ERwin tool, Data Cleansing, Transformation, Integration, Data import, Data export.
• Good experience in Database Design (Conceptual, Logical and Physical database design)
• Good experience in Capacity Planning and Bench Marking.
• Good experience in SQL, PL/SQL development. Written PL/SQL Functions, Procedures, Packages and Triggers.
• Experience in Partitioning (Range, List, Hash, Interval Partitioning).
• Experience in database security strategies. Creating database users, user roles, profiles and audits.
• Experienced in Planning, Installation, Physical and Logical Database Design, Data Migration, Backup and Recovery, Cloning, Refreshing test and development databases, Monitoring, Trouble shooting & Tuning.
• Goal Oriented, Good Co-ordination and Co-operation with the Team and Management. Adept at learning and adaptable to complex work environment.
• Managing projects ranging from simple implementation to heterogeneous setup for organizations of varying size and complexity in a 24/7 production environment. 
  

RDBMS

Oracle 8i, 9i, 10g RAC, 11g RAC, SQL Server, MySQL

OS

 Red Hat Linux 4.x/5/x/6.x, Sun Solaris, Sun 8/9/10, HP –UX 10x./11.x, Windows NT/2000/2003/Vista/XP/7

Languages

 SQL, PL/SQL, Unix Shell script, C, C++, JAVA, HTML.

Tools

RMAN, ASM, OEM/Grid Control, SQL*Plus, Export/Import, DataPump, SQL*Loader, Statspack, ASH, AWR, ADDM, Toad, SQL Developer, Erwin, Streams, GoldenGate, Informatica, Cognos, EMC, NetApp, Veritas NetBackup, TSM, HP Omni Back, Microsoft Office Tools.

EDUCATION:

• Bachelor of Engineering

PROFESSIONAL EXPERIENCE:

Role: Oracle DBA

Responsibilities:

• 24x7 Production on call Database support
• Installation, Configuration and Administration of Oracle 10g and 11g databases.
• Involved in Installation and configuration of Oracle 10g RAC, Oracle 11g RAC.
• Converted Single Instance Database to Multi Node RAC.
• Added nodes to existing RAC.
• Upgraded database from Oracle 9i to 10g to Oracle 10g to 11g.
• Installation, Configuration and Administration of Oracle 10g RAC, Oracle 11g RAC, Standby Database (Active Data Guard) for High Availability, Disaster Recovery and Reporting purpose.
• Migrated databases from Sun Solaris to HP-UX and Windows to Linux
• Database Cloning from production to test and development databases
• Maintained backups for recovery using RMAN.
• Designed and implemented backup and recovery strategies.
• Performed Full, Incremental backups using RMAN.
• Performed Cold/Hot backups.
• Performed Schema Refreshes using export/import and oracle Data Pump.
• Performance monitoring and tuning using SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.
• Planned and designed databases; including designing local structures and forecasting further expansions.
• Database Design (Logical and Physical database design).
• Capacity Planning and Bench Marking.
• SQL, PL/SQL development. Written PL/SQL Functions, Procedures, Packages and Triggers.
• Written Shell Scripts for backups, cloning databases, monitoring.
• Partitioned large tables for better performance.
• Replication using Materialized Views, Oracle Streams and GoldenGate.
• Automated the regular jobs using crontab and dbms_scheduler.
• Replicated tables of a Schema using Oracle Streams with two oracle databases in 10g.
• Extensively used Export/Import utilities for selective backup, transferred tables between oracle instances.
• Database security and auditing.
• Designed and conducted a data quality strategy plan to ensure no data was lost or corrupted during migration.
• Performed Space Management and Capacity Planning.
• Controlled and monitored user access to the database.
• Responsible for applying Oracle Patches and CPU patches.
• Generated SQL and PL/SQL scripts to create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Analyzed schemas on all the databases on a regular basis.
• Supported development, testing and production databases.

Environment: Oracle 11g RAC/10g RAC/9i, SQL, PL/SQL, SQL*Loader, RMAN, DATAPUMP, OEM Grid Control, SQL Plus, Sun Solaris, HP-UX, IBM AIX, RedHat Linux, Windows.

Confidential, TX Apr ’09- Sep’10 
Role: Oracle DBA

Responsibilities:

• 24x7 Production on call Database support
• Installation, Configuration and Administration of Oracle 9i, 10g and 11g databases.
• Involved in Installation and configuration of Oracle 10g RAC.
• Converted Single Instance Database to Multi Node RAC.
• Upgraded database from Oracle 9i to 10g to Oracle 10g to 11g.
• Built Physical standby databases.
• Designed and implemented backup and recovery strategies.
• Performed Full, Incremental backups using RMAN.
• Performed Cold/Hot backups.
• Performed logical backups using DataPump.
• Performed Schema Refreshes using export/import and Oracle Data Pump Export and Data Pump Import.
• Performance monitoring and tuning using SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.
• Replicated tables of a Schema using Oracle Streams with two oracle databases in 10g.
• Created Physical Database and storage structures.
• Partitioned tables.
• Used DBverify utility to check the data block corruptions.
• Created primary database storage structures like Tablespaces, tables, views, indexes etc.
• Performed Database cloning/refresh from production to the development database.
• Implemented Security administration by creating of roles, views and granting the necessary object/system privileges to users. Applied Database software fixes/patches.
• Interacted with the users and resolved the problems involved with the development of stored procedures, triggers and problems related to the privileges & resources.
• Aided developers in writing efficient code and making efficient use of resource leading to better performance and optimization.

Environment: Oracle 11g /10g RAC/9i, SQL, PL/SQL, SQL*Loader, RMAN, DATAPUMP, OEM Grid Control, SQL Plus, HP-UX, IBM AIX, RedHat Linux, Windows.

Confidential, CA Dec’08 – Mar’09
Role: Oracle DBA

Responsibilities:

• 24x7 Database administration support
• Installation, Configuration and Administration of Oracle 9i, and 10g databases.
• Supported the Production, Development and Test databases.
• Installed and configured Oracle 10g RAC.

• Performed Full, Incremental backups using RMAN.
• Performed Cold/Hot backups.
• Performed logical backups using DataPump.
• Performed Schema Refreshes using export/import and Oracle Data Pump Export and Data Pump Import.
• Performance monitoring and tuning using SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.
• Analyzed schemas on all the databases on a regular basis.
• Upgraded database from Oracle 8i to 9i and 9i to 10g.
• Applied patches to fix the bugs.
• Involved in Database Design (Conceptual, Logical and Physical database design)

• Used tools such as RMAN for backup and recovery.
• Designed new job process, and did performance tuning of the existing ones.
• Oracle Data Guard setup.
• Performed Database cloning for the Development environment.

Environment: Oracle 10g RAC/9i/8i, SQL, PL/SQL, SQL*Loader, RMAN, DATAPUMP, OEM Grid Control, SQL Plus, RedHat Linux, Sun Solaris, IBM AIX, Windows

Confidential Mar’07 – Nov’08
Role: Oracle DBA

Responsibilities:

• Installation, configuration and administration of Oracle 8i/9i/10g databases
• Installed Oracle and related tools, upgraded the database and applied patches as and when required.
• Cloned Production to QA, TEST and DEV environments.
• Performed Tuning by generation of STATSPACK reports and Tracing of Queries.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Monitoring the Database storage and day-to-day activities.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Performance monitoring and tuning using SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.
• Experience in database security strategies by creating database users, user roles, profiles and audits.
• Performed RMAN backups and tested various recovery scenarios for production databases.
• Coordination with the team and ORACLE Support for troubleshooting the database issues.
• Reorganization of tables and rebuilding of indexes.
• Developed UNIX Shell scripts to backup Oracle databases.

Environment: Oracle 10g RAC/9i/8i, SQL, PL/SQL, SQL*Loader, RMAN, DATAPUMP, OEM Grid Control, SQL Plus, RedHat Linux, Sun Solaris, HP-UX, Windows

Confidential May’06- Feb’07
Role: Oracle DBA

Responsibilities:

• Created Oracle Databases as per the requirements.
• Performed software installation and applying patches.
• Created the users and roles as per the business requirements.
• Performed Hot and Cold backups, Export/Import.
• Performed media recovery.
• Performed database administration tasks creating tablespaces, tables, indexes, synonyms, database links etc.
• Created Database links to connect different databases.
• Written Database stored Procedures, Functions, Packages & Triggers.
• Performed Unit, System and User Acceptance tests of different modules.
• Interaction with end user to solve their production related problems.
• PL/SQL programming and shell scripting.

Environment: Oracle 10g/9i/8i, SQL, PL/SQL, SQL*Loader, RMAN, DATAPUMP, OEM/Grid Control, SQL Plus, RedHat Linux, Sun Solaris,Windows