EXECUTIVE SUMMARY:

• Confidential has 18 years of rich professional experience on Oracle technologies and specialized in Oracle Database administration areas.
• Confidential has played key management roles in SAP (Success factors).
• Confidential has graduated with Bachelor of Science in Information Technology.
• In his recent stint with SAP (Success factors), Confidential has managed Multi - Million Dollar Project with customer facing role with end to end delivery, a Global Database Administration team as Technical Service Delivery Manager(SDM) for Cloud database support team and has led large Managed services engagement in India for various strategic customers.
• Confidential has specialized in remote database services and consulting, having varying experience on OLTP and Data Warehouse databases.
• Industry experience includes Banking and Financial Services, Insurance Telecommunication, Media and Entertainment Technology.
• Customer-centric with the ability to initiate profitable alliances with global vendors and suppliers.

PROFESSIONAL SUMMARY:

• Over 18+ years of experience as an Oracle DBA in Production and development environment and strong understanding of Oracle 12c/11gR2/10g/9i/8i/8.0/7.x on various flavours of Unix and NT/2000.
• Holding H1B US Visa.
• Successfully Migrated on Prim Datacentre DB’s/Server to AWS Cloud environment.
• Customer facing role with end to end delivery, accountable for managing SAP (Success Factors) Production Cloud Database Environment as Technical Solution Delivery Manager for Oracle DBA Team.
• Responsible for the delivery for Oracle Database support as single point of contact for all escalation or issues related to project and work across various Data centres.
• Managed/Monitored around 200+ DB’s across various Datacentre of Germany, US, Ashburn, Australia, China of various sizes from 1TB up to 40TB with INSIGHT DB monitoring system, Solar winds for monitoring performance and Jira ticketing tool.
• Managed all outstanding help desk tickets to ensure timely resolution and coordinate all technical activities regarding and covered databases.
• Primary contact for communication of any technical activities or problems, ensure the quality and timeliness of deliverables, and organize and conduct weekly status meetings with the client.
• Advise the client on any Hardware or Software issues that prevent from fulfilling the responsibilities.
• Participation in DB operational architectural review and Infrastructure upgrade reviews/evaluation on a monthly basis.
• Communicating with Client on the progress of various task items. Production Support Management, SLA tracking
• Review of Project documentation (e.g. solution design documents)
• Managing the Team of 12+ FTE’s Oracle DBA’s.
• Installation of Oracle 8i/9i/10g/11g/12c on UNIX/ VMware/Oracle Virtual Box & Windows NT and 2000.
• Expert with the technical aspects of DBA such as Installation (RAC /Non RAC), Data guard (DGMGRL), Upgradation, applying patches, Data-Pump, Import/Export, RMAN, SQL *Loader, Fine Grained Auditing (FGA), Database Auditing.
• Implemented Transparent Data Encryption (TDE), for personally identifiable information(PII) and sensitive information tables.
• Successfully Upgraded Oracle 11.2.0.3 Critical Production DB’s to latest Oracle 12c (12.2.0.1) across all the DB Servers.
• Successfully implemented Oracle 11.2.0.3 two node RAC, Installed Oracle 11.2.0.1 two node RAC on Sun Solaris10, Upgrade 10.2.0.4 to 11.2.0.3.
• Strong in Implementation of 11G Grid Control setup and Agent Installation using Pull Method for multiple targets on different platforms.
• Worked on RAC-GRID/Database Upgrades from 11.2.0.4 to 12.1.0.1 (12c) with Sun Solaris 10 Platform.
• Worked on Upgrades from Oracle 9i/10gR2 to 10gR2/11gR2. Applied Oracle Quarterly PSU / Critical Patches and version upgrades when needed for Linux, Sun and AIX OS.
• Managing RMAN Disk/Tape backups and ensuring the disk/tape backup being performed onto tape using NetBackup. Involved in restoring huge databases using RMAN.
• Worked on storage Migrations from NetApp to ASM storage on EMC using Physical standby cutover methods.
• Expert in Architecting and Implementing High Availability solution, designed and implementation of database and application disaster recovery (DR) plans using Physical standby database, 2 nodes RAC and SRDF storage technology.
• Expert in performing database refreshes (RMAN cloning) from Production to UAT, Test and DEV environments based on the requirements for testing and development.
• Performing export/import of databases, schema or tables. Loading the data into the tables using SQL* Loader or import.
• Setup and managed Oracle to Oracle Replication (Unidirectional Replication) for auditing and migrations, whereas Setup and managed Oracle to MS-SQL for (Unidirectional Replication) for Work Force Analytic (WFA) application.
• Performed/managed enterprise databases installation RAC, Data Guard, ASM on Linux, Sun OS.
• Worked on proactive and reactive Performance Tuning ADDM, AWR and ASH. Performing SQL tuning and advising the developers. Creating indexes on tables and revising the PL/SQL code helped to running faster.
• Database Sizing, Tablespace Management and Security Administration.
• User and security administration. Managing the roles and privileges, Encrypting/Decrypting data using DBMS CRYPTO, and Masking data at row level, column level using Virtual Private database (DBMS RLS.ADD POLICY)
• Conversant with the technical aspects of DBA such as Installation (RAC /Non RAC), Data guard (DGMGRL), Upgradation, applying patches, Data-Pump, Import/Export, RMAN, SQL *Loader, Fine Grained Auditing (FGA), Database Auditing
• Working knowledge of various Oracle access tools like Toad, SQL Navigator, Solar Winds, OEM-Grid Control, BMC-Patrol, SQL-Backtrack, Site-scope
• Having knowledge on shell scripts. Written and customized the shell/SQL scripts to monitor the database activity and also to automate the database tasks. File or data transfer using tools like SFTP, FTP and SCP.
• Exposure to Taking Backup using BCV/P (Split Mirror), Used SQL*Trace, Explain Plan for SQL tuning, AWR, Stats pack
• Strong experience on different flavours of UNIX like Linux, Sun Solaris, Confidential AIX, Window NT and Windows 2000.
• Proficient in design and development of Client/Server application using Oracle 7.x, 8.0,8i,9i,10g,11g/12c as Backend and Developer-2000 (Forms 5.0/6.0/6i, Reports 3.0 /6.0/6i) as front end
• Having excellent verbal and communication skills.
• Good Team Builder, worked with offshore team while managing them and written several technical SOP’s to guide the team.
• 24/7 on-call support for production support.

