IMRAN ALI 
[Send email using form at bottom]  (484)-432-8828
____________________________________________________________________________________
Visa Status:
•	Permanent Resident (Green Card)
____________________________________________________________________________________
Synopsis:
•	Overall 8+ years of IT experience in various roles of  Database Management,
Project Management, IT Infrastructure Management, Data Center Designing and
Migration Management, Security Audits & Compliance Management (SOX, SAS70 &
HIPAA), IT Operations Management, Release & Configuration Management, Managed
Services, Production Support, Global Delivery Models (On Site / Off Shore),
Applications Support Management
•	In-depth knowledge and experience in full life-cycle database including data
architecture, logical and physical database design, data modeling,
implementation, and administration
•	Extensive experience in planning, installing, configuring, and administering
multiple Oracle databases in  UNIX  & Windows environments using RAC & Dataguard
technologies
•	Hands-on experience in designing, developing, and implementing Extraction,
Transformation, and Load (ETL) techniques on multiple database platforms and
operating system environments using today's cutting edge technology
•	Solid skills in SQL Server database optimization and performance tuning for
servers, applications, and SQL queries
•	Experience in designing enterprise-wide database backup/recovery plans,
implementing failovers and replication procedures
•	Proven ability to deliver high quality products and services on schedule and
under budget
•	Experience in supervisory, team leadership and working with global teams
____________________________________________________________________________________
Key Skills/Attribute:

Operating Systems: UNIX (HP-UX/HP-AIX/Solaris/Linux), Window NT/XP/2003, VMS
Databases: Oracle 8i/9i/10g/11g, SQL Server 2000/2005, MS Access 97
Applications Servers: E Business Suite 11i, Oracle Application Server 10gR2
Tools: Grid Control (OEM), DataPump (export/import), SQL*Loader, TOAD, AWR,
Statspack, ASH, SQL Navigator, SQL Developer, Mercury Load Runner, Informatica,
Cognos, Hyperion
Packages: Oracle Warehouse Builder (OWB), Oracle Streams, Oracle Discoverer/BI,
Business Objects
Languages: SQL, PL/SQL, C/C++, Shell Scripting (ksh/perl)
CASE Tools and Design: Oracle Designer, ERWin
Hardware: HP Superdome Servers, Blade Integrity Servers, Sun Enterprise Servers,
Dell Itanium Servers 
____________________________________________________________________________________
Professional Experience:

GMAC Financial Services								     09/07 – 01/09
Senior Database Administrator		

Administer Oracle & SQL Server databases; manage 200+ Oracle/SQL Server database
instances sizes over tera bytes with clustering & dataguard technologies in
HP-UX, Solaris, and Windows platforms. Configure and support Oracle databases
using High Availability HP Service Guard Cluster packages. On-going support for
an Oracle 10g data warehouse databases using traditional data warehousing
techniques (star schema, data cleansing ETL, cube dimension and hierarchy
maintenance) and use informatica tool for ETL jobs. Replication support using
Materialized Views & Oracle Streams. Build & maintain data models using ERWin,
reverse engineer the system, maintain logical, physical and dimensional objects.
Perform RMAN backup and recovery, clone full and part of databases using
export/import utility. Perform Oracle software installation, database creation,
and several database upgrades from Version 9i to 10g. Perform extensive upgrade
and overhaul to an existing data warehouse system. Apply software patches
quarterly via Metalink CPU alert. Use 10g Grid Control & TOAD for database
administration and maintenance tasks. Installed Grid Control agents on different
platforms and fixed issues with agent’s installation. Monitor database
performance using AWR reports and tune the databases and associated applications
based on SQL Tuning advisors. Work actively with Oracle Metalink support on
different database issues, duty managed tasks. Provide 24x7 database on-call
support.
Major Accomplishments:
•	Key roles in 10g upgrades (OLTP/DW) & Oracle/SQL Server database server
consolidation project
•	Involve in testing the HP Service Guard failover on Multi node environment.
•	Design SQL Server security management policies involving encryption & Kerberos
authentication
•	Design a plan for rolling out CPU quarterly patches as part of SOX
requirements

SunGard Data Systems								     06/05 – 09/07
Database Engineer

Managed Oracle & SQL Server databases. Conducted server performance tuning and
performed backup & recovery using RMAN in Windows & Linux environments. Used
Server Management studio for database management tasks. Used SSIS tool for data
migration, performed snapshot and transactional replications. Define security
policies of the physical databases files using NTFS permissions. Design star
schema, established dimensions & ETL interfaces (Informatica, PL/SQL). Build data
models for legacy systems using ERWin & Visio tools. Analyzed data complexity,
remediate decision making process and understood complex business rules.
Installed and configured 2-node RAC cluster and Oracle Application Server 10g
Rel. 2 on Linux Itanium. Ran Loadrunner for capacity planning & performance
benchmarks. Configured J2EE based application servers, SSO, OID, SSL, WebCache,
BI, Portal, Web Services, SOA suite, OWB. Provided support for Linux operating
system, apply packages and create users/groups.

Major Accomplishments:
•	SQL Server migration from version 2000 to 2005
•	Production RAC machine setup for Oracle Databases & Applications Server
System
•	Oracle database upgrades from 9i to 10g & database migration from Windows 2003
to Linux 4.0

Unisys Corporation									     05/01 – 06/05
Oracle Financials DBA

Responsibility included: 24x7 architecture support, maintenance and
implementation of the Worldwide Corporate Databases and Oracle ERP Applications
version 11i, running on Windows 2003 64-bit. Support included proactive
monitoring, trouble shooting & performance tuning. Involved in various Oracle
database migration from UnixWare to Windows 2003 64-bit server. Applied database
and applications software patches & database cloning for Oracle Applications.
Used TOAD to perform reverse engineering tasks.

Major Accomplishments:
•	Oracle Financials Applications upgrade from 11.0.2 to 11i (11.5.8)
•	Oracle Database migration from UnixWare to Windows 2003 (64-bit) platform
•	Database upgrade Oracle 8i (8.1.7.4) to oracle 9i release 2 (9.2.0.4)
•	3rd party applications upgrade to Oracle 10g using Oracle Failsafe & MSCS
technology

Michigan Peer Review Organization							     11/00 – 05/01
Oracle DBA

Responsibility included: Database Administration and Tuning activities with
Oracle 8i. Ran Statspack to gather performance statistics of Oracle 8i testing
environment. Monitored and tune database performance, network bandwidth, and
space memory usage. Developed reports using Oracle Data on Oracle Discoverer 3i.
____________________________________________________________________________________
Education:
•	Master in Science in Computer Science from Pennsylvania State University (2005
- 2008)
•	Bachelor in Science in Computer Engineering from SSUET, Pakistan (1994 -
1998)
____________________________________________________________________________________
Professional Training:
•	5-days Oracle Performance Tuning Class
•	2-days Oracle RAC workshop
•	Oracle Database Administrator Certified Professional (OCP)
____________________________________________________________________________________
References: 
•	Available upon request