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.

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.

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.

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.

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.

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.

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.