Summary

Over 5 years of experience as an Oracle Database Administrator, Responsible for database administration, production support, installation, configuration, upgrades, patching, backup and recovery, database security, auditing, export/Import and space management.


Apart from Database, supporting organization in installation and management or WebLogic server, Application support and incident management

Projects

Upgrade Oracle Form& Reports ,Web logic and Window server 2k12
Upgrading Oracle Database 11g to Oracle 12c
Inventory Control System

Experience

Company Logo
Oracle Database & Application support
Pakistan Tobacco Company Limited
Jan 2017 - Present | Nowshera, Pakistan

Database Administration
Ø  Installation & configuration ofOracle 12c database server on Windows 2k12 OS platform.
Ø  Manage schedule and manual backups both Hot and Cold and check its validity by restoring Test environment.
Ø  Implement and maintain database security (create and maintain users and roles, assign privileges)
Ø  Patch Management and Version Control
Ø  perform both database and operating system performance tuning and monitoring
Ø  handle multiple databases and applications
Ø  Monitoring the database server to identify any Performance issues or bottlenecks.
Ø  Troubleshoot day-to-day database issues to ensure system availability.
Ø  Databases replica creation and configuration for new location ;
Ø  Creation of user, role, privilege, profile Management as per the requirement.
Ø  Data transfer via Replication process from master to slave and backward replicationand trouble shoot in case of any errors.
Data integration while processing replication process
Application support
Ø  Create, configured and maintain Web Logic server on server 2k12.
Ø  Oracle Fusion Middleware Repository creation and configuration as per application requirements.
Ø  Resolve IT application-related incidents, service requests and problems in a timely and efficient manner in line with Business requirements
Ø  Employ appropriate application maintenance, support and incident management processes and procedures to support and maintain IT applications, and to investigate and resolve IT application-related incidents.
Ø  As required, provide timely communication to users on the status of their service requests and incidents.
Ø  Incident management using portalTechDeck online and Cherwell. 
a)     Ensure 100% SLA and PLA compliance
b)     Responsible for driving all P1, P2, incidents, change requests and Service request.
c.Managing Service Request, Change Request,

Company Logo
Application/Database Support
Meta Soft International
May 2013 - Oct 2016 | Riyadh, Saudi Arabia

1. Supporting ERP (Hospital management system).
a. Application Implementation and maintenance.
b. Patches inhalation.
c. SQL server 2008 installation backup, Restoring on Test Server, disaster recovery, performance tuning.
d. Window server 2008 R2 administration.
e. HP server support.
f. New user training and registration., assign roles and rights to users.
g. User and Management feedback,
h. Analyzing new requirements and testing after patch installation.
i. Crystal reports customization.
j. Co-ordination with development teams Remotely Support for all Sites.
k. Client Connectivity/ Installing new system.
l. System performance through queries and procedures.
2. Co-ordination with development teams
3. Supporting 100 Users(Approximately).
4. Manage Biometric Attendance System..
5. Complete IT Support including Printers, Scanners, Photocopier Machine.
a. Acronics Image.
b. Network printer/ Scanner installation and user access.
c. Dot-matrix printer.
d. Data card Card printer.
e. NAS(Network Area storage ) management.

Company Logo
Administrator
Almazra Marketing Riyadh KSA
Mar 2010 - Feb 2013 | Riyadh, Saudi Arabia

• Develop and tested new financial reporting system using Ms Access/VBA and SQL server.(2005).
* Develop new reports.
* Edit existing Reports.
* Rectification of errors during posting and Un-Posting of transactions.
Create user and provide them privileges as suggests by IT manager.
• Perform modification on existing software.
• Prepare new system (Workstation) for user, designing ODBC connection and providing training.
• Server 2003 configuration and support.
• Regular backup of the Databases and AD.
• Printer and folder sharing over the network.
• Completer IT support including installation and troubleshooting.
• Tape Backup through Backup Server(daily).
• Create user and provide them privileges as suggests by manager.
• Server 2003/2008 configuration and support.
• Regular backup of the Databases and AD.
• Printer and folder sharing over the network.
• Completer IT and User support including installation and troubleshooting.

Education

University of Balochistan
Masters, Masters in Arts, ‎
Computer Science
2007
University of Peshawar
Bachelors, Bachelors in Arts, ‎
Computer Science, Mathematics Education
2004

Skills

Expert Backup management
Expert Database Monitoring
Expert ERP Application support, Analysis
Expert Legal Documents Management
Intermediate Microsoft MYSQL Server
Intermediate MSSQL
Beginner MySQL
Expert oracle database administrator
Expert ticket handeling
Beginner Web Designer Database
Intermediate Weblogic Administration
Intermediate Window Servers

Languages

Expert English
Intermediate Arabic
Expert Urdu
Expert Pashto

Companies Followed