OBJECTIVE:

To execute professionally challenging assignment as Oracle Database Administrator that would provide me scope to utilize core strength in RAC and/or Golden Gateandprovide opportunity to enhance my knowledge &skills in Oracle Database infrastructure management.

SUMMARY:

• Oracle Certified Expert with around 10 years of hands - on experience as Oracle Database Administratorand specialization in RAC/ASM& Golden Gate.
• Excellent experience in setting up complete Database environment with security implementations in Oracle Database (11g/10g/9i/8i).
• Installed and configured Oracle 12c Enterprise Management Cloud.
• Strong experience as L3/L4 DBA supporting 24x7 Production environment on VLDB
• Reviewed, recommended and implemented Golden Gate configuration for Java Message Service (JMS) on WebLogic 10.3.6 (11g R1)
• Excellent experience in OLTP environment
• Experience in Leading, Mentoring and managing teams throughout the Build phase.
• Co-ordination with multiple stake holders & LOB’s on the requirement gathering.
• Performed Critical COB drills as a part of regulatory norms.

SIGNIFICANT STRENGHTS:

• Good presentation and communication skills to provide support to the customer/Client.
• Ability to work flexibly as team member/team leader.
• Dedications with an inner drive to succeed and accomplish goals.
• Ability to perfectly plan and execute the given job to perfection.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• 10+ years experience as an OracleRACdatabase Administrator on UNIX/Windows operating systems with a track record in performance and troubleshooting of RAC Databases.
• Extensively worked on Oracle 11g, 10g, 9i RAC, 10g Streams, AIX/Sun/Linux UNIX systems administration, Shell programming, ASM, OEM Grid Control, RMAN, DataGuard Standby Database, Designing Database, Database Tuning, Database Security, Oracle Designer, Assigning the Roles, Profiles and Privileges to the Various Users on Objects, and Optimization by Explain Plan and Rollback Segment and SQL TRACE facility, Maintaining HOT and COLD BACKUP and RECOVERY.
• Supported 24/7 Production databases of 1 TB to 33+ TBRAC databases and responsible for round-the-clock database operations.
• Installed and configured OEM Grid Control across 100+ production and development environments from scratch.
• Installed and configured 150+ RAC servers and 100 + DataGuard setups.
• Participated in planning and moving servers and Oracle RAC databases across data centers.
• Ensuring High Availability for applications and Database.
• Solution designing for deploying Multiple Oracle RAC databases.
• Extensively worked on latest security patches CPU/PSU across all the oracle environments including RAC and Standalone database servers.
• Excellent experience in installing and managing RAC (Real Application Clusters) Oracle 10g/11g on Linux, AIX.
• Upgraded 33TB RAC 4-node cluster data warehousing database from 11.2.0.3 to 11.2.0.4.
• Change of Physical, Virtual, SCAN and DNS IPs in Oracle 11g RAC environments.
• Configuring TAF on Oracle 11g RAC for applications using adhoc JDBC connectivity methods.
• Implementation of Maximum Availability/High Availability Architecture (MAA/HA) by setting up RAC standby DataGuard for RAC primary database.
• Gathering customer requirements and translating them into physical and logical structures.
• Identifying the needs for Hardware improvements in to the customer requirements
• Transferring the customer requirements development team.
• Laying down the design possibilities for implementation and identifying the best one.
• Keeping the product life cycle active making sure we are on the latest versions and/or technologies meeting the industry standards.

GOLDEN GATE DBA

Confidential

Responsibilities:

