خلاصہ

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
نومبر ۲۰۱۸ - موجودہ | Karachi, Pakistan

Working on multiple Projects related to Database and Cyber Security.

کمپنی کا لوگو
Database & Middle-Ware Consultant
Royal Cyber Inc.
فروری ۲۰۱۷ - موجودہ | 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
دسمبر ۲۰۱۳ - فروری ۲۰۱۷ | 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

زبانیں

ماہر انگریزی