TECHNICAL SKILLS:

Operating Systems: Sun Solaris, Linux, HP-UX, AIX, Windows NT/2000

Database Management Systems: Oracle 12c,11g,10g,10g XE,9i,8i,7.x (7.3.3.0.0)

Cloud / Virtualization Software: AWS, VMware, Oracle Virtual Box

Programming Languages: UNIX Shell Programming, C, C++, Java, Access Programming

Fourth Generation Languages: Oracle D2K (Developer 2000) 5/6.0/6i, FoxPro.

Version Control Software: GitHub, Perforce, Clear Case, VSS (Microsoft Visual Source Safe), WinCVS.

Third Party Tools: Oracle SQL Developer tool, Erwin (Data Modelling), Solar Winds, Toad, OEM-Grid, BMC-Patrol, SQL-Backtrack, Site-scope, NetBackup 4.5/5.x, Tivoli.

Scheduling Tools: Control + M, Autosys

Ticketing System: BMC Remedy, Kintana, Virtual Tickets, Infoman, and Jira.

Hardware: Confidential eServer pSeries, Confidential RS/6000, HP 9000, Compaq, Sun E6500, Sun E4500, Sun E3500, Sun E450, Sun Ultra10, 5, 2, Sun Sparc, DLT and LTO Tape drives.

Others: Knowledge of Six Sigma, Lean, Confidential -GDF.

PROFESSIONAL EXPERIENCE:

Confidential

Consultant Oracle DBA

Responsibilities:

