Oracle Engineer

Abdul Hafeez Kalsekar

Experience Summary :

Posses around 14 years of experience as an Database Administrator and Database team lead . Installation, configuration, upgrades, patching, performance tuning, backup and recovery, cloning, database security and auditing. Core experience on clustering, Ha and Cob technologies . Indulged in L3 support handling escalations and providing rca . Handled alert reduction, problem management . Have served various projects including storage migration, data center migration, platform migration and cloud migration .

Have supported various database including Oracle,Sql server, DB2, Postgres on various platform including Windows, Linux, Aix, Solaris .

Accomplishments

Have implemented and supported various clustering, replication, HA and COB setup including

Rac, Dataguard, Exadata, Oraas, ODA, Dbaas, Always On, Sql server mirroring, Windows Clustering Implemented and supported various replication technologies including Golden Gate, SharePlex, Sql Server

Log Shipping, Cascading standby,

Performed various restoration, cloning and flashback query and flashback database . Restoring sql server

backup .

Have involved in implementing various auditing and security standards . Access controlling, controlling

grants and password lifetime . Enabling required database and system audits and tracing .

Implemented data / tablespace encryption .

Performed various patching on rac, active passive, sql server and golden gate .

Have involved in various performance tuning, troubleshooting and providing Rca for performance issues,

Node eviction, job slowness . Pining of old plan and diagnosing statistics issues in Oracle .

Providing storage and space estimation and disk additions

Implemented data archiving and partioning .

Providing service improvement recommendation and contribution on alert reduction .

Troubleshooting replication issues, missing archives, transaction log issues

Involved in various Dr / Cob testing activities including Snapshot standby, Standby activation,

Moving cluster resources to another node including caritas and windows cluster .

Troubleshooting Rac cluster issues, always on monitoring and issue handling .

Backup strategy designing and monitoring backup for oracle and sql database with hands on backup

strategy including EMC BCV, Rman using Veritas Netbackup 6,Comvault Simpana,Sql backtrack,

Actifio

Worked On ticketing tools like ER( Hp prodcuct ), BMC Remedy 7/9. SNOW

Software installation and DB creation, fixing inventory issues, oracle home cloning .

Handled database corruption and fragmentation issues .

Implemented various database and backup compression .

Have served various projects including storage migration, data center migration, platform migration and

cloud migration. Well versed with upgrading database to 11g, 12c, 19c, sql server 2012 .

External Certifications Cleared

Oracle Database Administrator Certified Professional 2019 ( 19c OCP )

(13/06/2020) .(Exam Code : 1Z0-083)

Oracle 12c Database Administrator Certified Professional (18/04/2020) .(Exam Code : 1Z0-060)

Administering a SQL Database Infrastructure 2016 -- MCSA ( 04/11/2019 ) (Exam Code : 70-764 )

Oracle Exadata Certified Implementation Specialist ( 08/12/2014 ) (Exam Code : 1Z0-485 )

Oracle GoldenGate 10 Certified Implementation Specialist (OCS)

( 19/07/2013 ) (Exam Code : 1Z0-539 )

Oracle Database 10g: Managing Oracle on Linux Certified Expert (OCE)

( 04/10/2012) (Exam Code : 1Z0-046 )

Oracle 11g R2 Real Application Clusters and Grid Infrastructure Administrator (OCE)

( 07/03/2012) (Exam Code : 1Z0-058 )

Oracle Database 11g Performance Tuning Certified Expert ( OCE )

( 12/01/2012) (Exam Code : 1Z0-054 )

IBM Certified Operator (24/12/2011) (Exam Code : 000-103 )

ITIL V3 Foundation (11/01/2011) (Exam Code : EX0-101)

Oracle 11g Database Administrator Certified Professional (23/12/2010) .(Exam Code : 1Z0-050)

Oracle 10g Rac Certified Expert ( OCE ) (29/12/2009) (Exam Code : 1Z0-048)

Microsoft Certified Technology Specialist . (MCTS) (19/10/2009) (Exam Code : 070-431)

Oracle 10G Database Administrator Certified Professional (21/09/2007). (Exam Code: 1Z0-040)

Oracle9i Database Administrator Certified Professional (OCP) (22/02/2007).

