Muhammad Usman Email & Phone Number

Lahore, Punjab, Pakistan

As a Database Team Lead, my responsibilities include:Overseeing the management, maintenance, and optimization of databases and applications to ensure optimal performance.Proactively executing version upgrades to maintain system integrity and performance.Leading and managing the database team, fostering collaboration, and coordinating team activities to achieve objectives.Efficiently managing time to meet deadlines and project milestones.Proactively identifying, addressing, and resolving database and application-related issues.Overseeing the maintenance of international clients' infrastructures, including databases across production, development, quality assurance, staging, and pre-production environments.Managing Agile PLM environments to ensure seamless operations.Lead internal and external support and consultancy portals, addressing tickets, and coordinating activities within the team.Establishing and overseeing support functions, including planning, tracking, reporting, quality management, and internal communication.Developing and maintaining comprehensive project plans to ensure alignment with project objectives.Upholding client SLAs by providing support, maintenance, administration, monitoring, automation, participating in meetings, and managing requirements engineering.Managing high-volume, high-transaction databases with proficiency.Executing successful migrations of production databases.Providing comprehensive instance-level performance monitoring and tuning for event waits, sessions, and memory usage.Applying quarterly patches, maintenance updates, and interim patches across all databases.Leading upgrade initiatives for production databases, navigating evolving challenges.Operational Support: Supporting end-of-day (EOD), end-of-month (EOM), and end-of-year (EOY) operations concerning application and database functions.Supporting 24/7 production environments, addressing critical issues, and resolving problems promptly.

Lahore, Punjab, Pakistan

As a Senior Database Administrator, I am responsible for the architecture, design, implementation, and maintenance of our company's and client's database systems. I ensured optimal performance, security, and reliability of databases across multiple environments, including on-premise and cloud-based solutions. My role involved leading complex database projects, collaborating with cross-functional teams to design and implement database strategies, and troubleshooting critical issues that affect business operations.Key Responsibilities:Design, deploy, and manage database systems to support business applications and services.Perform database optimization and tuning to ensure high availability and performance.Implement robust backup, recovery, and failover procedures to maintain data integrity and security.Lead database migration, upgrade, and consolidation projects.Develop and enforce database best practices, including security protocols, monitoring, and performance tuning.Collaborate with development teams to design scalable and efficient database schemas.Automate routine tasks and create scripts to streamline database operations.Monitor database systems and proactively identify and resolve potential issues.Provide mentorship and guidance to junior database administrators and other technical staff.Stay current with the latest database technologies, trends, and best practices.

Lahore, Punjab, Pakistan

Being a Database consultant following were my responsibilities:-• Installed and Configured Oracle 11g, 12c and 19c in Development, Staging, and Production Environments.• Installation & Configuration of Oracle EBS R12 (Single & Multi-Node) • Upgrade, platform Migrations, Tuning, RDMBS Patching, and management of complex 24×7 environments.•Perform Cloning the Oracle Production Instance for Dev, Test Environment, and Patches as per requirement• Oracle Data Guard 10g/11g/12c/19c (Fail Over, Switch Over, Snapshot)• Monitoring the scheduled backup procedures daily using OEM & crontab. • Providing instance-level performance monitoring and tuning for event waits, sessions, and memory usage with the help of AWR. • Applying upgrade quarterly patches, maintenance, and interim patches on all the databases. • Expertise in Oracle ASM Administration/Installation. • Managing Oracle Backups of More Than 50 Systems for daily, weekly, monthly, and Yearly.• Performing backup and recovery using Oracle user-managed backup such as automated or manual RMAN cold and hot backup procedures. • Managing storage for archive logs and database • Migrate database across different servers using data pump expdp/impdp and perform database refresh and RMAN Recovery.• Perform RMAN Point-in-Time Recovery daily after EOD operation and on Requirement. • DR and HA Machine synchronization with Production databases and Application • Upgrade Production Databases from 11g to 19c and 11g to 12c• Upgrade EBS Application from 12.1.2 to 12.2.11 and Database from 11g to 19c • Handle evolving challenges associated with upgrading Oracle EBS 12.1.2 to EBS 12.2.11• Preparing Documentation for R12.1.x and R12.2.x HOT CLONE using Recovery Manager. • Applied Patches, Cloning, and troubleshooting of Oracle E-Business Suite Release 12 in a Multi-Node environment. • Supported 24/7 production support and solved all kinds of critical problems. Gather client project requirements.

Lahore District, Punjab, Pakistan

As a Resident Oracle Apps Database ConsultantI successfully led and executed the following upgrades across both development and production environmentsOracle Database Upgrade from 11.1.0.7 to 12.1.0.2The project involved upgrading the Production Database from version 11.1.0.7 to 12.1.0.2. The upgrade process began by transitioning the database from 11.1.0.7 to version 11.2.0.4. the database was further upgraded to the 12.1.0.2 release on Linux 6.Conversion of Oracle Database Architecture from 32-bit to 64-bitThe Oracle Production Database was converted from a 32-bit to a 64-bit architecture. This conversion was necessary to facilitate the database upgrade to the latest release.Oracle Database Upgrade from 11.1.0.7 (32-Bit) to 19.14.0.0.0 on Red Hat Linux 8.3The Production Database was upgraded from version 11.1.0.7 to 19.14.0.0.0. The upgrade process included several key steps:The initial step involved converting the 11.1.0.7 Database from a 32-bit to a 64-bit architecture.The database was then upgraded from 11.1.0.7 to version 11.2.0.4 on Linux 4.5.A backup of the 11.2.0.4 database was taken and restored on an upgraded OS, Red Hat Linux 7.5, to address compatibility issues.In the final step, the database was upgraded to version 19.14.0.0.0, incorporating Oracle's multitenant architecture (CDB and PDB).Following the upgrade, backups of the 19.14.0.0.0 database were taken from Linux 7.5 and restored on the latest Red Hat Linux 8.3.Oracle E-Business Suite Upgrade from R12.1.2 to R12.2.11Following the database upgrade, the Oracle E-Business Suite was upgraded from release R12.1.2 to R12.2.11. This project required meticulous management of timelines and involved continuous, non-stop support over 52 hours to complete the production activity. The system handover was achieved 12 hours ahead of the expected completion time. Post-upgrade, I provided comprehensive support, ensuring system stability by applying necessary backups and synchronizations.

Lahore, Punjab, Pakistan

As a Resident Oracle Apps Database ConsultantI successfully led and executed the following upgrades across both development and production environments:Oracle Database Upgrade:Initial Upgrade: Upgraded the Oracle Production Database from version 11.1.0.7 to 11.2.0.4.Compatibility Adjustment: Due to OS compatibility issues, I backed up the upgraded 11.2.0.4 database and restored it on an upgraded OS (Linux 7.5).Final Upgrade: In the final phase, the database was further upgraded to version 19.11.0.0.0, implementing Oracle's multitenant architecture (CDB and PDB).Oracle E-Business Suite Upgrade:Upgrade Process: Upgraded Oracle E-Business Suite from R12.1.3 to R12.2.10 following the database upgrade.Project Management: I managed all project timelines independently, completing the Production upgrade in a continuous, non-stop 16-hour session, delivering the upgraded system 10 hours ahead of the expected completion time.Post-upgrade, I provided comprehensive support, including applying necessary backups and synchronizations to ensure system stability.

Lahore, Punjab, Pakistan

Master Of Science - Ms, Project Management, A

Bachelor'S Of Science, Computer Science, A