I will write, fix and optimize sql queries for your database
BI SQL Developer
About this Gig
I can help you write, fix and optimize SQL queries and solve common database-related problems.
I have 7+ years of experience working with SQL Server and Business Intelligence, including SQL development, data analysis, reporting and performance optimization.
I can help with:
Writing SQL queries from scratch
Fixing incorrect or failing queries
Optimizing slow SQL queries
Complex JOINs, subqueries and CTEs
Aggregations, GROUP BY and window functions
Views and stored procedures
Query performance analysis
Index recommendations
Execution plan analysis
Depending on the package you choose, I can provide the optimized query, an explanation of the changes and recommendations for improving performance.
I prefer to understand the actual problem before making changes, so please provide as much information as possible about your database and requirements.
If you are not sure which package you need, send me a message before placing an order and we can discuss your requirements.
Database type:
Relational database
Platform:
MS SQL
•
SQL Server
Expertise:
Data warehouse
•
SQL
•
Performance
•
Query optimization
Other Databases Services I Offer
FAQ
What databases do you work with?
My main area of expertise is Microsoft SQL Server. If you are using another SQL database, feel free to contact me first and I can confirm whether I can help with your specific requirements.
Can you optimize a slow SQL query?
Yes. I can analyze the query, execution plan and relevant database structure and provide optimization recommendations or a rewritten query
Can you write a query from scratch?
Yes. Send me the requirements, table structure and expected output and I can create the SQL query for you.
Can you work with large databases?
Yes. I have professional experience working with SQL Server and business intelligence environments. For large databases, please provide information about the approximate data volume and current performance so I can properly assess the task.
Do you need access to my database?
Not necessarily. In many cases, I can work with the query, table structures, sample data and execution plan. Please do not send passwords, credentials or other sensitive information.