• Golden Gate installation, configuration and troubleshooting various GG issues.
• Proficient in Oracle GoldenGate installation, upgrade, setup, monitoring, performance tuning, and troubleshooting.
• Environment and Database preparation for GoldenGate installation and setup.
• Experience with oracle GoldenGate replication setup in various modes like: unidirectional (for query offloading), Bidirectional (for Standby DB or Active-Active for HA), broadcast distribution and data integration.
• Initial load - direct load, direct bulk load, file to replicate, file to database utility; avoiding and handling Collisions during initial load
• Configure and build Golden Gate Extracts/Replicate for multiple databases
• Data selection, filtering, transformation and column mapping, and Built-in functions in GoldenGate.
• Commit change number (CSN), checkpoint file and checkpoint table.
• Macros, User Tokens, Event Marker System.
• Configuration options: BATCHSQL, compression, Compression of trail files, network communication, and passwords, ENCKEYS file, Command security: CMDSEC, Handling TCP/IP Errors - TCPERRS file
• Bi-direction configuration: Preventing Data Looping, Conflict Avoidance and Detection & resolution
• GoldenGate performance tuning and troubleshooting production issues.
• Experience with various GoldenGate tools/utilities like logdump, defgen, Reverse, convchk etc.
• Implementing necessary monitoring scripts for Golden Gate in Unix Shell/Perl scripting.
• Configuring GG-VIP for GoldenGate manager failover as part of node crash for GG High availability.
• Oracle DBA activities include but not limited to Installation, configuration, importing/exporting, migration, upgradation, patch installs capacity planning, DBMS SCHEDULER, DBMS JOBS, backup and recovery of mission critical databases and data files using command line syntax as well as Oracle RMAN, and Performance Tuning of databases.
• Administered Oracle databases using Oracle Enterprise Manager (OEM), Toad, and SQL Navigator.
• Configuration and maintaining Oracle Physical Standby databases.
• Configured Oracle 11g Active Data Guard and offloaded resource-intensive reporting jobs from DSS production database to standby database.
• Troubleshoot day-to-day problems encountered on production as well as development database environments.
• Conducted Performance Review of Oracle Database for business critical applications.
• Generated AWR/ADDMR reports from Oracle 10g/11g database and analyzed the reports for Oracle wait events, time consuming SQL queries.
• Tuning memory related issues like undersized SGA/PGA by using different memory target advisor.
• Involved in SQL Query tuning and provided tuning recommendations to time/CPU consuming queries and contention related issues lie locks/latches. Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
• Completed minimized the space related errors in Oracle Databases by conducting monthly review with Senior Management and addresses the space issues proactively.
• Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table re-org, add enough spaces to database
• Extended the boundaries of Large OLTP database performance through the application of optimized statistics gathering as well as advanced concepts such as Stored Outlines and Plan Stability Fully conversant with Oracle security features.
• Configuring of fast application failover for applications to comply with the Data Guard switchover.
• Project planning and execution for Oracle Databases in to the best practices of Oracle.
• Taking successful backup of Archive log files.
• Successful switchover of standby to production in case of crash.
• Verify that the primary database logs are being applied to the standby database.
• Configuration of Data guard.
• Deployment of latest security patches CPU/PSU across all the oracle environments.
• Configuration and maintaining Oracle Physical Standby databases and Snapshot standby database.
• Excellent knowledge of backup & recovery procedures including RMAN
• Quarterly Backup and Recovery testing to make sure that we will meet the recovery SLAs.
• Implemented RMAN Backups, Creation of catalog database.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Performed full and incremental backups using RMAN.
• Taking and verifying successful backup completion (Cold/Hot/RMAN) and Recoveries in various situation when DB crashing/corrupting files by RMAN.
• Backup and Recoveries using Recovery Manager (RMAN) and Flash-Back Recovery.
• Refresh database (Cloning) using RMAN.
• Basic UNIX administration, Shell, Perl scripting.
• Database Vault set up and HSM configuration.
• Analyze corruption issues & fix the data inconsistency issues.

Confidential, Warren, NJ

Lead Oracle Database Administrator

Responsibilities:

