Roles & Responsibilities :
Responsible for the migration existing ORACLE to PostgreSQL databases.
Design, Estimate and lead the ORACLE to PostgreSQL database including the changes required in PostgreSQL for the existing ORACLE database objects.
Develop Stored Procedures and Database Triggers in support of application
Participate in application development and be responsible for the database
architecture and design.
Participate in the creation of development, staging, and production database
instances, and the migration from one environment to another.
Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
Responsible for regular backups and recovery of databases.
Responsible for pro-active remediation of database operational problems and make sure application performs at par or better than the existing application.
Responsible for Query tuning and preventative maintenance.
Support complex OASIS applications.
Perform other duties as assigned.
Required Skills (Technical Competency) :
10+ years of experience in Software Applications development.
Experience in PostgreSQL 8.3+, ORACLE 12c+ and Database scripting using Pro C, Embedded SQL Statements with C / C++ (*.
pgc), PL / SQL Oracle and PL / pgSQL scripting.
Hands on experience in Applications Development on AIX / Linux systems.
Hands on experience in debug tools using DBX and GDB.
Hands on experience in Applications development using C, C++ ( OOPS ), STL.
Knowledge on Git and Agile Scrum Methodology.
Added advantage, knowledge in Interprocess Communication using Pipes, Named Pipes, Multi Threading using Mutex, Message Queuing, and Socket programming
Desired Skills : xxxx