概要

Database Administrator and Oracle/Exadata/MS SQL Server / Cassandra certified with over 14 years of IT experience. Technical strengths in the area of Oracle/MySQL/MS SQL Server/Cassandra Database Administrator committed team player with excellent written and verbal communication skills.

工作经历

公司标识
Managing Consultant DBA Cloud Service
System Limited
Feb 2022 - 代表 | Lahore, Pakistan

• Managing 24/7 Live databases.
• Migration Database on-Premises to RDS cloud.
• Setup Mongo DB three node replica set
• SQL Server Installation, configuration with Microsoft best practices
• Implemented Always-On High Availability configuration on SQL Server database instance (s)
• Implement SQL Server Clustering
• Implement SQL Server log shipping
• Windows Failover Cluster (WFC) Management
• Experience with Performance Tuning / Index Management & maintenance
• Implemented backup and disaster recovery solution as per business requirements
• Manage DBA team deploy on different clients.

公司标识
Technical Manager – Oracle
Techaccess Pakistan
Nov 2019 - Feb 2022 | Lahore, Pakistan

· Responsible for management of large size of Oracle databases running on Exadata· Working on Exadata X4-2, included half and quarter rack.· Migration oracle database from different platform· Coordinate with Oracle support for early resolution of issues· Manage oracle database team deploy on different clients.

公司标识
Assistant Manager Databases
Jazz
Jan 2017 - Sep 2019 | Lahore, Pakistan

· Responsible for management of large size instances of Oracle databases.· Responsible for performance management and optimization of live oracle databases.· Accountable for capacity and resource planning from operational perspective.· Conduct backups and restoration of backups.· Configure and Manage Oracle streams,Data Guard, Real Application cluster (RAC) and ASM environment.· Upgrade databases from 11g to 12c,18c· Configure and Manage MYSQL cluster and standalone database.· Coordinate with Oracle support and vendors for early resolution of issues.

公司标识
Specialist Database
Mobilink GSM (PMCL)
Aug 2014 - Dec 2016 | Lahore, Pakistan

· Responsible for management of large size instances of Oracle databases· Responsible for performance management and optimization of live oracle database· Accountable for capacity and resource planning from operational perspective· Conduct backups and restoration of backups.· Manage & administer Oracle streams, Data Guard and ASM environment.· oordinate with Oracle support and vendors for early resolution of issues.

公司标识
Software Engineer (Database Optimizer & Consultant)
Netsol Technology Limited
Jan 2014 - Aug 2014 | Lahore, Pakistan

· Implement Schema level replication through Oracle Golden Gate· Configure Oracle Steaming for table level replication.· Configure Oracle Active Data guard on Linux environment· Identify Oracle and MS SQL Server long running Quires/Store Procedures.· Import Export Oracle Database Schema through Data Pump.· Enable MS SQL Server log shipping· Optimization of Complex queries/ procedures/ functions (Oracle/ MS SQL)· R&D for optimal database solutions· Performance Troubleshooting of offshore client’s DB Servers [Mercedes, BMW, Nissan, etc]· SQL Server Administration (2008, 2012) 

公司标识
Database Administrator
Higher Education Department (Government of the Punjab)
Jun 2010 - Jan 2014 | Lahore, Pakistan

· Oracle software installation.· Configure Oracle 10g Data Guard.· Write and execute SQL statement against database and its objects.· Performing backup and recovery.·  Supervise the automation (Punjab Gateway Project) of Higher Education Department Punjab.· Focal Person/Master Trainer of Bio Metric Attendance system and online admission system of Higher Education Department Punjab.

公司标识
Database Administrator
LINKdotNET (An Orascom Telecom Company)
Oct 2008 - May 2010 | Lahore, Pakistan

· Oracle software installation.· Managing tablespaces, data files, redo logs, tables and its segments.· Write and execute SQL statement against database and its objects.· Performing backup and recovery.· Import and Export Data using oracle utility.· Controlling and monitoring user access to the database.· Configuration network local naming and host naming Services.· Unload data from oracle tables using Procedure and batch file.· Configuration network local naming and host naming Services.· Monitring Application (TRACER local application) Services.
 

学历

Datastax Apache Cassandra 3 Administrator Associate
证书, ‎
Apache Cassandra 3 Administrator Associate
Completed
2020
Oracle Corporation
证书, Certified Professional 11g‎
Databae Administration
Completed
2013
Oracle Corporation
证书, Oracle Certified Professional 10g‎
Database Administration
Completed
2009
University of the Punjab
硕士, , Information Technologhy‎
Database
CGPA 3.2/4
2007

技能

初学者 Cassandra
熟练 CV Screening Skills
中级 Mongodb
中级 MS SQL Server
初学者 MySQL
中级 MySQL Cluster
熟练 Oracle
熟练 Query Language

语言

熟练 乌尔都语
熟练 英语