ABD ALRHMAN ALLOUSH

● Manage and maintain 65+ MySQL Sharded clusters (~210 hosts), ensuring high availability, scalability, and optimal performance in production environments. ● Engineered secure and scalable data solutions using AWS RDS, Redshift, and DynamoDB, achieving 99.99% uptime and implementing Extract, Transform, Load (ETL) with DBs, ensuring optimal application performance. ● Architected and deployed scalable, multi-cloud database solutions implementing GCP Cloud SQL, Spanner, and Memorystore, ensuring 99.99% uptime across 200+ applications by implementing robust failover mechanisms. ● Created OpenSearch clusters using the Aiven platform, processing 2TB of log data with 99.99% uptime, and ensured real-time observability for Nylas microservices across production. ● Pioneered infrastructure-as-code automation using Terraform, Docker, Ansible, and Kubernetes, which allowed any developer on the team to deploy applications 5x faster, reducing deployment times by 60%.

* Engineered and maintained over 65 MySQL sharded clusters across approximately 210 hosts, achieving optimal performance metrics and ensuring high availability for mission-critical applications. * Developed secure data solutions utilizing AWS RDS and Redshift, which resulted in a 30% improvement in data retrieval speeds while maintaining robust security protocols across cloud environments. * Spearheaded initiatives to optimize database performance by implementing advanced indexing strategies that reduced query response times by up to 50%, significantly enhancing user experience. * Collaborated with cross-functional teams to migrate legacy systems to cloud-based solutions, achieving a seamless transition with zero downtime and increasing operational efficiency by 40% during peak business hours. Skills: MySQL, AWS RDS, Database Performance Optimization

● Deployed Percona XtraDB Cluster include three servers and configured Percona ProxySQL, achieving a 99.99% uptime and reducing planned downtime by 90%; zero data loss. ● Revamped MySQL database infrastructure, implementing robust backup and recovery that ensured 99.99% uptime and eliminated critical data incidents. ● Engineered a centralized logging system utilizing Elastic Stack (Elasticsearch, Logstash, Kibana), enabling real-time anomaly detection and reducing the time to identify root causes of issues by 75%. ● Optimized OpenACS, Zabbix, and Syslog-ng MySQL databases, achieving a 20% reduction in query response times and improved system stability. ● Directed daily backup operations across databases and all Goknet systems, safeguarding business data

- Administered and optimized MySQL databases, including installation, configuration, performance tuning, database design, and analysis, ensuring stable and high-performing production environments. - Deployed and maintained Percona XtraDB Cluster and ProxySQL, improving fault tolerance, load balancing, and recovery processes, resulting in 99.99% uptime across mission-critical systems. - Implemented Elastic Stack (ELK: Elasticsearch, Logstash, Kibana) for log aggregation, monitoring, and visualization, reducing incident response times by 30%. - Installed and configured MemSQL pipelines to archive and process big data from Kafka, enabling near real-time analytics on streaming data. - Managed diverse databases including OpenACS, Zabbix, and Syslog-ng, optimizing performance and availability to support enterprise IT operations. - Automated daily database, FreeRADIUS, and application backups, strengthening disaster recovery readiness and eliminating data loss incidents. - Conducted database analysis for new projects, applying structured analysis methodologies to ensure scalability, reliability, and compliance with industry standards. - Collaborated with end-users to design and implement new systems, troubleshoot issues, and enhance usability, boosting operational efficiency. - Developed and maintained billing system enhancements, tailoring solutions to evolving business needs and improving invoicing accuracy. - Created dynamic reports using JasperReports (JRXML), streamlining financial and operational reporting workflows. - Integrated banking web services (SOAP, WSDL, XML, XSLT) to automate invoice exports, payment imports, and financial reconciliation, reducing manual workload by 40%. - Directed IT projects as Project Manager, coordinating with outsourced consultants, defining scope, and ensuring on-time delivery.

● Revamped backup and recovery policies for 100+ enterprise clients, decreasing potential data loss by 90% and exceeding client expectations for data integrity, recognized by leadership. ● Spearheaded database administration across MySQL, MongoDB, AWS Aurora (MySQL), and Solr, guaranteeing 99.99% system uptime, resulting in zero data loss events during tenure and exceeding SLAs. ● Diagnosed performance bottlenecks within secondary database environments with a focus on Microsoft SQL Server; and Oracle; maintained system uptime exceeded 99.99% meeting stringent SLAs.

● Chartered curriculum on database design and data analysis, equipping 50+ students annually with skills for Edexcel-accredited programs and achieving a 98% student pass rate on certification exams. ● Delivered hands-on Oracle APEX training to 50+ students resulting in 98% passing rate on Edexcel-accredited database design examinations. ● Mentored 25+ students in database management and Oracle APEX, resulting in learners building and deploying database-driven applications that passed industry-standard performance benchmarks.

● Administered Oracle RAC 10g/11g RAC clusters, handling creation, configuration, troubleshooting, and debugging to ensure reliable delivery of core billing system database services. ● Administered and optimized Oracle 10g/11g databases, developing SQL and PL/SQL procedures, functions, triggers, and packages for mission-critical applications, increasing query performance by 50–60% and supporting 100K+ daily transactions with high availability. ● Improved database performance and capacity planning, and implemented daily backup strategies to protect critical business data. ● Pioneered a custom HR system using Oracle APEX, centralizing employee records, leave requests, cutting HR processing time by 60% and enhancing data accuracy.

[ FEB 2012 - AUG 2012 ]--------- SAMA NET ISP-------- Damascus Syria 1- Training for Database Developer. 2- Checking whole system. 3- Discovering bugs and fixing. www.samanet.sy

[ Dec 2011 - Mar-2012 ]--------- View ISP-------- Damascus Syria Consulting in Database, Radius, Billing System (Software and Servers)