Educational Qualification:

           §  Bachelor of Engineering (Computer-Science & Engineering) 2004-2008 under Anna University, Chennai, INDIA.

 Certification:

§  Oracle Certified Professional (OCP) from Oracle Corporation.

  Work Experience: 

Wipro Technologies, Bangalore – India.

September 2017 – Till Date

Client: Williams, USA.                                                   November 2018 – till date

Technical Lead

 Responsibilities

·         Providing 24/7 on Call support for mission critical applications.

·         Leading Oracle / SQL team’s [Onshore & Offshore] for 11/5, and work’s directly with customer as an individual contributor for future project’s, requirement, & deployments.

·         Helping team to complete tasks successfully and on-time and resolved obstacles encountered by team members.

·         Preparing technical documents &presentations/ participating in review meetings withstakeholders.

·         Upgrading existing Oracle 10g, 11g,12c databases to Oracle 18c based on Application compatibility.

·         Lead’s team to apply PSU / CPU patch’s on every quarter for PROD, DEV, QA, TEST environment’s.

·         Responsible for Oracle Vulnerabilities&Compliance.

·         Working directly with customer for modernization program [ Automation].

·         Lead’s Bi-weekly meeting with Customer, application, development teams for near future deployments and requirements.

·         Experience in troubleshooting / decision making knowledge on mission critical issues.

·         Driven deep dive analysis on Performance related issues.

·         Work with the application development team to define the application data model and work on tuning and optimizing database related operation.

·         Successfully completed disaster recovery DR-drills to ensure database availability.

·         Documented & presented RCA for Database related P1/P2.

Client: Royal Bank of Scotland, U.K                                         September 2017 – October 2018.

Technical Lead  

Responsibilities 

·         Responsible for migrating Database’s from One database centre to Another.

·         Performed SAN sideways &Lift / Shift Migration.

·         Migrated Database’s version [ 9i/10g/11g] like Standalone / RAC / VCS Clusters [Migrated Oracle high availability database’s RAC [SAN / L&S] migrations with IP Change.

·         Worked with application team post data centre migration, fixing issue’s based on application needs.

·         Closely worked with Customer DBA’S for Virtualisation of Oracle Instance’s.

·         Performed database migration on Cloud [ Google / AWS] as part of database modernization.

DXC Technologies [Formally Hewlett Packard Enterprise], Bangalore, INDIA

August 2014 – August 2017

Client’s: Luxottica, Italy / Avon, Brazil /Mondelez, USA.

SVC-ITO Service Delivery [ Oracle DBA]

Responsibilities

·         Management of 1100+ database with sizes ranging from 20GB to 20TB and a mix of single instance/RAC Environments.

·         Provided 24*7 / On-call support.

·         Worked with differentcustomer / different domain / different process / different environment / different ticking system at time [ i.e., Shared resource]

·         Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export). Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Manager).

·         Maintained DATA GUARD to provide high availability by implementing physical stand-by database, snapshot-standby, 11g Grid Control and Automatic Storage Management (ASM).

·         Experience on Non RAC to RAC database environments.

·         Worked with customer for different RAC related issue: [ hang check timer, split brain, RAC recovery, ASM, OCR corruptions, voting loss & so on]

·         Performed proactive database maintenance procedures to ensure optimal performance and uptime and implemented shell scripts for automation of day to day activities. Used AWR and ASH reports to prevent downtime and slowness and worked closely with the system operations team on database deployment processes and database capacity planning.

·         Ensures timeliness and accuracy of data sync during co-existence with legacy systems.

·         Provides support on to application team on database related matters (e.g. data patching, application deployments, extracting data from database for reporting)

·         Work with the application development team to define the application data model and work on tuning and optimizing database related operation.

·         Configured Stream’s & Golden gate as per customer requirements.

·         Setup Oracle Enterprise Manager (OEM) 12c.

·         Hands on experience in on demand refreshes’ [ Schema / Table].

·         Performed monthly and annual performance reports for trend analysis and capacity planning.

·         Have hands on experience in DR activities

·         Have Experience on software development life cycle methodologies

·         Experienced & learned writing UNIX/SHELL scripts for providing the reports.

·         Ensuring Oracle database is hardening in accordance to company's standards.

·         As a lead, tracked team members, preparing schedule metrics, supporting team in decision making, team meetings, skate holders meetings, performance discussion, management decision, culture change in organization etc.

 Infosys, Limited

January 2013 – July 2014

 Client’s: NORDSTROM, USA.

Technology Analyst

Responsibilities

 §  Supported large number of Production and Development Databases

§  Supported 500+ Odd Database’s [ Stand Alone & Data Guard].

§  Installing Oracle software, applying database patches, patch sets, and maintain database security, policies periodically.

§  Periodic database refreshes from PROD to QA & DEV databases with RMAN and Data Pump.

§  Evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.

§  Created Oracle Data Guard 10g and 11g standby databases, and participated in DR fail-overexercises for various regions.

§  Setting up and maintaining user accounts and profile.

§  Monitoring mount points, Database/tablespace/tables growth and taking necessary capacityplanning steps.

§  Communicating / supporting various teams like Applications support team, development team and system admin team.

§  Experienced in trouble shooting Golden Gate replications on both Prod / Non-Prod DB

§  Experienced in Performance Tuning.

Cambridge Technology Enterprise [ Formally Q-Soft Systems & Solution’s]

Jun 2010 – Jan 2013

Clients: Airport Authority of India, Vatech Wabag, ING Vysya Bank, Ashok Leyland, K.C.P Sugars, P.S.G Hospitals, GE Health Care, Vodafone

Consultant & Infrastructure Engineer [ Remote]

Responsibilities

§  Regular Monitoring of database and troubleshooting the errors.

§  Responsible for ensuring availability and performance of all Production and Development Oracle databases.

§  Provided database expertise in the design, implementation and integrations of multi-tieredapplications residing on relational database management systems (RDBMS).

§  Carried out multi databases DR DRILL in parallel at a same time as per RBI rule [ For Banking Clients].

§  Setting up and maintaining user accounts and profile.

§  Escalated & Involved Severity 1 and Severity 2 highpriority issues and resolving it in time

§  Experience in Space Management on all Environments.

§  Month end activities and purging activities.

• Excellent in the use of the import and Data Pump utilities to load data and performing database migrations

§  Database software installation, patch and upgrade to development, test and production servers

§  Provided all kinds of DBA support to development teams as well as production support to various applications.