Database Design and SQL Developer (Write,Debug,optimize,Review)

Apurba Adhikari

Starting at

/hr

About this service

Summary

I offer comprehensive database design, SQL development, and data integration services. With expertise in optimizing SQL queries, creating robust ETL processes, I ensure efficient and effective data management. My unique blend of skills in both database management and advanced analytics sets me apart, providing clients with data-driven solutions that enhance performance and drive growth.

What's included

Database Design Documentation:
ER Diagrams Table structures Relationships between tables Normalization details
SQL Code and ETL Process:
DDL, DCL, DQL and DML SQL scripts for creating tables, indexes, views, and triggers Stored procedures and functions Optimized SQL queries ETL scripts for data extraction, transformation, and loading Detailed process flow of the ETL operations
Performance Optimization:
Data quality checks and validation reports Indexing strategies Query performance analysis and optimization reports
Final Report:
Summary of work completed Key findings and insights Comprehensive project documentation Post-deployment support for a specified period

Example projects