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

Joshua S

Kenya

I speak English

2 orders completed

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...
Read More
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'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.

Read More
design database, erd, write sql queries, scripts, troubleshooting
Full Screen
design database, erd, write sql queries, scripts, troubleshooting

Expertise:

Administrator

•

Backup & recovery

•

Capacity planning

+1 more

Database type:

Centralized database

•

Distributed database

+2 more

Related tags