Professional Summary

Motivated, passionate & creative individual with 12+ years of proven experience in managing multi-tier Oracle 12G RAC database in multi-platform LINUX environment. Worked in the area of banking, finance, insurance, mobile and telecom industries. A top performer in database code optimization. Organized, multitask driven & capable of managing multiple workloads & projects with minimal supervision. Effective team player with strong communication skills.

AREA OF EXPERTISE

Executing High Availability data recovery & failover scenario

Comprehensive knowledge of Grid Infrastructure RAC and ASM

Managing multi-terabyte, mission critical and high transactional databases for applications like CRM ERP, BPM, EDMS, SAS, CBR, GTS, Tradenet, Oracle FlexCube, Oracle HRMS etc.

Database Performance & Tuning SQL / Oracle

Oracle Database Migration & Upgrade

Active Data-Guard 10g MAA & Standby snapshot

Oracle Enterprise Manager Grid-Control 12c

Release-Patch PSU & CPU management skills

Application T24 & FlexCube core banking setup

WebLogic and JBoss application server admin

Microsoft SQL server Database 2017 SSIS/SSRS and Failover cluster WFC Active/Passive

Unix, Linux, AIX, HP-UX, RHEL Administration

Prioritizing project timelines and meeting standards

TECHNICAL SKILLS

Platforms:

Unix®, Linux Red Hat® IBM-AIX®,HP UX®, SCO-Unix, Oracle Solaris® Java™ J2ee® Enterprise Application RedHat JBoss Platform (EAP) JBase

Databases:

Certification:

Oracle 12c /11g /10g, Microsoft SQL-Server 2012 / 2014 / 2016 / 2017 SSRS/SSIS/SSAS/DTS/SSMS

ITILv3 Foundation 2011 ITSM 2016 ITIL® ITSM

Oracle Certified Professional DBA, OCP®

Oracle Cloud Infrastructure, Oracle Certified Associate from Oracle University.

Languages:

FlexCube core banking, T24 Temenos core banking, Oracle SQL,PL/SQL,MS-SQL, Unix Shell scripting, Jython, Python WLST scripting, eCBS cellular billing / Telco billing system etc.

Applications Web server & BI

Monitor tools:

Oracle Fusion Middleware, WebLogic 12c, J2ee, JBoss® web application server, WebTier, OBIEE,SQL Developer tools, SQL-Navigator, Toad, SSH, VNC, Scom, Putty, WinSCP, sFTP, SCP, Xming, Quest SpotLight, SQLl Monitor, DBA Tools, ManageEngine, HPOV, Cygwin, Telnet, CitrixServer Server etc.

WORK EXPERIENCE

FINANCE HOUSE – Abu Dhabi, United Arab Emirates

Senior Database Administrator – Mar 2015 – Dec 2019

Key Accomplishments includes:

Key player in Data Center Migration Project for major applications T24 Core banking, CMS cards, BPM & some 50+applications,100+databases,45-VMs machines,20-Linux servers for building infra-structure of Oracle 12cRAC, Microsoft SQL server 2016 failover cluster, JBoss app server.

Database upgrades, platform migration & DC migration of all Oracle & Microsoft with 100+ applications / 100+ databases in 2-VM Host machines with HA & cluster.

Achieved 100+ applications databases big bang DC-Migration roll-out of 4-Tier Infra-structure program completed within 6-month period for Oracle T24Core Banking, Internet Banking, MIS reporting, CMS card integration & migration of 100+ database of Microsoft SQL servers 2016 for Prod/DR/UAT for 100+ applications and infrastructure on IBM Blades.

Achieved 50+ application 100+ databases of SQL-Consolidation roll-out of 4-Tier Infra-structure program in 6-months for Microsoft virtualization of 2 Host servers with 10-VM machines for migration of 100+ database/application consolidated into 30-VM host servers.

Responsibilities includes:

Performance tuning, application SQL performance tuning, capacity planning resource management and production system support.

Monitors database growth and activities; determines performance bottlenecks & tunes SQL code

Performs database Patching of Oracle & Microsoft SQL server SP, security & cumulative updates.

DB platform Migration, Upgrade & Patching of database RAC components Clusterware.

