Mhd Tarek M.
DubaiUnited Arab Emirates
100% Job Success
Top Rated

28+ Years expert, MS SQL DBA&Dev / ASP.NET / Xamarin. Windows hosting

I have more than 28 years of experience, in three main areas: 1- Software development Web, Desktop, Xamarin Mobile, Windows Services, API 2- Database Development and administration 3- Hosting for Windows and Linux Software development Including but not limited to: • Desktop/Web applications/API development (ASP.NET Framework/Core) • Win Forms, Web Forms, MVC, DevExpress • C#.Net, Visual Basic.Net • Mobile application development (Xamarin. Forms) • Android/IOS Apps • Windows service • SignalR Applications. • Very advanced Microsoft SQL Server Database design, development and administration. • Worked with MySQL database engine for hosting and data manipulation. • Preparing and implementing hosting environments (Linux / Windows) • Making reports using Microsoft reporting service (RDL) Files, and making applications to call these reports while changing the databases they connect to and also, linking these reports to dashboard applications to update their filtering while showing them. Database development and administration that includes but not limited to: • Complex queries • Complex integrations • Scheduled timely reports to be sent via emails directly from inside the SQL server. • Pivot SQL queries • Data import and integration • Migrate data between Multiple SQL servers • Migrate data between SQL servers and (MySql or Oracle) database servers • Stored procedures to take action • Stored procedures to return complex data tables. • User functions that make calculations • User functions that return table data conditional bases • Data views • Calling API from inside SQL server directly • High availability servers setup • Database mirroring setup. • Dashboard data collection from SQL databases • Database tuning • Stored procedure tuning • SQL Server Reporting service (SSRS) , Design / Update reports on life database servers. • SQL Server Integration service (SSIS) • Many ETL Task automations like export/Import data to CSV/Excel files, automating upload and download files into FTP sites. And many other important project specific jobs. • Splitting the database load to get pre-designed queries pre-cashed for getting fast reports by utilizing triggers and automated scheduled stored procedures. Windows and Linux hosting Includes but not limited to: • Long experience with reputed hosting providers with reasonable prices. • Install windows server on a Linux hosting environment when it is possible. • Installation for complex windows Environments including: o Clustered windows servers with failover technology o Windows DSF replication for folders across servers. o Windows Load balancing o IIS Load balancing using ARR technology o LetsEncrypt free SSL Certifications o Clustered High Availability storage across servers. o Installing SQL server over clustering o Installing SQL server high availability feature for selected databases over clustering o Setup SQL server database mirroring o Scheduling windows server backup over clustering environment o Install and configure VPN across multiple servers (Windows and SoftEther) o And many more features. • Install and configure (SolidCP) Free Control panel for Windows server hosting. • Install and configure (CWP) Free Control panel for Linux • Install and configure aaPanel free control panel for Linux • This includes: o Website hosting o DNS servers o Email servers • Install and configure Proxmox hypervisor on physical servers and configuring VMs (Windows and Linux) inside it for deferent windows and Linux purposes with port forwarding and NATing.

Mhd Tarek M. has more jobs. Create an account to review them

Skills

  • Microsoft SQL Server
  • SQL
  • ASP.NET Web API
  • Database Architecture
  • iOS
  • Database
  • API
  • ASP