• Managing LRN Database (minimum 40 instances, 8 are production, largest instance least 1.5 Terabyte in size)
• Installation and managing enterprise databases with RAC, Data Guard, ASM for high availability and scalability.
• Successfully upgraded Database from 11.2.0.3 to 12c (12.2.0.1) for Single Instance databases.
• Successfully completed Migrating databases to AWS cloud using Physical standby Method cutover.
• Successfully applied, oracle quarterly released CPU/PSU Critical Patches and version upgrades when needed for Linux and SUN.
• Setup monitoring the DB Alerts in Nagios Monitoring tool.
• Provide Root Cause Analysis reports and the problem resolution recommendations for all Sev1/P1 issues.
• Involved in design and implementation of database and application disaster recovery (DR) and restoring using RMAN.
• Work with the team to automate Proactive/ Reactive procedures where possible, and to promote rapid response to known issues.
• Performed Performance Tuning, ADDM, AWR and ASH. Performing SQL tuning and advising the developers. Creating indexes on tables and revising the PL/SQL code helped to running faster.
• Database instance cloning, database to be copied/cloned must be restored to server with the appropriate database software already installed.
• Implemented Transparent Data Encryption (TDE), for personally identifiable information(PII) and sensitive information tables.
• Work with teams to promote Database changes to QA and production environments. Assist in definition/implementation of standards, policies and procedures.
• Implemented Materialized views replication and maintenance in separate DB instance to avoid performance issues due to heavy reporting queries.
• Ensure adequate capacity is available at all times to meet the requirements of the operations and business through capacity planning and management.
• Capacity planning: Involved in Tablespace space management, data files, monitoring space growth on filesystem
• Accountable for maintaining databases configurations in compliance with established ‘best practices’.
• Maintain sufficient documentation with key system configurations and operational procedures to meet all support needs and situations.
• Work with Oracle Supplied Packages Statspack/AWR etc.
• Define/ Implement RMAN Net Backup Solutions and backup solutions using Iron Mountain.
• SQL and PL/SQL scripting and Managing code of procedures, triggers and packages.
• Development, implementation and support of old/new database code.
• Database Security: Enabling security policies and providing reports to SOX auditors.

Environment: 12c, 11gR2 RAC, RMAN, Data guard, ASM, TDE, Performance tuning, Auditing, PSU/CPU Patching, Upgradation, Database Cloning, Flash Back Technology, Critical DB Recoveries, Data Migrations, Storage Migrations, Materialized views, Nagios, Shell Scripting, Solaris, Linux, UNIX.

Confidential, Piscataway, NJ

Consultant Oracle DBA

Responsibilities:

• Working on Life cycle Project of Confidential solution, managing database build’s for Dev/UAT/Prod Env.
• Providing build and release support for the project.
• Primary contact for communication of any technical activities or problems, ensure the quality and timeliness of deliverables, and organize and conduct weekly status meetings with the client.
• Successfully upgraded/migrated the databases from 11gR2 to 12c two node RAC Cluster.
• Co-ordinating tasks with sysdamin and Network teams.
• Co-ordinating tasks with Business and development team for production tasks.
• Production instance monitoring and maintenance.
• Cloning production instance to Test
• Migrating databases to new data centre.
• Managed database backups using RMAN.
• Troubleshoot SQL related performance issues and tuning the same.
• Applying PSU Patches and bug fix patches.
• Code Migration across the instances.
• Advise the client on any Hardware or Software issues that prevent from fulfilling the responsibilities.
• Participation in DB operational architectural review and Infrastructure upgrade reviews/evaluation on a monthly basis.
• Review of Project documentation (e.g. solution design documents)

Confidential

Sr. Oracle DBA

Responsibilities:

• Customer facing role with end to end delivery, accountable for managing SAP (Success Factors) Production Cloud Database Environment as Technical Solution Delivery Manager for Oracle DBA Team.
• Responsible for the delivery for Oracle Database support as single point of contact for all escalation or issues related to project and work across various Data centres.
• Managed/Monitored around 200+ DB’s across various Datacentre of Germany, US, Ashburn, Australia, China of various sizes from 1TB up to 40TB with INSIGHT DB monitoring system, Solar winds for monitoring performance and Jira ticketing tool.
• Managed all outstanding help desk tickets to ensure timely resolution and coordinate all technical activities regarding and covered databases.
• Primary contact for communication of any technical activities or problems, ensure the quality and timeliness of deliverables, and organize and conduct weekly status meetings with the client.
• Advise the client on any Hardware or Software issues that prevent from fulfilling the responsibilities.
• Participation in DB operational architectural review and Infrastructure upgrade reviews/evaluation on a monthly basis.
• Communicating with Client on the progress of various task items. Production Support Management, SLA tracking
• Performing database health checks, evaluating & troubleshooting Database performance and capacity related issues. Monitor, review and resolve database space management and capacity issues for all monitored environments.
• Monitor and review of instance and Session Level Configurations parameters that may impact recoverability, manageability, and performance.
• Installation and managing enterprise databases with RAC, Data Guard, ASM for high availability and scalability.
• Capacity planning: Involved in adding Tablespaces, data files, monitoring space growth, tuning of memory and CPU(cores)
• Successfully upgraded/migrated the databases from 9i/10g versions to 10g/11gR2.
• Successfully applied, oracle quarterly released CPU/PSU Critical Patches and version upgrades when needed for Linux and SUN.
• Database Security: Enabling security policies and providing reports to SOX auditors.
• Provide Root Cause Analysis reports and the problem resolution recommendations for all Sev1/P1 issues.
• Involved in design and implementation of database and application disaster recovery (DR) and restoring using RMAN.
• Developed and customized the shell/SQL scripts to monitor the database activity and also to automate the database tasks.
• Performed Performance Tuning, ADDM, AWR and ASH. Performing SQL tuning and advising the developers. Creating indexes on tables and revising the PL/SQL code helped to running faster.
• Recommendations for SQL statement tuning for SQL statements that are identified as impacting production performance.
• Management of production databases in Primary/standby database environment and ensuring high availability. Also worked on replication tools like Golden Gate.
• Setup and managed Confidential for Oracle to Oracle Replication (Unidirectional Replication) for auditing and migrations, whereas Setup and managed Oracle to MS-SQL for (Unidirectional Replication) for Work Force Analytics (WFA) application.
• Managing RMAN Tape backups and ensuring the tape backup being performed onto tape using NetBackup/DD Boost. Worked extensively in restoring and recovering huge business critical databases using RMAN.
• Successfully migrated the RMAN Backups from NetBackup to DD Boost Backup.
• Database or table sizing, Tablespace management, Rollback (Undo) and Temp tablespace management.
• Database instance cloning, database to be copied/cloned must be restored to server with the appropriate database software already installed.
• Monitor and review all errors and events found in the database logs, trace files, and event logs as per the monitoring tool.
• Review of Project documentation (e.g. solution design documents)
• Managing the Team of 12+ FTE’s Oracle DBA’s.
• Working as a DBA in 24/7 production database support environment.