Manage & Supports T24 core banking web applications server & assists with the development of database designs for multiples application.

Install Configure & Deploy T24 application & MW JBOSS application server.

Shells scripting Unix platform, Monitor & Maintenance administration of UNIX platform RHEL,

Failure Recovery with RMAN & Duplicate Standby in DataGuard, Complete & Incomplete recovery

High Availability RAC cluster, RMAN, DataGuard, Cloning with RMAN duplicate.

MASHREQ BANK – Dubai, DOZ, United Arab Emirates

Oracle Database Administrator – Jan 2011 - Dec 2014

Key Accomplishments includes:

Achieved Extra Mile Award of Flex Cube Core Banking infra-structure project completion.

Achieved multi-country big bang roll-out of 4-Tier Infra-structure program in 54 months for Oracle Flexcube Core Banking, BI publisher, Informatica ETL integration & migration of 100+ databases, application servers of Prod & DR for 140 applications and infrastructure on IBM P-595 and Blades Power 6/7 platforms.

Hands-On experience of Robust database migration, upgrade, patching of 100+ databases, Deployed, Configured integrated 50+ web-based application servers on cross platform WebLogic, WebCache running on distributed environment across 140+ applications to work with Oracle Flex cube Universal Banking, Direct Banking, Gateway & online Middleware.

Achieved excellence by prioritizing project timelines, meeting standards, simulating Go-Live,

supporting DR-drill and following best practices for Oracle Database & Application servers

Responsibilities includes:

Installation, Configure and maintain highly optimized Oracle RAC Grid Infra structure system

Managing and Administrating HA technologies like log shipping, mirroring, Storage level SAN sync, Active data guard, MAA, RAC & Replication etc.

Implementing and developing database strategies in the art of database migration, upgrade, patching, rolling upgrade, standby first patch applies to meet organizational SLA.

DR Setup of Active data guard, switch-over, fail-over scenario, physical Redo, SQL snapshot & logical standby database.

Administrating and managing Oracle databases which run on multiple platforms of Unix also uses different Storage like IBM AIX SAN, ASM, Hp EVA.

Planning and scheduling backups, implement backup strategy, purging & archiving policy & automating backup via RMAN.

Performance Tuning using ADDM, ADR, AWR, ASH, RAT, RDA, DRA RMAN, Segment advisor, SQL trace, tkprof, SQLT, SQL profiles, SQL plan, TRCA & SQL Tuning advisor.

Oracle Flex cube UBS FCDB Gateway Online Middleware, MQ IBM WebSphere BMW Informatica Core Banking Project Rolling Upgrade of Qatar, UAE, Bahrain, Kuwait & Egypt regions.

NATIONAL CLEARING COMPANY – Karachi, Pakistan

Sr. DBA – Feb 2007 - Dec 2010

Key Accomplishments includes:

Key member in migration of 7 databases IBM AIX servers with 425 GB of Data from CDC Central Depository Company Pakistan Ltd 2007.

Key member in version upgrades & migration of Oracle-DB from 9iR2 to10gR4 at IBM-AIX 5.3 2008.

Key member in setting up of Standby Oracle DataGuard with MAA 10gR4 2008.

Major Key achievement for Direct-path Upgrade Oracle 9.2.0.1 to 10.2.0.1

Responsibilities includes:

Deploy patch set on all DBMS, integrated with the live & training environment. Troubleshooting DBMS failures

High Availability with MAA Data guard in case of disaster or maintenance.

Optimize and tune Adhoc queries. Recovery strategy and its implementation in Oracle 10g, IBM-AIX 5.2/5.3 RISC 6000 p-series 550, Grid EM, WebLogic 7 server.

COMPUTER RESEARCH Pvt LTD, – Karachi, Pakistan

Oracle DBA Consultant – Feb 2002 – Feb 2007

Clients includes:

CMPAK, Formerly PAKTEL / INSTAPHONE Pakistan

PTCL Telecom

Education and Certifications

Bachelor of Science, University of Karachi, Pakistan

Oracle Certified Associate, OCI foundation 2020, Oracle University, USA

Oracle Certified Professional, DBA Oracle University, USA

ITIL Foundation certificate IT Service Management, EXIN Axelos

Contact this candidate