I will write, optimize, and debug sql queries and databases
Enterprise data engineer building automated pipelines and optimizing SQL
About this Gig
Need help with SQL, database design, or a slow query?
I will write, debug, optimize, and improve your SQL queries and database structure using PostgreSQL, SQL Server, or MySQL.
I can help with:
- Complex SQL queries, joins, CTEs, subqueries & aggregations
- Query performance optimization
- Database schema and table design
- Data cleaning, transformation & migration
- Views, stored procedures & indexes
- Database normalization and ER diagrams
- Import/export and data validation
- Debugging incorrect or slow SQL queries
I focus on correct results, clean SQL, and efficient database performance.
Have a complex SQL problem? Send me the requirements or sample data before ordering, and I'll help determine the right approach.
Platform:
BigQuery
•
Hadoop
•
MariaDB
•
MongoDB
Expertise:
Big data
•
SQL
•
Performance
•
Query optimization
My Portfolio
FAQ
Which databases do you work with?
I primarily work with PostgreSQL, SQL Server, and MySQL. I can also work with other SQL-based databases depending on the project.
Can you optimize a slow SQL query?
Yes. I can analyze your query, joins, indexes, execution plan, and database structure to identify performance bottlenecks and optimize the query.
Can you design a database from scratch?
Yes. I can design tables, relationships, keys, constraints, indexes, and provide an ER diagram based on your requirements.
Can you fix an existing SQL query?
Yes. Send me the query, error/result, and expected output. I can debug and provide a corrected and optimized solution.
Can you migrate or import data?
Yes. I can help with data import/export, transformations, validation, and migration between supported database systems.
Can you work with large datasets?
Yes. I can optimize queries and database operations for large datasets, including indexing, joins, aggregations, and efficient data processing.
Should I contact you before ordering?
For complex database projects, yes. Send your requirements, database type, sample schema/data, and expected result so I can confirm the appropriate package.
