Database Administrator
Peshawar Electric Supply Company (PESCO) pakistan
Total years of experience :16 years, 0 Months
Working as DBA and responsible for installation, up gradation and Trouble Shooting for errors, Database Installing
Clonning and Maintaing Oracle ERP (Application, Databases)
Maintaining Oracle Exadata and Exalogic (X5.2) Machines
Creating and maintaining stand by database.
Extensively worked on Real Application Cluster (RAC).
Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
Automated hot backups using a combination of incremental, differential and full RMAN backups.
Maintaining archive data on appropriate storage devices.
Tracing, troubleshooting with database performance and tuning issues.
Export/Import of oracle databases.
Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
Analyzing and validating database objects.
Coordinating with team members.
Tuning SQL queries, On call support 24x7.
• Working as DBA and responsible for installation, up gradation
and Trouble Shooting for errors, Database Installing 9i, 10g,
11g database.
• Creating and maintaining stand by database.
• Extensively worked on Real Application Cluster (RAC).
• Maintenance of production database and development
database which includes tablespace space management, user
creation, privileges, roles etc.
• Automated hot backups using a combination of incremental,
differential and full RMAN backups.
• Maintaining archive data on appropriate storage devices.
• Tracing, troubleshooting with database performance and tuning
issues.
• Export/Import of oracle databases.
• Debugging, troubleshooting Oracle PL/SQL packages, stored
procedures and functions.
• Analyzing and validating database objects.
• Coordinating with team members.
• Tuning SQL queries, On call support 24x7.
• Doing Database as well as System Administration of In‐House
Developed ERP Solutions
• Planning and implementing changes and improvements in
Functioning systems (Reports Generation according to
requirements).
• Database backup management of different database
Applications
• Database backup through RMAN, Data pump and traditional
way
• Recovery of database (System crash), Availability of Database
• Application server management (Oracle 10g),
• Develop Inventory requisition system using Oracle 10g
• Responsible for Security management of Oracle Servers.
• Supporting End Users including Troubleshooting of day to day
user problems.
• Help users in learning new developed systems by arranging in
house training.
• Teaches oracle 10g Developer to Students (DBMS, SQL,
PL/SQL, Forms, Reports)
• Software Design, Development of inventory system, payroll
system for NIE Using Oracle 10g
• Software Design, Development, implementation of Human
Resource management system (HRMS) for NIE
• Database backup management of different database
Applications
• Database tuning in oracle 10g for best performance
• Database backup through RMAN, Data pump and traditional
way
• Recovery of database (System crash), Availability of Database
• Oracle database 11g installation Linux /windows
• Deliver lecture to intermediate course is comprise of Introduction
to computer, Hardware, software,
• C Language++ Language, Database Management System
(DBMS)
• Deliver lecture to Bachelor classes, Analysis and Develop
databases, Networking Troubleshooting
Software Engineering Data Mining Software Quality Algorithm
Oracle RDBMS 11g/10g/9i Oracle Developer 10g/9i, 6i Oracle DBA 11g/10g Oracle Data guard 10g Oracle RAC 10g Programming languages C, C++ Computer Networks Strong Concept of Computer Hardware Linux OS Unix OS MS Office (Access, Excel, MS Visio, Word)