Hire the Best Database Designers
in Sri Lanka

My goal is to maintain the 100% job success rate I've achieved by thoroughly understanding requirements of clients and ensuring I am competent in completing the job successfully before applying. I adhere to a policy of completing any awarded job ahead of schedule and meticulously verifying accuracy before submission, with the primary aim of utmost satisfaction of the client. I am adaptable and always open to accommodating reasonable changes requested by clients throughout the ongoing job. I carry out regular communication with the client to provide progress when necessary. Having earned a Bachelor of Science degree, and a Master of Science degree, and having fulfilled the coursework requirements for a Ph.D. in Biostatistics, my commitment to learning and acquiring new skills is ceaseless. With over 40 years of experience in the education sector, specifically in teaching Mathematics, Statistics, Physics, and Information and Communication Technology, I am prepared to carry out any given task with precision and efficiency.

Red Hat Certified System Engineer, having around 12 years of experience working in Linux environment and worked on many projects over the year involving Cloud and Dedicated servers. Knowledge of Enterprise Infrastructure technologies and architecture. Worked as consultant on various projects in the past to design and implement an environment which uses Linux and Clusters to run Applications. Os : Linux and Wondows server expert Cloud Services : AWS,GCP, Linode, ToggleBox Configuration : Ansible Containers : Docker/Kubernetes Relational Database Servers : MySql, Oracle, PostgreSql, MsSql,MongoDB DB Languages : Pl/Sql,Stored Procedures, SSIS Scripting Languages : Bash, Perl, Java No Sql Database servers : MongoDB Atlassian: Jira Web servers: Apache, Nginx, Tomcat Mail Servers : Zimbra,Postfix,Sendmail,Hmail,Dovecot Monitoring: Nagios, Zabbix, Monit, Munin, Cacti Virtualization: Openvz, Vmware/Vsphere ESXi/server, VirtualBox CMS : Wordpress, Magento firewalls: iptables, ufw Other: standard network services (DNS, DHCP, FTP, SVN/Git, http proxy, VPN, backups, monitoring etc)

I am a highly skilled MSSQL Database Administrator with over 9 years of experience in both software development and database administration. My experience includes 5+ years as a DBA and 4+ years as a Developer, giving me a unique perspective and a broad range of skills. My key skills include: SQL Server Administration - Expert SQL and TSQL Development - Expert SSRS Reporting Server (up to 2017) - Expert SSIS - Expert PowerShell - Expert Sub Skills MongoDB Cassandra Oracle, PostgreSQL MySQL Python In addition, I have expertise in programming languages including C#, VB.Net, ASP.Net, WCF, JavaScript, XML, HTML, CSS, Ajax, and IIS, as well as REST, SOAP, and JSON. I am well-versed in Visual Studio (2003, 2005, 2008, 2010, 2013), and familiar with ITIL basics and documentation.

I am experienced in database administration, optimization, and high availability solutions. Ten years overall as Microsoft SQL Server DBA (SQL Server 2000-2019). Hardworking and meet deadlines, I accomplish tasks qualitatively. My specialization: ✅- Performance optimization: -------- Server performance optimization (settings\configurations\indexes) -------- Code performance optimization (procedures\views\functions) ✅- Troubleshooting and recovering ✅- Scripting\automatization ( T-SQL) ✅- Migration and upgrading ✅- SSRS (optimization reports, writing reports), SSIS (writing packages, troubleshooting) ✅- AWS and Azure ✅-MSSQL cluster configuration -------- MS SQL Failover Cluster Always on setup -------- Windows failover Cluster configuration -------- MSSQL cluster configuration and both nodes I have managed 100 instances, had deal with VLDBs (1TB-10TB).

