SUMMARY:

• 9 years of experience as Senior Database Administrator in planning, designing, installing, configuring, upgrades and patches, performance tuning including RMAN backup and recovery, cloning, Database Security and administering multiple Oracle databases with EXADATA, RAC, DATA GUARD, GOLDENGATE in Oracle Enterprise Linux, Red Hat & Sun Solaris UNIX (SAN storage, RAID).
• Solid skills in database design, optimization and performance tuning, design and developed applications, and SQL queries, Flash - Back Recovery, Data Pump, ASM, ASH, AWR, ADDM, Automatic Undo management, OEM Grid Monitoring and Recycle Bin, SCAN, FAN, TAF, RAC ONE NODE, Server pools.
• 24x7 Production support of Oracle 9i/10g/11g/12c databases. Managed very large (Multiple TB) size databases.
• Worked on NUMA environment NUMA is fully supported by Linux and Windows setup Oracle can now better exploit high end NUMA hardware in SMP servers.
• Oracle DBA (Oracle RDBMS 9i /10g/11g/12c)
• Work on Oracle Data Masking and Subsetting to helps database customers improve security, accelerate compliance, and reduce IT costs by sanitizing copies of production data for testing, development, and other activities and by easily discarding unnecessary data.
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning or Refreshing Database and Oracle Applications.
• Experienced in upgrading Oracle database to 10.2.0.4 to 11.2.0.4.
• Experience in setting up and maintaining Oracle Data Guard for production databases.
• Expertise in using ORADEBUG, TKPROF and SQLT for fixing performance tuning issues.
• Proficient in analyzing and optimizing queries, performance tuning and providing reports using TKPROF and Explain Plan.
• Expertise in converting single instance database to two node Real Application Cluster (RAC) / Automatic Storage Management (ASM)
• Experience in registering services through OEM11g/12c GRID Control.
• Good Experience on RMAN, Data pump, Flashback tables, ASM, ADDM, AWR, ASH etc…
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases
• Experience in general troubleshooting, firefighting, and development of scripts, documentation and issue resolution.
• Supported cross-product support across database/middle-tier issues with the development and release of Application products.
• Install, configure and troubleshoot all components maintained multiple Oracle databases.
• Perform day-to-day database administration and ensure integrity, security and availability of applications environments.
• Implemented active Oracle Data Guard to facilitate data protection, site redundancy and disaster recovery.
• Create, maintain and provide support to Oracle Cluster databases.
• Installed Oracle grid infrastructure & Oracle database software to meet the current needs and upgraded as needed to meet the expansion needs of the company.
• Knowledge on setup and configuration of Weblogic 12c and EM 12c.
• Managed databases on Exadata and GoldenGate.
• Utilized GoldenGate for data replication and synchronization
• Developed RMAN scripts for database Backup and recovery including- hot and cold backup
• Experience in Security Management and Database Auditing.
• Worked on Fusion applications and oracle Spatial with SaaS Pot environments
• Worked on Oracle 12c databse fusion applications
• Tuning the databases for optimal performance and monitoring CPU performance.
• Database Upgrading from one server to another using RMAN.
• Expertise in RMAN for recovery and cloning.
• Expertise in applying security patches.
• Basic Administration of UNIX systems (Solaris, LINUX, HP-UNIX TRU64, AIX).
• Experienced in writing UNIX shell scripts and setting up cron jobs for database needs.
• Expertise in Cloning of databases from RAC to RAC and RAC to non-RAC.
• Maintaining Hot Backups, Cold Backup.
• Monitored and managed various database components (logical & physical) like table- spaces, segments
• Work on Data Masking and subsetting can be performed on a cloned copy of the original data, eliminating any overhead on production systems
• Experience in working with ticketing tools BMC Track IT and Bugzilla.
• Strong Analytical skills and ability to interact with end-users, managers, and technical personnel.
• Good team player, self-motivated and a quick learner.
• Proficient in raising SR’s with Oracle Support and using Metalink to resolve the bottlenecks in the database environments

TECHNICAL SKILLS:

Applications: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, Erwin, TOAD, Data Pump (expdp, impdp), Autosys, Query Analyzer, VERITAS NetBackup, Developer 2000, SQL*Plus, SQL*Loader, Golden Gate,Commvault,Toad,SQL Developer

