Since Nov’11 with DXC Technology (Formerly Hewlett Packard Enterprise Ltd.), Bengaluru as Lead DBA

Key Result Areas:

·         Leading a team of 24 Database Administrators for building & managing Oracle databases and troubleshooting, debugging, evaluating, and resolving software issues in the organisation’s custom & internal end-user applications

·         Designing, administering & implementing appropriate AWS best practices; creating database and complete database management on AWS environment

·         Creating & maintaining users along with security roles and privileges

·         Delivering 24*7 on-call support for production databases

·         Ensuring day-to-day performance monitoring and tuning of database in 24*7 environments

·         Implementing new release in training and production environments

·         Performing proactive maintenance including monitoring alert logs to find and act on errors before an incident

·         Monitoring overall database health, performance and session locks

·         Working in large team environment and developing & supporting applications on offshore/onsite client delivery model

·         Reorganizing the fragmented tables and indexes

·         Preparing fragmentation analysis reports on a monthly basis for all production databases

·         Developing indexes to boost the performance; tuning SQL queries by ensuring proper usage of Indexes

·         Attending Change Advisory Board (CAB) Meetings to discuss and approve changes affecting the production environment

·         Facilitating WAR room to resolve the incident with other teams

·         Tracking action items and conducting incident review meetings to discuss the details of major & critical resolved incidents

·         Reviewing RCA document content (lesson learnt, corrective actions and root cause)

·         Updating change and incident logs to conduct meetings

·         Participating in Problem Management Meetings to review major & critical resolved incidents and related problem tickets

Highlights:

·         Recognized as Employee of the Month in Feb’14 at HP Global Soft Pvt. Ltd. for delivering exceptional performance for Marathon Petroleum Project

·         Recognized as Employee of the Month in Mar’13 at HP Global Soft Pvt. Ltd. for SCOM implementation in Marathon Petroleum

·         Awarded from HP India Vice President in 2015 for implementation of 12c OEM/SCOM/Remedy ticket automation

·         Appreciation certificate in May-Aug’15 for Ahold database support project transition from Mphasis to HP

·         Received certificate of recognition in Mar’18 from Ahold Service Coordinator for 70% overall incident reduction and zero SLA misses

Project Undertaken:

With DXC Technology

Title: Ahold

Role: Lead Database Administrator

Description: The project involves Ahold is an international retailing group based in the Netherlands and active in United States and Europe. 2000+ instances are using Oracle databases 10g, 11g and 12c running on Linux Platform with WebLogic as its middleware. It includes about 300 production databases from 9i to 12c versions. It involves Oracle enterprise management server for monitoring and HPSM for ticketing tool.

Others: Marathon Petroleum USA, Delphi, Unilever, Cadbury, BNPP, Konecranes, METSO, DPSG, and Seadrill in HP

Previous Experience

Jun’10-Oct’11 with ITC Infotech India Pvt. Ltd., Bengaluru as Oracle DBA

Project: DHL and Quantas Airlines

Highlight:

·         Received Star Project Award as a team for Qantas Airways in 2010

Apr’08-Jun’10 with Zensar Technology, Pune as Oracle DBA     

Project: Spar Hypermarket

Highlight:

·         Recipient of Spot SSU Award for delivering best performance in 2009

Previous Experience

Jun’10-Oct’11 with ITC Infotech India Pvt. Ltd., Bengaluru as Oracle DBA

Project: DHL and Quantas Airlines

Highlight:

·         Received Star Project Award as a team for Qantas Airways in 2010

Education

·         MBA from United Institute of Management, Allahabad, UP Technical University in 2007

·         B.Com. from Allahabad University in 2004

Certifications

·         Oracle Cloud Certification

·         OCA 11g from Oracle Corporation in 2017

·         ITIL Foundation in 2016

Trainings

·         Oracle12 C Training from Oracle Corporation

·         Oracle 9i Training from System Domain, Bengaluru

·         Oracle Training Course from CS3, New Delhi

Technical Skills

·         Database: Oracle 9i, 10g, 11g, 12c, AWS Admin, Mongo DB, MS-SQL, and Informix

·         Middleware: WebLogic 11g / TUXEDO 10 – Administration

·         Ticketing Tools: BMC Remedy, ServiceNow, and HPSM

·         System: Windows, UNIX, IBM AIX, Linux, Sun Solaris, and HP-Unix

·         Process: MIP, Incident Management, Problem Management and Change Management

·         Oracle Tools: PLSQL Developer, Oracle Enterprise Manager 9i, 10g, 11g, 12c, 13c, SQL Net Easy Configuration, Net8 Configuration Assistant, Database Configuration Assistant, ASM Configuration Assistance, SQL Plus, TOAD, and Oracle Grid Control