Fermé

pgsql stored procedures

Need an expert sql developer to write a set of synchronization procedures and triggers. We need about 8 procedures. These procedures need to work on pgsql 8.4, and 9.0 across two databases. The bid needs to include 6 months of support.

We have two databases. The first database has 25 and the second has about 20 tables. The tables in these two databases are very different. For example columns in tables in first database map to rows into the other database. This requires introduction of constants, and translation. So the work involves in keeping these two databases in synch using these procedures. The synchronization has to be continuous. Also required a log file with things as a happen.

If database A is updated, B needs to be changed. Similarly if B is changed, A needs to be updated.

There is also a possibility that we need some lookup tables to aid in this translation.

Deliverables:

1. Require the developer to be online on skype from 7AM to 12PM Chicago time during development.

2. Documentation of triggers

3. Installation of the procedures/triggers in production

4. Support for 6 months after go-live

5. About 20% of requirement will change, so developer must be prepared to handle that

6. Need an NDA signed

Compétences : Script Install, SQL

Voir plus : sql developer online, signed nda example, online sql developer, live map online, introduction databases, example of nda, databases introduction, database constants, write a script online, online nda, stored, stored procedures, production support, Procedures, synchronization script, translation procedures, script triggers, SQL stored, skype install, sql change log, database include tables, database synchronization using, live map sql, bid support documentation, file synchronization database

Concernant l'employeur :
( 13 commentaires ) Chicago, United States

N° du projet : #1040251

13 freelance ont fait une offre moyenne de 155 $ pour ce travail

guevanjr

Certified SQL Expert ready to start.

100 $ USD en 4 jours
(3 Commentaires)
2.5
Frankie4Fingers

Check PM, please.

250 $ USD en 5 jours
(0 Commentaires)
0.0
ashishkat

--need to provide db access and details of the db in the initial stage -- extra cost for 6 months support after post project.

250 $ USD en 100 jours
(0 Commentaires)
0.0
amsak

Pls see PM

100 $ USD en 21 jours
(0 Commentaires)
0.0
jackpot888888

I can do this. Please give it to me!

250 $ USD en 30 jours
(0 Commentaires)
0.0
Rajithr

I have 6 years expereince in database(sql,plsql) programming, i have a confidence that i can do any sort of programming in database. Also I am working in Oracle Organization

100 $ USD en 4 jours
(0 Commentaires)
0.0
Wentark

I am a Expert Level PL/SQL Developer for over 16 years experience. I have the relevant skills in OraclePL/SQL to dd this project. Willing to sign a NDA.

250 $ USD en 30 jours
(0 Commentaires)
0.0
shubham1809

- 4 years of extensive SQL Server Development experience - Worked with top MNC's and studied in top ranked college

30 $ USD en 15 jours
(0 Commentaires)
0.0
vlopes777

Hi there I'm a programmer for more than 12 years using VB6, SQL, PL-SQL ,Access, Crystal Reports, etc...and I've been also working with VB.NET for the last 3 years. I can do this for you with no problem... Hope t Plus

250 $ USD en 15 jours
(0 Commentaires)
0.0
adroitdeveloper

Hello sj250 , Lets start work, Please check PMB. Thanks

160 $ USD en 7 jours
(0 Commentaires)
0.0
satyapalgarhwal

ready to work with u ... according to terms and condition

100 $ USD en 5 jours
(0 Commentaires)
0.0
DxDragan

I carefully read your job post and I believe that my strong technical experience and education will make me a very competitive candidate for this job.

150 $ USD en 9 jours
(0 Commentaires)
0.0
GoodDBA

I have 12 + yrs IT experience, I am very strong database design and development. I do like you to work with you on long term basis.

30 $ USD en 0 jours
(0 Commentaires)
0.0