
Mohsin Ali
Senior Multi-Cloud Database Architect | High Availability
Salary / Daily rate
Dubai - United Arab Emirates
Freelance, open to permanent contract
Skills
Languages
About me
Intro
Multi-cloud database architect with 10+ years expertise in Oracle, MySQL, MongoDB, PostgreSQL systems. Led zero-downtime migrations, implemented HA clusters reducing failover to under 5 minutes, and managed enterprise-grade CI/CD pipelines. Specialized in cloud migrations, automation, and delivering SLA-driven database solutions for mission-critical systems.
Work experience
Lead Technical Architect
Confidential
Mar 2025 - Present
1 year 8 months
Dubai - United Arab Emirates
- Leading enterprise-grade CI/CD pipelines on Kubernetes/OpenShift using Jenkins, GitLab, and GitOps - Architecting and deploying MongoDB ReplicaSets with advanced security and replication strategies - Implementing Redis Sentinel/Cluster for HA and caching to support high-performance applications - Designing and managing PostgreSQL Patroni clusters with automated failover and replication - Engineering MySQL InnoDB Clusters with Group Replication and zero-downtime patching - Administering SQL Server Always-On Availability Groups for mission-critical systems - Delivering Oracle 19c upgrades, migrations, and patch management across multi-platform estates - Managing Oracle Fusion Middleware/WebLogic clusters with ADF application deployments - Driving cloud migrations to OCI and AWS, leveraging DMS, GoldenGate, and automation frameworks - Building custom automation with Ansible, Python, and Shell scripting for efficiency and resilience - Leading cross-functional teams of DBAs, DevOps, and engineers to deliver SLA-driven outcomes - Enabling enterprise observability and monitoring with Prometheus, Grafana, and ELK stacks.
Postgres/ Cassandra/ MongoDB Consultant
HosstedFreelance
Jul 2024 - Present
2 years 4 months
Senior Database Specialist
Singtel
May 2024 - May 2025
1 year 1 month
Singapore
SQL Server Consultant
Digital Dolphin Technologies LLC FZ
Aug 2024 - Dec 2024
5 months
Dubai - United Arab Emirates
Sr. Database Administrator
Gulf Business Solutions
Feb 2024 - Jul 2024
6 months
Dubai & Riyadh
Central Bank of The UAE
Apr 2022 - Mar 2024
2 years
Abu Dhabi - United Arab Emirates
Senior Database Analyst - Team Lead
Oct 2022 - Mar 2024
1 year 6 months
Abu Dhabi - United Arab Emirates
Experienced Database Administrator with expertise in multidimensional databases, data warehousing, and Oracle, MySQL, MongoDB, YugaByteDB, and PostgreSQL systems. Key Achievements: - Successful Oracle migrations, installations, and upgrades. - Disaster recovery implementations and Oracle EXACC X10M-2 deployments. - Proficient in MySQL high availability, user management, and backups. - Skilled in MongoDB data replication, index optimization, and robust backups. - Accomplished YugaByteDB orchestrator, ensuring fault tolerance. Additional Strengths: - Proven leadership in technical projects and disaster recovery solutions. - Versatility across AIX, Solaris, Linux, and Oracle WebLogic Suite configurations. With a proactive and customer-focused approach, I collaborate effectively. Seeking opportunities to connect on LinkedIn. Known for meticulous attention to detail, managing budget allocations, and supporting data warehousing strategies. Specializing in Oracle migrations, I've also installed Oracle RAC 12c on AIX 7.2, upgraded databases, and managed EXACC X10M-2 deployments. Contributions include reducing Oracle licensing costs, installing Oracle WLS, SOA & EPM, and deploying SOA composites. In MySQL, I excel in installation, configuration, and support, including InnoDB Cluster setups. MongoDB expertise includes data replication, index optimization, and robust backups. As a YugaByteDB orchestrator, I've ensured fault tolerance and optimal performance. In PostgreSQL, I've managed user roles, access permissions, and authentication in EDB, with expertise in query optimization and routine maintenance. My comprehensive skill set and experience make me a valuable asset in database administration. Excited about connecting on LinkedIn for potential collaborations in this dynamic field.
Specialist - Database Administration
Apr 2022 - Oct 2022
7 months
Abu Dhabi - United Arab Emirates
Oracle DBA Responsibilities: - Install, configure, and upgrade Oracle database software. - Monitor and optimize Oracle database performance. - Design and implement HA and DR solutions using Oracle RAC and Data Guard. - Develop HTML-based health check reports for Oracle databases. - Troubleshoot and resolve Oracle database issues. - Automate tasks using Shell and Python scripting. - Perform security assessments and implement necessary security measures. - Plan and follow the complete Oracle database upgrade lifecycle. - Develop centralized backup reports for Oracle backups. MySQL DBA Responsibilities: - Install, configure, and upgrade MySQL database software. - Monitor and optimize MySQL database performance. - Design and implement HA and DR solutions using MySQL Cluster and ClusterSet. - Develop HTML-based health check reports for MySQL databases. - Troubleshoot and resolve MySQL database issues. - Automate tasks using Shell and Python scripting. - Perform security assessments and implement necessary security measures. - Plan and follow the complete MySQL database upgrade lifecycle. - Develop centralized backup reports for MySQL backups. MongoDB DBA Responsibilities: - Install, configure, and upgrade MongoDB database software. - Monitor and optimize MongoDB database performance. - Design and implement HA and DR solutions using MongoDB replica sets. - Develop HTML-based health check reports for MongoDB databases. - Troubleshoot and resolve MongoDB database issues. - Automate tasks using Shell, Python, and appropriate scripting languages. - Perform security assessments and implement necessary security measures. - Plan and follow the complete MongoDB database upgrade lifecycle. - Develop centralized backup reports for MongoDB backups.
Database Administrator | FMW | SuperCluster | Exadata (MENA)
Kuwait Food Company (Americana)
Nov 2019 - May 2022
2 years 7 months
Sharjah - United Arab Emirates
• Managing 24x7 Database servers using oracle 11g R2 RAC, 12c R1 RAC,18c RAC, 19c Data-guard, and Enterprise grid controls to meet high availability and data protection of nonstop business operations. • Installing, Configuring, patching, upgrading and migrating live DB servers with minimal Downtime. • Managing online backups of servers, testing, validating and storing on tape to keep historical Data safe. • Oracle SuperCluster M7 and Exadata storage administration, configuration and patching management. • DR setup for all critical application, performed switch-over to test DR • Cross-Platform database migration from Windows to AIX 7.2. • Database upgrades and migrations. • Oracle fusion middleware Web-logic 11g/12c server administration, configuration and troubleshooting and 12c WebLogic Suite Clustering on 2-node. • Have experience in data Extraction, Loading and Transformation. • Govern the development, including operational procedures of the IT infrastructure services • Providing advice and leadership regarding the development and improvement of IT services • Install, Configure and Administer Oracle Cluster-ware / Grid Infra Structure • Apply patches to an Oracle application and database tiers. • Plane and Configure RMAN backups. • Migrated DB2 database from On-premises to MySQL database hosted on Ali Baba cloud. • Migrated MS SQL Server 2016 on Windows Server 2012 to Oracle 19.3 on AIX 7.2 using Oracle GoldenGate nearly 0-downtime. • Experience of Administration of SAN/NAS i.e. adding and configuring LUNs, provisioning, zone volume group etc. • Helping Developers in develop and tuning custom forms and reports. • Automate Oracle Data-guard Switchover/Failover, using Shell Scripting. • Data Center Management, working on OVM and MS Hyper-V. • Providing high availability solutions to business by deploying Data Guard refining operating procedures to enable switchovers and failovers in less than the agreed SLA of 5 minutes for key business systems.
Senior Database Consultant
Al Hilal Bank
Dec 2018 - Dec 2019
1 year 1 month
Abu Dhabi - United Arab Emirates
• Support for High Available 24x7 Databases • Responsible for any technical issues related to Databases • Defining, implementing and monitoring Backup and Recovery strategy. • Oracle EBS R12: Install, Patch and Maintain Applications • Cloning the Production databases to different systems and supporting the application team for database related activities. • Applying CPU Security Patches according to release of the Oracle Support • Administration Oracle Target Database using EM Grid Control • Upgrade activities oracle database servers from Oracle 10g and 11g to 12c/18c • Following HP open view for Change Management, and Ticketing System to manage and troubleshoot the Oracle Database issues. • Managing oracle 10g IAS server for HPS application (Cards Application) • Implementing business rules and policies for SQL Service accounts and controlling access to SQL Servers by providing object level access to users. MySQL DBA Skill Set: • Benchmark MySQL servers for performance requirements. • Installation, configuration, upgrading and support of different version of MySQL.(MySQL 5.5, 5.7,8.0) • Installation, configuration and support of MySQL InnoDB Custer for High availability setup. • Install MySQL server and create databases as per project requirement. • Deploy and configuration of MySQL Auditing. • Use different tools mysql, mysqladmin, mysqlshell, mysql router to perform administrative activities. • Good Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM. • Use mysqldump, mysqlpump and mysql enterprise backup utilities to take different types of backups. • Prepare and schedule shell scripts to automate backup and configure email alerts. • Ensure proper backup policies are in place to recover from any data and configuration loss. • Proactively monitor MySQL Error Logs for any errors , warnings and take necessary actions. • Provision MySQL instances, both in clustered and non-clustered configurations as per requirement.
Senior Database and Fusion Middleware Administrator @ RTA - ISOFT
Roads and Transport Authority
Apr 2016 - Dec 2018
2 years 9 months
Dubai - United Arab Emirates
Managing 24x7 Database servers using oracle 12c R1 RAC, Data-guard and Enterprise grid controls to meet high availability and data protection of nonstop business operations. Installing, Configuring, patching, upgrading and migrating live DB servers with minimal Down time. Managing online backups of servers, testing, validating and storing on tape to keep historical Data safe. Day today support, capacity planning and performance tuning for Oracle Databases. Oracle fusion middleware Web-logic 11g/12c server administration, configuration and troubleshooting and 12c WebLogic Clustering on 2-node. Backup and Recovery Administration. Govern the development, including operational procedures of the IT infrastructure services Providing advice and leadership regarding the development and improvement of IT services Install, Configure and Administer Oracle Cluster-ware / Grid Infra Structure Apply patches to an Oracle application and database tiers. Plane and Configure RMAN backups. End to end Configuration, Management and Maintenance Replication using Golden-gate, Bidirectional replication using Golden-Gate. End to end Configuration, Management and Maintenance Replication using Oracle Streams. Administering through Oracle Cloud control Management Server (EM). Experience of Administration of SAN/NAS i.e. adding and configuring LUNs, provisioning, zone volume group etc. Helping Developers in develop and tuning custom forms and reports. Implementing Oracle Enterprise Manager 11g Grid Control Production machines on Windows and LINUX platforms. Automate Oracle Data-guard Switchover/Failover, using Shell Scripting. Data Center Management. Providing high availability solutions to business by deploying Data Guard refining operating procedures to enable switchovers and failovers in less than the agreed SLA of 5 minutes for key business systems.
Oracle Database Administrator (Core+Apps)
Lamprell
Mar 2015 - Mar 2016
1 year 1 month
Sharjah - United Arab Emirates
Managing 24x7 Database servers using oracle 11g R2 RAC, Data-guard and Enterprise grid controls to meet high availability and data protection of nonstop business operations over Pillar Axiom Storage Oracle. Installing, Configuring, patching, upgrading and migrating live DB servers with minimal Down time. Managing online backups of servers, testing, validating and storing on tape to keep historical Data safe. Day today support, capacity planning and performance tuning for Oracle Databases. Oracle fusion middleware Web-logic 11g server administration, configuration and troubleshooting and WebLogic Clustering on 2-node. Backup and Recovery Administration. Install, Configure and Administer Oracle Cluster-ware / Grid Infra Structure Apply patches to an Oracle application and database tiers. Install Oracle Apps 12.1.1 with Database 11.1.0.7 on Solaris 11.1 on SPARC 64-bit. Upgrade Database from 11.1.0.7 to 11.2.0.3 Upgrade Apps from 12.1.1 to 12.1.3 Convert Database to 2 node RAC Configure Data Guard for DR site Configure/Convert 2 node Apps with Brocade Load-balancer Apps and DB Administration Backup & Recovery (Symantec NetApp) Solaris 11 Administration Pillar Axiom Storage Administration. Upgraded oracle 11i EBS production servers to oracle EBS R12 servers and DB Tiers upgraded from 9i to 10g R2, Patching cloning etc. Cloned Multi node system to single node system (Rapid Clone). Administering through Oracle Management Server (OEM). Experience of Administration of SAN/NAS i.e. adding and configuring LUNs, provisioning, zone volume group etc. Installing, Patching, assigning roles to users in Oracle R12 apps. Helping Developers in develop and tuning custom forms and reports. Upgrade Oracle EBS 12.1.1 to 12.1.3 and upgrade database from 11.1.0 to 11.2.4. Converted single Instance EBS database to RAC using Rconfig. Hands on experience in Managing EBS R12 instances.
Education
University of Engineering & Technology Peshawar
BS (CS)
2005 - 2009
5 years