I will design database model, erd, write sql queries, scripts, troubleshooting

5.0
5.0

Peru

I speak English, Spanish

100 orders completed

Gig Summary

Senior Data Engineer

Systems Engineer with 15+ years of experience delivering Data Analytics and Data Engineering solutions. Expertise in software development, database architecture, performance optimization, dashboard de...
About this Gig

Do you need help designing your database model? Are you struggling with complex SQL queries that don't work or that take too much time to run? If so, I'll be glad to provide you assistance in:


  • Database Creation, Maintenance, Tuning and Troubleshooting (bug fixing): MySQL, MS SQL Server (T-SQL) and Oracle (PL/SQL).
  • Database Model Design: Enhanced Entity-Relationship diagrams (EER and ER). Editable diagram included.
  • Conceptual, Logical and Physical Schema.
  • Creation and optimization of complex SQL queries: DDL, DQL, DML, DCL and TCL scripts.
  • ETL (extract, transform and load) processes.
  • Normalization and denormalization.
  • Tables, views, indexes and partitions.
  • Constraints and relationships.
  • Stored procedures, functions and triggers.
  • Jobs and scheduled tasks.
  • Security, users and roles.
  • Backup and restore.
  • Data import and export. Mock data generation.
  • Documentation.


With 15+ years of experience in Database Development and Administration (DBA), Business Intelligence and Data Analytics, client's satisfaction is my main goal. Please contact me before placing your order to understand your needs and scope.


Please note that I don't do academic works.

Database type:

Centralized database

Distributed database

Platform:

MS SQL

MySQL

PL/SQL

SQL Server

Expertise:

Design

ERD

SQL

Performance

Other Databases Services I Offer

Reviews

40 reviews for this Gig
5.0

(40)
(0)
(0)
(0)
(0)
Rating Breakdown
  • Seller communication level
    5
  • Recommend to a friend
    5
  • Service as described
    5
Sort By
Most relevant
  • M

    missbrebre1

    US

    United States

    Ongoing collaboration
    5

    This seller is very good with TSQL and understood the code logic immediately! He is very respectful, patient and helpful. I would definitely reach out to him for any TSQL code questions that you may have. Thank you so much!

    $50

    Price

    3 days

    Duration

    Helpful?
    Yes
    No
  • F
    image-docs

    foureyelabs

    CA

    Canada

    Ongoing collaboration
    5

    Always great service!

    $50-$100

    Price

    Helpful?
    Yes
    No
  • F
    image-docs

    foureyelabs

    CA

    Canada

    Ongoing collaboration
    5

    Very knowledgeable, attentive listener and able to quickly analyze a situation and make intelligent recommendations.

    $50-$100

    Price

    Worksample image
    Helpful?
    Yes
    No
  • S
    image-docs

    slovius

    SG

    Singapore

    Ongoing collaboration
    5

    Definitely recommend. Thank you so much for your help bro 👍🏻

    $50-$100

    Price

    Helpful?
    Yes
    No
  • A

    asdws161

    US

    United States

    5

    Great job. We will definitely be back for future projects. You made the process simple and answered all of our inquiries in a timely manner. Thanks again!

    $50

    Price

    Worksample image
    Helpful?
    Yes
    No
Reviews

40 reviews for this Gig
5.0

(40)
(0)
(0)
(0)
(0)
Rating Breakdown
  • Seller communication level
    5
  • Recommend to a friend
    5
  • Service as described
    5
Sort By
Most relevant
  • M

    missbrebre1

    US

    United States

    Ongoing collaboration
    5

    This seller is very good with TSQL and understood the code logic immediately! He is very respectful, patient and helpful. I would definitely reach out to him for any TSQL code questions that you may have. Thank you so much!

    $50

    Price

    3 days

    Duration

    Helpful?
    Yes
    No
  • F
    image-docs

    foureyelabs

    CA

    Canada

    Ongoing collaboration
    5

    Always great service!

    $50-$100

    Price

    Helpful?
    Yes
    No
  • F
    image-docs

    foureyelabs

    CA

    Canada

    Ongoing collaboration
    5

    Very knowledgeable, attentive listener and able to quickly analyze a situation and make intelligent recommendations.

    $50-$100

    Price

    Worksample image
    Helpful?
    Yes
    No
  • S
    image-docs

    slovius

    SG

    Singapore

    Ongoing collaboration
    5

    Definitely recommend. Thank you so much for your help bro 👍🏻

    $50-$100

    Price

    Helpful?
    Yes
    No
  • A

    asdws161

    US

    United States

    5

    Great job. We will definitely be back for future projects. You made the process simple and answered all of our inquiries in a timely manner. Thanks again!

    $50

    Price

    Worksample image
    Helpful?
    Yes
    No