Objective :
A challenging position as an Oracle Database Administrator where I can
contribute with my technical, innovative and leadership skills.

Summary of Qualifications
•	Oracle Certified Professional (DBA) with experience in deploying global,
business critical applications and production databases in a 24x7 environment.
•	Tune and troubleshoot large production Oracle databases using various tools
and methodologies (AWR, ADDM, Statspack, Explain Plan, Trace files from SQL Trace
and Event 10046 using Hotsos Profiler tool, Alert Log, OEM’s Diagnostic and
Tuning Packs) and Quest Tools (Toad, SQL Xpert, Performance Analyzer).
•	Planning complete backup and recovery procedures during major deployments,
upgrades and patches of applications and technology stack components.
•	Accomplished, innovative, results-oriented professional with proven ability to
identify, troubleshoot, analyze and solve difficult problems.
•	Ability to work under pressure and managing multiple projects with little or
no supervision.
•	Dynamic team player with excellent communication and technical presentation
skills.
•	Well versed with managing databases from sandbox to production while following
strict change management methodologies and maintaining 21 CFR Part 11
compliance.
•	Comfortable working with and guiding development team during complete SDLC
process
•	Identify, resolve and implement appropriate solutions for database performance
problems including changes to physical database design and optimizing sql
queries.
•	Assisting application and system architects with logical and physical database
design.
•	Use vendor resources (Oracle’s MetaLink and Tar escalation procedures) to
solve complex db issues.
•	Currently working on virtualization technologies (VMWare, VirtualBox) on
Window and Linux platforms.

Professional Experience

BLC Consulting: Oracle Production DBA (Pfizer).                                 
                        Aug 2006 – Dec 2008
•	Responsible for deploying and managing several large scale global business
critical production application databases (Oracle Clinical, Documentum, LiveLink)
through the complete SDLC (Production to Sandbox ) on Solaris and WinTel
platforms.
•	Managing the Vertias Cluster installation for Oracle 9i Clinical Trials
Database (2 node cluster- 4Tb)
•	Monitoring MV based replication between active and inactive 9i OC Databases.
•	Provide 3rd level support for OPA suite of products, LiveLink and other
critical applications.
•	Oracle Clinical installation consisted of about 14 databases over 3 servers
totaling 30Tb of storage.
•	Part of a team responsible for planning and upgrading OPA-OC from TMS 4.5 to 
TMS 4.6 and RDC 4.5.3, applying the necessary i-Patches under strict change
control and compliance with 21 CFR Part 11.
•	Upgrades of SNOMED, WhoDrug, MedDRA dictionaries and OC integration with
(AERS) Argus and Aris-G products.
•	Review and optimize server based PL/SQL code (Triggers, Stored Procedures) as
well as complex reporting queries (SQL) prior to deployment into production.
•	Member of a DR planning committee representing the databases of business
critical applications for offsite backup and recovery tests.
•	Planning for complete disaster protection and backup and recovery during major
upgrades (complete infrastructure)
•	Deploy secure password management policy using profiles and custom password
verify function.
•	Work with OC product development team at Oracle to resolve performance issues
post upgrade to RDC 4.5.3.
•	Developed SOP for managing the various environments of OC databases including
cloning of databases.
•	Analyzed and resolved a sticky performance problem for the ECM database
(LiveLink) resulting in a savings of over $250,000 by avoiding the purchase of
additional d/b server hardware.
•	Fulfilling downstream application requirements for OC data (using db-links,
Materialized Views, replication, real-time DataMirror redo log mining)
•	Issue tracking using Service Center and ensuring all SLA’s are met for problem
resolutions.

Keane Canada: Principal Oracle Consultant (Pfizer).                             
                        Aug 2004 – Jul 2006
•	As part of a “Red Team”, identified and resolved sources of severe application
performance problems. Recommended solutions for database included parameter
changes, indexing techniques and partitioning of large tables, resulting in a
reduction of login times from 2-4 mins to about 5 secs.
•	Lead the project to plan and execute the upgrade of Livelink application and
it’s schema.
•	Work with the application vendor’s development team in optimizing the
application sql queries – resulting in two critical patches. Achieved over 200%
reduction in logical and physical i/o’s to the d/b.
•	Develop executive reports to mine application adoption data across regions and
various time zones.
•	Assist various groups (clinical trial, contracts and outsourcing, regulatory
data) with data analysis using sql queries (translating business requirements to
reports).
•	Assist in the creation of a test environment for QA, development and
data-mining reporting requirements. Supervise dba activities for Production
Global Enterprise Content Management Application with database approaching 3 TB
in size (d/b and content).

Shell Netherlands and other clients: Oracle Performance Consultant.             
            	May 2004 – Jul 2004
