Performance Tuning(SQL DBA)

Hello, As an expert in sql, i am very much interested to optimize your query. Is it sql server based? Let's discuss more. Thanks

Hi. If you can share query/tables schema would be great, will think about chances to optimize it.

Programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Microsoft SQL, Access and etc. I can fine tune the query for quicker and accurate result. Some reference projects: a) Responsive website on .NET - https://www.freelancer.com/projects/C-Sharp-Programming-ASP-NET/ASP-Net-Responsive-Web-Application/ --> Review -> “Thanks Hardik! Great work.” b) VB 2013 Desktop Application with AWS integration -https://www.freelancer.com/projects/Amazon-Web-Services-Windows/Visual-Basic-Express-Desktop-Application/ --> Review--> "Great Job! Would hire again!" c) Data pull application from Facebook using VB.NET -https://www.freelancer.com/projects/PHP-Social-Networking/Timeline-Posts-Extraction-with-Likes/ --> Feedback by Client --> "I was extremely satisfied by hardikshah83's work. Excellent communication skills. Very professional. I asked for a couple of changes in the course of the project and he delivered them gracefully." Let's discuss and make this project a success. This is a tentative bid, and may change post understanding exact scope.

I am mysql dba having more then 8 yrs of experience and expertise in mysql performance tunnjng. I have completed more then 100 projects on mysql

I am a database/MSBi/Solution architect and have more than 14 years of experience in IT industry. And I am also expert to improve the SQL performance without changing the database estructure. Please let me know if you want to discuss further. 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 • 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; • Having good amount of practical exposure on AngularJS, Javascript, ASP.Net with C# language and executed multiple projects independently.

Hi i am expertise in sql query and performance tuning please let me know in what aspects u need the info

Hi. I'm MS SQL Server senior DBA. I may do this in one day if this is a minor issue. Let me know what exactly do you need

I have been working in mysql for many years and have database，a single table can be up to 1 billion records and 200 GB data file. so I am quite good at it.

Hi there, I can take a look at this optimization for you. I have a deep background in large, high-performance databases, am well-versed in all aspects of ODBC-compliant databases like SQL Server/Oracle, and have highlighted my SQL proficiency with the SQL certification exam attached to my Freelancer.com profile. Regards, Barry OBrien

Would you like to attach some information about that query to your project? Also, is it about MS SQ, Oracle or MySQ? I doubt all three of them are involved. And well, I have more than 10 years of experience with optimizing SQL queries.

Hello, I am DBA since SQL Server 2000. I have more than 14 years of experience. A person right for your job What is more details than needs to be done by chat. Thank you for your attention, Marcelo Furtado

hi I'm well equipped knowledge of SQL query writing. I'm 2 years experience of report writing on SQL stored procedures

can we discuss on this project so that we can plan accordingly and start working on it. I have been working on database since last two years so, it will easily for us to optimize your sql query. if u don't know about joins then we can help u to understand them also thanks

Hi, I will never complete your task, because I don't have the intelligence and experience required. It's no joke, I swear to SQL. :D

I have good experience in MSSQL Server. I can do your work on timely. You can assign your project with us. We are waiting for your response positively. I have worked on size of 8 TB databases.

I'm an experienced freelancer database and report design, development and optimization with 10 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design. Here is few technologies I have mastered since last 10 years and can deliver the best solutions if you get me hired. I am in Florida, US 1) Sql Server 2005/2008/2012 2) MYSQL, MS Access 3) Oracle (PL/SQL) 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS

Hello, I am an IT Software Engineer certified in databases (MCP, MCTS, MCSA) with more than 10 years of experience managing Oracle, MS SQL Server and MySQL databases.

I have 12+ years of working experience with SQL Server, would love to help you achieve your goals. Please provide more information about the project. Thanks. Note: I can assist you for free of cost for this task, need good rating.

• 7 years of experience in Database Administration for very large and complex databases in SQL Server 2016/2014/2012/2008R2/2008 and 2005. • Administering SQL Server High Availability and Disaster Recovery strategies. • Expertise in MS SQL Server Installation, Configuration, Migration and Maintenance. • Experience in using DMV and dynamic management functions for finding out long running queries. • Having good knowledge and experience on two node active/active, active/passive cluster. • Experience with SQL Server Security and SQL Server Auditing. • Experience in handling Database performance issues, log shipping, Mirroring and other distributed data issues. • Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA). • Having hands on experience in DR processes including Log shipping and Database Mirroring. • Recovery of the database during crash or data loss. • Expertise in defining Database Backup, Recovery and Disaster Recovery Procedures. • Experience in Supporting Production Servers and Applications 24x7 to US, UK, Dubai, Canada users, on-call basis. • Creating jobs and maintenance plans. • Experience in supporting Very Large databases (VLDB) and troubleshooting the problems. • Configuring, scheduling and administering routine jobs, tasks, alerts and maintenance Plans. • Implementing database change requests received from developers through change request.

I have strong knowledge in SQL/PLSQL as i have 3+years experience in the same field in Oracle company. I can able to help you on this project on given time. Kindly consider this and contact me