• Level 3-4 Support for clients to maintain and manage over 25 oracle databases with total size more than 33 TB.
• Installed and configured 2-node and 4- node 11g RAC on Linux/AIX platform
• Trouble shooting of Various RAC issues including node eviction, HAIP configuration, OCR, Voting disk recoveries.
• Implemented DR by creating NON-RAC and RAC Standby Data Guard for RAC Physical database and maintenance of DR databases, troubleshooting of various DG issues.
• Leading the COB drills as a part of Year end activities which includes conversion of physical standby database to SNAPSHOT standby database. Switchover activities.
• Golden Gate installation, configuration and troubleshooting various GG issues.
• Oracle Golden Gate installation, upgrade, setup, monitoring, performance tuning, and troubleshooting.
• Installed and configured Oracle 12c Container & Pluggable databases.
• Performed Oracle cluster up-gradation from Oracle 11gR2 to 12cR1.
• Performed database conversion from Non-CDB to PDB database.
• Environment and Database preparation for Golden Gate installation and setup.
• Experience with oracle Golden Gate replication setup in various modes like: unidirectional (for query offloading), Bidirectional (for Standby DB or Active-Active for HA), broadcast distribution and data integration.
• Initial load - direct load, direct bulk load, file to Replicate, file to database utility; avoiding and handling Collisions during initial load
• Configure and build GoldenGateExtracts/replicate for multiple databases
• Data selection, filtering, transformation and column mapping, and Built-in functions in Golden Gate.
• Conducted Performance Review of Oracle Database for business critical applications.
• Generated AWR/ADDMR reports from Oracle 10g/11g database and analyzed the reports for Oracle wait events, time consuming SQL queries.
• Tuning memory related issues like undersized SGA/PGA by using different memory target advisor.
• Involved in SQL Query tuning and provided tuning recommendations to time/CPU consuming queries and contention related issues lie locks/latches.Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
• Completed minimized the space related errors in Oracle Databases by conducting monthly review with Senior Management and addresses the space issues proactively.
• Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database.
• Commit change number (CSN), checkpoint file and checkpoint table.
• Macros, User Tokens, Event Marker System.
• Configuration options: BATCHSQL, compression, Compression of trail files, network communication, and passwords, ENCKEYS file, Command security: CMDSEC, Handling TCP/IP Errors - TCPERRS file
• Bi-direction configuration: Preventing Data Looping, Conflict Avoidance and Detection & resolution
• Golden Gate performance tuning and troubleshooting production issues.
• Used various Golden Gate tools/utilities like logdump, defgen, Reverse, convchk etc.
• Implementing necessary monitoring scripts for Golden gate in Unix Shell/Perl scripting.
• Using log miner utilities to analyze corruption issues.
• Using logdump utility to read the trail files and fix the data inconsistency issues.
• Golden Gate installation, Configuration of Bi-Directional and Unidirectional processes for ACTIVE-ACTIVE, Active-Passive environments and troubleshooting various issues.
• Designed and implemented RMAN backup policies with automation
• Migrated databases from ASM to NON-ASM and NON-ASM to ASM using RMAN.
• Migration of databases from standalone to RAC.
• Created and upgraded 10g/11g databases, enabled monitoring, registered databases with RMAN, updated corporatetnsnames following Organization standards.
• Implemented PSU/CPU patches on quarterly basis following organization security standards.
• Created Disaster Recovery Documentation and participated in yearly exercise.
• DB server power cycle and space management by defragmentation, index rebuilding, table reorganization etc.
• Maintenance of ASM instance, Creating Disk groups, Configuration ACFS file system and checking disk header,asm rules files(udev rules) before adding/creating disk groups to avoid storage issues.
• Optimized memory parameters, Cursors, Processes .etcinit parameters to improve the database performance.
• Using log miner utilities to analyze corruption issues; usinglogdump utility to read the trail files and fix the data inconsistency issues.
• Using Flashback queries to restore database to SCN, TIME or SAVE Point.
• Troubleshoot performance issues by identifying bottle necks, wait eventsgenerating AWR reports.
• Downloaded latest opatchavailable from metalink and applied, rollback, and resolved patch conflicts using Opatch
• Created scripts to manage archive log destination by deleting the already backed up/ ftpiedarchived logs.
• Created Change Requests, Service Requests and Incidents to strictly follow Organization standards for implementing any changes.
• Immediately responding to incidents as they arise, providing 24x7 support also worked in various shifts.
• Active participation in client meetings.

