Hadi Pourneshati Email & Phone Number

Tehran, IR

Tehran, Tehran Province, Iran

• Directed a skilled team of 3 DBAs, overseeing the management, optimization, and security of over 50 database systems in development, test, and production environments.
• Enforced stringent database administration standards and best practices to ensure system integrity and efficiency.
• Collaborated with developers and analysts to design and deploy cutting-edge database solutions using SQL Server 2016/2017/2019/2022.
• Utilized T-SQL, Redgate Monitor, and PowerShell to monitor and refine database performance, achieving a 99.9% uptime rate.
• Architected robust High Availability Disaster Recovery (HADR) solutions like Always On Availability Groups, ensuring continuous data accessibility over 8 individual clusters.
• Crafted and maintained complex T-SQL queries, views, and stored procedures, significantly improving query response times up to 30%.

Tehran, Tehran Province, Iran

• Managed and secured over 1000 database systems in a high-load, 24/7 banking environment as part of a 10 member MSSQL DBA team.
• Executed installation, configuration, and maintenance tasks across various MSSQL versions.
• Boosted database performance almost 10% through meticulous optimization.
• ensuring 99.9% availability, and robust security measures.
• Conducted successful backup and recovery operations, demonstrating a 99.9% data retrieval success rate.
• Developed custom database solutions, including objects and stored procedures, to support critical banking applications.

Tehran, Tehran Province, Iran

• Architected and orchestrated robust high-availability disaster recovery (HADR) solutions, elevating system uptime and reliability across multi-site data centers across geographically dispersed data centers up to 99.9%.
• Enhanced system performance by meticulously monitoring and fine-tuning databases using advanced RDBMS tools, resulting in a marked increase in efficiency.
• Deployment and management of a Redis cluster, achieving seamless application cache synchronization between web servers and reducing latency up to 40%.
• Implemented Apache Kafka to streamline queuing and event streaming processes, handling high-volume client traffic with improved throughput.
• Automated an ETL process for over 20 million clients event logs per hour, leveraging a sophisticated tech stack (Logstash, Kafka, Python, Redis and Clickhouse), which drastically reduced processing time and increased.
• Crafted complex T-SQL queries and developed reporting solutions that provided critical insights for decision-making and strategic planning.

Tehran, Tehran Province, Iran