Oracle PL/SQL Developer

Medicaid/MCare Eligibility Interface Developer Our client needs someone to help us reverse-engineer and document and upgrade the Medicaid/MCare eligibility interfaces that include highly complex data transformations written in PL/SQL and SQL. This Developer will be primarily responsible for upgrading and maintaining these interfaces, as well as making recommendations for future enhancements to these interfaces and help us transfer ownership of these interfaces from one support team to another. Representative tasks may include: Modifying or writing new PL/SQL packages and procedures based on requirements. Regression testing an interface after it has been migrated. Investigating interface issues: Troubleshooting slow SQL queries. Investigating underlying data Reverse-engineering undocumented logic Reverse-engineering undocumented data structures Analyzing undocumented source data Communicating with other IT teams that support source systems to understand their underlying data and logic Oracle SQL Oracle PL/SQL Data Analysis Required Skills: Oracle SQL and PL/SQL programming Understand complex database table structures and relationships in an Oracle Database Ability create tests that validate assumptions about interface code, both existing and new Ability to communicate with both technical and non-technical staff to understand existing systems. Samprasoft