HUMA OMAR

DBA/AppsDBA/Developer

Career Objective

Seeking for a job role as AppsDBA/DBA/Developer in an environment that encourages innovative thinking, recognition and career development.

Career Summary

A Professional with more than 10 years of extensive experience and strong IT academic background would like to establish a fulfilling proactive career and assume ever increasing responsibility in the course of time.

Work experience

Hedley International Emirates Contracting LLC, Dubai Team Lead –Applications

Dec 2012 – Nov, 2015

Promoted to the Team Lead with the target of stabilizing the IT applications department.

Documented, Implemented and executed Process knowledge SOP’s for DBA tasks and change management for the database development.

Rewrite of Queries with improved execution plans.

Responsible for availability of databases and Web applications along with their management and performance enhancement. Upgrade of Oracle Apps 11i to Oracle EBS release 12 along with database from 9i to 11g .

Maintenance of concurrent processing requests and concurrent managers.

Interact with the functional team; define responsibilities, menus, request groups, users.

Usage different Oracle Applications utilities like Adadmin, Adctrl, Adpatch etc., for maintaining database and applications. Applying latest releases of the application patches from Oracle on Production and test instance to resolve application issues. Coordinate in resolving various performance issues. Code migration for custom development from production environment to Development and vice versa.

Key skills

AREAS OF EXPERTISE

Database Administration

Database Development

Performance Tuning

System Administration

Fusion Middleware Development

PROFESSIONAL EXPERTISE

Excellent analytical and troubleshooting skills.

Well organized and detail oriented with strong

adherence to deadlines.

Experience in EBS Applications Administration,

upgrades, usage of utilities, cloning and report

development.

Strong experience in variety of database

management systems, their architecture,

development and administration.

Experience on multiple Products i.e. Oracle

databases, Oracle Applications EBS/ERP, web

based applications and Website development

and maintenance.

Experience in troubleshooting and resolving

database integrity issues, performance issues,

blocking and deadlocking issues, replication

issues, log shipping issues, connectivity issues,

security issues etc.

Experience in Performance Tuning, Query

Optimization, using Performance Monitor, SQL

Profiler and other related monitoring and

troubleshooting tools.

Ability to detect and troubleshoot CPU,

memory, I/O, disk space and other resource

contention.

Strong knowledge of backups, restores,

recovery models, database shrink operations,

DBCC commands, Clustering, RAC.

Expert experience in implementing operational

automation.

Strong knowledge of index management,

integrity checks, configuration, patching.

Knowledge & hands on experience of tools (

Profiler, DTA, SSMS, SAC, SSCM, PerfMon,

DMVs, system sprocs) (Toad, OEM)

Database Operational support to technical

users.

Page 1 of 3

Hedley International Emirates Contracting LLC, Dubai AppsDBA/DBA/Developer

1

st

Feb 2011 – 1

st

December 2012

Responsible for managing multiple databases and applications. Oracle database & Applications Administration along with maintenance, patching, Performance Tuning.

PL/SQL scripts creation for report making, bug fixing and data fixes.

Setup customized HR solution using Oracle Application Server along with Oracle database.

Oracle Forms and Reports development.

Track issues and verify implementation of corrective actions and solutions.

Support and development requirement fulfillment of customized HR system and Workshop management System using Business Intelligence.

Discoverer with Oracle Applications 11i.

Reviewed the project requirements and proposed the solutions. Training of new database team members.

Wellogic ME LLC, Dubai

Database Administrator/Developer

1

st

May 2007 – 31

st

Jan 2011

Worked on Multiple Oracle and MS SQL server databases for healthcare web application projects.

Reviewed the project requirements and proposed optimal solutions.

Database server installations, configuration and management. Performance monitoring and database tuning.

Identify performance bottlenecks and worked for performance improvement.

PL/SQL scripts creation, executions and change management using Git and subversion control versioning system. Automation of database administration and system

administration tasks using shell scripts.

Coordinated development teams with bug fixing and report making purposes.

Cloning of Oracle and MS SQL Server databases.

Automation of database backup jobs using shell and PL/SQL scripts.

Oracle Data Integrator Implementations and troubleshooting. Migration from Oracle to MS SQL Server database.

Daily scrum reporting with US-Cambridge office.

Technical Skills

TOOLS

Eclipse Netbeans

SQL Developer TOAD

GIT Bitbucket

Database Utilities

Oracle ERP

Apps

utilities

HANDS ON EXPERIENCE PRODUCTS

Oracle 9i

MSSQL

Server

Oracle 10g Perl/Shell

Oracle 11g Linux/Unix

Oracle Forms/Reports Java 6

Oracle Applications 11i HTML,CSS

JavaScript

CERTIFICATIONS/TRAINIGS

Oracle 9i Database Certified Professional

Oracle 10g Database Developer Training

Oracle 11g Database Certified Professional

Redhat Linux 5 Operating system Training

Oracle 11i Applications DBA Training

ACADEMIC QUALIFICATIONS

Heriot-Watt University Dubai 2012-2013

Masters IT Software Systems

University of Karachi, Karachi 2001-2005

BS Computer Science

Govt. Nazerath Girls College, Hyd. 1999-2000

HSC Pre-Engineering

IELTS – Academic 6.5

TOEFL 81

Page 2 of 3

Jaffer Brothers Ltd. Jaffer Consultancy, Karachi

Oracle Apps Technical Consultant

September 2005 – May 2007

Worked on Multiple Oracle Applications and database projects. Reviewed project requirements and proposed the solutions. Implemented and documented the Oracle Applications upgrade projects .

Automation of database administration, Oracle ERP Application. Automation of system administration tasks using shell scripts. Coordinated development teams with bug fixing and report making purposes.

Cloning of Oracle Applications and databases.

Migration of database and Oracle applications across different from operating systems.

REFERENCES

Mr. Talal A.G.Shaikh

Associate Professor,

Heriot-Watt University Dubai,

Mr. George Norman

Director Saas Operations,

Wellogic ME LLC,

Dubai

Mr. Omar Najeeb Khan

Project Lead, Oracle Functional

DuTech LLC

Dubai

Mr. Badar Sami

Assistant Professor,

University of Karachi,

Karachi

CONTACT DETAILS

Huma Omar,

Mississauga, Canada.

Cell: +1-647-***-****

Email: ac0mpn@r.postjobfree.com

Page 3 of 3

Contact this candidate