⭐⭐⭐⭐⭐ “Our services ran 10x faster after Shafir’s optimization. He’s a genius!” — Paul S., Schoop Ltd 📣 With over 11 years of professional experience, I am a skilled SQL Server freelancer on Upwork, specializing in SQL Server DBA, database development, and business intelligence development (Data Engineer). 🎯 I've successfully resolved customer-facing SQL Server bottlenecks and achieved significant performance enhancements for Fortune companies and renowned organizations, including the following to illustrate some of them: ☑️ AAA Communication Inc. USA (~14 Million Estimated Revenue per Year) ☑️ NeTex Consulting. USA ☑️ Cloud Retailer. USA (Over 1 Million Invested on Upwork) ☑️ Selectel Wireless. USA ☑️ Jevin Inc. USA ☑️ Boender & BeuteI GmbH, Germany ☑️ Access IT, USA Extensive Experience as a SQL Server DBA (Versions 2000 - 2022) methodically identifying and resolving complex underlying causes of Microsoft SQL Server problems, using a vast variety of techniques and tools. I have solved numerous show-stopping SQL Server Performance problems, as well as often re-engineered immensely complex designs and code, providing significantly improved performance. Expert Level ability with Data Extraction, Transformation, and Loading (ETL) from numerous heterogeneous data sources. I pride myself in my ability to intuitively gather, interpret and understand your requirements, as well as develop intuitive and creative Business Intelligence Solutions using the full MSBI stack (Power BI, SSAS, SSRS, and SSIS). ⭐ Here's what I can offer to your project ⭐ ✔️ Top-notch experience in utilizing SQL Server across all versions from 2000 to 2022, as well as on various cloud platforms. ✔️ Extensive experience in SQL Server database corruption repair and recovery. ✔️ Extensive experience handling large-scale enterprise transactional databases. ✔️ Expertise in data security best practices, particularly regarding PII and PHI data. ✔️ Proficient in swiftly diagnosing SQL performance issues and pinpointing query bottlenecks. ✔️ Expertise in ETL development using SSIS for data warehouses and Power BI databases. ✔️ 24/7 reliable communication: keeping you constantly informed of project status. ✔️ A dedicated professional committed to your success and adding value to your business. ⭐ Why I stand out from other freelancers. ⭐ ✔️ Client Reviews: My priority is delivering value and building trust with every client. ✔️ Over-Delivering: This principle is central to my freelance work. I aim to exceed expectations and take pride in leaving clients saying "WOW" ✔️ Responsiveness: Highly responsive, ensuring all lines of communication are always open with my clients. ✔️ Resilience: Reach out to any of my current or former clients and inquire about my ability to tackle challenges head-on and find effective solutions for any issue they face. ✔️ Kindness: A core value that permeates every aspect of my life. I treat everyone with respect, approach all situations with empathy, and genuinely strive to enhance my clients' experiences. 🏆 Testimonials and feedback from prominent clients🏆 The client reviews below, also featured in my work history section, highlight the quality of work and value you can expect when working with me. ⭐⭐⭐⭐⭐"I hired Shafir to repair a corrupted SQL database. We used 2 other SQL engineers prior to meeting Shafir and also attempted a repair using a database repair application which also failed. We were at a point where nothing was working and we were coming to the conclusion that this was not repairable as there were too many errors. Shafir was very confident that he could repair the database and after watching him work for just a few minutes I immediately felt some hope of a successful repair. After working on the database for several hours Shafir managed to repair the database and get it working better than it was before. Working 20 years in IT I had never seen anything like it. Shafir is very professional and truly an SQL expert. I would highly recommend Shafir for any SQL project. Thank you." - Dean Cutajar, Director - Access IT ⭐⭐⭐⭐⭐ "Amazing experience! Shafir did the impossible. He was able to take a highly corrupted database and bring it back to life with zero data loss. Once repaired, he optimized the database and has it running better than it was before the corruption. He is responsive and easy to work with. Highly recommended. Will use again in the future." Jeff Cross 303 Networks Inc 🙋🏼♂️I am eager to work with you, to provide reliable, consistent, and High-Level solutions to design/development challenges. Please contact me, so we can discuss how we can work together to FULLY meet your Business Needs!