Sql Server Database Administrator

Objective:

Oracle Certified Professional (OCP) Database Administrator, Analyst and Architect with strong knowledge and proven industry experience in Oracle. I have worked on Oracle 10g, 9i and Oracle 8i on various operating systems including SUN Solaris, Linux, AIX, and Windows NT. And also experience as Production, Operational on OLTP, and Data Warehouse. Have good knowledge of Oracle RAC, Data Guard, Performance Tuning and 11i Applications.

I am a highly motivated person and able to produce results in timely constraints environments. Able to effectively plan, organize and prioritize responsibilities to meet schedules/deadlines without close supervision. Team player and team leader; committed to obtaining results.

Technical Expertise

·Oracle RDBMS versions 9i,10g, 11g,12C,19C, 11i, R12 Application

·Implementation and troubleshooting of Distributed Databases.

·Oracle Recovery Manager (RMAN)

·Implementation and administration of Oracle Standby database 9i,10g,11g,12C etc

·Silent Installation of Oracle 9i, 10g and 11g, 12c

·Oracle Enterprise Manager cloud control, Tel net, VPN

·SQL Loader, Stats Pack, Explain Plan

·Oracle RDBMS installation, configuration and effective administration on database and O/S ends

·Implementation and administration of enterprise level solutions/databases including RAC, Standby DB.

·Deep understanding of Telecom environment,

·Oracle Data guard implementation for high availability of Data for the manual fail over and switch over.

·Installation of Oracle 12c forms and report Configuration of Oracle WebLogic.

·Database up gradation from different version and between different architecture.

·SQL Server 2019 multiple nodes (Active/Passive) in SQL clustering Features.

Mr. Sohail Ahmad

Father’s Name: Lal Dar Khan

Date Of Birth: 02nd Feb, 1981

Passport #: GM1155701

CNIC #: 17101-8163570-7

Languages: English, Pashto, Urdu

Cell # +92-300-*******,031********

Qualification:

BS Computer Science From University of Peshawar.(2000-2004)

International Certifications

Oracle Certified Professional (OCP)(August2006)

International Certification from Oracle University, USA.

ITIL Foundation Training from TNA Technology Islamabad

Oracle 9i DBA Professional Training

·Introduction to Oracle 9i SQL

·Oracle 9i Database Fundamental-1

·Oracle 9i Database Fundamental-2

·Oracle9i Database Performance & Tuning.

From Techno-ed Partners Oracle University, U.S.A

Oracle 10g New Features for Administration

Oracle R12 EBS suit Administration

Oracle 10g Dataguard

Training& Workshops:

·11i apps dbaWorkshop . 2months training in OraNet Islamabad (www.oranet.com.pk)

Install patch

System administration

·10G RAC Workshop

5 Day training of oracle 10G RAC in ora-tech systems.

·10G DataGuardWorkshop

5 Day training of oracle 10G RAC in ora-tech systems.

ITIL Foundation training

5 day ITIL tranning from TNA Technology Islamabad

Leadership and Communication skill workshop