Environment: Oracle 11g/10g, RAC 11g/10g, ASM, RMAN, OEM 11g, OEM10g, Data Pump, Golden Gate, AIX, RHEL

Confidential, Jersey City, NJ

Sr. Oracle RAC DBA

Responsibilities:

• Oracle 11g/10g installation, cloning, migration of OLTP databases adhering the standards.
• Central point-of-contact for DBA architecture needs across the organization to ensure databases and systems are adequately built, tested and ready for production.
• Oracle ASM Installation, configuration and administration
• Participated in planning and moving servers and Oracle RAC databases across data centers.
• Extensively worked on latest security patches CPU/PSU across all the oracle environments including RAC and Standalone database servers.
• Excellent experience in installing and managing RAC (Real Application Clusters) Oracle 10g/11g on Linux, AIX.
• Environment and Database preparation for Golden Gate installation and setup.
• Experience with oracle Golden Gate replication setup in various modes like: unidirectional (for query offloading), Bidirectional (for Standby DB or Active-Active for HA), broadcast distribution and data integration.
• Initial load - direct load, direct bulk load, file to Replicate, file to database utility; avoiding and handling Collisions during initial load
• Configure and build GoldenGate Extracts/replicate for multiple databases
• Data selection, filtering, transformation and column mapping, and Built-in functions in Golden Gate.
• Conducted Performance Review of Oracle Database for business critical applications.
• Generated AWR/ADDMR reports from Oracle 10g/11g database and analyzed the reports for Oracle wait events, time consuming SQL queries.
• Tuning memory related issues like undersized SGA/PGA by using different memory target advisor.
• Involved in SQL Query tuning and provided tuning recommendations to time/CPU consuming queries and contention related issues lie locks/latches.Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
• Completed minimized the space related errors in Oracle Databases by conducting monthly review with Senior Management and addresses the space issues proactively.
• Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database
• Installed and configured Oracle 12c Container & Pluggable databases.
• Performed Oracle cluster up-gradation from Oracle 11gR2 to 12cR1.
• Performed database conversion from Non-CDB to PDB database.
• Solution designing for deploying Multiple Oracle RAC databases.
• Gathering customer requirements and translating them into physical and logical structures.
• Identifying the needs for Hardware improvements in to the customer requirements
• Transferring the customer requirements development team.
• Laying down the design possibilities for implementation and identifying the best one.
• Keeping the product life cycle active making sure we are on the latest versions and/or technologies meeting the industry standards.
• Ensuring High Availability for applications and Database.
• Change of Physical, Virtual, SCAN and DNS IPs in Oracle 11g RAC environments.
• Configuring TAF on Oracle 11g RAC for applications using adhoc JDBC connectivity methods.
• Implementation of Maximum Availability/High Availability Architecture (MAA/HA) by setting up RAC standby DataGuard for RAC primary database.
• Oracle Data Guard configuration and administration in physical standby environment
• Perform RMAN backups and create and test recovery and fail over strategies.
• Analyze incidents, Change records completed by DBA’s and make sure all changes, resolutions were done according to the company standards with proper updates by doing root cause analysis.
• Optimized database accessibility by developing load balancing architectures and created procedures to eliminate down time for migration, backup and patching activities.
• Coordinating with different LOBs which are part of JPMC as a part of build provisioning.
• Each LOB consist its own process during the build phase, which requires lot of coordination activities to accomplish the build activity.
• Proficient in Leading, Mentoring and managing teams throughout the Build phase.
• Proficient in stake holder expectation management, Scheduling, Prioritizing, Decision making, Problem solving, Time management, process improvement and Negotiation.
• Strong technical background and excellent interpersonal skills with an ability to interact with individuals at all levels.
• Extensively worked with various tools which are related to JPMC like AUTOSYS, BBDA, TAMS, ITPAMand ESM.
• Development support for Database Maintenance jobs, application issues and Database recoveries using Export/Import and RMAN backup.
• Configuration of ASM and Maintaining the ASM instance.
• Data Guard set up configuration and maintaining the primary and standby database sites.

