Resume

Sign in

Data Oracle

Location:
Mumbai, Maharashtra, India
Posted:
February 01, 2018

Contact this candidate

Resume:

MALESH L. GUMMULA

Contact: +91-963******* E-Mail: ac4arx@r.postjobfree.com

Visa: H1B

EXECUTIVE SUMMARY:

Malesh has 17 years of rich professional experience on Oracle technologies and specialized in Oracle Database administration areas. Malesh has played key management roles in SAP (Success factors), State Street Corp and IBM India Ltd.

Malesh has graduated with Bachelor of Science in Information Technology. In his recent stint with SAP (Success factors), Malesh 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. Malesh 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 17+ 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.

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 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.

Dexterously 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, IBM 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)

Virtualization Software : 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 : Clear Case, VSS (Microsoft Visual Source Safe), WinCVS.

Third Party Tools : 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 : IBM eServer pSeries, IBM 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, IBM-GDF.

PROFESSIONAL EXPERIENCE

Client: LRN. 09-Mar-2017 – Present

Consultant Oracle DBA

Managing LRN Database (minimum 20 instances, 5 are production, largest instance least 500 gigabyte in size)

Installation and managing enterprise databases with RAC, Data Guard, ASM for high availability and scalability.

Successfully upgraded/migrated the databases from 10g/11gR2.

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 adding Tablespaces, data files, monitoring space growth

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: 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, Materialized views, Nagios, Shell Scripting, Solaris, Linux, UNIX.

Client: Wizard Tech Solutions Inc., Piscataway, NJ 06-Jun-2016 – 30-Sep-2016

Consultant Oracle DBA

Responsibilities:

Working on Life cycle Project of Wizard tech 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)

At Rolta

Client: SAP – Success Factors (Cloud Database Services) 04th Aug 2014 – 22nd Mar 2016

Technical Service Delivery Manager – 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 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.

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.

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 GG 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 (GG),

EM Grid Control, Solar Winds, Shell Scripting, Solaris, Linux, UNIX.

At Ericsson

Client: Cricket Wireless 23rd Jan 2014 – 25th Jul 2014

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

Responsibilities:

Transitioning the new clients support like Cricket Wireless to Ericsson 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 Ericsson 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 (GG), EM Grid Control, Solar Winds, Shell Scripting, Solaris, Linux, Unix.

At State Street Corp & IBM

Client: State Street Corporation 22nd Nov 2010 – 06th Sep 2013

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 GG 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 IBM.

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 (GG), Cloakware, EM Grid Control, Shell Scripting, SME, Solaris, Linux, Unix.

At IBM

Client: Telstra Database Support-Australia 19th Aug 2009 – 19th Nov 2010

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 IBM 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 IBM.

Distinctively followed the IBM 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.

At Patni Computer Systems Ltd

Client: MetLife (NYC, NY) 18th Dec 2008 – 07th Aug 2009

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 MetLife 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, IBM AIX 4.3-5.1,Solaris,Red hat, Veritas.

At Polaris Software Labs Limited

Client: CitiBank NY-US (Global Wealth Management), Deutsche Bank, NRI-Japan Feb 2007 –Dec 2008

Team Lead – Oracle DBA

Responsibilities:

Handled multiple databases for Citibank 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 Citibank 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 Polaris for the clients Deutsche Bank and Citibank.

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, IBM AIX 4.3-5.1,Solaris,Red hat and Veritas

At Patni Computer Systems Ltd

Client: GE-NBC-Universal Studios (NYC, NY) 1st Oct 04 – 15th Dec 2006

Shift Lead DBA / Senior Software Engineer

Responsibilities:

Working as a shift lead, supporting the NBC (News Broadcasting Channel) and Universal Studios as Production DBA on behalf of GE (General Electric) for multiple location New York, Los Angeles and UK, Universal Studio is in Entertainment Business and their TV shows tops the rating in United Stated. There are approx. 300+ databases and availability of these databases for 24 x 7 is highly critical to their business.

Installation & Creation of Oracle Database Server with ASM, Real application Cluster (RAC) on Linux.

Monitoring and database health checks

Backup and recovery using Hot/Cold, exp/imp, RMAN, SQL-Back Track, CommVault Galaxy Backup & Recovery.

Applying Security Patches and Patch set Upgradation for Dev/QA/Test/Prod.

Unix Shell Scripting for automating the tasks.

Monitoring and coordinating Database Application Outage activities

Setting up the monitors for the databases using third party tools like BMC-Patrol, Site scope and Insight.

Setting DR servers – Physical Standby Databases/Data guard and Maintenance.

Scaling down the response time of queries below the targets set (as per Organizational standards)

Giving Support to various applications such as SAP Databases, People soft, JD Edwards Enterprise One ERPs and other internal application.

Involved in Transition from offshore for NBCUI.

Mentoring other team members.

Member of Technical Interview panel.

Environment: 7.x/8i/9i/10g RAC, RMAN, Standby Databases, Performance tuning, Auditing, PSU/CPU Patching, Upgradation, Database Cloning, Critical DB Recoveries, HP-UX 11&11i, IBM AIX 4.3-5.1,Solaris and Redhat, Veritas.

At Clover Technologies Pvt Ltd

Client: Orange Hutchison Max (Telecom) + Sapient - RS-Holding (Insurent) 27th Sep 2003 – 12th Sep 2004

Consultant Oracle DBA

Responsibilities:

Managed billing and non-billing databases with Data centre of Orange Hutchison Max (Telecom) as Production DBA.



Contact this candidate