(Exam Code: 1Z0-007 / 1Z0-031 / 1Z0-032 / 1Z0-033)

Awards And Achievements

Received “Special Recognition Award” through CapGemini on 23-Nov-2010 along with special

one time bonus for technical expertise and throughout extended support provided in major crisis.

Have been recognized with numerous awards by Citibank for various projects and extended support.

Skillset

Database :

Oracle database 9i/10g/11g/12c/19c, Exadata X2 /X3, ODA, Oraas ( Cloud )

Ms Sql 2005/2008/2012/2016, Db2 9.5., Postgres

High Availability Strategies :

Oracle Rac Active-Active, Oracle Active-Passive, Vcs, Srdf, HACMP, Windows Cluster .

Replication Strategies :

Dataguard, Golden Gate Hub, Shareplex, Multi Mater replication

Sql Server AlwaysOn,Sql Server Database Mirroring

Backup Solutions :

Actifio, EMC BCV, Veritas Netbackup 6,Comvault Simpana,Sql backtrack, Rman

Cloud :

AWS

External Training Undertaken :

Oracle Apps DBA (R12.2) Administration - from K21 Technologies in October 2016

PMP v4 training from “Reniks Corporate Solutions” (Mumbai ) in 2011

[Gained 35 PDU required to undertake PMP certification PMI-001]

Red Hat Linux 5 (modules RH133, RH033) from Vibrant Technologies (MUMBAI) in 2007.

Oracle 10g Dba ON Red Hat Linux from QSOFT(MUMBAI) IN AUGUST 2007

Oracle 9i Database administration, 9i SQL from SQL Star International (MUMBAI) in 2006.

Comptia N+ (Networking) and A+ (Hardware) from Karrox Technologies (Mumbai) 2006.

Diploma in Programming from Brain Point (Mumbai) in 2003.

Macromedia, Web Page Designing from Ansari Comp. And Research Center in 2001

Training Attended Through Company

Training Through Cognizant :

1) Oracle 11g: RAC and Grid Infrastructure Administration Accelerated Release 2

{1 week Training given by Oracle Corp} {course code: D60488GC11}

2) Six Sigma Yellow Belt 3) Oracle Weblogic

4) Oracle 11g golden gate { 1 week }

5) Exadata Database Machine Administration Workshop Ed 1 -- X3

( 1 week training by Oracle Corp )

6) Oracle database 12c : New features for Administrators . D77758GC10

( 1 week training by Oracle Corp )

Training Through IBM : AIX 6 System Administration and Implementation (AU14).

Training Through Wipro : ITIL V3, Email Etiquettes, Soft Skills, Sql Server 2005 .

Experience Summary

Company

Employment Type

Project / Client

Designation

Start Date

End Date

WORK

LOCATION

Total eBiz Solutions Pte Ltd

Contract

Land Transport Authority

Database Analyst

28-Sep-2020

Till Date

Singapore

NTT Singapore Digital Business Solutions Pte. Ltd.

Contract

Ministry of Education

Senior database administrator

10-Oct-2019

25-Sep-2020

Singapore

NTT Data Services

Permanent

Citibank

Database Advisor

01-Dec-2015

09-Oct-2019

Singapore

Cognizant

Permanent

1) Emdeon

2) UBS

Technology Architect

1)13-Jun-11

2) 18-dec-12

1) 16-Dec-12

2) 30-Nov-15

1) Bangalore.

2) Singapore

Capgemini

Permanent

Total Gas

Consultant – Oracle DBA

2-Jun-10

7-Jun-11

Mumbai

IBM

Permanent

Vodafone

Oracle DBA

2-Mar-10

31-May-10

Pune

Wipro InfoTech

Permanent

Yes Bank

Engineer

Database Administrator

17-Apr-08

26-Feb-10

Mumbai

Srl Ranbaxy

Permanent

Srl Ranbaxy

Database Administrator

5-Apr-07

15-Apr-08

Mumbai

Education

DEGREE

UNIVERSITY

START YEAR

END YEAR

MODE

B. Com

Mumbai University

2005

2006

FULL TIME

H.S.C

Mumbai University

1999

2000

FULL TIME

S.S.C

