my profile

 

Please Note :

Information posted in blog are for Guidance only .  Please raise Sr for all issues . 

 Abdul Hafeez Kalsekar

   PMP®, AWS®, 5xOCP®, OCS®, OCE®,OCI® ,MCSA®, ITIIL®, Scrum®

---

 

v    Experience Summary : 

Posses around 15 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 . Been part of various teams mainly  Bau , Operations , Change management  and Projects . Have hands on managing database on both public and private cloud .

Supported  various database including Oracle ,Sql server, DB2 , Postgres on various platform including Windows, Linux , Aix , Solaris with leading experience on Oracle.

 

v    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  , Oracle Cascading  standby ,  Heterogeneous Dataguard

Ÿ  Handled varous database upgrade ,  Oracle Oms and agent upgrade , storage migration , data center

    migration, platform migration and   cloud migration.

Ÿ  Performed various restoration , cloning  and  flashback query and flashback database .

Ÿ  Handling  Bau support  including Change planning and implementations  .

Ÿ  Implementing  various auditing and  hardening  standards . Access  controlling , controlling  

    grants and password lifetime . Enabling required database and  system audits and hardening of database  .

Ÿ  Implemented data /  tablespace  encryption .

Ÿ  Team Management , Shift resource planning ,

Ÿ  Automating Dr activation / Rman  restore operations .

Ÿ  Patching  Oracle  Rac , Oracle active passive Cluster , 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  .

Ÿ  Implemented data archiving  and partioning . Implemented various database and  backup compression

Ÿ  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 Oracle Snapshot standby , Standby activation ,

    Hacmp , Vcs  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 .

 

 

v    External  Certifications Cleared

 

• Oracle Cloud Infrastructure Foundations 2021 Associate  (11/10/2021)  (Exam Code: 1Z0-1085-21)

 

• Project Management Professional (PMP)  ( 29/06/2021)

 

• Scrum Fundamentals Certified (SFC)   (10-12-2020) 

 

• AWS Certified Solutions Architect – Associate (29/11/2020) .(Exam Code : SAA-C02)

 

• 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)

 

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

 

 

                                                                                                                          

v    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   , Oracle Active-Passive  Cluster , 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 , Citi In house cloud ,

 

 

Team Lead  :

Ø  Shift Planning , Shift handling ,  Sla tracking , Providing Rca   

 

 

 

v    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

 

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