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

Certaines informations sont présentées en anglais.
Joshua S

Kenya

Je parle Anglais

2 commandes terminées

Experienced IT professional with a diverse skill set in computer networking, project management, web programming, cybersecurity, and database design and management. Proven track record in creating eff...
Plus d’infos
À propos de ce service

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, PostgreSQL, MS Access, 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 4+ years of experience in Database Development and Administration (DBA) client's satisfaction is my main goal. Please contact me before placing your order to understand your needs and scope.

Plus d’infos
design database, erd, write sql queries, scripts, troubleshooting
Plein écran
design database, erd, write sql queries, scripts, troubleshooting

Expertise:

Administrateur

•

Sauvegarde et récupération

+2

Type de base de données:

Base de données centralisée

+3

Balises associées