Environment: Oracle 11g/10g, RAC 11g/10g, ASM, RMAN, OEM 11g/ 10g, Data Pump, AIX, RHEL

Confidential, Milwaukee, WI

Sr. Oracle DBA

Responsibilities:

• Installed and configured OEM Grid Control 12c single handedly and deployed agents across more than 30 production and development servers.
• Prepared and maintained customer, infrastructure, disaster recovery documentation and created DBA checklist for daily tasks.
• Migrated Oracle Databases to ASM using RMAN.
• Database Backup and Recovery operations ensuring 100% recoverability
• Provide Oracle DBA 24x7 support for multiple large databases in production, development and test environments for various types of databases - OLTP.
• Coordinated with Infrastructure and storage teams to resolve performance issues and to improve system response and run times
• Conducted Performance Review of Oracle Database for business critical applications.
• Generated AWR/ADDMR reports from Oracle 10g/11g database and analyzed the reports for Oracle wait events, time consuming SQL queries.
• Tuning memory related issues like undersized SGA/PGA by using different memory target advisor.
• Environment and Database preparation for Golden Gate installation and setup.
• Experience with oracle Golden Gate replication setup in various modes like: unidirectional (for query offloading), Bidirectional (for Standby DB or Active-Active for HA), broadcast distribution and data integration.
• Initial load - direct load, direct bulk load, file to Replicate, file to database utility; avoiding and handling Collisions during initial load
• Configure and build GoldenGateExtracts/replicate for multiple databases
• Data selection, filtering, transformation and column mapping, and Built-in functions in Golden Gate.
• Involved in SQL Query tuning and provided tuning recommendations to time/CPU consuming queries and contention related issues lie locks/latches.Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
• Completed minimized the space related errors in Oracle Databases by conducting monthly review with Senior Management and addresses the space issues proactively.
• Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database
• Installed and managed Real Application Clusters (RAC)10g and 11g.
• Created shell scripts and automated daily activities like RMAN backups, Archive log maintenance, Password changes and alert log monitoring etc.
• Monitored and optimized performance of the database, plan for backup and recovery of the database and allocate system storage and plan future storage requirements

Environment: Oracle 11g/10g, RAC 11g/10g, RMAN, OEM 11g/ 10g, Data Pump, Grid Control,AIX, RHEL

Confidential, Atlanta, GA

Senior Oracle Database Engineer

Responsibilities:

• Performed Oracle database configuration, monitoring, performance tuning, and patch administration with two node RAC and ASM and Grid Control environment.
• Create and apply solutions for data privacy, data recovery, data maintenance, data integrity, and space management of the physical databases.
• Responsible for creating and managing Data guard instances, database installation, maintenance and administration for disaster recovery.
• Administered and monitored 10g grid control.
• Database tuning methodologies and monitoring techniques.
• Createdincremental RMAN backup scripts (Level 0, Level 1, archive log) and optimally scheduled RMAN backupsacross databases to relieve load on netbackup server.
• Experience required administering database including job scheduling (DBMS JOB), backup/restore (RMAN), data import/export (IMP/EXP), etc.
• Management of tablespaces such as dropping/creation and modification of storage parameters.
• Conducted Performance Review of Oracle Database for business critical applications.
• Generated AWR/ADDMR reports from Oracle 10g/11g database and analyzed the reports for Oracle wait events, time consuming SQL queries.
• Tuning memory related issues like undersized SGA/PGA by using different memory target advisor.
• Environment and Database preparation for Golden Gate installation and setup.
• Experience with oracle Golden Gate replication setup in various modes like: unidirectional (for query offloading), Bidirectional (for Standby DB or Active-Active for HA), broadcast distribution and data integration.
• Initial load - direct load, direct bulk load, file to Replicate, file to database utility; avoiding and handling Collisions during initial load
• Configure and build GoldenGateExtracts/replicate for multiple databases
• Data selection, filtering, transformation and column mapping, and Built-in functions in Golden Gate.
• Involved in SQL Query tuning and provided tuning recommendations to time/CPU consuming queries and contention related issues lie locks/latches.Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
• Completed minimized the space related errors in Oracle Databases by conducting monthly review with Senior Management and addresses the space issues proactively.
• Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database
• Installed Oracle 11gR2 RAC on IBM Power 7 AIX 6.1
• Benchmarked databases for performance for the 11g/10g/9i upgrades and created best plans to collect performance statistics to improve the response times.
• Generated and analyzed STATSPACK reports and created statistics jobs for database performance.
• Created the database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords (security).
• Communicating with Oracle support on different Technical Assistant Requests TARs and bugs related to Standard Oracle Applications Security

