SUMMARY

• Over Seven years of IT experience as Oracle Database Administrator with key strengths in Oracle 8i, 9i, 10g and 11g databases running on HP - UX, SUN SOLARIS, AIX, Red Hat Linux and Windows operating system environments
• Worked with team to support 24/7 production environments.
• Oracle Database Administration experience in variety of different environments like Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, database design, TAR support, Unix shell scripting and documentation.
• Experienced in installing and setting up Oracle 11g, 10g, 9i, 8i databases and upgrading the databases to 10g and 11g on HP-UX
• Experience with Real Application Testing (RAT)
• Planned and implemented high availability solutions using Oracle 10g RAC, Oracle 11g RAC Standby Database (Oracle Active Data Guard).
• Proficient in using OEM grid control.
• Experience in Data Migrations using oracle export/import, data pump.
• Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN.
• Demonstrated ability to identify root causes of problems, consider both long and short-term impact of proposed solutions and develop workable solution. Ability to manage multiple project tasks with changing priorities and tight deadlines.
• Experience in MS SQL Server DBA
• Experience in data management methodologies such as partitioning; materialize views, space management for tablespaces.
• Familiarity with E-Business Suite.
• Expertise in Oracle performance tuning using STATSPACK, TKPROF, EXPLAIN PLAN, ASH, AWR and ADDM
• Expertise in SQL, PL/SQL coding.
• Experience in Erwin Data Modeling, Logical and Physical database design.
• Worked with development teams and data administration staff to enhance Database and application performance.
• Proficient in proactive monitoring, identifying areas that need to be improved in the application and database.
• Experience in management of schemas, objects & partitioning the tables & indexes.
• Experience in administration of large Oracle databases running in SAN environment, setting up databases for bank environment.
• Experience in Oracle Streams and familiarity with GoldenGate replication.
• Experience in Benchmarking and capacity planning using oracle stats pack historical data analysis.
• Excellent experience in OLTP/DSS database systems, implementing and managing Large Oracle databases (VLDB).
• Expertise in data warehousing design and ETL.
• Demonstrated ability to work well with a wide variety of people at various levels, foster cooperation and collaboration among individuals in the work unit, help team resolve conflicts constructively and ability and willingness to communicate when help is needed.
• A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges. Strong listening, interpersonal and analytical skills.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris, 8, 9, 10, AIX 5.1, 5.2, 5.3 Red Hat Linux RHEL 4.x, 5.x, 6.x and Windows 95/98/ME/NT/2000/XP.

RDBMS: Oracle8i, Oracle 9i, Oracle 10g (RAC), Oracle 11g (RAC), Data Guard MS SQL server 2008

Languages: SQL, PL/SQL, Java, C, PERL, UNIX Shell

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, ERWIN, TOAD

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK,ASH,AWR,ADDM

Database Modeling: Erwin 4.0, Rational rose

ETL Tools: Informatica 5.1 Power Center 7.1/6.1 /5.1, Power Mart 6.1 /5.1,SAS 9.1

Reporting Tools: Business Objects XI/6.x/5.x, Crystal Reports 10.X/XI

Other: EMC, NetApp, VERITAS Net Backup, TSM, Litespeed

Web Tools: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Oracle DBA Consultant

Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
• Installation, Configuration of Oracle 10g RAC, Oracle 11g RAC Stand by database (Oracle Active Data Guard).
• Managed schemas, objects partitioning the tables, table spaces & indexes.
• Upgraded databases from Oracle 9i to Oracle 10g, Oracle 10g to Oracle 11g.
• Configured the cluster hardware and installed RAC on HP-UX
• Optimization and tuning using TRACE FILE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ASH,ADDM
• Applied patches to Oracle RDBMS
• Implemented Oracle 11g OEM,OMS and repository
• Performed archive and delete processes for large partitioned tables using IBM OPTIM
• Implemented Real Application Testing (RAT) for upgrades and migration.
• Capture, analyze and replay database transactions by using RAT.
• IdentifySQL execution plan changes and performance regressions through SQL Performance Analyzer with RAT.
• Cloned/Refreshed Oracle Databases for development and testing.
• Responsible for optimizing the queries and application tuning.
• Implemented space reduction of huge tables using oracle 11g Advanced compression.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Perform Schema configuration, job scheduling of the data warehouse related to BO development.
• Implemented the Logical and Physical Schemas with technical support.
• Provided support to Application Database Administrators in designing the database.
• Perform Data Migrations using oracle export/import, data pump and sqlldr.
• Installed and Implemented Backup & Recovery procedures.
• Involved in taking Backups using Oracle RMAN (Recovery Manager) and VERITAS Net backup as a Media Management Layer. Configured Media and Storage devices for Net Backup. Automate RMAN backup using scripts. Defined VERITAS Net backup policies like Storage unit and media use, backup schedules etc.
• Setup backup and recovery procedures using RMAN. Performed hot and cold backups using RMAN.
• Management of multiple instances of Oracle deployment platforms using OEM 11g for grid control.
• Implement Hot, Cold and Logical backup plans.
• Performed block recovery using RMAN. Performed backup validations using RMAN.
• Customization and development of Korn shell scripts. Oracle Database monitoring, troubleshoot and resolve the issues.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Performed other regular DBA activities including space management and performance monitoring.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters and Oracle Standby Server.

