概要

I am a tech-savvy professional with over 15 years of experience in Oracle and Applications Database Administration, specializing in the Oracle E-Business Suite (EBS) and complex database environments. Throughout my career, I have developed a strong foundation in Oracle Database technologies, including versions 11g, 12c, and 19c, and have consistently delivered results through my expertise in database installation, configuration, and daily management. I am passionate about optimizing system performance, ensuring high availability, and keeping mission-critical applications running smoothly.


Over the years, I have managed various Oracle EBS environments, taking charge of everything from installation to patching, upgrades, and troubleshooting. My work with multi-node setups, load balancing, and system performance tuning has helped organizations achieve seamless operations. I have a deep understanding of RMAN and Veritas backup tools, which I have leveraged to create reliable backup strategies, while my expertise in hardware sizing and system policy development ensures that my solutions are tailored to meet business needs and industry standards.


In addition to my Oracle experience, I have a strong background in managing SQL Server environments, covering versions 2012 through 2022. I have successfully installed, configured, and maintained SQL Server databases, ensuring optimal performance and security. I am also proficient in working with Oracle Cloud Infrastructure, where I focus on disaster recovery provisioning and proactive system health monitoring to prevent potential risks and minimize downtime.


My technical skills extend beyond database management, as I am also knowledgeable in system administration, middleware, high availability setups, and cybersecurity practices. My goal is to always deliver scalable, secure, and efficient solutions, while ensuring that systems are fully compliant with licensing and regulatory requirements. With strong communication skills and a knack for solving complex technical challenges, I take pride in my ability to align IT operations with the broader goals of the business.

项目

LESCO Upgrade
LESCO EBS 11i to 12.2.4 Upgrade

工作经历

公司标识
Oracle DBA / Apps DBA
A’Saffa Foods (S.A.O.G)
Mar 2021 - 代表 | Muscat, Oman

Manage Oracle Database R12.2.7 (12.1.0.2.0) of a1TB multi-node environment to ensure high availability and load balancing with parallel processing (PCP) and Oracle Enterprise Command Center. Play an integral role in supervising WebLogic, Apache Tomcat, IAS, Discoverer, and Qlik Sense systems. Supervise Vansales Solution while using Apache Tomcat and AngularJS platforms. Hold full accountability for maintaining product licensing and compliance for database, application, middleware, and OLVM environments. Manage an IT ticketing solution (SolarWinds) to capture, organize, manage, and automate tickets as well as resolve network performance problems/outages. Implement Oracle GoldenGate to execute and replicate data. Assume and maintained full liability for DR site provisioning, DR health monitoring, and troubleshooting on Oracle Cloud Infrastructure.
Key Accomplishments

Enhanced system performance and optimized resource utilization through Oracle Enterprise Command Center, Oracle Discoverer, and Oracle Linux Virtualization Manager (OLVM v4.3) management across production, development, and test environments, including LUN volume mounting with OLVM, failover, and maintenance.
Managed RMAN and Veritas backups (hot, cold, full, incremental) and performed daily health checks, periodic restorations, and offsite backup placement in bank vaults for data integrity and security.
Improved SQL Server performance through attendance management via heterogeneous DB links, periodic backups, recovery, and regular health checks.
Set a benchmark of excellence by enhancing application, database security through proactive health checks, automation via scripting, and Cron jobs.
Optimized middleware environments using WebLogic, Apache Tomcat, Oracle SOA Suite, OBIEE, and Qlik Sense for applications, plus Vansales Solution (Angular JS-based) and SQL Server Attendance Management via heterogeneous DB link.
Played a key role in executing data replication, migration projects, including Oracle-to-Oracle (Windows to Linux) using tablespaces, SQL Server to Oracle via Migration Repository, and Oracle-to-Oracle replication with GoldenGate.
Resolved performance bottlenecks by analyzing AWR, ADDM, top, sar reports related to resource utilization, query, index, concurrent processing through timely and proactive measures.
Designed SOPs for hardware sizing, application usage, audit compliance, recommended solutions, and conducted POCs for Oracle Cloud, ClickSense, Oracle Apex implementations.

公司标识
Oracle DBA / Apps DBA
Mukhtar A. Sheikh Hospital
Aug 2018 - Mar 2020 | Multan, Pakistan

Administered Oracle E-Business Suite (EBS) R12.1 and R12.2 with database upgrades from 11g to 19c while managing migrations and updates including R12.1.3 to R12.2.6 and R12.1.3 to R12.2.9. Led the installation, cloning, patching, upgrading, backup, and recovery of the core database management. Created database Health check reports, such as AWR, ADDM, and OEM. Configured Oracle Learning Management with Content Server and WebLogic 12c to enhance OLM functionality. Managed Middleware and Application Servers, including Oracle WebLogic and Apache Tomcat to improve system performance. Performed OBIEE installation and configuration, Samba setup on Linux, and SOA Gateway configuration for seamless integration. Administered MongoDB 4.0 and 4+ for healthcare IoT data, including deployment, backup, and recovery. Managed tasks using Freedcamp and handled basic issues with JIRA.
Key Accomplishments

Administered Oracle Apex 5 to 20.2, configured Oracle APEX with BI, Apache Tomcat, ORDS, Jetty Server, and SSL for HIMS, and supported ERP, Apex development while coordinating with technical teams.
Installed and configured Oracle Data Guard, Oracle OBIEE 12.2.1.3/12.2.1.4, and Oracle Hyperion Planning.
Administered SQL Server (2012, 2016, 2019, 2022), integrated Oracle 12c with 2014, implemented Always On Availability Groups, conducted routine DBCC checks, and managed backup, recovery, security, health monitoring.

