SQL Server DBARayan Pardaz Kavosh Co. – Full TimeJuly 2022 – Up to the presentTehran, IranHybridhttps://rpkavosh.ir+98-(21) 88 540 480 I lead SQL Server performance optimization initiatives across enterprise-grade systems. My role involves diagnosing slow-running queries, restructuring indexes, improving database structures, and implementing high-availability and disaster recovery strategies. I regularly collaborate with cross-functional teams to ensure data solutions align with evolving business goals. Key Responsibilities & Achievements  Database Architecture & Optimization Designed and implemented scalable, high-performance database solutions, aligning with complex business requirements. Developed efficient database schemas, ensuring data integrity, normalization, and optimized indexing strategies. Led SQL Server performance tuning initiatives, identifying and resolving bottlenecks to improve query execution

Certified Judicial Expert | Computer & IT SpecialistAssociation of Expert Witnesses – Part-time October 2021 – Up to the presentArak, IranHybridwww.iaoemarkazi.ir+98-(86) 33 12 51 18 As a Certified Judicial Expert and an official member of the Association of Judicial Expert in Computer and IT, I played a crucial role in the judicial system, providing technical analysis, forensic investigations, and expert reports on complex IT-related cases. My expertise was instrumental in supporting legal proceedings, dispute resolution, and forensic investigations, ensuring that accurate and data-driven insights were presented in court. Key Responsibilities & Achievements  Judicial Consultation & Expert Reporting Collaborated with provincial judges and legal teams to analyze and evaluate IT-related cases, offering expert

Database Consultant | SQL Server Optimization SpecialistMedad Bakhtar Company – Part-time March 2019 – February 2020 (1 year)Arak, IranHybridwww.madadbakhtar.cominfo@madadbakhtar.com+98-(86) 34 13 06 12 As a Database Consultant at Medad Bakhtar Company, I played a pivotal role in optimizing database performance, enhancing data integrity, and advising senior management on database-related strategies. My primary focus was on analyzing and improving the database structure of the Billing System for the Power Administration, ensuring optimal performance, reliability, and scalability. Key Responsibilities & Achievements  Database Performance Optimization & Administration Conducted an in-depth analysis and optimization of the Billing System database to enhance efficiency, response time, and data integrity. Identified and resolved bottlenecks by optimizing SQL queries, indexing strategies, and execution

SQL Server DBAAris Rayaneh Co. – Full time January 2018 – June 2022Arak, IranOn-sitewww.arisrayaneh.cominfo@arisrayaneh.com+98-(21) 91 00 13 23 As a Senior SQL Server Database Administrator and Performance Tuning Expert at Aris Rayaneh (2004–2022), I specialized in designing and implementing robust database solutions, optimizing query performance, and ensuring high database availability and security. My role included managing complex ETL processes, advanced troubleshooting, and mentoring technical teams, consistently enhancing database performance and reliability. Key Responsibilities & Achievements  Database Architecture & Optimization Designed and implemented scalable, high-performance database solutions, aligning with complex business requirements. Developed efficient database schemas, ensuring data integrity, normalization, and optimized indexing strategies.

  June 2016 – May 2017 (1 year)Arak, Markazi Province, IranHybridmr.ssaa.ir As a Database Consultant, I supported the Central Province Department of Registry of Deeds and Real Estate in enhancing the performance and scalability of their operational database systems. My primary focus was on query performance tuning and advising on architecture enhancements for future growth and system stability. Key Responsibilities & Achievements 🔹 SQL Query Optimization & Performance Tuning Diagnosed and resolved performance bottlenecks in the legacy database systems. Refactored complex queries and applied advanced indexing strategies to improve execution times. Reviewed existing database structures and recommended improvements for better normalization

C#.NET DeveloperAris Rayaneh Co. – Full time January 2004 – January 2018Arak, IranOn-sitewww.arisrayaneh.cominfo@arisrayaneh.com+98-(21) 91 00 13 23 As a C#.NET Developer at Aris Rayaneh Company, I played a key role in designing and developing custom enterprise applications integrated with large-scale SQL Server databases. My work focused on building scalable, maintainable, and high-performance systems that streamlined business operations and improved data accessibility across departments. Key Responsibilities & Achievements 🔹 Designed and developed multi-tier applications using C#, .NET Framework, and ADO.NET integrated with SQL Server databases.🔹 Implemented data access layers (DAL) and optimized stored procedure calls for maximum efficiency and minimal latency.🔹 Developed Windows Forms