Environment: Oracle 11g/10g, RAC 11g/10g, ASM, RMAN, OEM 11g/ 10g, Data Pump, AIX, RHEL.

Confidential

Senior Software Engineer

Responsibilities:

• Working in Development/production environment when required for Oracle Databases.
• Development support for Database Maintenance jobs, application issues and Database recoveries using RMAN backup.
• Oracle installation, configuration and managing database security. Creating users, granting privileges to users and allocating space. Providing technical support to the application team.
• Managing datafiles, control files, online redo log files and tablespace. Performing export/import utility for logical backup and created schemas in databases.
• Oracle 10g Architectural Components, Managing Redo log file, Managing Users, Managing Privileges, Managing Roles.
• Export import utility for logical backup, creating schemas in databases.
• Daily health check of cluster by using CRSCTL and SRVCTL commands.
• Configuring security features like VPD, HSM and Database Vault.
• Configuring FGA audit for the database and integrated FGA audit with RSA envision tool.
• Performed Oracle database configuration, monitoring, performance tuning, and patch administration with two node RAC and ASM and Grid Control environment.
• Create and apply solutions for data privacy, data recovery, data maintenance, data integrity, and space management of the physical databases.
• Responsible for creating and managing Data guard instances, database installation, maintenance and administration for disaster recovery.

Confidential

Oracle Database Administrator

Responsibilities:

• Working in Production environment with 24X7 Support when required for Oracle Databases.
• Production support for Database Maintenance jobs, application issues and Database recoveries using RMAN backup.
• Oracle installation, configuration and managing database security. Creating users, granting privileges to users and allocating space. Providing technical support to the application team.
• Managing datafiles, control files, online redo log files and tablespaces. Performing export/import utility for logical backup and created schemas in databases.
• Working with the Ticket Management tool (Intraweb portal, JIRA, Service desk) to manage tickets. Handle Change Management Tickets and Incident Management Tickets for all the production, development and testing databases.
• Oracle 10g Architectural Components, Creating Database manually, Managing Redo log file, Managing Users, Managing Privileges, Managing Roles.
• Export import utility for logical backup, creating schemas in databases.

Confidential

Jr Oracle DBA

Responsibilities:

• Performed basic L1 tasks
• Execution of scripts as per the development teams request and tickets raised by them.
• Creation of New Tickets, Constant Monitoring of VTs, Follow up of User and System VTs
• Creating users and assigning roles, profiles and privileges to them
• Allocating quota to the users as per the request in the ticket.
• Working on user account lock and unlocking scenarios based on the tickets we receive.
• Perform password resets.
• Monitoring error logs whenever there is some issues.
• Space management - Monitoring database level space using views, addition / resize of data files, creation of new table spaces etc, purging objects to reclaim space etc..
• Schema and Roles management - Creating / dropping database users, creation of roles, assigning roles and privileges to users, unlocking users based on the requirement, database profiles etc.