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.
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
13 freelancers are bidding on average $155 for this job
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
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.
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.