3day workshop at seven`skills isalmabad

Contact Me

Mobile Number: +92-300-*******, 031******** Email Address: ******.*****@*******.**.**

Professional Experiences:

Leady Reading Hospital Peshawar

www.Lrh.edu.pk

As SENIOR DATABASE ADMINISTRATOR

Employment Date: March 29, 2020 – till date

Employer: Eccentric Technologies

Responsibilities:

Providing 24x7 databases support.

Installation, maintenance, tuning and up gradation of Oracle database products.

Planning and migration of Database and applications.

Creation, Management and Capacity planning of physical databases including space management.

Develop and maintain backup and recovery processes to ensure timely Oracle database system recovery.

Physical design implementation, patch promotions and data archiving.

Set up and maintain production, testing and development database environments.

Database and application performance tuning.

Database user management.

Worked on controlling user privileges, monitoring the security and Audit issues.

12C WebLogic installation and configuration. And Upgradation from 12.2.1.3 to 12.2.1.4. and Database from 12c To 19c.

Also responsible for all servers of which are running in SQL Plate form (SQL Server 2008, 20014,20019).

Extensive knowledge in database maintenance and SQL Server optimization using SQL tools such as SQL Profiler, Database Tuning Advisor, Maintenance Plans, and Database Performance Analyzer.

Setup multiple nodes (Active/Passive) in SQL Server to add clustering Features.

Performed log shipping and implemented Replication as high availability technique.

Applied patches and service packs to keep the database at the current patch level.

Tracked server activity, Query Performance, and Disk Usage activity statistics via performance Data Collection.

Managing the Concurrent Managers and its operations by triggering automated scripts from concurrent requests running on daily basis, purging concurrent requests historical data, tunning of concurrent managers of the concurrent manager operations.

Administration and managing the Oracle Instance using custom scripts and Oracle Enterprise Manager (OEM) database control and OAM.

Disaster Management -> Setup implementations for DR, Recovery steps and participation on DR Exercise.

Applications Environment:

12C WebLogic Severs, .net apps

OS and DB Environment:

UNIX family operating system, Microsoft windows server, SQL SERVER 2019, Oracle databases, Oracle RAC, DataGuard, WebLogic Servers, OS cluster. IIS Server

International Rescue Committee (I.R.C)

Senior Technological & Adaptation Manager (consultant)

From Aug 2021 – Till date

Organization’s Type: The International Rescue Committee is a global humanitarian aid, relief and development nongovernmental organization

Environment: .net 2019 and MS Sql server 2019

Development of complete DMIS system for Provincial Disaster Management Authority (PDMA) Khaybar Pukhtoon Khawa.

International Rescue Committee (I.R.C)

Manager IT SOLUTION

From Aug 2015 – sep 2020

Organization’s Type: The International Rescue Committee is a global humanitarian aid, relief and development nongovernmental organization

Environment : Windows 2014_64bits, MS SQL Server 2, 2008, .net framework

Job Responsibilities:

Management of information technology and computer systems

Plan, organize, control and evaluate IT and electronic data operations

NETWORK CONFIURATION AND DESIGNING

SERVERS MAINTANCE AND UPGRADATION

Manage IT staff by recruiting, training and coaching employees, communicating job expectations and appraising their performance. Build the capacity of IVAP and partner organization in ODK data collection and server management.

Design, develop, implement and coordinate systems, policies and procedures

Ensure security of data, network access and backup systems

Act in alignment with user needs and system functionality to contribute to organizational policy

Identify problematic areas and implement strategic solutions in time

Preserve assets, information security and control structures

Handle annual budget and ensure cost effectiveness.

Data management & Data analysis look for trends/flaws in data and feed back from Program Coordinator and Manager Data Collection to improve data quality of data.

External liaising with external partners (including UN Agencies, INGOs, PDMA, FDMA etc) to share appropriate information on need base.

Rehman Medical Institute Peshawar(rmi.edu.pk)

As ERP admin + DATABASE ADMINISTRATOR/CONSULTANT

From March 2011 – 2015

Organization’s Type: Health Care Hospital and Medical College.

Environment: Oracle 11g, windows 2008_64bits, MS SQL Server 2005, 2014 and Microsoft D-365

Supervise 2 database administrator directly and 8 software engineers in Hospital management system

Integrations: Standard practices requires standard tools, therefore to manage Human Resource, Supply Chain Management

and Financials a standard ERP (MICROSOFT Dynamics) is implemented but incapable to handle Hospital Clinical functionalities. Through Integration both modules (D-365 and VICENNA) have been connected and getting real time info. The Covered Integrations are: Patient/Customer Demographics, HR, Pharmacy (i.e. two-way Consumption and Real time stocks reflection) and financial Integration.

International Rescue Committee (I.R.C)

Senior Team Leader Information Management

From Aug 2013 – 31March 2015

Organization’s Type: The International Rescue Committee is a global humanitarian aid, relief and development nongovernmental organization

Environment: windows 2008_64bits, MS SQL Server 2, 2008, .net platform

Supervise 4 senior database officer directly and 10 call center staff

Ora-Tech System Islamabad, Pakistan

As DATABASE ADMINISTRATOR & PRODUCTION SUPPORT

From June 2005 to June 2009.

Organization’s Type: Oracle Corporation Authorized Partners in Pakistan

Responsibilities Performed in the following projects;

1.MTN Afghanistan (Tele-communication)

2.Wi-tribe Islamabad (Tele_communication)

3.OGDCL Islamabad (Oil & Gas Company)

4.UFone Pakistan (Tele-Communication)

5.Roshan Telecom, Afghanistan

6.Public Secretariat Mineral Department Govt. of NWFP

Detail of Client’s Projects

Company’s Name:

MTN Kabul Afghanistan.

Organizatin’s Type:

Telecommunication

Environment:

Oracle 10g, Oracle 9i, RAC, Data Guard, Linux RedHat 4, Sun Solaris, IBM AIX 5-I Server, Microsoft Server

My Role:

Database Administrator

Company’s Name:

Wi-Tribe Islamabad Pakistan.

Organizatin’s Type:

Telecommunication

Environment:

Oracle Apps R12 (64Bits), Solaris Operating System.

My Role:

Application Database Administrator (Apps DBA)

Company’s Name:

OGDCL Islamabad Pakistan.

Organizatin’s Type:

Oil & Gas Company

Environment:

Oracle Applications 11i (64Bits), Solaris Operating system, HP-Unix

My Role:

Monitor & Optimizer the performance of Apps Server

Company’s Name:

UFone Islamabad Pakistan

Organizatin’s Type:

Telecommunication

Environment:

Oracle 10g, Oracle 9i, RAC, Data Guard, Linux RedHat 4, Sun Solaris, IBM AIX 5-I, Microsoft Storage Server HPXP SAN 1024

My Role:

Oracle DBA Team Leader

Company’s Name:

Roshan Telecom Afghanistan

Organizatin’s Type:

Telecommunication

Environment:

Oracle 10g, Oracle 9i, Solaris and Linux Itanium

My Role:

Data Warehouse Database Consultant

References

Will be provide on request

RESUME

Contact this candidate