Oracle Database
Resume:
KHURRAM SHEHZAD BHATTI
Oracle Database Administrator
*******.******@*******.***
CAREER SUMMARY
6+ years of working experience as Database Administrator (Oracle & MSSQL).
Experience of managing database systems on UNIX/AIX/Windows platform.
Ensured 24x7 system availability in production database environment.
Bachelor of Engineering in computer systems.
TECHNICAL SKILLS
Technologies
Experience
Databases
Oracle (10g/11g/12c)
6+ years
MSSQL (2005/2008)
1+ years
Operating Systems
RedHat Linux 4/5/6, Oracle Linux 4/5/6,
AIX 5/6, MS Windows
9+ years
Database Tools
OEM, Grid Control, Oracle SQL Developer,
PL/SQL Developer, TOAD
6+ years
Database Performance Tuning
AWR, ASH, ADDM and Stats pack reports, Explain Plan, Enterprise Manager, TOAD Advance SQL Optimizer
6+ years
WORK EXPERIENCE
Oracle Database Administrator
Habib Bank Limited (Largest bank of Pakistan - www.hbl.com)
Nov 2013 – Jul 2016
Performed the following activities at HBL:
Managed multiple instances of Oracle production environments with high volume financial transactions.
Performed capacity planning with technical support team to ensure that the technical infrastructure meet operational requirements and take corrective actions accordingly.
Created and maintained DBMS products for development, production and test usage.
Through reviews and regular interactions, ensured that database systems are designed to meet storage, availability and performance requirements
Completed projects in a timely and cost effective manner.
Worked with Project Managers & Business Analysts to keep update with the recent database version and technology.
Provided 24x7 on-call support after office hours for production systems.
Implanted Oracle Transparent Data Encryption to advance database security.
Configured & managed Oracle Standby & high availability using RAC.
Performed documentation of installation/migration/upgradation and other operational procedures and maintain SOPs.
Also involved in the following projects:
Oracle GoldenGate implementation and Grid Control 12c
Oracle Database Administrator
Jaffer Brothers Pvt. Ltd (Oracle’s Gold Partner - www.jaffer.com)
Jul 2013 – Nov 2013
Worked as an Oracle Database Administrator and performed the following activities:
Database installation and migration to Oracle from other database.
Applied database patches and performed Oracle Performance Tuning.
Database partitioning in OLAP Environment. .
Monitor database alerts and jobs and write change and incident reports.
Coordinate with developer for developing Scripts using PL/SQL, including SSH and UNIX scripting also.
Performed database troubleshooting and root cause analysis.
Co-ordinated with Oracle Support team and vendors to resolve database issues and problems.
Provided active support for new projects and prepare change requests.
Oracle Database Administrator
Techaccess (Oracle’s Diamond Partner - www.techaccesspak.com)
Jan 2012 – Jul 2013
Provided consultancy to troubleshoot for performance hike and bug removal for different Oracle Products.
Responsible for technical assistance for tuning, backup & Recovery issues.
Delivered Technical Presentations and Hands-on Training.
Created and maintained databases for production and non-production usage.
Backup and restore database using cold backup and RMAN.
Performed import export using data pump.
Oracle Support Analyst
Ora-Tech Systems (Oracle’s Platinum Partner www.ora-tech.com)
Jul 2010 – Dec 2011
Provided onsite and remote assistance to the clients.
Oracle Database installation on Linux and Windows environment.
10g Dataguard implementation with physical standby.
Performed backup and Recovery using RMAN
Database and System Support Engineer
Al-Baasit Technology Group
Aug 2006 – Jun 2010
Maintained documentation of installed and available Database patches to ensure that Databases and Windows Environments are up-to-date.
Database space management for smooth database availability.
Performed installation, support and regular maintenance of Oracle and SQL server database and Microsoft Windows Environment.
EDUCATION & CERTIFICATIONS
Bachelor of Engineering – (Computer Systems)
Equivalent to Canadian 4 years Bachelor’s degree (Assessed by U of T)
Oracle 10g & 11g Certified Professional (DBA Track).
2005
2011
Contact this candidate