概要

Seeking an opportunity in an esteemed organization that provides exposure to the hanging trends in the field of System, Database and Application Management along with interaction with professional work force and exciting projects to fully exploit the knowledge in order to achieve higher degree of professionalism.

项目

IBM DB2 Database High Availability & Disaster Recovery (HADR) Solution.
Oracle Database Upgrade to 12c

工作经历

公司标识
DBA & Cyber Security Consultant
Gulf Business Machines
Nov 2018 - 代表 | Karachi, Pakistan

Working on multiple Projects related to Database and Cyber Security.

公司标识
Database & Middle-Ware Consultant
Royal Cyber Inc.
Feb 2017 - 代表 | Karachi, Pakistan

TracFone Wireless (USA Telecom Company)

Current Project.

Working as Offshore DB Team lead for Oracle Database 11g/12c & IBM DB2 v9.7.0.6.

Responsible to take care of 13 SIT/DEV Oracle DB environments with 4 members team.

Also, taking care of 18 SIT/DEV IBM DB2 DB environments for IBM Commerce & Portal applications.

Acknowledging tickets from developers using tool CA Service Desk.

Downloading PF-Forms/CR-Forms from Clarity (web-based application).

Deployment of DML Scripts, Packages, Package body using Version Control (CVS) Tool as per the CR/PF Forms.

In case of invalid packages, deployment of same package from PROD/TST environments.
Running some business Jobs as and when requested.

Providing Access to Database and Application Users.

Taking care of the access to the Database objects as per Access Forms.

Refreshing the tables/materialized views from PROD/TST as and when requested.

Communication with the developers on Skype for Business (IM) to help them in case of issues.

Meetings with the customer for upcoming projects.

Taking DB2 Backups before Data load and other applications changes.

Restore of DB2 Databases from PROD/TST backups for Major changes in SIT environments.

Majorly involved in Syncing the Oracle SIT/DEV environments with Production releases frequently.

Managing filesystem spaces in all the Database Servers.

Also involved in the build and deployment of code using Anthill Pro for SOA/OSB.

Sending Anthill logs to the Developer in case of any failure in Deployment for Code check.
Build and Deployment of IBM Commerce code using WCDB utility.

In case of Failure in Deployment of Commerce Build/Deployment, sharing logs with Commerce Development Team.

Deployment of IBM Portal Application Code through RAF tool.

Performing Data Load & Mass Load for commerce Application.

公司标识
Database Analyst
Techaccess Pakistan Pvt Ltd
Dec 2013 - Feb 2017 | Karachi, Pakistan

MAJOR RESPONSIBILITIES

IBM DB2

IBM DB2 Installation and Configuration on AIX, Linux and Windows 2003.
Cataloging and un-cataloging database.
Backup and Restoration of DB2 database.
Implementing Fix Packs.
High Availability & Disaster Recovery Solution Implementation.
Monitor database performance and recommend improvements for operational efficiency.
Assist in capacity planning, space management and data maintenance activities for database system.
Maintain patches for database environments.

Oracle Database

Installation of Oracle Database 10g, 11g on Linux, Window.
Troubleshoot Oracle issues.
Visit client premises to resolve critical Oracle problems.
Responsible for 24/7 support for clients.
Performance monitoring on Oracle systems related to Oracle DB.
Monitor scheduled backups on Oracle databases.
Tune UNIX (Linux) for smooth Oracle functioning and performance.
Provided consultancy to troubleshoot for performance hike and bug removal for different Oracle Products.
Maintain System & Object Privileges.
Using Export, Import and Data Pump for creating test environments.

SQL Server

Installation and Configuration of SQL Server 2008, 2010, 2012.
Configuration of SQL Cluster environment.
Configuration for Disaster Recovery/mirroring of SQL Server.
Managing Spaces for Scheduled/Manual Backups, TxnLogs and Active Logs.
Providing 24/7 end user support regarding SQL issues.

MySql

Installation of Mysql Database.

Fine tune the Sql Quries by Analysis of Reports.

Taking care of usless/idel sessions, Deadlocks.

Maintenance of Mysql Mount Points.

User Management for Db as well as for Application.

Checking the credibility of Scheduled Backups.

Creating SIT/UAT environments for Developing team testing.

学历

Mohammad Ali Jinnah University
硕士, 科学硕士学位, Masters in Computer Science‎
Web Aplication, Electronics, Computer Programing
CGPA 2.9/4
2016
University of Sindh
学士, , Bachelors in Commerce‎
Accounting & Finance
等级 B+
2012

技能

熟练 AIX
中级 Application Management Services
熟练 Database Replication
熟练 IBM DB2
中级 IBM Rational Tools
中级 IBM Security Guardium
熟练 Linux System
中级 MySQL
熟练 Oracle Administration

语言

熟练 英语