Experience Summary

• A certified professional Oracle DBA with around 10 years of experience in Production, UAT and Development environments of version from 8 to 11gR2.
• Managed and supported mission critical database running 24X7 Oracle 9i / 10g / 11g Production databases.
• Installed, Upgraded and configured various Oracle software packages, troubleshooting and development tasks on various platforms HP-UX / Sun Solaris/ IBM AIX/ NT at client site.
• Migrated from Single Instance Database to 4 nodes on Real Application Cluster Database.
• Re-engineer databases to meet standards and ease of maintenance.
• Design, implement and support Golden gate implementations.
• Experience in consolidation of databases in migration to Exadata.
• Configured RMAN to take backup of the Databases.
• Installed and configured Oracle 9i, oracle 10g and 11g on UNIX based machines.
• Installed Solaris on Sun SPARC server performed custom jumpstart installation.
• Automation of daily routine tasks like including user management, daily hot backup weekly cold backup using CRON AT , storage management, develop data feed and having exposure to UNIX shell scripts.
• Expertise in Using Oracle tools like Datapump, Export, Import and SQL Loader. To use perform wider variety of automated backup and recovery functions and for moving the data from one machine to another, using SQL Loader to convert non-oracle data to oracle environment.
• Implemented Oracle Partitioning and Transportable Tablespace by extensively using partitioning to maintain such a huge size databases. Script and automate partition maintenance jobs.
• Configured Data guard to provide high availability by implementing Physical stand by database.
• Adept in Advanced Replication techniques using - Materialized views set up multi- master replication, dealt with conflict resolution and performance issues.
• Implemented Standby configuration Disaster Recovery , Switchover/Switchback and Failover/Failback operation of data guard and standby database on both cluster and standalone mode.
• Restored the database after database crash, when the files are corrupted and system crash.
• Tune databases and provide design changes and support stress tests to proactively fix problems.
• Used Automatic Workload Repository AWR Automatic Database Diagnostic Monitor ADDM in RAC for Performance Tuning.
• Implemented Oracle Parallel Query Option.
• Lead a team of 18 Database Administrators 24x7
• Frequent monitoring of the database to look for any resource drain as well as any runaway processes effecting the system response time
• Did trouble shooting at 1 application level using tkprof/explain plan
• 2 OS level using SAR, VMSTAT, IOSTAT and TOP commands.
• Having experience in Performance and Instance Tuning of the database.
• Monitoring growth of the databases to take proactive action. Managing Tablespaces, Rollback Segments,Temporary Tablespace, Tables, Indexes etc...
• Expertise in maintaining Database Security using security compliance auditing,
• Experience in Database Application performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 10g OEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
• Managing rollback segments, redo log files, controlfiles and datafiles.
• Expertise in Performance Tuning of Database, includes memory tuning, application tuning, Buffers Maintenance, Disk I/O Tuning, O.S Tuning, Eliminated Database Contention.
• Did Successful transition for Oracle 10g SQL Server 2005.
• Did Successful implementation for Oracle 11g RAC.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, latch contention etc by Provide technical direction to system administrators.

Technical Skills

PROFESSIONAL EXPERIENCE:

Role: Sr. Oracle DBA

Description:

Comcast Corporation Nasdaq: CMCSA, CMCSK is a global media and technology company with two primary businesses, Comcast Cable and NBCUniversal. Comcast Cable is the nation's largest video, high-speed Internet and phone provider to residential customers under the XFINITY brand and also provides these services to businesses. NBCUniversal operates 30 news, entertainment and sports cable networks, the NBC and Telemundo broadcast networks, television production operations, television station groups, Universal Pictures and Universal Parks and Resorts.

Responsibilities:

• Installed configured Grid infrastructure with ASM on RAC servers for 11g R2.
• Configured Active data guard for oracle 11g database for disaster recovery reporting which suffices read only applications.
• Had setup GoldenGate for replication between active-passive sites with high availability using RAC.
• Analyzed AWR, ASH, ADDM reports, 10046 trace..etc. Tuned bad Sql with execution plan flip, missing bind variables, bad sql formatting with different test cases.
• Worked in the release, support testing by validating the changes at the database fixed performance issues at the DB to avoid any blockers for smooth delivery.
• Had configured backup cycle performed 11g RMAN clone for different environments using duplicate database.
• Worked with Unix shell scripts, materialized views, Capacity planning.
• Did data migration from Oracle 10g to 11g databases.

Environment: Oracle11g/10g, OEM 12c, RAC, GoldenGate, Active Data Guard, Linux.

Confidential

Role: Sr. Oracle DBA Architect

Description:

Confidential is a leading international specialty retailer offering Clothing, Accessories and Personal care products for men, women, and children. Under the Confidential Banana Republic, Confidential Piperlime and Athleta are the brand names. Its headquarters offices are based in the San Francisco Bay Area and product design offices are located primarily in Confidential . As per the last revenue statistics it is 14.2 billion Company.

Responsibilities:

• Installed 12c Databases, Oracle 11g RAC and Upgrading Oracle 11g, 10g RAC databases.
• Performing the migration to Exadata to save the license cost, Infrastructure etc for high performance.
• Designed GoldenGate configuration for databases implemented filters with rules to meet the business usage which will reduce load on the production databases for better performance with replication on multiple sites.
• Had fixed several performance tuning issues which relates to RAC standalone databases by recommending better solutions that could save cost, virtualization, resources...etc
• Implemented Managed Physical Standby.
• Tuned the RAC database by observing the views like gv sysstat, gv session wait etc
• Implemented Database resource manager to segregate the current workloads at production database reduce the resource consumption for high volume transactions..
• Plan, Support and implement major projects in Oracle database domain like Site redesigns, Scrum releases for Agile model.
• Proactive Monitoring, identifying areas that need to be improved in the application and database using Statspack, AWR, ADDM and OEM Grid Monitoring.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Configured Automatic Storage Management ASM .
• Tuned Goldengate performance by adding multiple processes and using Ranges.
• Automated monitoring of Golden Gate process, Lags and heart beat monitoring.
• Fix Goldengate setups based on Lags, process failures and veridata reports.
• Provide 3rd level support for Oracle RAC, including applying patches CPU, PSU, Interim , performance tuning, Backup and recovery issues with RMAN, trace analysis, service creation for the apps to fail over, cluster and system management.
• Automated Rebuilding indexes, Partition additions and space additions.
• Engineering, implementation , documented and support builds of new clusters to use Oracle 10g/11g RAC for high availability solutions which includes installing clusterware, ASM and shared disks , creating new databases.specific network storage and clustering solutions
• Involved in all phases of the software development life cycle.
• Implemented partitioning on large tables, expertise in using composite partitioning, local indexes and global indexes.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Monitoring adherence to laid down SOX controls. Doing internal Testing and Audit for compliance to database related SOX controls. This includes controls related to Database Access, Computer Operations and Program Control.
• Implemented indexes of Hash partitions, Reverse key Indexes, Indexes with smaller block size.
• Migrated and upgraded Oracle 11gR2 Databases from Sun Solaris 10 to Redhat Linux 5 using Goldengate.
• Worked in setting up monitoring alerts in Oracle using Nagios between the ECOM OMS databases , DB Upgrades etc

Environment: Oracle 12c/11g/10g, OEM 12c, RAC, GoldenGate, Migration to Exadata, Linux, AIX.

Confidential

Sr. Oracle DBA

Description:

Confidential headquartered in the MasterCard International Global Headquarters, Purchase, Confidential . The Global Operations Headquarters is located in O'Fallon, Confidential , a suburb of Saint Louis, Missouri. Throughout the world, its principal business is to process payments between the banks of merchants and the card issuing banks or credit unions of the purchasers who use the MasterCard brand debit and credit cards to make purchases. MasterCard Worldwide has been a publicly traded company since 2006. Prior to its initial public offering, MasterCard Worldwide was a cooperative owned by the 25,000 financial institutions that issue its branded cards.

