SUMMARY:

• 9+ years of experience as an Oracle DBA in database administration, production support, installation, upgrade, configuration, patches, performance and tuning, backup and recovery, export/import, storage management, database security and designing databases.
• Extensive experience on database administration for Oracle 11g RAC/10g RAC/9i.
• Experience in Configuring Single Instance, Oracle Real Application Clusters (RAC) and Automatic Storage Management(ASM).
• Expert in backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring, cloning, upgrading and migration of oracle software and tools.
• Solid experience on Upgrading Oracle databases for Oracle 11g RAC/10g RAC /9i.
• Expert in backup/recovery in both Offline and Online backup scenarios (Cold /Hot backups).
• Solid experience in Oracle Recovery Manager (RMAN), and standby database using Data Guard.
• Expertise in the database infrastructure design which also include Real Applications Clusters (RAC), Standby Databases (Data Guard).
• Data transferring with export/import utilities and Data Pump and SQL* Loader.
• Good experience in SQL, PL/SQL Programming (Functions, procedures, packages and triggers).
• Developed SQL, UNIX and LINUX shell scripts to automate DBA functions. Diagnosed problems and implement corrective actions.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Listener, TNS Names.
• Maintained large production as well as development/test/stage databases which involve Web Logic.
• Hands on experience in build and Design of Databases for Oracle 10g and 11g.
• Proficient with SQL Developer, RMAN, Toad, Win Merge, Win SCP and Putty.
• Exposure to Oracle Utilities and Tools like Import - Export, RMAN
• Experience in all facets of the systems development lifecycle, from requirement development, architecture design, testing, and post implementation revisions.
• Capable of working under pressure and stiff deadlines with 24/7 Database support.
• Experience in analyzing, translating business requirements to technical requirements and architecture.
• Experienced in performance tuning of various aspects of the database by using oracle utilities like TKPROF, EXPLAIN PACK PLAN, STATS, SQL TRACE, TOAD.

TECHNICAL SKILLS:

Databases: Oracle 11g R2 RAC, 10gR2 RAC, 9i, 8i, Server 2012/2008/2005.

Operating Systems: HP-UX, Sun Solaris, AIX, Linux and Windows.

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Tools: RMAN, SQL*Loader, EXP, IMP, Data Pump

Tuning Tools: TKPROF, EXPLAIN PLAN, S TATSPACK, AWR.

ETL Tools: TOAD, BMC Remedy, Clear Case, Putty, Win Merge, Win SCP

PROFESSIONAL EXPERIENCE:

Confidential, Burbank, CA

Oracle RAC DBA

Responsibilities:

• Installation, configuration and administration of Oracle Real Application Clusters (Oracle 11g RAC/Oracle 10g RAC) and Standby Databases for High Availability and Disaster Recovery purpose.
• Proficient in managing Oracle Instance, database storage structure, schema objects and database objects, including tables, Indexes, views, sequences, packages and procedures.
• Upgrade/Migrated the production and development databases from 10g to 11g.
• Performed and monitored Hot and Cold database backups and implemented backup and recovery using RMAN (with and without catalogue).
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with dev team, Oracle Install, Upgrade, 24x7 production support.
• Apparently perform SQL tuning and baseline tuning.
• Skilled with STATSPACK, AWR and Explain Plan to check health of database & hardware.
• Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with other counterpart as well as Clients and understanding requirements.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Generating Stats pack reports and AWR reports for Database for Application tuning and also database Partitioning.
• Experience in Data Migration Working with Oracle 10g and 11g.
• Experience in proprietary Change Management processes to prevent production disruptions and outages.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Experience in quality support and delivery to the end-user.
• Designing and developing Database structures (Database triggers, Procedures, Functions to implement business Rules). Loading data into Database using external tables.
• Exposure to Oracle Utilities and Tools like Import-Export, RMAN.
• Troubleshooting for Production database issues/Performance issues based on Remedial tickets.
• Documentation of RAC Database Setup, Stream Replication and administration of Server Environment.

Environment: IBM-AIX, SunSparcSolaris64bit, and RedHat Linux.

Confidential, San Jose, CA

Database Administrator

Responsibilities:

• 24/7 Production Database support of multi-terabyte Oracle 11g database.
• Performed all aspects of database administration including Installation, Configuration, Patches, Monitoring, Import/Export, Cloning, etc.
• Upgrade/Migrated the production and development databases from RAC /10g to RAC /11g.
• Installation, configuration and administration of Oracle Real Application Clusters (Oracle 11g RAC/Oracle 10g RAC) and Standby Databases for High Availability and Disaster Recovery purpose.
• Plan, implement, and troubleshooting Oracle RMAN backup, restore, and recovery.
• Provide performance tuning, problem diagnosis, data reorganization and database upgrade support.
• Monitor and tune Oracle database for optimum performance. Assist in capacity planning of Oracle database servers.
• Generated and analyzed STATSPACK, AWR, Explain Plan reports, error checking and monitored statistics for performance tuning of the database.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Performed data loads using SQL*LOADER.
• Developed PL/SQL Packages, functions and triggers to implement various functionalities.
• Experience in Managing work repositories and creating reports.
• Wrote UNIX Shell Scripts for Backup and cloning.
• Tune SQL, PL/SQL statements found in the reporting utilities and queries.
• Involved in the maintenance and trouble shooting of RAC Databases.
• Monitored and managed the space usage and table partitioning.
• Implemented and Configured Standby database (Data guard) for disaster Recovery.
• Primary point of contact between customer and core development team.

