Restructure and optimize database queries, stored procedure in MS SQL

Proposal - You can expect any kind of work on SQL Server including performance tuning of any kind of sql query. 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;

Hello Sir, Check my profile , IAM CORE SQL SERVER DBA WITH DEEP EXPERTISE IN PERFORMANCE OPTIMIZATION No matter where ever i am from . i can do the best for you if i am given the opportunity . I am proficient in all activities of SQL Server Administration and Development . Have worked on number of performance Tuning assignments , I can do anything in SQL Server with 100% best industry standard s. I guarantee you will have top notch support .Please ping me to get started . For sure you will like My support..Give me a chance . Thanks

Hi there, I believe I'm suitable for the job after reading your job request. I can actually follow up on the instructions that you will provide smooth and can add nice technical feedback about what's the cons and pros. I'm an expert database developer for more than 15 years, as I understand the theoretical and practical parts of the database. so I can analyze issues more deeply and I can help you for giving you optimal queries with high performance. Moreover, I'm a certified Software Engineering Tester (ISTQB). Having more than 6 years of testing activities on mobile apps on android / iOS, Windows / Mac desktop apps, web-applications on different browsers, games, client-server. Just let me check the details. I am looking forward to hearing from you. Yours, Tamer MA in Information Technology. Software Testing, Test Automation, Testing / QA, Usability Testing, Website Testing, Localization Testing Java, Software Architecture, Selenium, CasperJS, Database, Oracle, Assembly.

Greetings. I am MSSQL DBA. Total 14 years of experience. Since 6 years working as dedicated DBA. Past 8 years of experience as SQL and .NET developer. Begin DBA and Developer, I have very good understanding of performance improvement at server, database and query level. I think I could help you in improving performance of your SQL Server queries as well as SQL box. Looking forward to work with you to complete your request. Thanks & Regards, Milind

Hello, Greetings of the day!!! I would like to work with you on this assignment. I have 14 years of experience on web development, testing, deployment and project management. Below are my core skills: •ASP.Net/MVC/HTML/CSS/JavaScript/JQuery/Bootstrap/Angular •Drupal/PHP/PHP Core/WordPress/Larvel/CodeIgniter •C#/VB.Net SOLID Design Principles •MS SQL, AZURE SQL, MySql, Azure Table storage, Azure DocumentDb 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#) •Team City and Octopus Server •VSS/TFS/GitHub/SVN/Bitbucket/VSO •Agile/Scrum/Kanban/Zendesk •JIRA/Confluence •Unit tests, Integration tests using nUnit and xUnit framework •Acceptance/ Behavioral testing using SpecFlow •API Authentication using JSON web token •Domain Driven Design (DDD) •Command Query Responsibility Segregation (CQRS) •Owin Web hosting •QuartzNet for Cron job •SSRS and Crystal Reports •Integration and implementation of Carrier(DHL, UPS, FedEx,TNT) APIs in the ASP.Net application •Integration and implementation of payment gateway(PayPal, PayUMoney) APIs in the ASP.Net application •Autofac, AutoMapper, SeriLog, Elastic-Search, Kibana, RoboMongo, RabbitMQ, MassTransit, TopShelf Looking forward for your positive response and further discussion. Best Regards

Hi, I am writing this after reviewed your project description. I am interested in your project and Kindly drop a message so we can discuss. • Over 7+ Years I've been working on and around Database Design, Development & Support of MS SQL Server. • Expertise in Writing Queries, Functions, Stored Procedures, Views Using MS SQL Server. • Hands on experience in Optimization of SQL Queries. I Can help you to Optimize the SQL Queries & Procedures as per your requirements. Looking forward to hearing from you. Thanks

Hi, I am from Bangalore, I have worked on multiple query optimization. Like: Using sub-query and create temporary tables to reduce load on DB. Please let me know if we can discuss further on the same. Thanks, Rangam

I have lot of knowledge on PostgresSQL and I feel very confident in order to apply this job. I have already made some databeses using PGAdmin IV I and think I can solve your proble.

Hey! I am placing default bid price now and we can discuss it later. I am skilled as a database administrator, using SQL and Ms SQL server ain't a big deal for speeding up the queries response. Will be glad to discuss further details via chat. I am available to start work immediately. Thank you! Gabriel :)

i have 10+ years of experience in working with SQL server. worked with Thousands of Complex Stored Procedures/SQL Queries/Views. I have worked with many optimization task , can optimize queries , suggest indexes. you can share Profile trace with details events with execution plan i can suggest you optimization. actual work will need Copy database restored on server and Query call to run and record performance , optimize and check the improvement.

Hi, as I'm a .NET Developer whom specialize in API Development, I just think that my skills in data access layer and as well in TSQL can justify your concern.