Resume

Sign in

Oracle Database

Location:
Toronto, Ontario, Canada
Salary:
$50/hr
Posted:
October 06, 2016

Contact this candidate

Resume:

KHURRAM SHEHZAD BHATTI

Oracle Database Administrator

acwxtw@r.postjobfree.com

647-***-****

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