Responsibilities:

• Designing, creation, maintenance and troubleshooting of database.
• Tuning the Oracle instance for optimal performance.
• Expertise in Backup recovery RMAN , export/import of database.
• Worked with Range, Hash, List Partitioning techniques.
• Worked with unix shell scripts, materialized views, Capacity planning.
• Tuned the RAC database by observing the views like gv sysstat, gv session wait etc.
• Configured the listeners and aliases to set up Transparent Application Failover TAF .
• Helped development team in writing, executing and Tuning PL/SQL Functions, Procedures, Packages.
• Configured Recovery Manager RMAN for RAC Database backup, restore and recovery.
• Installed Configured Oracle 11g Enterprise Manager Grid Control.
• Configured Automatic Storage Management ASM .
• Converting Single Instance Database to Oracle RAC Database.
• Adding Removing a Cluster Node.
• Created undo tablespaces, Redo log file groups and thread 2 for adding second instance to the RAC System.
• Fixed performance issues in Goldengate by adding more processes and using Range distributions.
• Defined various init.ora parameters and database level parameters in the SPFile on the common Shared Disk Subsystem SDS .
• Setup and modified Goldengate with single and multiple sources.
• Involved in system study, analysis, design and maintenance of database.
• Set up monitoring, autostart in bi-directional replication in Goldengate.
• Experience in using GoldenGate in moving large moving of transactional data with minimal impact to online systems and performing GoldenGate on process of extract and replication of single instance as well as RAC Databases.
• Add/remove tables in Goldengate setups and support for Gap resolutions.
• Setup Active-Active bi-directional replication using Goldengate with conflict resolution.
• Installation of Oracle 11g RAC and Upgrading Oracle 10g 10.2.0.5 RAC database and its related tools to new work stations and a server
• Continuous Performance monitoring and tuning of the databases and application using AWR, ADDM, ASH.
• Cloning the test and development environments from production.
• Implemented Oracle 11g Dataguard Physical Standby
• Monitoring a Physical Standby Progress.
• Performed Disaster Recovery tests.

Environment: Oracle 11g/10g, RAC, GoldenGate, Linux.

Confidential

Sr. Oracle DBA

Description:

The Confidential , located at 400 South LaSalle Street in Chicago, is the largest Confidential options exchange with annual trading volume that hovered around one billion contracts at the end of 2007. CBOE offers options on over 2,200 companies, 22 stock indices, and 140 exchange-traded funds ETFs .

Responsibilities:

• Installation of Oracle 10g RAC and Upgrading Oracle 9i 9.2.0.4 RAC database and its related tools to new work stations and a server.
• Involved in system study, analysis, design and maintenance of database.
• Defined various init.ora parameters and database level parameters in the SPFile on the common Shared Disk Subsystem SDS .
• Created undo tablespaces, Redo log file groups and thread 2 for adding second instance to the RAC System.
• Adding Removing a Cluster Node.
• Converting Single Instance Database to Oracle 10g RAC Database.
• Configured Automatic Storage Management ASM .
• Installed Configured Oracle 10g Enterprise Manager Grid Control.
• Configured Recovery Manager RMAN for RAC Database backup, restore and recovery operations.
• Configured the listeners and aliases to set up Transparent Application Failover TAF .
• Tuned the RAC database by observing the views like gv sysstat, gv session wait etc.
• Worked with unix shell scripts, materialized views, Capacity planning.
• Worked with Range, Hash, List Partitioning techniques.
• Tuning the Oracle instance for optimal performance.
• Expertise in Backup recovery RMAN , export/import of database.

SQL Tuning using Quest Central Tools.

• Continuous Performance monitoring and tuning of the databases and application using STATSPACK, AWR, ADDM, ASH.
• Cloning the test and development environments from production.
• Implemented Oracle 10g Dataguard Physical Standby
• Monitoring a Physical Standby Progress.
• Implemented Oracle 10g Streams.

