Oracle Sql Server

Muhammad Naeem Khan

H # ** St # ** Cat-II Sector I-8/1, Islamabad, Pakistan C: (+92)

033******** *********@*******.***

Current Position

Assistant Manager Database Administration at Pakistan Telecommunication

Company Ltd. Islamabad (PTCL)

Career Summary

Database Administrator (OCP 10g) with 6+ years of experience in Oracle

Database Administration on LINUX and Solaris platforms and Microsoft SQL

Server 2008 Administration on Windows 2008 Server (Sept 2007 - TO DATE).

ORACLE DBA skills on Linux & Solaris Platforms include:

EXADATA X 3-2 Machine Administration Oracle RAC & ASM Monitoring

Oracle 9i/10g/11g Database Data Pump, SQL *Loader, External Tables

Administration Data Guard Configuration &

SQL / PL-SQL Programming Administration

Database Security, Auditing, Oracle Oracle Streams Configuration &

Scheduler Administration

Performance Tuning & Capacity GoldenGate Configuration &

Monitoring Administration

Planning and Designing experience in MS Backup & Recovery (RMAN)

SQL system Expert on Microsoft SQL Server 2008

Installation & Configuration of Oracle Expert in SQL Queries, Stored procedures

10g/11g

Designing management reports in Crystal

Reports

Personal Information

Sex: Male Marital Status: Married

Nationality: Pakistani

Oracle Certifications

Oracle Certified Professional 10g training from ICT

Oracle Exadata Machine Administration

OCP Certified

Other Certifications

Juniper Configuring Steel-Belted Radius 7.5

Technical Skills

Oracle EXADATA Administration: Oracle EXADATA X 3-2 Machine

Database Administration: Oracle 10g / 11g, SQL Server 2000 / 2005 / 2008,

MYSQL

Languages / Concepts: Java, JSP, C, C++, Object Oriented Programming, Data

Warehouse Design

Operating Systems: Solaris 10, Red Hat Linux 4-5, Windows 2003 Server

Tools / Software: Oracle Toad, PLSQL Developer, WinSCP, SecureCRT, VMware, HP

Data Protector

Education & Training

VITUAL UNIVERSITY, Islamabad, PAKISTAN 09/2012

Masters of Science, Major in Computer Science

UNIVERSITY COLLEGE OF INFORMATION TECHNOLOGY, Islamabad, 07/2003

PAKISTAN

Bachelor of Science, Major in Computer Science

Professional Experience

PAKISTAN TELECOMMUNICATION COMPANY LIMITED (PTCL) 09/2009 - Present

LOCATION: Islamabad, PAKISTAN

POSITION: Assistant Manager Database Administration

Job Responsibilities:

. EXADATA X 3-2 Machine Administration

. Oracle 11g database administration (Oracle RAC, Streams, Data Guard)

. PL-SQL programming to write/modify/tune Procedures

. Moving data using Data Pump, SQL* Loader & External Tables etc

. Create shell scripts for task automation (kron jobs, dbms_scheduler)

. Analyze and sustain capacity and performance requirements

. Analyze, consolidate and tune database for optimal efficiency

. Monitor systems and platforms for availability.

. Oversee backup, clustering, mirroring, replication and fail over.

. Install and test upgrades and patches.

. Provide 24/7 support for critical situations.

. Evaluate and recommend new database technologies.

. Manage and update Index/query tuning.

. Ensure live Database Backups are taken regularly and maintained

properly.

. Maintain strong liaison with in-house developers and third party

vendors for any issue that affect the applications and for the

completion of new projects..

. Ensure proper planning and steps for disaster management and

recovery.

. Other duties and responsibilities as assigned by the management.

Key projects:

. Worked with PTCL Vendors and served a Database Person role from PTCL

side during the up gradation of Database Servers from 2-node Oracle

10g RAC (SUN M-5000 Machines) to Oracle EXADATA X 3-2 Half Rack

Machines (4-node RAC) (2012-2013).

. Bi-directional Oracle 11g Streams Configuration between two Oracle

EXADATA Machines

. Worked with PTCL Vendors and served a Database Person role from PTCL

side during the up gradation of Database Servers from single node

Oracle 10g (SUN T4100 Machines) to 2-node Oracle 10 RAC (SUN M-5000

Machines) (2010-2011)

. Oracle 10g Data Guard Configuration (Physical Standby Database)

Solaris 10 platform

. Configuration of Oracle Golden Gate between two Oracle 11g Databases

on CentOS 6 (Test Machines)

. Oracle 10g Database Migration from ASM to Non ASM Environment (PTCL

Server to Test Machine)

. Written different PL-SQL Procedures & Scripts for PTCL Servers i.e.

o Procedure for Authentication of PTCL DSL Users

o Procedure for CDR Files Generation for Accounting Purpose

o Procedure for Bulk Data Insertion Deletion for controlling table

growth size

o RMAN/Data Pump Backups Shell Scripts

o Procedure to split table partitions to create new partition and

create a tablespace for new partition

FUTURE TECHNOLOGY (FT) LOCATION: Islamabad, PAKISTAN 05/2005 - 07/2009

POSITION: Database Administrator / Developer

Job Responsibilities:

. SQL Server 2000-2005 Database Administration of different Databases

. Database Development using .NET, JSP and SQL Server

. Installation of Windows 2000 and 2003 Servers.

. Web Server Installation and Configuring IIS

. Installation and Configuration of Database Servers.

Key projects:

. Data Migration from MS Access/Foxpro to SQL Server using the SQL

Queries

CMS (Complain Management System - 1218)

. Implementation of CMS with Vendor

CDAS (Computerized Directory Assistance System - 1217)

. Implementation of CDAS with Vendor

BNCC (ETL activity for BnCC (Billing and Customer Care System)

Professional References

Available upon request

Contact this candidate