SUMMARY

• Around 8 Years of experience in Oracle Database Administrator worked on Linux (RedHat Linux, Oracle Enterprise Linux), Unix (HP - UX, Sun Solaris, IBM AIX) and windows platforms, which involves Designing, Installing, Migrating, Upgrading, 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/12c/Exadata
• 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.
• 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.
• Performance monitoring and tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR, ASH, ADDM
• 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/12c/Exadata, 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, JAVA, PHP, XML, HTML

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Senior Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support
• Installation, Configuration, Maintaining, Implementing and Monitoring of Oracle Exadata, Oracle 12c, 11g RAC and DataGuard for high availability and disaster recovery.
• Upgrade databases Oracle from 10g to 11g, 11g to 12c.
• Apply CPU, PSU patches
• Migrated databases from Sun Solaris, Windows to Linux
• Creation, managing of Database Links and Materialized views
• Logical and Physical database design
• Capacity planning and benchmarking
• Creation and managing dba jobs and scheduler jobs to automate the jobs and monitor issues during on call support.
• Involved in user management such as user creations, profiles, privileges (sys and obj), roles, tables, indexes, constraints, scheduler jobs, db links, materialized views, refresh groups etc.
• Creating and Managing table partitions for optimizing queries and to boost the overall performance of databases.
• Performance monitoring and tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR, ASH, ADDM
• SQL Advisor, ADDM, SQL Tuning, Database Replay and EXPLAIN PLAN analysis for query optimization
• Involved in PL/SQL coding using cursors, triggers, stored procedures, functions and packages.
• Assisted developers in tuning SQL statements, PL/SQL programs
• Written Shell Scripts for backups, cloning and custom monitoring.
• Backup and recovery of the databases.
• Backup management using RMAN (incremental and full backup)
• Monitor databases and servers using Oracle 12c OEM GridControl.
• GoldenGate implementation and administration for replication.
• Providing technical support to Application Support team for performance and database related issues.

Environment: Oracle Exadata, 10g, 11g, 12c, RAC, Data Guard, HP-UX, Sun Solaris, Windows, SQL Developer, TOAD, RMAN, ASM, Data Pump, Exadata.

Confidential, Minnetonka, MN

Senior Oracle DBA

Responsibilities:

• Configuring and Maintaining the Data Guard to ensure high availability and data protection.
• Implementing and Monitoring the databases in the Oracle 10g RAC, 11g RAC.
• Installation, configuration and maintaining the Oracle 11g RAC.
• Implemented Data Guard (Physical Standby) for disaster recovery.
• Writing shell scripts to actively monitor the data guard databases (status, create standbys, rebuild data guard broker etc.), Data guard services, Data guard protection modes
• Monitoring the databases while performing switchover operation (FSFO and bystander)
• Involved in manual creation of the standby databases.
• Load data using SQL Loader
• Logical and physical design of the databases.
• Migration of databases from Non ASM to ASM platform and vicerversa
• Migration of databases from IBM AIX to HP-UX using logical exports/imports and Data Pump
• Creating new schemas, roles, profiles and grant privileges according to the requirements.
• Writing scripts to restore, recover databases using RMAN for all the data guarded databases
• Performed complete database recovery, tablespaces recovery, particular datafile recovery using RMAN.
• Applying patches PSU, CPU patches to update the oracle version and fixing the bugs using OPatch utility
• Updating OPatch version to apply the newly released quarterly patches.
• Performance tuning of databases, SQL Tuning and generating reports using AWR, ADDM for the complete statistics
• Writing cursors, stored procedures, functions in the packages.

Environment: Oracle 11g RAC, Oracle 10g, 11g Data Guard, HP-UX, IBM AIX, Windows, SQL Developer, TOAD, RMAN, ASM, Data Pump, Oracle Forms 6i, 11g

Confidential, Herndon, VA

Senior Oracle DBA

Responsibilities:

• 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.

Confidential, Irving, Texas

Oracle DBA

Responsibilities:

• 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

Confidential, Coppell, TX

Oracle DBA

Responsibilities:

• 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