Environment: Oracle 11g R2 RAC Prod DB , 11g R2 Physical Standby,

OEL 5.6

Confidential

Sr. Oracle DBA

Description:

Confidential is state government of Michigan has several departments for catering the needs of Confidential state residents. The State of Confidential State , through the Confidential Department of Human Services DHS , with assistance of the Confidential Department of Technology Management and Budget DTMB , has issued the Contract to expand the online self service capability of the Confidential Bridges system. Bridges is Confidential integrated system supporting eligibility and benefit determination for Confidential cash assistance, medical assistance, food assistance, state emergency relief and child care assistance programs.

Responsibilities:

• Tuning the Oracle instance for optimal performance.
• Tuned the RAC database by observing the views like gv sysstat, gv session wait etc.
• Configured the listeners and aliases to set up Transparent Application Failover TAF .
• Configured Recovery Manager RMAN for RAC Database backup, restore and recovery operations.
• Installed Configured Oracle 10g Enterprise Manager Grid Control.
• Configured Automatic Storage Management ASM .
• Created undo tablespaces, Redo log file groups and thread 2 for adding second instance to the RAC System.
• Involved in Creating the Database on Shared Disk Subsystem on RAW partitions and changing the Database to Archive Log Mode.
• Defined various init.ora parameters and put the database level parameters in the SPFile on the common Shared Disk Subsystem SDS .
• Created various RAW Partitions for the database and symbolic links to access these Raw Partitions from the Oracle Database.
• Installed Oracle 9.2.0.1 RAC software and patched it to upgrade to 9.2.0.4.
• Installed Sun Solaris 10 on the nodes after creating necessary partitions and configured different parameters for setting up private network, public network, rlogin...etc on Nodes.
• RAC Database has been implemented over Storage Area Network SAN , with EMC Clarion FC 4700 storage, Fiber Channel Host Bus Adapter FCHBA I/O controller, 8 port FC switch and fiber channel media.
• Involved in system study, analysis, design and maintenance of database.
• Installation of Oracle 10g RAC and Upgrading Oracle 9i 9.2.0.4 RAC database and its related tools to new work stations and a server.
• Continuous Performance monitoring and tuning of the databases and application using AWR, ADDM, ASH.
• Cloning the test and development environments from production.

Environment: Oracle 9i/10g, Solaris 2.8, IBM-AIX - 4.3, MS SQL Server 2005.

Confidential

Sr. Oracle DBA

Description:

Confidential is a multinational banking and financial services company headquartered in London, United Kingdom. It operates a network of over 1,700 branches and outlets including subsidiaries, associates and joint ventures across more than 70 countries and employs around 87,000 people. It is a universal bank with operations in consumer, corporate and institutional banking, and treasury services. Despite its Confidential base, it does not conduct retail banking in the UK, and around 90 of its profits come from Africa, Asia and the Middle East.

Responsibilities:

• Worked with Range, Hash, List Partitioning techniques.
• Applied patches to Oracle Server.
• Worked with materialized views.
• Involved with the development team and developed functions, procedures and packages using PL/SQL.
• Using RMAN utility to perform backup and recovery functions.
• Erwin Modelmart is used for Data modeling Logical/Physical and for designing entity relationships.
• Performance and kernel tuning to get optimal performance tuning of the database.
• Involved in system study, analysis, design and maintenance of database.
• Responsible for performance tuning of databases, SQL query tuning, and working with development team to tune applications.
• Managed Basic, Advanced, Multi-master Replication. Monitoring Replication.
• Involved in data warehousing project implementation.
• Expert in using Oracle Enterprise Manager OEM , Database Configuration Assistant DBCA , Database Upgrade Assistant DBUA .
• Updating the test and development environments from production cloning .
• Maintaining of Hot Standby Database.
• Tuning the oracle instance for optimal performance.

Environment: Oracle 8i/9i/10g, Solaris 2.8, Linux Advanced Server -2.1, HPUX- 2.0, IBM-AIX - 4.3, EMC SAN