Oracle Project
Resume:
Ali U. Bajwa
Senior Oracle DBA/Architect East Meadow,
NY
***.*****@**************.***, *************@*****.***
Cell: 516-***-****, Business: 516-390-
1303
Objective
To work as Talented, results-driven IT Tech/Team Lead/Oracle Applications Architect /Sr Oracle Applications DBA
with versatile, cross-platform experience as Oracle APPS DBA and/or Oracle
CRM DBA and/or Senior Systems DBA, anywhere in USA.
Decisive, Action oriented, results focused professional offering 7+ years of experience in IT
industry with last 5+ years focused on project management and Leading the team for various Oracle Applications
Implementation and Database Migration/Upgrade Projects. With a very strong History of turning "Break Even"
projects into profitable projects through delivery of cost saving
solutions as well as enhancing process and designs.
Professional Summary
Over 7+ Years of rich experience working as Oracle DBA (Oracle Server 7.x, 8.0.5, 8i, 9i, 10g, 10.2.0.x,11g,11.2.0
and RAC) and Oracle Applications DBA/Architect with a multiple/cross platform experience on UNIX (Solaris
5.8/10, IBM AIX 5.2/5.3, HP-UX, Linux Red Hat/SuSe and windows).
Over 5+ years of production experience in Financial/Weight Management Industry serving as Senior Oracle
Applications DBA, Tech Lead/Oracle Architect working on Financial, CRM, self service
banking, iProcurement on multiple versions of Oracle Apps 11i (11.0.3, 11.5.4, 11.5.5, 11.5.8,
11.5.9, 11.5.10, 12i) and working as Tech Lead for Stress Testing/benchmarking Oracle
Production System and Oracle Enterprise Data Warehouse, BI integration with
11i Oracle Applications, effectively leading and planning a 24*7 support across
DEV, Business, Functional and Reporting teams.
Lead the team in many successful Oracle Applications 11i upgrades and Database upgrades. Very actively involved in
process documentation and training the team with the design and architecture of Oracle Database with various
components for 24*7 Production support.
Extensively worked on Oracle Database 7x, 8i, 9i, 10g, 11g, Oracle Data Guard (StandBy Database),10g
RAC(Real Application Cluster), RMAN, TOAD, Oracle Enterprise Manager, Oracle Grid Control for Database
monitoring, SQL Analyzer, SQL*Plus, PL/SQL, Oracle Forms 4i/6i Oracle Reports 4i/6i, Apache, Oracle Single Sign
On, RMAN, Veritas Clusters, NetApp, Oracle Workflow, WEB ADI, Oracle Application Server 10G, Oracle
Application server Portal 10G 10.1.2.0.2, LDAP/OID/SSO, 10G AS Infrastructure, Oracle 10G AS Repository, during
the entire lifecycle of projects .
Over 7 Oracle Database Upgrade projects (from 7, 8i, 9i and 10g to 11g), Expertise in
Oracle Server Installations, Upgrades, Capacity Planning, Space Management, Performance
Tuning and Backup & Recovery. Security Administration, Patching, Oracle Database Administration, Data
Modeling, Data Architecting, Oracle Web Application Server, Oracle Parallel Server. Many full life cycle experiences
in supporting and implementing both development and production. Excellent Oracle Database and Applications
1
Troubleshooting Skills. Trained Oracle 9i, 10g Professional, Trained Oracle 10G Application Server Professional
and E-Business Suite.
Major Roles
Sr.Oracle Application DBA/Architect with Weight Watchers International.
Lead for VLDB upgrade and platform Upgrade for Oracle 10g to 11g.
Tech Lead for Data-Guard Implementation and writing Failover and Switchover Processes.
Lead for many Oracle DB performance Tuning Project using OEM, AWR, Statspack and third Party Tools.
Tech Lead for Enterprise Data warehouse Project
Tech Lead for Stress Testing and Benchmarking of 10G Applications Server Portal/Discoverer
with e-Business Suite 11.5.10
Lead the efforts for the successful implementation of Shared Application Top in our Production
Environments.
Tech Lead for Oracle 10gAS upgrade from 10.1.2 to 10.1.3
Lead a successful effort for upgrade of Oracle Applications 11.5.10.2 to 12i.
Involved in many full SDLC of Oracle Applications upgrade projects including Database upgrade
Efficient Project Management and Resource Management skills
Highly efficient in meeting Project Deliverables and Deadlines
Recent Accomplishments
Upgrade 2.5 TB 10g Database to 11.2.0.2
Implemented DR (Disaster Recovery) Site for all Oracle Products within Weight Watchers.
Upgrade VLDB from 32-bit OS to 64-bit OS (Linux), saving 1 million in hardware and license cost.
Implemented 10G OID and LDAP as a Single Sign On (SSO) solution with Oracle
Applications 11.5.10 RUP2 and Microsoft Active Directory.
Worked on Data Off-setting project using Applimation by Infomatica.
Implemented and Architect Oracle Application Server 10G within a short span of 6 weeks saving approx 800-
K for the client.
Lead the team to successful implementation of Shared Application Top technology with Oracle
Applications 11.5.10 RUP2 in Production systems.
Successful implementation of 6 Node Disaster Recovery solution for Production Environment with
Oracle Applications 10G Discoverer/ Reports with in a Clustered environment
2 Node Oracle Data Guard for Database Disaster recovery solution.
LDAP, OID, WebCache and clusters implementation and process definition
Successful implementation of Oracle Applications 11.5.11.2 on Linux VMs.
Various Oracle Database upgrade projects on different version and platforms
Ex: upgraded 9i to 10g, 10.2.0.1 to 10.2.0.5 and 10.2.0.5 to 11.2.0.2
Upgraded Oracle Applications 11.5.9 to 11.5.10 Maintenance Pack Consolidate Update 2
(11.5.10.2)
Upgraded Oracle Applications Database 10.2.0.2 to 10.2.0.5 Version
Installation & Configuration of latest Release of Oracle Applications e-Business Suite 12i
2
Technical Skills
Hardware: IBM AIX p595, Sun v440, v480, v490, 280R, v660, v880, v890, Sun 25K, HP9000
Veritas Clusters, EMC SRDF
Client Server Tools: SQL*Forms(4.5, 3.0, 2.3, 6i,10g), Reports (1.1, 2.0, 2.5, 4i, 6i,10g)
Discoverer Administration (9.0.4, 10.1.2, 10.2.0.2), Discoverer desktop (9.0.4, 10.1.2)
Oracle Enterprise manager Grid Control (10g & 11g)
Relational Database: ORACLE (7.0, 7.1, 8.0.6, 8.1.7.1, 8.1.7.4, 9.0.2, 9.2.0.5, 10g, 11g)
Languages/Products: Oracle Applications, Oracle Financials, Object Library,
Oracle Alerts, Oracle Mail, SQL*Plus, SQL*Forms 6i/9i, Oracle Reports, PL/SQL, Unix
Shell Scripting, Cron processes, SQL Scripting, C, csh, ksh
Operating Systems: IBM AIX 5.3, Sun Solaris 8, Linux RHEL3, Linux RHEL4, Suse SLES9, HP-UX 11.0,X-
Windows, MS-DOS, Windows NT/2000, Digital Unix 4.0b, CentOS 4.0
Experience
Weight Watchers International
Sr.Oracle DBA/Architect
New York, NY
JAN-2008 – Till Date
Project Summary
Tech Lead for Stress Testing and Performance benchmarking for Production Oracle
Applications 11.5.10 RUP2 OLTP system
Tech Lead for Enterprise Database Warehouse Project
Tech Lead for Oracle Business Intelligence Discoverer Integration project
Tech Lead for Various Database Upgraded Project on multiple platforms.
Tech Lead for designing and building DR site in different state than the Primary Datacenter.
Tech Lead for Data Off-Setting project using Applimation.
Automated all Database and application replication from Primary site to DR site.
Architected Globalization Project on Oracle 10g.
Upgraded Oracle Applications to 11.5.10 and migrated to Shared Apps Tier Architecture
Architected the complete infrastructure for the optimal performance of Shared Apps Tier
integration with Oracle Applications 11.5.10
Architected the complete life cycle of 10G AS Portal/OID/LDAP/SSO with Oracle Apps 11i
(11.5.9 & 10) for the scalability of OLTP Production system with 30,000+ users of workload
Defined OID Cloning process with Oracle Applications 11i
Implemented Automatic DB clone using custom Shell Scripts.
Defined a complete 10G Portal Cloning Process with Oracle Applications 11i
Expertise in OID, LDAP and SSO (Single Sign On) implementation and maintenance
Defined 10G Portal 10.1.2 Implementation procedures with Oracle Applications 11i and
trained the team
Oracle Database 8.0.6,8.1.7.4,9.0.2.x,9.2.0.2,9.2.0.3,9.2.0.5,10.2.0.1,10.2.0.2,10.2.0.4
10.2.0.5,11,2.0.2
Configured Data Guard for providing high availability solution for Database
Applied DST patches for all DB lower than 10.2.0.4
Cloning, Backup and Recovery of Oracle Database using RMAN.
3
Fine Tuning Oracle Wait events, Tuning sorts/temp segments
Maintaining Hit ratios of Oracle Database for optimal performance
Identifying top sqls/sessions and tuning
Fine tuning datafile waits and I/O
Monitoring and troubleshooting top cpu/memory consuming processes
24*7 Production Support including US and other countries across the Globe
Oracle Applications 11.5.4, 11.5.5, 11.5.8. 11.5.9 & 11.5.10
Extensive experience in cloning and configuring Oracle Applications using Adclone, Adconfig and
Rapid Clone .
Fixed Assets, Accounts Payables, General Ledger, Procurement,Self Service
Implemented and Configured Multi Languages in 11i Oracle Applications Production system
e.g. Polish, Dutch, French, German etc.
Installed and Configured Dutch,Portuguese, French, German, Latin America Spanish, Polish etc
Languages for Portal
Experienced in working with Single Byte and Multi Byte Character Sets including UTF8
10G Application Server 9.0.4.0.0,10G 9.0.4.0.0 and 10G 10.1.2.0.2
Installation and Configuration of 10G Portal with Oracle Applications 11.5.9
Implemented 10G Web Cache with Oralce Portal and Discoverer for Performance
10G Infrastructure and Repository
10G Discoverer Standalone and with 11i e-Business Suite
Configured 10G Oracle Applications Middle Tiers for Portal and Reports with 11i
Load Balancing 10G Middle Tiers for high availability and COB (Continuity of Business)
10G WebCache Clustering and Middle Tiers Clustering
SSL configuration with Oracle Applications (all 11i releases) 10G AS and WebCache
Enterprise Manager Console, Oracle Process Manager,
DCM control, iAS Console, LDAP, OID-DAS, Portal Repository
Upgraded Oracle Apps 9iApplication Server 1.0.2.2 to 9iApplication Server 1.0.2.2.2
Upgraded Oracle 8i (8.1.7.4) Database to 9i (9.0.2) Database
Upgraded Oracle 9i (9.0.2) Database to 9i (9.2.0.3) to fix Slow Workflow Processing
Upgraded Oracle 9i (9.2.0.3) to 9i (9.2.0.4) to fix Frequent Database Crashes
Upgraded Oracle 9i (9.2.0.4) to 9i (9.2.0.5) to fix SGA and Jsp Memory Leaks
Upgraded Oracle 9i (9.2.0.5) to 10g (10.2.0.2) to Comply with Support.
Upgraded Oracle 10g (10.2.0.2) to 10g (10.2.0.5) for Performance and BUG fixes.
Upgraded Oracle EBS DB 10g (10.2.0.4) to 11g (11.2.0.2) as part of R12 Upgrade.
Expertise in 5 major Oracle Applications upgrades from (11.5.5/11.5.3) to 11i (11.5.9)
including OLTP Production, EDW Production and Development e-Business Suite Applications .
As an Architectural change Implemented and Configured Standalone Version of 10G Discoverer
Migrated 2.5 TB Database (10.2.0.4) from 32-bit Linux to 64-bit Linux.
Implemented MTS for memory savings
Worked with Unix/Systems team for better design of hardware for optimal Oracle DB performance.
Load Balancing JVM’s
Highly effective in Performance tuning Oracle Applications and Database.
Implemented Multi Node Architecture for load balancing Oracle Applications using BigIP and
3DNS Load Balancing Routers
Implemented Compression for Space savings
Implemented OATM in EBS for better tablespace design and space saving.
Implemented Oracle Application Server 10g Discoverer and Reports with EPM 8.9
Configure and strategize the Backup and Recovery operations
4
Configured RMAN for database backups
Extensively worked on Recovery scenarios
Worked on RAC for daily Maintenance.
Worked on Control-M by BMC.
Hardware
Sun Fire 4800, Sun 660, Sun Fire V880, Sun Fire 6800, Sun 1280, Sun Fire E25k,
IBM p595,HP DL-580 G-7.
Veritas Clusters, NetApp.
Operating System
Unix, Linux 4 and 5, Solaris 5.8 Generic and 10, IBM-AIX 5.2/5.3
Windows NT Server version 4.0, Windows 2000 Advanced Server, Windows 98
Citigroup
Oracle DBA
Tampa, FL
Project: Procure to Pay (P2P)
JUL 2005 – JAN 2008
Project Summary
Analyze & Design the Oracle Applications BI Architecture
Address & Fix major Performance Issues for Oracle Apps 11.5.10.2
Supported biggest iProcument Project across Globe with 250,000 users.
Address, define & Implement Cloning Procedures for Oracle Applications 11.5.10.2
Address, define & Implement Patching/Maintenance Procedures for Apps 11.5.10.2
Worked on DB upgrade from 9.2.0.5 to 10.2.0.2
Applied adpatches and Opatches.
Supported all Major releases for international countries.
Applications e-Business Suite 11.5.10.2 Production & Development Systems
Analyze & Architect a long term Oracle Applications Infrastructure strategy.
Worked on AUTOSYS for Job scheduling.
Used Kintana to Deploy Code all systems.
Hardware
Sun-Fire-V480, Sun-Fire-V890, Sun 280R, IBM Linux Servers
Operating System
Sun Solaris 5.10 (SunOS 10), Suse Linux Enterprise Server 9, Windows NT Server version 4.0,
Windows 2000 Advanced Server
Napa Group LLC
Oracle DBA
New York, NY
DEC 2002 – JUNE 2005
Project Summary
Installed and maintained Oracle Database for Trading Application used in Wall Street.
Designed Schema and tablespace architecture for high volume Transaction Application.
Installed Oracle Enterprise Grid Control for Monitoring and performance tuning.
5
Worked with Companies client to solve administration and performance issue (Citigroup etc).
Applied all BUG fixes as part of DOTNET application upgrade.
Upgraded Database from 10.2.0.1 to 10.2.0.2
Worked on SQL-Server Database.
Applied all Required DST patches.
Helped in all Major and Minor releases.
Operating System
Suse Linux Enterprise Server, Windows NT Server, Windows 2000 Advanced Server
Training
Attended Oracle Database 11g Performance Tuning Training from Oracle
Attended Data Guard administration training from Oracle
Education
High School Diploma – John Bowne High School (Flushing, NY)
Information Technology – Hofstra University (Long Island, NY)
All references will be provided upon request.
6
Contact this candidate