I need to have a schema created/replicated using data tables exported from our CRM system.

Posted 2 weeks ago

Only freelancers located in the U.S. may apply.U.S. located freelancers only

Summary

This project is to create a full backup copy of our CRM database. We have nightly exports of all the related tables, but the CRM vendor does not allow the export of the schema for "proprietary reasons." The tables are in an AWS Oracle database. Deliverables: Entity Relationship Diagram (ERD) Fully normalized schema (or an intentional denormalized design where appropriate) Primary/foreign key definitions Data dictionary Naming conventions Index recommendations Migration strategy from the current CRM tables Sample SQL DDL scripts

Less than 30 hrs/week
Hourly
1-3 months
Duration
Expert
Experience Level
$50.00
-
$150.00
Hourly
Remote Job
Ongoing project
Project Type

Skills and Expertise

Mandatory skills

SQL

Oracle Database

Database Architecture

Activity on this job

Proposals:50+
Last viewed by client:2 weeks ago
Interviewing:
3
Invites sent:
0
Unanswered invites:
0

About the client

Member since Dec 29, 2022

United States
San Anselmo6:38 AM
$5.7K total spent
3 hires, 0 active
79 hours
Large company (100-1,000 people)

Explore similar jobs on Upwork

Database of Government WebsitesFixed-price‐ Posted 4 weeks ago

Database Administration

Data Entry

Database Management

English

Microsoft SQL Server Admin/Developer & C# Services Freelancer Nee…Hourly‐ Posted 1 month ago

SQL

Bug Fix

Query Debugging

Query Analysis

Microsoft SQL Server

.NET Framework

MySQL

How it works

Create your free profile
Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you want
Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securely
From contract to payment, we help you work safely and get paid securely.