Environment: Oracle 11g RAC/10g RAC, RedHat Linux, Sun Solaris, HP-UX, AIX, Windows, SQL, PL/SQL, RMAN, SQL*Loader, Import/Export, Data Pump, Data guard, AWR, ADDM.

Confidential, Irving, TX

Senior Oracle DBA

Responsibilities:

• Installation and configuration of the Development, Test and Production databases.
• Installation, configuration and administration of Oracle Real Application Clusters (Oracle 11g RAC/Oracle 10g RAC) and Standby Databases for High Availability and Disaster Recovery purpose Performed database logical and physical design, maintenance, archiving, cloning, administration and upgrades for Oracle.
• Upgrade/Migrated the production and development databases from 9i to 10g.
• Upgrade/Migrated the production and development databases from RAC /10g to RAC /11g.
• Performed and monitored Hot and cold database backups and implemented backup and recovery using RMAN.
• Installation and Configuration of Web Logic Server on Sun Solaris for People Soft HCM Migration.
• Involved in the Design of Backup and Recovery Strategies using RMAN and traditional backup methods.
• Provided 24/7 Production Database and Applications support.
• Maintenance of 8 TB EDW Data warehousing environment.
• Worked closely with Business Intelligence Developers to extract data From EDW using Informatica.
• Implemented and Configured Standby database (Data guard) for disaster Recovery
• Involved in performance-tuning activities to improve performance of the Oracle database. Tune database through initialization parameter, SQL/PLSQL statement, error checking and memory by performing routine checks of the SGA, CPU, logical and physical I/Os and contention.
• Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, recovery time allowed etc.
• Applied patches and updates to the Oracle database.
• Provided documentation as well as training on process and procedures for infrastructure architecture.
• Worked on Shell scripts to automate system and database administration tasks.
• Designed data files, log files and control files layout across disks.
• Developed PL/SQL Packages, procedures and triggers to implement various functionalities.
• Support and ensure the high availability of all the databases especially on Clustered Databases.
• Implemented Oracle Real Application Clusters (RAC).
• Generated and analyzed STATSPACK, AWR, ADDM, Explain Plan reports and monitored statistics for performance tuning of the database.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.

Environment: Oracle 11gRAC/10g RAC, 9i, HP-UX, LINUX, SUN SOLARIS, WINDOWS, RMAN, SQL*Loader, SQL*Plus, Data Pump.

Confidential, Dallas, TX

Database Administrator

Responsibilities:

• Installation and configuration of the Development, Test and Production databases.
• Installation, configuration and administration of Oracle Real Application Clusters (Oracle 11g RAC/Oracle 10g RAC) and Standby Databases for High Availability and Disaster Recovery purpose.
• Performed database logical and physical design, maintenance, archiving, cloning, administration and upgrades for Oracle.
• 24/7 Production Database and Applications support.
• Performed and monitored Hot and cold database backups and implemented backup and recovery using RMAN.
• Designed data files, log files and control files layout across disks.
• Upgrade/Migrated the production and development databases from 9i to 10g.
• Involved in the Design of Backup and Recovery Strategies using RMAN and traditional backup methods.
• Provided documentation as well as training on process and procedures for infrastructure architecture.
• Applied patches and updates to the Oracle database.
• Support and ensure the high availability of all the databases especially on Clustered Databases.
• Implemented Oracle Real Application Clusters (RAC).
• Worked on Shell scripts to automate system and database administration tasks.
• Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, recovery time allowed etc.
• Developed PL/SQL Packages, procedures and triggers to implement various functionalities.
• Involved in performance-tuning activities to improve performance of the Oracle database. Tune database through initialization parameter, SQL/PLSQL statement, and memory by performing routine checks of the SGA, CPU, logical and physical I/Os and contention.
• Generated and analyzed STATSPACK, AWR, ADDM, Explain Plan reports and monitored statistics for performance tuning of the database.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Troubleshooting for Production database issues/Performance issues based on Remedial tickets (iTAM).
• Documentation of RAC Database Setup and administration of Server.

Environment: Oracle Database 10g RAC/9i, RedHat Linux, HP-UX, Sun Solaris, AIX, TOAD, RMAN, Data Pump, SQL*Loader.

Confidential

Oracle DBA

Responsibilities:

• Part of a 5 member DBA team which was involved in the maintenance of the Oracle 9i/8i databases for the Production as well as the development environments.
• 24x7 Production database and applications support.
• Configuring RMAN backup to various databases.
• Setup and configured Oracle Physical Standby database (Data Guard) for disaster recovery as well as to offload the running of huge reports.
• Generated and analyzed STATSPACK, AWR, ADDM reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database.
• Database cloning to setup identical databases in the production and development environments.
• Create and maintain users, roles and privileges & Auditing Triggers.
• Upgrade/Migrated the production and development databases from 8i to 9i.
• Setup and configured 2 node Oracle 10g RAC.
• Back end Programming/scripting using SQL and PL / SQL.
• Created table partition and index partition.
• Troubleshooting for Production database issues/Performance issues.

Environment: Oracle 10g RAC9i/8i, HP-UNIX, Linux SUSE, SQL, Explain Plan, Toad, Win SCP, Win Merge, BMC Remedy and Putty.