Find Jobs
Hire Freelancers

Hire a SQL developer

$250-750 USD

Fullført
Lagt ut over 6 år siden

$250-750 USD

Betalt ved levering
Objective: Conversion of production-ready stored procedures from integration with a commonly used residential construction CRM database (Builder1440) to integration with an alternative software database for the same purpose (Sales Simplicity). Environment: Customer environment consists of multiple, distinct data sources (MS SQL and Firebird). Data access and merging is generally handled through a single, central database (MS SQL) which hosts 450+ stored procedures that query and combine data from the disparate sources. Additionally, the company consists of seven independent, geographic divisions. Each of which may have distinct configurations and requirements for various aspects of the business (commissions, home models, pricing, etc…). Job Overview: This job will require an experienced dba or skilled SQL script developer. Builder1440 (now called Sales1440) is CRM software designed for use in the residential home construction industry ([login to view URL]). Sales Simplicity is a competitive product ([login to view URL]). The customer has numerous stored procedures that query data from a Builder1440 database and combine it with materials, cost, buyer, and sales data from several other sources. The 1440 server is configured as a linked server on a central hub which is a Microsoft SQL server. In most cases, the 1440 data is accessible via views created under a custom database. In all cases where 1440 data is used, the option must exist to query the analogous Sales Simplicity data instead. Tasks: 1. Determine that subset of stored procedures that utilize Builder1440 data. 2. Analyze and compare the Builder1440 and Sales Simplicity schema and develop a comprehensive mapping of data from one database to the other. This analysis must contain a description of points of disparity between the two sources for which there is no obvious correlation. 3. For all points in the existing stored procedures at which Builder1440 data is used, design an efficient and effective method by which either Builder1440 data or Sales Simplicity data can be queried based on the results of the analysis from task 2. a. NOTE: In time, the customer will move all divisions to Sales Simplicity. However, there will be a period during which some divisions are active in Sales Simplicity while others continue to utilize Builder1440. Therefore, it is imperative that on a division basis one data source or the other can be chosen. b. A linked server solution as is currently employed with Builder1440 is preferred if feasible and at least as effective/efficient as comparable alternatives. However, if there are legitimate reasons to consider an alternative design the customer is open to the possibility. 4. Fully implement and test the Builder1440/Sales Simplicity interchange strategy based on the proposed design from task 3. This will require significant and clear communication with the software design team to ensure that any and all changes that alter the output of the existing stored procedures can be resolved in the systems consuming the data. We will be ready to provide copies of each database for the migration, with sample data loaded
Prosjekt-ID: 15332948

Om prosjektet

1 forslag
Eksternt prosjekt
Aktiv 6 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
Tildelt til:
Brukeravatar
Respected Sir, We have more than 10 years of experience in SQL. You can see our profile as SQL is from our main skills. Before going further we will show you with optimising your queries Relevant Skills and Experience We have read your entire requirement and also looked on described website and we are ensure as we are able to do this project with much more you expecting on optimising level as well. Proposed Milestones $2117 USD - Full
$2 117 USD om 15 dager
5,0 (33 omtaler)
6,8
6,8

Om klienten

UNITED STATESs flagg
United States
0,0
0
Betalingsmetode bekreftet
Medlem siden okt. 5, 2017

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.