Environment: 11gR2 RAC, RMAN, Data guard, ASM, Performance tuning, Auditing, PSU/CPU Patching, Upgradation, Database Cloning, Flash Back Technology, Critical DB Recoveries, Data Migrations, Storage Migrations, Golden Gate ( Confidential )EM Grid Control, Solar Winds, Shell Scripting, Solaris, Linux, UNIX.

Confidential

Sr. Oracle DBA - Senior Subject Matter Expert (SME)

Responsibilities:

• Transitioning the new clients support like Confidential to Confidential DBA Support.
• Performing database health checks, evaluating & troubleshooting Database performance and capacity related issues. Monitor, review and resolve database space management and capacity issues for all monitored environments.
• Monitor and review all errors and events found in the database logs, trace files, and event logs as per the monitoring tool for various sized DB’s from 500GB to 14TB.
• Implemented 11G Grid Control setup and Agent Installation using Pull Method for multiple targets on different platforms.
• Performed performance Tuning, ADDM, AWR and ASH. Performing SQL tuning and advising the developers. Creating indexes on tables and revising the PL/SQL code helped to running faster.
• Recommendations for SQL statement tuning for SQL statements that are identified as impacting production performance.
• Performing database refreshes (RMAN cloning) and replication from Production to Test/UAT for analysis, reporting, testing and development as per the request.
• Patches: Applying oracle patches on databases and version upgrades when needed for Sun and Linux OS.
• Managing RMAN backup and generate backup report from OEM and restore when required.
• Managing OEM Repository for Prod and Dev environment.
• Developed and customized the shell/SQL scripts to monitor the database activity and also to automate the database tasks.
• Interacting with the vendors - under critical situations for oracle technology.
• Installation and managing databases on RAC, Data Guard, ASM for high availability and scalability.
• Accountable for managing Confidential Production Database Environment as a Sr. Subject Matter Expert (SME) for Oracle DBA Team.
• Code review for any code deployment in Prod/UAT and Work with application for deploying the code in required environment.
• Provide Root Cause Analysis reports and the problem resolution recommendations for all Sev1/P1 issues.
• Worked as an Oracle DBA in 24/7 production database support environment.

Environment: 11gR2 RAC, RMAN, Data guard, ASM, Performance tuning, Auditing, PSU/CPU Patching, Upgradation, Database Cloning, Flash Back Technology, Critical DB Recoveries, Data Migrations, Storage Migrations, Golden Gate ( Confidential ), EM Grid Control, Solar Winds, Shell Scripting, Solaris, Linux, Unix.

Confidential

Sr. Oracle DBA - Technical Lead

Responsibilities:

• Performing day-to-day database monitoring, troubleshooting space and memory issues as per the OEM monitoring tool and customised shell scripts and resolved all the issues for the monitored environments of various sized DB’s from 30GB up to 18TB’s
• Installed Oracle 11.2.0.1 two node RAC on Sun Solaris10 using VERITAS SFRAC and CFS for database data files and migrated single instance to two Nodes 11g RAC
• Upgraded Oracle RAC 10.2.0.4 and 11.2.0.1 databases to 11.2.0.2 and 11.2.0.3 databases for Business Critical Applications.
• Setting up the new database Infrastructure of SSgA as per the new requirements of Life cycle projects.
• Successfully Deployed the Mass deployment of EM Agents Builds and automation of the same saving large amount of time for implementing the same
• Setup and managed Confidential for Oracle to Oracle unidirectional replication, whereas setup and managed Oracle to MS-SQL for (Unidirectional Replication).
• Automation of repeated complex tasks like Schema/Data Refreshes, database creation and Health Checks for the databases
• Supporting RCA for all SEV1, Change Failure for the Service Level / technology
• Setting and Automating the RMAN backups and Quarterly Testing Backups for critical Production databases
• Setting up DR Physical standby database/Data guard and managing the same.
• Documenting all the new processes implemented (Like EM agent build, 11gR2 upgrade, Streams setup, etc.).
• Applying CPU/PSU and One-off patch set.
• Upgrading 10.2.0.4 to 11.2.0.1 and 11.2.0.1 to 11.2.0.2 for Dev/UAT/Prod databases
• Manually database failover using VCS during planned downtime.
• Cloning Using RMAN, Converting single Instance database to RAC database Instances
• Creating / Reviewing the Run Book or Tech plan for any change to be implemented on Prod.
• Deep dive to resolve complex prod issues and perform the root cause analysis
• Interacting with the vendors - under critical situations for oracle technology, Working with Oracle Support for Critical Production issues and maintaining the log of number of bugs faced and patches applied
• Generating the SOX auditing related information to management.
• Implemented Oracle 11.2.0.3 two node RAC on Sun Solaris10 for Business Critical Applications using VERITAS SFRAC and CFS for database data files
• Implemented Oracle 11.2.0.1 Streams Bi-Directional replication setup, providing Update/Customs handlers for data conflicts
• Implemented 11G Grid Control setup and Agent Installation using Pull Method for multiple targets on different platforms
• Implemented Two nodes 10g RAC on Red Hat Linux with VMware on Windows and Oracle 11g Single instance Installation on Oracle Solaris with Oracle Virtual Box on Windows as POC.
• Ascertaining adherence to transition process and smooth transition of all Oracle related activities to Confidential .

Environment: 11gR2 RAC, RMAN, Data guard, ASM, Performance tuning, Auditing, PSU/CPU Patching, Upgradation, Database Cloning, Flash Back Technology, Critical DB Recoveries, Veritas, Data Migrations, Storage Migrations, SRDF, Golden Gate ( Confidential ), Cloakware, EM Grid Control, Shell Scripting, SME, Solaris, Linux, Unix.

Confidential

Sr. Oracle DBA - Team Leader

Responsibilities:

• Monitor/Resolve the issues assigned through BMC Remedy ticketing system.
• Managed/monitored around 500+ DB’s of various sizes from 5GB up to 17TB.
• Implemented Oracle 9i (9.2.0.8) RAC on Sun Solaris9 using VERITAS CFS for database data files for client TELSTRA the Largest Telecom service provider of Australia and migrated single instance to two Nodes RAC.
• Installed 9i/10g RAC and built databases for various requirements. Built over 12+ databases.
• Involved in design and implementation of disaster recovery (DR) and successfully setup the DR (Disaster Recovery) using Physical and Logical Standby DB’s as per the client requirement.
• Involved in setting up and testing the RMAN Backups for new Project builds.
• Used Tape backups for databases using NetBackup. Involved in restoring huge databases using RMAN and NetBackup.
• Performed QA for databases before the database go live.
• Involved in proactive and reactive Performance Tuning using ADDM, AWR and ASH. Performed SQL tuning and advised the developers.
• Developed and customized the shell/SQL scripts to monitor the database activity and also to automate the database tasks.
• Implement Oracle Critical Patches and version upgrades when needed for 8i/9i/10g DB’s on Sun, Linux.
• Successfully Deployed the Mass deployment of EM Agents Builds and automation of the same saving large amount of time for implementing the same.
• Registering the EM agent with Repository and Troubleshoot / fix EM agent related issues.
• Created / reviewed the Run Book or Tech plan for any change to be implemented on Prod.
• Work with the vendors - under critical situations for oracle technology, Working with Oracle Support for Critical Production issues and maintaining the log of number of bugs faced and patches applied
• Expertise in different flavours of UNIX like Confidential AIX, HP UNIX, Sun Solaris, Linux.
• Served as the Member of Technical Interview panel
• Technically managed Telstra Australian Telecom Project as Team Lead with 20+ member’s team of Oracle DBA with Confidential .
• Distinctively followed the Confidential GDF processes and made sure project is compliant with all GDF processes.