•	Analyzed and resolved performance issues with Oracle 9i, 10g by analyzing
statspack and sql trace files.
o	Recommended parameter changes to oracle installation
o	Worked with the OpenText consultant to develop a custom patch to resolve
application code inefficiencies
o	Added custom indexes to the schema to improve some of the frequently executed
reports.
•	Assist with the performance optimization of the Oracle Database hosting their
LiveLink application
•	Develop several custom business critical LiveReports (advanced SQL Query
writing)  to expose objects stored in their Enterprise Content (unstructured
content)

OpenText Corp: Oracle Technical Specialist/DBA.		           	                   
 Apr 2000 – Apr 2004
•	Performed Application DBA related activities (SQL*Loader, Export, Import,
Backup up and recovery, Database tuning), migration between Oracle, SQL Server
6.5 and 7.0 and Sybase Adaptive Server V11 and 12.
•	Provided 3rd level support for Enterprise Customers concerning performance
issues with LiveLink on Oracle DB. 
•	Provided on-site Oracle d/b consulting (performance tuning, architecture and
configuration planning) to Enterprise customers in Canada, US and Europe.  100%
success rate in achieving and in some cases exceeding customer expectations.
•	Developed and delivered Oracle training curriculum for OpenText Technical and
Customer Support staff The training reduced the “problem resolution time” for
Oracle related support calls from several days to less than 1 day.
•	Worked closely with the development and QA teams in defining strategies for
enhancements to core products. Recommendations resulted in significant
improvement in the overall performance of the product. In some cases over 400 %
performance improvement was observed.
•	Primary internal consultant to IT, Professional Services, QA and Technical
Sales groups on issues relating to planning, installation, configuration and
optimization of Oracle databases (HA architecture, SAN/Raid/Memory, Kernel
parameters).
•	Conducted technical presentations at LiveLinkUP User conferences in US and
Europe.

Freelance consultant: Oracle DBA/Reports-Forms Development                      
           Jan 1999 – Apr 2000

•	Performed DBA activities (SQL*Loader, Export, Import, Backup up and recovery
and basic tuning). 
•	Configured and set up Report Servers, reports and scripts for automated report
generation, resulting in significant improvement in overall d/b performance and
timely delivery of accurate reports. 
•	Developed client side applications using Developer 2000 tools and Database
triggers, packages and procedures using PL/SQL. 
•	Installed and configured Oracle Web Application Server and 8i Enterprise
Edition on NT. 
•	Developed Web Based Application using Oracle's Web Application Server and
PL/SQL web toolkit. 
 
Technical Skills:
Certifications:	OCP-DBA 8i, 9i, 10g Certified Technician, Novell CNA, MCP-NT
Server
Databases:	Oracle (8,8i,9i,10g, 11g), SQL Server, MySQL, MS-Access, Paradox, 4th
Dim, RDb/VMS
DB/DR Tools: 	RAC, RMAN, Oracle Streams, Data Guard, LogMiner, FlashBack,
OEM(Grid Control)/TOAD/SQL Xpert, performance monitoring tools, Symantec’s VCS
Application Server: 	Oracle's Application Server OAS and 9i iAS.
Developer Products: 	Oracle Developer  2000/6i,9i (Forms, Reports in client
server as well as n-tier configurations), WebDB, HTML-DB, OAS(4.x) and 9iAS,
Crystal Reports, Business Intelligence Publisher, TOAD 9.6/9.7, SQL Developer
1.5.4
Languages:	SQL, PL/SQL, SQL*Plus, C++, Java, VB,VMS-DCL
OS:	Windows NT/2000/XP, Solaris, HP/UX, Red Hat, Ubuntu, Novell, VAX/VMS,
OpenVMS, Oracle’s Enterprise Linux
Virtualization:	Sun’s xVM-Virtualbox, VmWare, Oracle’s VMServer

Education and Professional Development
	Queen's University of Belfast (U.K) B.Sc Aeronautical Engineering 
	Oracle 9i Data Warehouse Administration, Data Warehousing Fundamentals and
Design, Oracle  Warehouse Builder and ETL process
	Apps 11i DBA - Oracle Applications Architecture, Workflow, Install Patch and
Maintain Oracle Apps, System Administrator Fundamentals, AOL (Extend Apps using
Forms)
	Oracle Database (8,8i) Administration Training, 9i New features for
Administrators
	Oracle OCP-Developer Training ( Developing Oracle Apps using Java, installing
and configuring 9iAS, Oracle Forms and Reports 9i, Publishing Reports for the
Web, Adv PL/SQL programming, System Design and Architect) 
	Sun Solaris 8.x System Administration, MS-Windows NT Server, Desktop Admin,
Novell 4.x Admin
	Open VMS System Manager, Performance Tuning and Optimization

References available upon request.