Environment: Oracle Server 11g RAC, 10g RAC/9i,OEM Grid Control 11g, SQL, PL/SQL, RMAN, ASM, SQL*Loader, DataPump, HP-UX, Sun Solaris, IBM AIX, Red Hat Linux, Windows, Shell scripting

Confidential, Fort Worth, TX

Oracle DBA Consultant

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation, Configuration and Maintenance of RAC, Stand by database.
• Installation of Cluster ware, configuring public, private and VIP.
• Proactive database monitoring using 10g grid monitoring tool.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading development and production databases to Oracle 11g.
• Applied patches to Oracle Databases and Oracle Applications.
• Applied Oracle Applications and database patches.
• Performed MS SQL Server database administration, configure Scheduled Tasks for regular Database Backup and Maintenance Activities, create and modify tables, stored procedures, various clustered/non-clustered indexes, triggers, check constraints and functions.
• Responsible for optimizing the queries and application tuning.
• Performed CDC (Change Data Capture) along with data replication and MDM (Master Data Management) capabilities ofGoldenGate
• Performed improvements, implementation and post-deployment support ofGoldenGatein standby configuration
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans.
• Customization and development of Korn shell scripts.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies.
• Perform other regular DBA activities including space management and performance monitoring.
• Installed and configured Litespeed for oracle.
• Administered Litespeed with Veritas Net backup and RMAN
• Performance Tuning using TRACE FILE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR
• Involved in process improvement, Oracle Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.
• Code Promotions to UAT & Production environments.
• Code review to ensure that the new customizations were developed within corporate programming standards.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Management of schemas, objects partitioning the tables & indexes.

Environment: Oracle Server 11g RAC, 10g RAC/9i, OEM Grid Control, SQL, PL/SQL, RMAN, ASM, IBM AIX, Red Hat Linux, Shell scripting

Confidential, Richardson, TX

Oracle DBA Consultant

Responsibilities:

• Creation and up gradation of Oracle 9.x/10g database.
• 24 X 7 on call support of all production environments in --group supported by our team.
• Setup and configure Standby database for high availability by using Data guard.
• SQL statement Tuning using Explain Plan and SQL Trace using TKPROF utility and AUTOTRACE utility.
• Tuning the database performance through STATSPACK report.
• Maintained MS SQL Server 2005/2008, including security, configuration and install service packs upgrades.
• Implement migration SQL Server databases, user logins, and DTS packages from one server to another
• Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup.
• Implemented Oracle Streams with change data capture.
• Managed the captured LCR’s in Oracle Streams
• Data transferring with export/import utilities and Data Pump.
• Monitoring and maintenance of multiple databases for production, development, testing and staging purposes using utilities like OEM and Toad.
• Frequent interaction with Developers, and working with them in developing the applications using SQL Trace and Explain Plan utilities
• Maintenance of ORACLE Database, Performance Tuning, Backup, Recovery and other database related activities.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
• Database Administration and Planning including logical design, physical design, backup & recovery.

Environment: Oracle Server 10g, 10g RAC /9i, SQL, PL/SQL, RMAN, ASM, SQL*Loader, HP-UX, Sun Solaris, Red Hat Linux, Shell scripting

Confidential

Responsibilities:

• Provided 24X7 support for all the production and development databases.
• Installed and configured Oracle 10g.
• Performed upgrades from Oracle 9i to 10g.
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting and backup and recoveries.
• Applied Oracle Applications and database patches.
• Cloned/Refreshed Oracle Databases and Oracle Applications.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Implemented Oracle streams and administered the capture, staging, consumption
• Used Oracle streams to record table changes and managed rule based transformations
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies.
• Perform other regular DBA activities including space management and performance monitoring.
• Performance Tuning using TRACE FILE, TKPROF, EXPLAIN PLAN, STATSPACK.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Backup & Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing

Environment: Oracle Server 10g/9i, HP-UX, AIX 5.2, SQL, PL/SQL, RMAN, SQL*Loader, Shell scripting

Confidential

Oracle Developer/DBA

Responsibilities:

• Provided support for all the databases as an operational database administrator.
• Responsible for administering and supporting production and development Oracle 8i/9i databases.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Upgraded databases from Oracle 8i to Oracle 9i environment.
• Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.
• Instance cloning done to create test and training environments.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Configured scripts to monitor activity with database.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Developer Environments setup using database cloning and refresh procedures.

Environment: Oracle Server 9i/8i, SQL, PL/SQL, Sun Solaris, HP-UX, Shell scripting