Mumbai University

1997

1998

FULL TIME

Detailed Experience

1)

CURRENT COMPANY : Total eBiz Solutions Pte Ltd

Client : Land Transport Authority - Singapore

PERIOD : 28-Sep-2020 till date

ENVIROMENT : Oracle 12C, Db2 10

DESIGNATION : Database analyst .

EMPLOYMENT TYPE : Contract

Job Profile : Data modular

2)

CURRENT COMPANY : NTT Singapore Digital Business Solutions Pte. Ltd.

Client : Ministry of Education - Singapore

PERIOD : 10-Oct-2019 till 22-Sep-2020

ENVIROMENT : Oracle 12C, 19c, Aws, Rac, Sql server 2008/2016 .

DESIGNATION : Senior Database Engineer .

EMPLOYMENT TYPE : Contract

Job Profile : L3 Bau and project support for oracle and sql database .

Responsibilities:

Successfully installed Sql server 2016 always on cluster

Successfully migrated oracle 12c database and grid to 19.3

Managing database on Aws Rds

Completed san migration for standalone and rac database servers .

Configuring auditing as per splunk standard to point audit information to syslog and event logs .

Installing of sql server service packs on standalone and cluster database

Applying latest database security patches for oracle and sql server

Supporting Dr testing

Troubleshooting sql server cluster failover issues

Planning and implementing audit policies . Generating audit reports using Bladelogic tool

to ensure audit compliances are in place

Troubleshooting performance issues and suggesting performance improvement plans

Handling various implementation and migration projects

Restoring oracle and Sql database on demand .

Scheduling sql servers jobs for backups and statistics gathering .

Successfully recovered deleted Oracle data using flashback query .

Successfully fixed sql server database from suspect mode .

Implementing audit policies on sql server and oracle as as per CIS standards

3)

CURRENT COMPANY : Dell Services / NTT DATA

Client : Citibank

PERIOD : 01-JAN-2016 till 09-Oct-2019

ENVIROMENT : Oracle 12C, Oraas, Rac, Golden Gate, Shareplex .

DESIGNATION : Database advisor .

EMPLOYMENT TYPE : Permanent

Job Profile : Implementing BAU database implementations projects in SIT/UAT / Production.

Providing L3 support, handling escalations Bau support .

Responsibilities:

Part of ICG APAC L3 Regional database team

Handling BAU project of implementations and migration in SIT/UAT/Production including Golden gate

, RAC and Oracle active passive cluster . Handling various projects of P2x, datacenter migration etc.

Implemented Golden Gate Hub, Oracle Cluster service Active/Passive, Cascading standby,

Oracle Golden Gate on Rac with apps Vip .

Providing L3 Support handling escalations

Planning and execution of Changes including Cob testing, flashback, patching .

Psu patching, Dr drills, Cob resource failover testing using SRDF and HACMP

Migrating database to Oraas and support Bau Oraas database

Supporting production issues, managing escalations .

Troubleshooting Golden gate and Shareplex replication issues.

Handled Data center migration, Storage migrations, Database 12c upgrade, Upgrade Golden Gate to

Latest version

Handling Golden Gate issues, Monitoring, Setup up Heart beat tables ., Lag issues

Private and Public Ip change for Tac cluster for data canter migrations .

Handling Oraas database on Citi In house Cloud . Managing various activities on Cloud database

Installed oracle 12c Rac database and handling rac migrations

Take part of all infra related on-going issues, service improvement meetings and provide suggestion

Wherever required and provide service improvement initiatives – saving space, cost and improving

major System performance.

Performed backup and recovery of table spaces and indexes and monitored performance/tuning

For Db2 Performed image copy, quiesce, recovery, reorg, report, modify, bind check, and loads

Extensive experience in utilities and tools used for database monitoring (DB2 traces, online

performance monitors, reports, EXPLAIN, DB2 catalog queries), data movement and organization

(LOAD,UNLOAD,REORG),data consistency utilities and catalog manipulation utilities

(RUNSTATS,MODIFY,STOSPACE), Tuned system DSNZPARMS, BUFFERPOOLS, SORTPOOLS,

EDMPOOLS, and DASD configuration

Providing service improve and alert reduction plans .

