PROFILE SUMMARY:

14 years’ experience of database administration, troubleshooting, backup & recovery of different databases on different operating systems including HP - UX/SOLARIS, Linux and windows. Work experience of IBM DB2 / DB2 warehouse (Multi partition, multi node MPP deployment on docker container platform), Oracle RAC / Grid Infrastructure installation, administration and troubleshoot. Deployment, configuration and administration of Oracle Data Guard, ASM, and Multi-Master Replication on different platforms. Used to with third party tools such as Quest Spotlight for Oracle/Linux, TOAD etc.

KEY SKILLS SUMMARY:

Oracle RAC/11g/12c Grid Infrastructure

Oracle ASM

Oracle Data Guard

IBM DB2 (Linux, Unix, Windows)

IBM DB2 Warehouse (MPP Deployment on Docker container platform)

IBM DB2 HADR setup with TSA

Shell scripting

PROFESSIONAL EXPERIENCE;

Sr. DBA

Confidential

Environment: Oracle 11g R2/12c, Solaris 10, DB2 (LUW), DB2w (Warehouse)

Responsibilities:

• I am engaged on multiple client projects providing database level support regarding database architecture, deployment, administration, security, DB performance and maximum availability.
• Below are the different databases that I have been working on in IBM
• Oracle
• DB2 (LUW)
• DB2w (MPP) - Multipartition environment on Docker Platform
• MS SQL Server

Sr. DBA

Confidential

Environment: Oracle 10g/11g R2, Solaris 10, MySQL, EMC Networker

Responsibilities:

• Responsible to manage and maintain core CRM/Billing system databases to ensure continuous and smooth DB operations and 24/7 service availability.
• This also includes 24/7 support for issue resolution, new installations, Backup & Recovery, Data Lifecycle Management, database upgrade/patching as per requirement, Devising and implementing DB access/security policies etc.

Sr. DBA

Confidential

Environment: Oracle 10g/11g R2, Solaris 10, Oracle Enterprise Linux, Oracle EBS R12, MS SQLServer 2012, MySQL, Oracle Application Server 10g, EMC Networker, SAP HANA SP12

Responsibilities:

• Worked as Sr. Database Engineer for Ericson providing DBA support for Confidential in IT Managed Services department.
• Locally hired by Arkan Itihad Management Solutions (Bahrain) and outsourced to Confidential
• Consolidated Database health check process.
• Database upgrade from 9i to 11g R2
• Cloning of EBS R12 Application and Database tiers
• Database growth and capacity management plan
• Successfully installed and configured Oracle GoldenGate 11g on UAT server
• Responsibilities includes all the standard operation activities implied by the DBA role which include 24/7 support for DB administration related tasks along with new implementations required by the projects.

Sr. DBA

Confidential

Environment: Oracle Exadata X3-2, Oracle 9i RAC on VCS cluster, Oracle 10g/11g/12c, ASM, Solaris 10, Oracle Enterprise Linux, Veritass NetBackup

Responsibilities:

• Devised, documented and implemented Database Access control Policy and DB Storage Management & Data retention and offloading Policies for Confidential ’s core databases
• Consolidated Database health check process.
• Developed and deployed automated notification mechanism for proactive monitoring.
• Performed Oracle Hybrid Columnar Compression (HCC) on Oracle Exadata database.
• Oracle DB migration from Windows to Linux platform with data files from local file system to ASM.
• Installed Oracle 12c and configured PDBs for test and development servers for up gradation and migration projects.

Sr. IT Executive-Databases

Confidential

Environment: Oracle 10g RAC/11g Grid Infrastructure, ASM, Solaris 10, Veritas NetBackup, Oracle AS 10g

Responsibilities:

• Implemented two node and three node Oracle 11g RAC on Solaris10, using ASM and VERITAS file system
• Implemented Oracle 10g Data Guard.
• Performed database migration and upgradation from Oracle 10g to 11g R2.

Sr. IT/IS Audit Officer (Databases)

Confidential

Responsibilities:

• Job responsibilities included conducting audits of information systems to assess independently and objectively the controls, reliability and integrity of bank’s Information Technology environment.
• Making recommendations which can help to maintain and/or improve the efficiency and effectiveness of IT risk management, internal controls and corporate governance

Sr. Officer-Databases

Confidential

Environment: Oracle 10g RAC, Solaris 10, Veritas NetBackup, Oracle AS 10g

Responsibilities:

• Worked as Sr. DBA in a team of seven DBAs performing a variety of database administration related tasks for Oracle 10g, running on Solaris operating system.
• This includes trouble-shooting and database maintenance and on-call support beyond office hours.
• Implemented two node and two node Oracle 10g RAC on Solaris10, using ASM and VERITAS file system.
• Performed database migration and upgradation from Oracle 9i to 10g.

Oracle DBA

Confidential

Environment: Oracle 10g, HP-UX, Solaris 9, Oracle 10g RAC, ASM, VERITAS NetBackup, RMAN

Responsibilities:

• Worked as part of a team of four DBAs supporting several production, development and test databases.
• This included on-call production support and shift work to support Confidential ’s dynamic working environment.
• Implemented 2 node Oracle 10g RAC on HP-UX platform.
• Configured Oracle Enterprise Manager 10g.