公司标识
Apps DBA E-Business Suite R12
ESN Soft
Mar 2016 - Jul 2018 | Multan, Pakistan


Upgraded database from 11.2.0.1 to 12.1.0.2, from R12.1.3 to R12.2.6, and R12.2.0 to R12.2.7 Delta 10.
Managed the full lifecycle of EBS environments, including installation, cloning, patching, upgrading, backup/recovery, ensuring minimal downtime and robust data protection.
Installed FMW and WebLogic as well as provided support to members to ensure optimal performance.

公司标识
Oracle Associate Application DBA
Inbox Business Technologies (Pvt) Ltd.
Mar 2015 - Feb 2016 | Lahore, Pakistan

Worked as an Apps Database Administrator for various clients, such as
Lahore Electric Supply Company, Lahore, Pakistan

Achieved targets within time by collaborating with technical teams.
Upgraded EBS from 11.5.10.2 to R12.2.4 with database migration from 9i to 12cR1, and from R12.2.0 to R12.2.7.
Completed R12.2.0 to R12.2.4 64-bit upgrade and executed 11i multi-node cloning on Oracle Linux 4.8 64-bit.
Implemented online patching for R12.2.4, integrated EBS with SSO to simplify user access and authentication processes.
Managed service requests (normal, escalated, OWC) and administered ASM and Fusion Middleware.

Haleeb Foods Limited, Lahore Pakistan

Led R12.2.4 re-implementation on Oracle Linux 6.7 64-bit, including installation, upgrades, backup, recovery for smooth transition and minimal disruptions.
Guaranteed swift resolution of complex patching issues faced by functional and technical teams in a timely manner.

Punjab Vocational Training Council (PVTC), Lahore Pakistan

Worked on the R12.1.3 implementation project on Oracle Linux 5.8 64-bit and handled various tasks such as installation, upgradations, backup/recovery, patching, issue resolutions faced by various team.

Nishat Chunni Power Limited, Lahore, Pakistan

Provided R12.1.3 support, executed patching, and offered technical, functional team assistance for prompt issue resolution.

公司标识
Oracle Apps DBA E-Business Suite R12
ESN Soft
Apr 2013 - Feb 2015 | Multan, Pakistan


Installed, configured, and maintained Oracle products on Linux platforms as well as upgraded E-Business Suite from R12.1.1 to R12.1.3 on Red Hat 5.4 (32-bit) to ensure improved functionality and stability across applications.
Led maintenance activities on Oracle Apps, such as installations, cloning, patching, and adding new products to installations.
Led patching, executable relinking, and maintenance of reports using AD Patch, AD Admin, AD Relink, and AD Merge.
Examined maintenance packs, family packs, rollup patches, and one-off patches for databases and applications.
Planned, designed, and executed database backup and recovery mechanisms using RMAN to ensure robust data protection for development environments.

公司标识
Oracle DBA
Chemical Kinetics
Feb 2011 - Mar 2013 | Lahore, Pakistan


Installed, configured, troubleshooted, and maintained database systems to ensure optimal performance and reliability.
Implemented and configured database instances, replication, backups, partitions, storage, and access controls, resolving any issues encountered.
Administered and maintained Oracle Core DBA servers (up to 11gR2) for mission-critical, 24/7 applications with large databases, ensuring high availability, security, and efficient backup recovery.
Planned and executed data synchronization across multiple development, testing, and production environments, while evaluating and applying system upgrades and enhancements.

公司标识
Software Developer/ Database Administrator
SE Software Technologies
May 2009 - Feb 2011 | Multan, Pakistan


Led the design and maintenance of new and existing websites, ensuring seamless user experience and functionality.
Created landing pages and email templates that increased user engagement and conversion rates.
Improved the aesthetic appeal, functionality, and overall performance of websites through consistent enhancements.
Resolved technical issues, ensuring smooth and efficient website operation.
Developed user-friendly, visually appealing websites optimized for easy navigation.

学历

Bahauddin Zakariya University
硕士, , MSc E-Commerce‎
2009

技能

熟练 Oracle Backup & Recovery
熟练 oracle application R12
熟练 database architecture a
熟练 Linux
中级 Perl
中级 Unix
中级 AI developer
熟练 Analytical Skills
初学者 API Development
中级 Artificial Intelligence Knowledge
中级 Automation Languages Command
熟练 Backup configurations and Monitoring.
中级 Big Data
中级 Classroom Observation
中级 Cloud Administration
熟练 Configuration and monitor clustering.
熟练 Configuration of high availability features.
熟练 CV Screening Skills
熟练 Data Administration
熟练 Data Engineering
熟练 Database
中级 Database Vault
中级 Dataware House
熟练 DBA
熟练 Designing of database.
初学者 Django
中级 Enterprise Security
初学者 Experienced in ETL (Extract-Transform-Load)
熟练 Field Data
初学者 Git
中级 GUI Framework
中级 Hadoop
熟练 Handling Assignments
中级 Hortonswork
熟练 Internet
初学者 Keras
中级 Language Models
熟练 Linux System
中级 mail-flow troubleshooting Virtualization - VMware
中级 Masking
初学者 Mercurial
中级 Mongodb
初学者 MSSQL
初学者 MySQL
熟练 Operational Tasks Handling
熟练 Oracle
熟练 oracle 10g RAC DB installation
熟练 Oracle 8i 11g
熟练 Oracle Administration
熟练 Oracle Administrator

语言

初学者 阿拉伯语
熟练 英语
熟练 乌尔都语

Hammad 联系人

Muhammad Ajmal Atta
Bio Track Enterprises