Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Oad

Springfield,Singapore

Summary

Architect with 12 years of experience with progressive career history across design, project leadership and cost reduction initiatives, in various environments like Enterprise & Community Database versions, Oracle, MySQL, Maria (Galera Clusters), Aurora DB, MongoDB, Redis and Rabbit MQ.

Experienced in heterogeneous environments with database deployments across various platforms like on VM’s, bare-metal and hybrid cloud (AWS & GCP). Building, scaling and delivering secure end to end infrastructure solutions starting from information gathering to delivery, deployment and maintenance across various Tier I, II and III applications.

Focus on achieving business value efficiently through automation and analysis with experience.

Overview

14
14
years of professional experience

Work History

Architect

LIBERTY WIRELESS Pvt. Ltd, CIRCLES.LIFE
10.2016 - Current
  • Circles is emerging MVNO Currently operating in five different regions (Singapore, Taiwan, Australia, Indonesia & Japan).
  • Adhered to timelines to meet quality assurance targets.
  • Determined project specifications by thoroughly studying performance standards, requirements and technical studies.
  • Setup Production databases on On-Prim Servers & on Cloud Platform (i,e AWS & GCP)
  • Setup Hybrid Oracle Production Database is On-Prim and DR Database is in AWS Cloud (DR) (Using Data-Guard).
  • Setup multi AZ cluster for Maria, Mongo, RMQ,Redis & ETCD on AWS & GCP Cloud.
  • DR setup for all the Production Databases (Oracle, Maria, Mongo, MYSQL, Aurora DB, & Redis) in multi region
  • Oracle DB Migration from 11g to 12c and 12c to 19c for standalone and RAC DB
  • Installation, configuration and Database integration of oracle enterprise manager cloud control (OEMCC) to effectively monitor Oracle databases.
  • Configured Physical Data Guard for critical databases
  • Implemented comprehensive backup policy for all the Production databases
  • Lead veritas NetBackup solution implementation and configuration Project in Circles
  • Lead Oracle Servers X-6, X-7, X-8 and Private Cloud appliance (PCA) implementation, migration and expansion Projects
  • Implemented security policy and database controls
  • Transparent Data Encryption and SSL configured
  • Oracle Database Hardening and Perform Audit for all Database Servers
  • Successfully completed DB Storage Migration project from Oracle ZFS to Huawei Storage for Oracle ASM Files system
  • Configuration and integration of Cluster Control for monitoring and management of Mongo, Maria & Redis Clusters
  • Worked on Designing and scalability of Production environments

Database Administrator

Jaffer Brothers (Private) Limited, UFONE PROJECT
04.2015 - 09.2016

Worked as a Database Administrator since April 2015 at Jaffer Brothers (JB), which is providing Oracle Consulting Services to different sectors like Telecom’s & Banking sector. Worked as a Resident Engineer for a Telecommunication Company Ufone (PTML) which is one of the biggest telecom service providers in Pakistan. Provided Oracle consultancy regarding different technologies like Exadata, RAC, Data Guard, Golden Gate and ASM.

  • Developed daily health check scripts to ease monitoring and administrative efforts.
  • Installation, Configuration, and administration of Oracle Golden Gate, performed database migration through Oracle Golden Gate for heterogenous environments across multi-platforms i,e LINUX to AIX
  • Installation, Configuration, and administration of Oracle Enterprise Manager (OEM) 13c/12c/11g
  • Setup custom reports and configure alerts using Oracle Enterprise Manager grid control (OEM).
  • Setup Data guard (Physical Standby) for mission critical RAC databases
  • Physical Standby Database Roll Forward using RMAN
  • Performance tuning of long running queries for Production databases
  • Oracle Database version Upgrade 11g to 12c
  • Database migration from 9i to 11g.
  • Responsible for database security and data loss prevention
  • Worked with Internal & External Audit teams and conducted successful DB Audits

Database Consultant

Network Centric Solutions
04.2010 - 05.2014
  • NCS is UK based Oracle Consulting Services Company, providing support to multiple clients.

http://www.networkcentricsupport.com

Associated Northcliffe Digital

The BMJ (British Medical Journal)

Local World UK

National Magazines

Penson Financials Ltd (UK)

WWF UK

Resolute Management LLOYDS

Diabetes UK

BEAMTV

Prepay

  • Supported building of new system environments and upgrading or patching existing systems.
  • Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.
  • Reviewed project requests describing database user needs to estimate time and cost required to accomplish projects.
  • Completed installation and configuration of 12c EM Cloud Control Server.
  • Upgrade Production RAC server from 11.1.0.7 to 11.2.0.3.
  • Set up 11.2.0.3 single instance DataGuard for RAC primary database.
  • Upgrade 2 Node production RAC database from 10.2.0.4 to 11.1.0.7 within 5 hours of planned downtime.
  • Setup of DataGuard Broker between primary and standby RAC databases.
  • RMAN backup setup for production database through a script.
  • Configure Grid Control Server to receive email alerts for critical errors.
  • Upgrade 9i (9.2.0.8) database to 11.2.0.3 using export / import.
  • Migrate and upgraded database from file systems to ASM DISKS.
  • Liaised with system administrators to monitor, troubleshoot, triage and provide RCAs for incidents.

Education

Bachelor of Science - IT

Quaid-e-Awam University of Engineering Science & Technology
Pakistan
2010

Skills

  • Leadership and supervision
  • AWS & GCP Cloud
  • Oracle DB, MongoDB, MariaDB (Galara Cluster), Mysql, Aurora, Rabbit MQ, ETCD, Redis (Sentinel Cluster)
  • Cluster Control, Newrelic, Grafana & OEM
  • Rich experience in installation and management of database on Oracle engineered Server Exadata
  • Experience in Installation, configuration and administration of Oracle Golden Gate and Performed database migration through Oracle Golden Gate for heterogenous environments across multi-platforms
  • Expertise in Performance tuning of production database to achieve optimal performance
  • Experience in capacity planning, database Upgradation and patch implementation
  • Planned and implemented backup and restoration strategies for production databases using RMAN utility and Oracle data pump
  • Performed Database point in time recovery Good knowledge of UNIX Administrator for the Linux, Sun Solaris, AIX and Windows
  • Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, SATSPACK, OEM Grid Control and manual scripts
  • Providing 24x7 support for mission and business critical production databases and interfacing with vendors and clients for problem resolutions and issue rectifications

Timeline

Architect

LIBERTY WIRELESS Pvt. Ltd, CIRCLES.LIFE
10.2016 - Current

Database Administrator

Jaffer Brothers (Private) Limited, UFONE PROJECT
04.2015 - 09.2016

Database Consultant

Network Centric Solutions
04.2010 - 05.2014

Bachelor of Science - IT

Quaid-e-Awam University of Engineering Science & Technology
Oad