MS DB Query/SP Optimization

INTRODUCTION I am an experienced Professional with Database Programming and Administration skills across MySQL, MS SQL and Business Intelligence Development. I have 4+ years’ experience with Database Programming and Administration. I am also skilled in BI administration, building reports and customized dashboards and the ability to turn ideas into functional solutions. I possess ability to take the technical lead in projects and supporting technical implementation whilst working on multiple products. EDUCATION • BSc Computer Sciences, University of Hertfordshire, UK 2014 • Microsoft Certified Business Intelligence Developer 2009. • Microsoft Certified SQL Server Administrator 2008. • compTIA A+ Certified 2008.

Hello! I am a Computer Engineer, MCSA SQL Server, MS Certified Database Solutions Expert, with 14 years of experience as a Database Engineer and SQL Developer. I am a near-native English speaker, currently available and results-oriented. I have plenty of experience on database optimisation - I've used Blitz FRK and Hallengren scripts, execution plan analysis, index creation/maintenance/deletion, table partitioning, datatype changing, query tuning, and the new SQL features such as Index Management and Automatic Tuning. You can provide me a copy of your database and I will restore it on my premises, I have all the software required to do the job. We can discuss details over chat if you need it. Thanks! Sergio

I have deep and proven experience in T-SQL development and debugging of queries with huge complexity. My total MSSQL Experience is 10+ years. Five of them was within USA company as Senior SQL/BI Developer. My everyday duties were: development of different types of reports, dashboards, KPIs, ETLs and functional modules for application`s data layer, Investigation and resolution of performance and locking issues on high loaded production environment. You could accept me and i will share my expertise with you.

Hi, I'm sql server expert and have done many query optimization and I can easily do this job. Could you please share which version of mssql server you are using ? Also, what's the size of databae ? I can start work now if you could provide me the database copy and query Thanks

Proposal - You can expect any kind of work on SQL Server with performance tuning. Let me know if you want to discuss further. I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database/Datawarehouse - SQL Server, Oracle, MySQL -- Proficiency (P4) BI - Microsoft MSBI and Informatica ETL -- Proficiency (P4) Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... -- Proficiency (P3) Cloud - Azure (Paas and IaaS) -- -- Proficiency (P1) My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;

Hi,I can help you I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions in SQL Server environments. Proficient in an assortment of technologies MS SQL Server 2000/2005/2008/2012/2014/2016/2017, SAN Storage and Backup Solutions Thank you for your time and consideration. Best Regards, Shaker

Hi i am expertise in sql queries and also query runing if u are interested please let me know do that we will fix

Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 10.1 years experience in MS SQL Server and 7.4 years experience in SSRS, SSIS (Import / Export). Please let me know more details and when we will start. Sky pe jikenjd

Hi, I am an expert C# developer, also have good experience in Microsoft SQL Server. As I havent seen your database nor query, I cant tell now how to improve, but certainly there must be some performance hints that can be done. I would like to have a look at your database and query. Regards,

I’m an acknowledged expert in sql server. Ex Microsoft MVP. See my web site www.nigelrivett.net. Would need to know how the query works, can it be put in a stored procedure or split into multiple queries. Which version sql server as that makes a difference to what’s available e.g. column store indexes. Can the database be restructured or adductor ion always redundant tables added? Anyway I’m sure I could help.

Hello. I  have more then 10 years of experience in SQL Server databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performance tuning. I am also good for BI part like SSIS, SSRS and SSAS. I have attached my profile.  I am immediate available to join.  I am ready to work any time zone.  Thanks Anil Patel 

Dear Sir/Madam, I have relational database design and development experience of 10 years. Several months ago I worked on the performance issue of an HR database where the query included searching a large free-text field. The duration of the query was 20 minutes. After I completed my work the query completed only in 20 seconds. The employer and I have been working since then. I would like to improve the performance of your query. Hope to hear from you soon. Best Regards Huseyin Aygun

Hi! I have around 14 years of experience into SQL query optimization and tuning and worked on complex performance issues before for mission critical databases. Please share details to understand problem and assure you that it will be done in time with high quality.

Dear Prospect Hiring Manager, After a full understanding of your project description, I can say I could help you with strong interests and desire. I am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have the skills you've mentioned Some skills are : HTML / CSS / JavaScript / Jquery / Asp.Net MVC / Core / Web APIs / Microsoft Azure If you allow me to help you, I'd be honored, and I'll put all my energy and time on this project from now. I hope to hear from you soon. Thank You

Hi I have 12 years experience in SQL and designing Complex databases.I also have expertise in Query Optimize. I can do this work with optimize and clean query. Thanks

Hi, Thanks for the posting. I am writing this after reviewed your project description. • Overall 7+ years of experience in Software Development Projects. • Over 7+ Years I've been working on and around Database Design, Development & Support of MS SQL Server 2008/2014/2016. • Expertise in Writing Queries, Functions, Stored Procedures, Views Using MS SQL Server. • Hands on experience in Optimization of SQL Queries. Request you to kindly consider my proposal and give the opportunity to serve you in this project. Looking forward to hearing from you. Thanks

I have 20 years in Database Developing, administration, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Excel, VBA, VB6, Vb.net, C#, SQL, SQL/PL SQL, and MS SQL Server

Hello , I'm Expert in MSSQL server operations more than 5+yrs , creating stored procedures , Views (Including Joins & Union) , DB triggers , connecting to other DBs via linked server connections (To MSSQL , Oracle ..etc) , OpenQuery operations (update - Insert - delete), i've worked on windows server 2012 & 2016 using MSSQL server 2012 , 2014 , 2016. I'm sure i'll be able to full fill your requirements , ping me to agree on the details proceed right away. Thanks

Hi Greetings of the Day, I am interested in this task, I am full time freelancer carrying 15 yrs of experience in Web and Windows development and Mobile development using ASP.Net, C#, SQL server, Xamarin, WebAPI, VB6, ASP , XML, Cr Reports etc. I have 4 years experience as well in remote working (as freelancer) for Overseas clients. Please feel free to contact me. Thanks

Hi I have 6.5 years of experience in Business Analytics and Data Architecture. Expertise in building end-to-end BI Infrastructure across industries including developing Data Models, Data Warehouses and creating visualizations using SQL server (other DBs such as MYSQL, Oracle, PostgreSQL and etc), MSBI stack (SSIS & SSAS) and Power BI. I have hands on experience in SQL Server Admin activities and handling huge amount of data. I have expertise in Customer Analytics, Sales Analytics, Pricing, Sales & Operations Planning, Digital Analytics domains across Retail, F&B, Entertainment, Fitness, Health Care, Textile anManufacturing industries. I am good at understanding the business context, problem solving and coming up with a solution. You can give me a SAMPLE QUERY (or may be SCENARIO to write a logic) to understand my CAPABILITIES before accepting the project. I am flexible with timings and amount of work.