DATABASE SPECIALIST
Ministry of Interior,
Total years of experience :14 years, 0 Months
Project:
Oracle Apps and Core DBA on different Oracle Database’s in MOI supporting
different services
Responsibilities:
• Daily Maintenance/Monitoring of Database
• Perform database tuning and performance monitoring
• Establish and maintain sound backup and recovery policies and
procedures(Apps & Database)
• Install 12cR2 and 19c RAC on AIX 7.1/7.2, Applying Patches
• Apply Media patches on 19c Media
• Add and remove RAC nodes on AIX
• Maintain Database's RMAN Backups
• Implement and maintain database security (create and maintain users
and roles, assign privileges)
• Policy Managed Database(19c), With Application Continuity.
• Interface with Oracle Corporation for technical support.
• Patch Management and Version Control
• Take care of the Database design and implementation
• Build Data Guard and DG Broker for Oracle Database.
• Install and Configure EMC control 13c.
• Working on different project’s Database’s.
Ø Tools: SQL*Plus, EM, Grid Control,
SQL*Loader, RMAN, Tracing, Explain-
Plan, AWR, Scheduler, Data Pump,
Shell Scripting, ASH
RECENTEMPLOYMENTEXPERIENCE
SENIOR ORACLE APPS & CORE
Project:
Askari Bank AMS
Responsibilities:
• Daily database administration and monitoring tasks
• Oracle EBS and Oracle PeopleSoft App and database management
• RAC installation & administration of Oracle 11G &10G(PR and DR Site)
• Data Guard configuration of Oracle 11G and 10G
• Migration of database 10g, 11g from AIX Power System 6 to system 7
• Perform EBS & Peoplesoft database performance tuning
• Perform production cloning of application (EBS and Peoplesoft)
• PeopleSoft People Tools Upgrade(8.49 to 8.52)
• PeopleSoft HRMS and Global Payroll patching using change assistant.
• PeopleSoft application installation & configuration
• Compiling Peoplesoft Cobol files
• Web Sphere installation configuration on AIX.
• Establish and maintain backup and recovery policies and procedures
• Perform general technical trouble shooting and give consultation to
development teams
• Work with Oracle Corporation for technical support
• Patch management and version control of app and database
• Maintain database's RMAN backups & Restore/Recover RMAN Backups
• Take care of the Database design and implementation
• Implement and maintain database security
• Shell Scripting for RMAN Backups
• Setup and maintain documentation and standards
KEYCOMPETENCIES
PROBLEM SOLVING:
I am able to maintain composure when
presented with problems and work out the
most effective strategy to overcome them.
MULTITASKING:
I have a proactive and flexible approach to
juggling many different priorities, and able to
work autonomously and take ownership of all
aspects of a task or project.
TIME MANAGEMENT:
I am able to structure and prioritise my
workload in order to get the most work done
efficiently in a day
CLIENT FOCUS:
An active listener who works diligently to
understand client’s specific requirements,
provide tailored solutions and meet
expectations.
TEAM PLAYER:
I am experienced in and work well in a team
environment whilst preserving the ability to
work independently and autonomously.
ORGANISED:
I am highly organised which enables me to
complete my work efficiently and in a timely
manner.
SELF MOTIVATED:
I am naturally highly motivated and always
challenging myself.
Securities and Exchange Commission of Pakistan -SECP
British Petroleum Iraq- BP IRAQ
Pakistan Telecommunication Company Ltd- PTCL
Saudi International Petrochemical Company-SIPCHEM
Road and Transport Authority (Dubai)-RTA
Zong (CMPAK) Telecom Pakistan
Zain Atheer Data Warehouse Project Kuwait
Zain Bahrain Data Warehouse Project
Key Food
Responsibilities:
• Administration of oracle 10g and 11g database installed on Sun Solaris
and configuring on ASM.
• Database maintenance
• RMAN Backups
• Data warehouse batch error rectification
• Backend reconciliations with all data sources interfaced with DWH.
• Handling periodic/regular reconciliations.
• Archiving of OLAPs repository.
• Maintaining the batch execution documents up-to-date and history.
• Participating in optimising the jobs execution time.
• Files comparison
• Verify DB Instance is up
• Check for Errors in alert log file.
• Adding ASM disks to UNIX mount points.
• Performance Tuning
• Oracle Application Server database
• Check for Errors in alert log file
• Database Backup recovery using RMAN & Data Pump
• Manual creation of Data Guard for DB switch over between primary &
secondary databases
• Multimaster Replication by using Replication Management API and
Database Streams Replication
courses: CERTIFICATIONS Oracle Certified Professional (DBA Track Oracle 9i)