I am looking for an experienced PostgreSQL DBA/developer to help develop 4 stored procedures for use in a postgres database.
The stored procedures will provide the ability to create, modify, retrieve and delete jobs and schedules for pgagent.
I have attached the schema used by the pgagent daemon, and have also provided stubs (i.e. templates) for the stored procedures that have to be implemented.
This project can be completed in under an hour by a developer who is experienced with writing postgresql SPs using PL/PGSQL. The SPs developed in this project will be tested against a running pgagent daemon, to make sure the jobs, schedules etc have been created correctly.
Refer to attached file for further details. If anything is not clear, ask me for further clarification.
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).