Senior Oracle Apps

WASEEM CHAUDHRY, Senior Oracle Apps DBA Team Leadership &

Database Management

Bolingbrook IL, 60490, USA, +1-630-***-****, *********@************.*** linkedin.com/in/wchaudhry098

SUMMARY Innovative Infrastructure Architect with 20 years of experience in designing and implementing robust IT infrastructure solutions. Adept at leveraging emerging technologies to optimize system performance and align with business goals. Dedicated to fostering cross-functional collaboration to drive strategic initiatives and deliver measurable results.

WORK EXPERIENCE

01/2016 – Present Senior Oracle Apps DBA Team Leadership & Database Chicago, USA Management, Cook County Government Project

• Installed EBS R12.2.0 and elevated it to version 12.2.14.

• Migrated infrastructure from IBM AIX cloud to Oracle Cloud, ensuring high availability of application systems.

• Executed a comprehensive security matrix deployment within Cook County Government Department.

• Configured and installed BI, SOA, Hyperion, SSO, and 13C OEM on RAC, achieving a high-availability application system.

• Applied all quartile CPU patches in conjunction with database upgrades.

09/2015 – 12/2015 Senior Oracle Apps DBA Team Leadership & Milwaukee, USA Database Management, Spancrete

• Upgraded the application from version 12.1.3 to 12.2.4.

• Delivered comprehensive training to clients on the new features of Oracle E-Business Suite 12.2.4.

03/2014 – 07/2015 Senior Oracle Apps DBA Team Leadership & Lahore, Pakistan Database Management, Inbox

• Engineered and executed a Tier-3 data center with enhanced infrastructure.

• Conducted hardware server sizing and capacity planning to optimize resource allocation.

• Migrated database from version 9.2.0.6 (32-bit) to 12C (12.1.0.2) with 64-bit architecture.

• Facilitated application migration from 11.5.10.2 (32-bit) to R12.2.4

(64-bit architecture).

06/2013 – 02/2014 Senior Oracle Apps DBA Team Leadership & Lahore, Pakistan Database Management, Addvantum Innovative Technology

• Configured RAC on 11g R2, achieving a high-availability application with 12.1.3.

• Established DMZ architecture with R12 (12.1.3) for enhanced security.

• Applied patches for the Arabic Calendar, enabling Arabic language support.

• Contributed to the design of a Tier-3 data center.

• Performed hardware server sizing and capacity planning for system optimization.

• Installed E-Business Suite 12.1.3 effectively.

02/2009 – 07/2012 Oracle Apps DBA & Infrastructure Management, Khobar, Saudi Arabia Al-Mutlaq Group

• Managed the in-house upgrade project from 11i Application to 12.1.3.

• Constructed two data centers in Khobar and Riyadh.

• Deployed RAC and high-availability solutions for Oracle databases and E-Business Suite 12.1.3 applications.

• Implemented a robust Disaster Recovery (DR) solution. 01/2008 – 12/2008 Oracle Core Database Administrator, Lahore, Pakistan HAFEEZ SHAFI TANNERIES (PVT) LTD

• Held complete authority and responsibility for all DBA tasks.

• Oversaw installation of new feature-supported RDBMS, ensuring all pre-install requirements were met, including Oracle Database Upgrade Paths, automatic pre and post-install validations, and simplification of initialization parameters for successful database upgrades.

• Monitored and enforced implemented security policies using various logs and auditing tools to identify and respond to violations.

• Managed data movement within databases and tablespaces utilizing Data Pump Direct Path Considerations and Job Monitoring Views.

• Configured and enabled Advanced Database Diagnostic Monitor

(ADDM) and Automatic Shared Memory Management features to retrieve comprehensive ADDM Reports.

• Optimized database performance through automatic statistics gathering, query optimization using Enterprise Manager, and SQL Tuning practices.

• Ensured database availability by employing backup and recovery strategies with RMAN features, including flashback capabilities and automatic channel failover.

• Enhanced database storage management through proactive techniques such as segment advisor assessments, online segment shrink, and efficient undo tablespace management.

02/2006 – 12/2007 Junior Oracle Apps DBA Database, Lahore, Pakistan ORA-TECH SYSTEM (PVT) LTD

• Specialized in Oracle Databases (versions 10g, 9i) and Oracle Apps Database Administration (11.5.10.2).

• Acquired hands-on experience in planning, installation, backup and recovery, and cloning processes.

• Executed and upgraded Oracle Applications 11i (single and multi- node) to R12 efficiently.

• Executed cloning operations for Oracle Applications 11i and their respective databases.

• Demonstrated troubleshooting expertise across all tiers including Apache, Forms, Concurrent, Admin, and database.

08/2003 – 03/2005 Junior HR Administrator, Dixy Chicken London, UK

• Implemented ERP (Enterprise Resource Planning) systems with a focus on quality assurance.

• Maintained comprehensive data records for all employees, both in- office and on-site.

• Developed a new grading and salary structure, facilitating revolutionary changes within the food industry.

• Performed daily updates to the database system regarding new employee onboarding.

• Crafted advertisements targeting high-profile professionals across various newspapers, irrespective of the construction industry.

• Negotiated and managed contracts with agencies for temporary employees, ensuring timely payment schedules.

EDUCATION

04/2002 – 06/2004 American World University London, UK Master of Business Administration, Human Resource

Management

09/2000 – 04/2002 American World University London, UK Post Graduate Degree, Management Studies

1998 – 2000 Al-Khair University Lahore, Pakistan

Bachelor of Business Administration

SKILLS Oracle Cloud Infrastructure (OCI) Apps DBA

DBA Oracle RAC

Data Guard Linux

IBM AIX Leadership

Oracle Performance Tuning

Security Incident Management

On-Call Support Database Administration

RMAN Enterprise Manager

Data Masking

LANGUAGE English Urdu

Contact this candidate