Databases: Installation, Implementation, Administration, Upgrading and Troubleshooting of Oracle 8i, 9i, 10g RAC, 11g RAC,11gR2 grid control RAC.

Tool/Utilities: TKPROF, STATSPACK, Explain Plan, ORACLE Bug DB, Oracle Demantra, OEM.

Operating Systems: Windows NT/2000/2003/XP, RHEL, Sun Solaris, AIX, HP-UX.

Others AD Utilities: SQL * Loader, TOAD, XML/BI Publisher,XtermIO,webto go mobile tool, Workflow Builder, SQL Developer.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle DBA

Responsibilities:

• Upgraded databases from 11.2.0.3 to 11.2.0.4
• Working for dell services as dell implementation partner for Harvard pilgrim.
• Working on Dell servers and tools
• Worked on setup and configuration of Fusion Middleware components Oracle SOA, WebLogic 12c, IDM and EM 12c.
• Consisting of R12 Oracle Financials, 12c Grid OEM. 11g RAC, exadata, SOA 11gR 2 11.1.1.6.3, with first North American implementation of OHI (Oracle Hospital Insurance module) on 12c Fusion Middleware Weblogic platform
• Responsible for upgrading numerous Apex (Application Express) environments from 4.0 to 4.2.
• Install Apex Oracle REST DATA services in all environments
• Responsible for new clones of Weblogic Fusion Middleware OHI, bring up managed servers and deploying war, ear, and jar files. Utilized Remedy software for managing work queues, dealing with hundreds of trouble tickets tied to administrative tasks, security, code migrations, performance tuning, imports, exports, patching and all around trouble shooting and maintenance.
• Work on Data Masking and Subletting to helps sercurtiy for Customers SSN Numbers and Personal information.
• Work on Data Masking and subsetting can be performed on a cloned copy of the original data, eliminating any overhead on production systems
• Help developers writing database triggers, packages, procedures, functions, utilities for application development.
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Configured RMAN backups.
• Maintain monitor patching on oracle Exadata x5-2 machines and environments on
• Provisioning of Fusion and EBS databases on Exadata RAC configuration.
• Worked on Dell servers and tools connected through SAN to an XtremIO
• Performed Non-RAC to RAC and RAC to Non-RAC cloning.
• Performance tuning of Oracle Database, applications and queries
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Configured Workflow Notification Mailer for inbound and outbound processing.
• Maintenance and support of Development, Test and Production environments.
• Converted single instance e-business database to Oracle 11g RAC
• Worked with technical, functional teams and Oracle Support to troubleshoot and resolve issues.
• Working on System Administrator Activities.
• Installation of Oracle Database
• Responsible for supporting multiple instances, activities include installation, maintenance and upgrade of Oracle databases.
• Supported cross-product support across database/middle-tier issues with the development and release of Application products.
• Install, configure and troubleshoot all components of Multiple Oracle.
• Perform day-to-day database administration and ensure integrity, security and availability of database environments.
• Create, maintain and provide support to Oracle Cluster databases.

Confidential, Redwood Shores, CA

Sr. Oracle DBA

Responsibilities:

• Provided production 24*7 support several databases.
• Working on System Administrator Activities.
• Installation of Oracle Database
• Responsible for supporting multiple instances, activities include installation, maintenance and upgrade of Oracle databases.
• Supported cross-product support across database/middle-tier issues with the development and release of Application products.
• Install, configure and troubleshoot all components of Multiple Oracle.
• Installed, upgrade and configured Oracle Enterprise Databases 11.1 to 11.2 and configure datagaurd 11g for DR with two physical standby database for upgrade, migrations and patch sets application.
• Creation and maintenance of Active Dataguard in 11g.
• Switch over and Fail over between Primary and Standby whenever needed.
• Dataguard Broker setup, which would help in Fast Start Fail Over.
• Worked on Fusion applications and oracle Spatial with SaaS Pot environments
• Worked on Oracle 12c databse fusion applications
• Troubleshooting oracle connectivity issues & performance issues as reported by clients in the warranty period after the Build is completed.
• Installed OEM12c and configured for 7 production windows databases.
• Configured the RMAN backups for several Production databases with one catalog database.
• Perform day-to-day database administration and ensure integrity, security and availability of database environments.
• Create, maintain and provide support to Oracle Cluster databases.
• Managed databases on Exadata and GoldenGate.
• Utilized Oracle Streams and GoldenGate for data replication and synchronization
• Extract/Replicat with Golden gate for active-passive, live setup
• Implement and Manage Oracle GoldenGate for Databases replication, Query offloading, Data loading from Oracle to Oracle
• Worked on data loading and extract using Export/Import, Data Pump, SQL loader and External Tables.
• Worked High Availability Oracle Golden Gate (OGG) systems on Oracle 11g and 11gR2 RAC environments (Front-end: Linux 5, Back-end: Oracle Exadata).
• Worked on setup and configuration of OEM11g/ 12c.
• Experience in registering services through OEM11g/12c GRID Control .
• Automate the Zip DB (Compressed Oracle DB) master setup saving time and effort by achieving a reduction of 70% in time..
• Manage storage and host resources for all the development and QA teams.
• Regular database activities, backups monitoring, issue resolving through EMS(Environment Management System Tool)
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like TKPROF, EXPLAIN PLAN, AWR, ADDM, ASH and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
• Used hints for SQL tuning and optimization
• Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.
• Experienced in ASM administration.
• Conduct training and mentor new hires on the core environment management platform.
• Upgraded Database to 11g (11.2.0.4) RAC in both TEST and PRODUCTION environment.
• 24*7 on-call production support handling weekday, weekend, nighttime, and holiday outages with focused effort to minimize downtime.
• Configured RMAN backups.
• Performed NON-RAC to RAC and RAC to NON-RAC cloning.
• Performance tuning of Oracle Database, applications and queries
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Configured Workflow Notification Mailer for inbound and outbound processing.
• Maintenance and support of Development, Test and Production environments.
• Converted single instance e-business database to Oracle 11g RAC
• Oracle Data Guard Implementation for High Availability and remote Disaster Recovery (DR) site.
• Work on Data Masking and subsetting can be performed on a cloned copy of the original data, eliminating any overhead on production systems
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Performance tuning of Oracle Database, applications and queries.
• Worked on NUMA environment NUMA is fully supported by Linux and Windows setup Oracle can now better exploit high end NUMA hardware in SMP servers.
• Cloning of database RMAN and other cloning options to create an in house instance for internal research and development.
• Work on Oracle Data Masking and Subsetting to helps database customers improve security, accelerate compliance, and reduce IT costs by sanitizing copies of production data for testing, development, and other activities and by easily discarding unnecessary data.
• Performance Monitoring, Space Monitoring / Capacity planning, concurrent manager tuning.
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Responding to different types of alerts automation using oracle alerts.
• Troubleshooting / resolving issues with concurrent managers
• Worked with technical, functional teams and Oracle Support to troubleshoot and resolve issues.
• Performing pre and post health checkups of oracle databases.
• Researched and documented available options to create a DB Link between oracle and SQL Development databases to rewrite the existing interface.

Environment: Red Hat Linux 5, OEL 5.4,Windows 2003,11g R1, Oracle Applications EBS 11i,R12.1.2,R12.2 11gR1 11g2 grid control RAC,12C,TOAD, Developer 6i.

Confidential, Pleasanton, CA

Oracle DBA

Responsibilities:

• 24x7 Production Oracle Database Administration.
• Maintaining production, development & test databases and applications.
• Oracle 10g Database Implementation/Upgrade/Support.
• Oracle 10g Application Server Implementation/Upgrade/Support.
• Good knowledge on Oracle applications 11i Rapid Installation.
• Schedule backup in 11g using db console.
• Constant monitoring of database space and space management
• Setting up Oracle Standby Data Guard.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
• Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace
• Devised an efficient backup and recovery strategy and implemented it in line with Business requirements (SQL Backtrack and RMAN)
• Automating the backup processes using shell scripts. Performing recovery in cases of system crashes.
• Worked with RAC implementation team. Added nodes.
• Have implemented standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC
• Expertise in converting single instance database to Real Application Cluster (RAC) / Automatic Storage Management (ASM)
• Configured RMAN backups.Performed NON-RAC to RAC and RAC to NON-RAC cloning.
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
• Help developers writing database triggers, packages, procedures, functions, utilities for application development.
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Upgraded Oracle E-Business Suite 11.5.10 to 11.5.10.2, 11.5.10.2 and database 9.2.0.8 to 10g
• Configuration of Workflow Notification Mailer, OAM, OEM10g.
• Oracle Applications Systems Administration. RMAN used in scheduled recovery, hot and cold backup of Oracle10G database.
• Installed and configured Single-Sign-On (SSO) and Implemented SSL Security.
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigned to users.
• Planning and Administration of backup and recovery strategies.
• Oracle Data Guard Implementation for High Availability and remote Disaster Recovery (DR) site.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Performance tuning of Oracle Database, applications and queries.