Supported various flashback of database, flashback query and Flash archive table

4)

CURRENT COMPANY : COGNIZANT

PAYROLL OF : COGNIZANT

PROJECTS worked for : Emdeon, Wellington Management Company, UBS

PERIOD : 13-Jun-11 till 31st Dec 2015

ENVIROMENT : Oracle 10g, 11g r1/r2 database on Aix,10g/11g dataguard,

10g/11gr2 rac, range partitioning, tablespace and table compression,

11.2.0.1 grid and agents configured, index organized tables, cluster

tables Oracle HAS, Materialized Views . Dbass /ODA X4-2 machine

DESIGNATION : Technology Architect .

EMPLOYMENT TYPE : Permanent

Job Profile : Providing remote support to around 230 production Database. Need to monitor

netcool alerts and Taking care for tickets using HP tool ER. Need to submit RCA .

Also need to submit various reports . Been also team lead for team of 10

associates

Responsibilities:

Managing deputy team lead role managing operations, handling service now queue,

Managing shift roasters and escalation management .

Grid and Agent management: Monitoring alerts and targets using OEM grid .

And troubleshooting agents unavailability., Upgrading target agents

Managing database on Exadata X3 .

Upgraded 11.2.0.1 and 11.1.0.7 RDBMS and RAC to 11.2.0.2.

Managing dataguard for RAC and Single instance

PSU and one off patching (rolling) to cluster and rdbms home

Rman backup and restore from tape using netbackup and simpana for RAC and single instance .

Manage 10g rac and 11g r2 rac having oracle restart, scan listener and services configured .

Managing Service request, incident tickets and problem tickets .

Rebuild Oracle inventory when corrupted.

Capacity planning: Estimating the storage requirement based on going usage.

Working with Oracle support for fixes and escalations and backport patches for bug fixes

Maintaining object stats and restoring old stats if required .

Involved in alert reduction and other service improvement programs.

Troubleshooting performance issues and submission of RCA.

Managing DBAAS and tablespace wallet

Managing Sql server 2005-2012, backup & recovery, mirroring, logshipping, replication

5)

PREVIOUS COMPANY : CAPGEMINI

PAYROLL OF : CAPGEMINI ( INDIA )

PROJECT : TOTAL GAS

PERIOD : 02-JUNE-2010 till 07-june-2011

ENVIROMENT : Oracle 8i, 9i, 10g on Aix, Solaris, Windows 2003

DESIGNATION : CONSULTANT .

EMPLOYMENT TYPE : Permanent - P3 Band

Job Profile : Providing remote support using Citrix to around 200 production

Database. Need to ensure proper uptime and service as per SLA .

Need to monitor and close the Change request and Incident raised in

Ticketing tool Remedy ( BMC product )

Responsibilities:

Ensuring all Change request and incidents are adhered as per SLM.

( Software installations, Db creations,Troubleshoot Issue’s faced etc. )

Fulfilling cold backup and rman restoration request

Ensuring data guard sync with production

Cloning oracle home and serving fresh installation request .

Resolving any technical issue faced .

Preparing RCA for issues faced .

6)

PREVIOUS COMPANY : IBM INDIA

Client : VODAFONE

PERIOD : 02-MAR-2010 till 31-MAY-2010

ENVIROMENT : Oracle 8i, 9i, 10g, 11g on Aix, HP Unix . 10g/ 11g RAC

DESIGNATION : ORACLE DBA. L3 Support .

EMPLOYMENT TYPE : Permanent - Band 5

Job Profile : Ensuring day to day database business operation are carried out without any

hurdles . Managing around 30 production and handling team of 5 DBA

Responsibilities:

Successfully carried out transition for Vodafone project from Oracle to IBM which included Migration, Upgrade, PSU and Cpu patching .

Providing necessary support to L1 team .

Handling severity 2 and 3 Remedy request .

Implemented cluster tables, table partitioning and compressing old table partition .

Handling new software installation and database creation request . Creation of users and roles with

required rights / privileges. Retiring old database .

Scheduling jobs in cron and database as per requirement.

Configuring and monitoring alerts using OEM having EM agents configured .

Managing Lun to Lun replication, User Managed hot backup to reporting server

