Summary
Overview
Work History
Education
Skills
Websites
Certification
Personal Information
Publications
Projects
Status
Honorsandawards
Timeline
Generic
Zulqarnain Hayat

Zulqarnain Hayat

Abu Dhabi

Summary

To be the part of a team of hi-caliber professionals in a progressive, transnational organization, thus sharpening my own technical skills while at the same time, contributing my best to the overall development of the organization.

23 years of Experience with last 15 years in UAE Government Education Sector IT Department as Team Lead. During this period my role was involved in different MIS and Enterprise Applications Projects like Banner, Oracle ERP, Big data, and Data ware house Upgrading, Integrations and core customization along with Operation support to ensure the business continuity. Currently leading team of 10 resources in Middleware Applications and Linux platform

Overview

24
24
years of professional experience
1
1
Certification

Work History

Team Lead

Khalifa University
Abu Dhabi
09.2014 - Current
  • Company Overview: http://www.kustar.ac.ae
  • Oversee project timelines, ensuring deliverables are met on time and within budget
  • Serve as the primary technical expert and provide guidance on architecture, system design, and development practices
  • Lead a team of developers, engineers, or IT support staff in delivering critical business applications or infrastructure
  • Staying updated with the latest IT trends, technologies, and best practices, encouraging continuous learning within the team
  • Implementing Best Practices for migration Oracle to PostgreSQL
  • Improve data processing and retrieving performance
  • Analyzed and executed the test cases for various phases of testing - Integration, regression and user acceptance
  • Leading the FAB Informatica team of 3 members & Responsible for providing Technical guidance/solutions to the team
  • Design and implement disaster recovery for the PostgreSQL Database
  • Patch, Upgrade and keep the PostgreSQL DBs current
  • Develop and enhance scripts to automate and execute various DBA tasks
  • Configuring and fixing the Issues with Pgadmin-III client application
  • Responsible for monitoring environments using monitoring tool viz
  • Nagios, Newrelic, custom scripts and other supporting tools like pgBadger, SolarWinds and Blue Modera
  • PostgreSQL Installation, Configuration, Migration, Upgrades and Patches
  • Server versions ranged from PostgreSQL 8.2 to 15
  • Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases
  • Optimize postgresql.conf for performance improvement
  • Review all PostgreSQL logs for problems
  • Installing databases preferably on-premise and Cloud PostgreSQL
  • Designing/developing/maintaining database schemas
  • Ansible for configuration management
  • Terraform for infrastructure provisioning
  • Enforced Security Administration, Active directory, CyberArk and principle of least privilege
  • Migrations from Oracle/ SQL Server databases (2008, 2012,2016, 2019) to PostgreSQL in Clouds
  • Perform Installations, Upgrades, Patching
  • Day-to-day Database Administration
  • Regular database Performance tuning
  • Provide technical guidance and mentoring to peers, less experienced engineers, and client personnel
  • Designing for high availability and business continuity using self-healing-based architectures, fail-over routing policies, multi-AZ deployment of EC2 instances, ELB health checks, Auto Scaling, and other disaster recovery models
  • Leveraged AWS Control Tower, AWS Organization, etc., to set up and govern a secure, multi-account AWS environment based on the company’s requirements
  • Implemented and managed Ansible Tower to scale automation and handle complex deployments
  • Monitoring and optimize the environment to ensure costs and performance scale on demand
  • Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms
  • Administered and monitored over 150 databases both on 10g/11g on prod/test/dev environments
  • Administering Oracle Databases 10g/11g of sizes ranging from 100GB to 5TB
  • Data warehouse solution for large databases for data consolidation, intended for OLAP and BI, ETL, using tools such as ERWIN, INFORMATICA, SQL-LOADER
  • Migrated databases from File-system to Automatic Storage Management (ASM)
  • Up-gradation of single instance databases from 10.2.0.4 to 11.2.0.3 on Linux
  • Responsible for using Flashback query mechanism along with automatic undo management
  • Automating Alerts, using SQL to set thresholds and triggers
  • Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases
  • Programming in shell to create shell scripts that automate the database backups and maintenance
  • Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c
  • Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance
  • Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing
  • Setup, reconfigured and monitored 2, 3 Node RAC Primary to 2, 3 Node RAC Dataguard for DR
  • Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints
  • Performance monitoring and Database/Instance/ clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance
  • Involved in Installing/configuring MS Server 2016,2017 and Azure 2019
  • Data Design and Development on Microsoft SQL Server 2012/2008R2/2008/2005/2000, T-SQL
  • Experience with High Availability and Disaster Recovery solutions for SQL Server
  • Experience working with Windows Server, including Active Directory and proper disk configuration for Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing
  • Create DTS packages and jobs to monitor, backup, import/export data and data warehouse extracts
  • Proficient in developing Continuous Integration/ Delivery pipelines
  • Manage and monitor databases and queried using Sql workbench
  • Specific hands on experience include administering large and complex Databases, Database Design, Normalization, Replication, Log Shipping, Full text indexing, and Database Application Development using varied development tools
  • Hot and Cold Backups, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, Pl/pgsql, Stored Procedures, Functions and Cursors and Triggers etc
  • Experience with High Availability and Disaster Recovery solutions for SQL Server
  • Knowledgeable in setting up TDE for critical database and database tables for security reasons
  • Providing database security administration such as User ID’s, Passwords, roles, etc
  • Manage and maintain logical database structures, physical structures, data, file systems, disk sub-systems, accounts/passwords, logical and physical backups, and database tuning
  • Perform DBA tasks to install, configure, test, maintain, backup, recover, patch, and upgrade
  • Tune, administer, and maintain SQL Server instance according to set standards
  • Develop and document procedures for backup and recovery of SQL Server database environments
  • Performing BASIC TASKS on OBJECTS such as, creating roles, granting privileges, creating tables
  • Experience with using SQL Profiler, Extended Event Sessions and Database Tuning Advisor in troubleshooting and tuning database and queries related issues
  • Working knowledge on HA and Always on clustering
  • Creating and deploying always on AG groups on brand new VMs in a cluster setup and troubleshooting related issues that may arise in case of poor data synchronization or listener related issues
  • Implementing the use of indexes, and primary & foreign key constraints as required
  • Providing PRODUCTION SUPPORT based on a ticketing system
  • Assisted in defining and implementing MAINTAINANCE PLAN for the database systems
  • High Availability (always on, log shipping, clustering)
  • Data Warehousing (SSRS, SSIR, SSAS)
  • Work experience on different hardware of server class machine which Include Sun Fire V20z, 280R, V240, V440, SUN T4-1B, SUN T5, M5000, T6300, SUN X6350, Cisco UCS, IBM, Oracle Mini Cluster, Oracle Exadata Engineering system, Oracle SPARC, Intel servers’ administration
  • Coordinating with Oracle support for logging Tar and knowledge-based search to find solution to the problems that are occurring in the live server while applying patches
  • Innovative professional with proven ability to identify, analyze, and solve problems to increase customer satisfaction and control costs
  • Deep understanding of technology with focus on delivering business solutions
  • Proven ability to be a strong professional with the sound knowledge of the new technologies and advance applications
  • Recommends resolutions to complex matters of significance and coordinate the implementation of the approved course of action
  • Http://www.kustar.ac.ae