Environment: 8i/9i/10/11gR2 RAC, RMAN, Data guard, ASM, Performance tuning, Auditing, PSU/CPU Patching, Upgradation, Database Cloning, Flash Back Technology, Critical DB Recoveries, Data Migrations, Storage Migrations, EM Grid Control, Shell Scripting, Solaris, Linux, Unix.

Confidential, NYC, NY

Sr. Oracle DBA, Tech Lead, Senior Software Specialist

Responsibilities:

• Monitoring and fixing the issues ticket using Remedy for production activities.
• Monitoring and fixing the Alerts which send alerts to Mailbox/Mobile/cell using third party tool Alarm Point on Demand
• Setting DR/COB servers - Physical Stand by Databases (Data guard) and Maintenance
• Switch over and Switch back during any scheduled/unscheduled maintenance. Maintain the Data guard broker configurations (for any used environment). Maintain the standby database to ensure it is operational and being maintained.
• Scaling down the response time of queries below the targets set (as per Organizational standards)
• Involved in proactive and reactive Performance Tuning using ADDM, AWR and ASH. Performed SQL tuning and advised the developers.
• Code review for any code deployment in Prod/UAT and Work with application for deploying the code in required environment.
• Provide Root Cause Analysis reports and the problem resolution recommendations for all Sev1/P1 issues.
• Developed and customized the shell/SQL scripts to monitor the database activity and also to automate the database tasks.
• Designed and implemented the RMAN backup strategies as per client requirements and monitoring the same.
• Technically managed Confidential project as Tech Lead with 12 member’s team of Oracle DBA.

Environment: 8i/9i/10/11gR2 RAC, RMAN, Data guard, ASM, Performance tuning, Auditing, PSU/CPU Patching, Upgradation, Database Cloning, Flash Back Technology, Critical DB Recoveries, Data Migrations, Storage Migrations, EM Grid Control, Shell Scripting, HP-UX 11&11i, Confidential AIX 4.3-5.1,Solaris, Red hat, Veritas.

Confidential, NY

Team Lead - Oracle DBA

Responsibilities:

• Handled multiple databases for Confidential USA GWMDBA (Global Wealth Management) supporting various Applications like Business Intelligence, Single Sign On, Risk Reports, Project One, One Source, CARE, CCS, Info links, Plan View, Oreas etc.
• Implemented Oracle 10g RAC on HP-UX 11i with Service guard Ex-tension For RAC (SGeRAC) using SLVM VG (Shared Raw Logical Volume Manager) for Oracle RAC database data files for client NRI (Nomura Research Institute Limited) Japan
• Implemented Oracle 9i RAC on Sun Solaris10 with Veritas Storage Foundation for Oracle RAC 5.0 (SF RAC) using Veritas CFS for database data files for client Deutsche Bank.
• Implemented Single Instance Oracle 9i Data guard on Sun Solaris10 for 2 Node RAC for the client Deutsche Bank. Successfully performed Switchover and Failover
• Carried out the Offshorization of database activities by successfully transitioning Confidential USA GWMDBA - New York Project and setup infrastructure at offshore for supporting the activities
• Performed Backup and recovery using Hot/Cold backup, exp/imp, RMAN.
• Applying Security Patches and Patch set, upgradation for Dev/QA/Test/Prod
• Unix Shell Scripting for automating the tasks
• Setting DR/COB servers - Physical Stand by Databases (Data guard) and Maintenance
• Scaling down the response time of queries below the targets set (as per Organizational standards)
• Monitoring Tivoli Alerts, Ticket using VT (Virtual Ticketing system), Infoman and package release from change management team for production activities
• Setting up the databases to support multilingual languages
• Managed the team of Oracle DBA’s with Confidential for the clients Deutsche Bank and Confidential .
• Served as the member of Technical Interview panel

Environment: 9i/10g RAC, RMAN, Standby Databases, Performance tuning, Auditing, PSU/CPU Patching, Upgradation, Database Cloning, Critical DB Recoveries, HP-UX 11&11i, Confidential AIX 4.3-5.1,Solaris,Red hat and Veritas