Fine tune MSSQL Database - Expert knowladge pls

I also believe that I have a team of developers with expertise in MS SQL Server and can do the needful. I shall be assigning the senior most developer to your project. I am willing to assign him to run through the database with you on Teamviewer. However, once you ascertain that we are apt for the project, I would like to work on fixed cost basis or hourly basis without having to track time through this site (I cannot allow my team member to access my account). I look forward to hearing from you.

Hi, I have 11 years experience in development and deployment that includes SQL Server, SSRS, SSIS and .NET. Involved in SQL Server activities like Installing, Migrations, Table Partitioning, Configuring maintenance jobs, Optimizing etc. I have expertise in writing complex queries with proper joins and index selection. Involved in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. I have delivered highly successful projects in ASP.NET, C#/VB.NET Win-Forms, EF with complex logic in SQL Server Stored Procedures. Microsoft Certified Technology Specialist in SQL Server. Thanks

Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2012 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits dashboards via Power BI and reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

I'm expert in SQL Server. Please clarify next information: SQL Server version and edition (2016 and Enterprise for example) DB size Hardware used Primary purposes of DB: store data, analyze data etc. Typical number of concurrent connections divided by purposes.

I am ready to work on your project as per your need. I have 4 years experience in c# and MS SQL. I have worked with Triggers, Stored procedures, Functions etc.

SQL SERVER optimization of scripts

have been working with Sql for 13 yrs but you are correct need to check whether i am the one who can resolve all issues....hope to chat n give it a try.

A proposal has not yet been provided

ello, i have read your job description and fully understand your requirements. It looks like I’ll be the perfect candidate for this job because I have hands on experience in this field. Could you provide us more details about your needs? I will make all changes which you want until you'll be satisfied. Your website will be full responsive for all devices (desktops, tablets and mobiles) and pixel perfect implemented. i have more than 3 years of experience in this. I am sure i can successfully complete your job within short period. For sample work you can view my portfolio. i have develop many large scale projects mentioned in my portfolio. I will be glad if i will work for you and if we can set a long collaboration. Your Invitation over a private chat would be highly appreciated. Let me know your thoughts.

Hello, I would like to take this assignment. I am having 14 years of experience on web development and deployment. Below are my core technical skills •ASP.Net /HTML/CSS/JavaScript •C# and VB.Net SOLID Design Principles •MS SQL, AZURE SQL, MySql and non-relational databases like Azure Table storage, Azure Document Db and MongoDb •Entity Framework (Database first, Code first and OData) •Azure Service Bus, N Service Bus and Azure Service Fabric •Restful API Development (using C#) and deployment on cloud •Team City and Octopus Server for Continuous Integration and deployment •VSS/TFS/GitHub/SVN/Bitbucket/VSO •Agile/Scrum/Kanban/Zendesk •JIRA/Confluence •Unit tests using nUnit and xUnit framework •Integration testing •Acceptance/ Behavioral testing using SpecFlow •API Authentication using JSON web token •JSON format for information exchange •Domain Driven Design (DDD) •Command Query Responsibilities Segregation (CQRS) •Owin Web hosting •QuartzNet for Cron job Working on tools like: Zendesk, Autofac, AutoMapper, SeriLog, Elastic-Search, Kibana, RoboMongo, RabbitMQ, TopShelf Looking forward for further discussion and to start. Best Regards

Very interesting and fair proposal, I'm a Sql Server Administrator since 2008, nine years and counting, working as Dba, writing querys or tuning database architecture, it is my daily routine that have served to me to accumulate a lot of expertise using Microsoft Techniques or other techniques to improve, enhance, monitor, assess and recommend changes in infrastructure or simply documenting the architecture, I can use free tools also that could help us to get a better comprenhension of SQL Server. Experiencie with Sql Server 2000, 2005,2008,2008r2,2012,2014,2016,2017.

I have extensive skills in designing the database, optimizing SQL procedures, fine tuning queries and debugging performance issues for 5yrs.

Currently i am working in this area only. different type of indexes and partitioning and in memory tables