Senior Database Administrator

ACTVET
Abu Dhabi
03.2011 - 09.2014
  • Company Overview: http://www.actvet.ac.ae
  • Http://www.actvet.ac.ae

Senior Database Administrator

University of Sharjah
Sharjah
12.2008 - 02.2011
  • Company Overview: http://www.sharjah.ac.ae
  • Http://www.sharjah.ac.ae

Database Architect

AXENTECH
Dubai
12.2007 - 11.2008
  • Company Overview: http://www.techaccess.com/
  • Http://www.techaccess.com/

Senior Database Administrator

ARY Speed Remit
Dubai
09.2006 - 11.2007
  • Company Overview: https://www.speedremit.ae
  • Https://www.speedremit.ae

Database Administrator

DANCOM Online Services
Lahore
11.2000 - 03.2005
  • Company Overview: http://www.dancom.com.my/
  • Http://www.dancom.com.my/

Education

MS - Computer Science

01.2017

BCS - Computer Science

01.2001

Skills

  • Management
  • AWS
  • Azure
  • GCP
  • Oracle Cloud
  • Banner UDC technology stack
  • Virtualizing technology
  • Technology Services Budget process
  • Oracle Databases
  • Microsoft SharePoint
  • Microsoft SQL Server DBA
  • Oracle ODS for Banner
  • Sierra Library System Admin
  • Database Administration
  • Sun Solaris Administration
  • Linux Red Hat
  • Oracle Linux
  • Centos
  • FreeBSD
  • Windows Server Administration
  • Oracle Data Warehouse Builder
  • SQL Server Administration
  • Project Management
  • Problem solving skills
  • Systems audit and control
  • Data Center design
  • VMware Infrastructure
  • EMC Storage
  • Legato Networker Administration