Environment: Red Hat Linux 4/5, SUN Solaris 9, HP-UX 11i v1 (B.11.11), Windows XP, Oracle 8i (8.1.7), 9i (9.2.0) & 10g (10.2.0), Oracle Applications EBS 11i/R12, Oracle 9i & 10g RAC, TOAD, Developer 6i.

Confidential, Fallon, MO

Oracle DBA

Description:

• MasterCard is a technology company and payments industry leader. For more than four decades, we have been a driving force at the heart of commerce, making the global economy safer, more efficient, more inclusive and more transparent for all. Consumers, merchants, business partners and governments in markets around the world have reaped the benefits of our innovative products and solutions which, simply put, are designed to make life easier
• Responsibilities:
• Successfully upgraded Oracle Applications Database from 10.2.0.2 to 10.2.0.4
• Worked closely with technical, functional teams and Oracle Support to troubleshoot and resolve issues during upgrade.
• Performed maintenance tasks like Purging Concurrent manager log files, Gather schema statistics, Purging Workflow Obsolete Runtime Data.
• 24*7 on-call production support handling weekday, weekend, nighttime, and holiday outages with focused effort to minimize downtime.
• System Administration responsibilities include application security, scheduling work shifts, registering new concurrent programs / request Sets.
• Researched and resolved JInitiator performance issues and suggested migration to Sun JDK.
• Critical patch update/oracle support (TAR)/ application patching activity/Application bug fix as suggested by oracle support.
• Work on Data Masking and subsetting can be performed on a cloned copy of the original data, eliminating any overhead on production systems
• Upgraded JInitiator and other technology stack components in development environment.
• Performance Monitoring, Space Monitoring / Capacity planning, concurrent manager tuning.
• Configured Workflow Notification Mailer for inbound and outbound processing
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Responding to different types of alerts automation using oracle alerts.
• Applied Oracle Projects Maintenance pack to Development environments.
• Worked with technical, functional teams and Oracle Support to troubleshoot and resolve issues.
• Researched and documented available options to create a DB Link between oracle and SQL Development databases to rewrite the existing interface.
• Created and implemented Oracle database backup and recovery strategies using RMAN.
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN PLAN, optimizer hints and SQL tuning advisor.

Environment: Unix/Linux, HP-UX and AIX,, Oracle 10g and 9i, Oracle RAC, Oracle Streams, TOAD, Enterprise Manager, EXPLAIN PLAN, TKPROF, SQL Trace, Query Analyzer, Oracle Fail Safe, AD Utilities.

Confidential

Junior Oracle DBA

Responsibilities:

• Installation, Implementation and maintenance of Oracle databases.
• Create the users, roles, schemas with suitable permissions
• Creating and managing the database objects such as tables, indexes and views
• Creating and managing the database storage structures which include index table spaces, rollback table spaces and rollback segments
• Cloning using Rapid clone, Auto config and adclone utility.
• Pre-patch or Impact analysis for the patches and document preparation with pre and post patch installation steps.
• Experience in Writing shell scripts, SQL scripts and implementing auto manageable scripts.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Wrote custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
• Monitoring specific user requested sessions.Gathering statistics for the database on a regular basis.
• Database backup Includes daily, weekly and monthly.
• User management and cloning several instances for UAT and testing and development purposes from the Production database.
• Supporting and troubleshooting the pre and post implementation of several projects from database point of view.Automating the process of monitor using cron jobs and shell scripts
• Assisted DBA in writing statements in Oracle SQL & PL/SQL.

Environment: Unix/Linux, HP-UX and AIX,, Oracle 10g and 9i, Oracle RAC, Oracle Streams, TOAD, Enterprise Manager, EXPLAIN PLAN, TKPROF, SQL Trace, Query Analyzer, Oracle Fail Safe