Modifying Kernel parameters for Hp unix servers as required .

Handling database performance and Client connectivity issues.

Performing Log mining to identify user errors done .

Managing 4 node Rac: migrating datafile to asm, applied rolling patch on it.

Renaming datafiles having special/junk characters .

7)

Previous Company : Wipro Infotech (MUMBAI)

CLIENT SITE : Yes Bank / Reliance Life Insurance ( Mumbai )

PERIOD : 17-apr-2008 till 26-FEB-2010

ENVIRONMENT : ORACLE 9I / 10G on AIX 5.3, Sun Solaris 5.9, Windows

DESIGNATION : Engineer Database Administrator .

EMPLOYMENT TYPE : Permanent (Core)

TEAM SIZE : 3

JOB PROFILE : Managing almost 19 PRODUCTION database and 10 UAT database on AIX .

Specific responsibilities include but are not limited to Database Administration,

Performance tuning and monitoring including statistical analysis, SQL

optimization, resource utilization management and error/event log monitoring.

Also handling user request for Sql Server backup and restoration .

Responsibilities:

Successfully installed 9.2.0.5 RAC on windows using ocfs and configured TAF for the same.

Managing 2 node 10.2.0.4 RAC on Solaris with ASM configured

Migrated database from 9.2.0.8 to 10.2.0.3 along.

Upgraded database from 9.2.0.4/5 to 9.2.0.8 with its Standby DB .

Managed Oracle Fail Safe 3.3.3 .

Implemented RMAN for all production database using catalog database.

Successfully performed block media recovery .

Monitoring Physical Dataguard manually using third party tool (PANACES) .

Applying latest CPU patch, after successful testing in UAT .

Applying respective bug / interim patch

Implemented table range partitioning .

Managing DR testing (activating and recreating DR)

Implementing a comprehensive database AUDIT mechanism

Providing necessary support to application support them.

Monitoring row chaining,archive generation, invalid objects, tablespace free space, hit ratio,

Top Sql on Daily basis.

Capacity planning including disk utilization, growth forecasting and database expansion

Monitoring wait events and long operations .

Managing backup strategy based on SLA

Handling user incident and service request.

Handling session tracing and tkprof as per request .

Generating explain plan and providing suggestion based on that .

Managing database statistics, reorg. and index rebuilding

Taking up issues with Oracle Support for bug fixes etc.

Analyzing statspack / awr and providing suggestions .

Managing perfstat schema .

8)

Previous Company : SRL RANBAXY (MUMBAI – ANDHERI)

Client : SRL RANBAXY

PERIOD : 05-apr-2007 to 15-apr-2008

ENVIRONMENT : ORACLE 9I / 10G, WINDOWS 2003 SERVER

DESIGNATION : Database Administrator .

EMPLOYMENT TYPE : PERMENANT

TEAM SIZE : 4

JOB PROFILE : Monitoring almost 12 production and DR, 2 web server,4 UAT .

Ensuring minimum downtime . Providing optimum utilization of resource available .

Responsibilities:

Successfully created 9.2.0.8 and 10.2.0.4 Physical Dataguard on Windows .

Refreshing 10g dataguard using incremental backup .

Creating /managing 9I Multi master Replication

Implementing Oracle security .

(PROFILES, LISTENER, DEFAULT USERS PASS., checking privileges)

Cloning the database

Monitoring daily export backup and import in BO environment

Monitoring database logs and dr sync status on daily basis

Physical and logical space management

Monitoring index usage / Pining objects in shared pool.

Monitoring the database in case of any issue faced

Managing roles and privileges .

Sizing and tuning various SGA structures

Capturing top sql and tuning the same .

Maintaining data life cycle and archival process .

Preparing monthly database reports considering growth forecast etc.

Personal Information:

Date of Birth : 8th August 1982

Languages Known : English, Hindi and Marathi

Marital Status : Married

Nationality : Indian

Email : **************@*****.***, ***********@*****.***

Phone : Singapore Number : +65-90292607

India Number : +91 - 986-***-****

Connect Me : http://abdul-hafeez-kalsekar.blogspot.sg/

linkedin.com/in/abdul-hafeez-kalsekar-39a630159

Contact this candidate