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

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'm here to help you.

I will be happy 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). I will provide you an editable diagram.
• 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.