Certification

  • Oracle Autonomous Database Cloud 2019 Certified Specialist
  • Oracle Cloud Infrastructure Foundations 2020 Certified Associate
  • Oracle Cloud Infrastructure 2019 Certified Architect Associate
  • Microsoft training SQL 2008 (Dubai UAE)
  • Project Management (PMO ACTVET)
  • Solaris Certified System (SA, SNA)
  • VMware Infrastructure training Dubai UAE
  • Oracle training 10G/11G, 12C(Cloud)
  • Microsoft Certified Professional (MCP)
  • Microsoft Certified Solution Developer (MCSD)
  • Cisco Certified Network Associate (CCNA) (Training CORVIT Lahore)
  • Cisco Certified Network professional (CCNP) (Training CORVIT Lahore)
  • EMC Legato Networker Training from EMC Dubai UAE
  • EMC Data Domain Training from EMC Dubai UAE
  • EMC VNX storage Training from EMC Dubai UAE
  • AWS Certified Cloud Practitioner

Personal Information

  • Date of Birth: 11/15/77
  • Nationality: Pakistani
  • Driving License: Dubai, UAE
  • Marital Status: Married
  • Religion: ISLAM

Publications

  • Hybrid Data Protection Framework to Enhance A2O Functionality in Production Database Virtualization, https://www.ijrte.org/wp-content/uploads/papers/v8i6/F1203038620.pdf
  • Cloud data security enhancement approach for redundant server failure, https://search.emarefa.net/detail/BIM-934479
  • Implementation of Microsoft SQL Server using 'AlwaysOn' for High Availability and Disaster Recovery without Shared Storage, https://ijelcs.iobm.edu.pk/wp-content/uploads/2022/04/330-Article-Text-1106-1-11-20201111.pdf
  • Implementation of Oracle Real Application Cluster, https://iieta.org/sites/default/files/Journals/RCES/03.4_01.pdf

Projects

Ministry of Education Banner Student information system Migration application from on premises to Cloud Setup Disaster recovery for mission critical applications Native Backup implementation for mission critical application Migration databases from Windows to Linux platform Migration and Upgrade databases @Trans guard Group Dubai Disaster recovery setup Khalifa University, ACTVET, ADU LDAP Integration @ American University Dubai Sun Ray deployment @Amadeus Group Abu Dhabi Implementation and configuration VMware Infrastructure @National Bank of Dubai EMC Storage Deployment @Oasis Hospital Al-AIN Implementation of KOHA project with 420 libraries for Ministry of Education all over UAE Installation, administration and troubleshooting of Red hat Enterprise and Linux servers at Khalifa University Abu Dhabi Campus Administration and monitoring of assigned data centers at KU, Abu Dhabi Campus Administration and monitoring of assigned Implementation Oracle OVM 250 Servers deployed data centers

Status

UAE Golden Visa(10 years)

Honorsandawards

  • Khalifa University Certificate of Appreciation, In recognition of exceptional Commitment and Engagement in support Services, http://www.ku.ac.ae
  • Honor Best performance award from University of Sharjah, http://www.sharjah.ac.ae
  • Global Award big data, https://www.globaltechaward.com/imgs/SocialMediaShare.jpg
  • Support Services Recognition and innovation, http://www.ku.ac.ae

Timeline

Team Lead

Khalifa University
09.2014 - Current

Senior Database Administrator

ACTVET
03.2011 - 09.2014

Senior Database Administrator

University of Sharjah
12.2008 - 02.2011

Database Architect

AXENTECH
12.2007 - 11.2008

Senior Database Administrator

ARY Speed Remit
09.2006 - 11.2007

Database Administrator

DANCOM Online Services
11.2000 - 03.2005

MS - Computer Science

BCS - Computer Science

Similar Profiles

CREATE PROFILE
Zulqarnain Hayat