Oracle PL/SQL Developer Job at Samprasoft, Augusta, ME

cGNIVEJNS1EzdmxHSTZsSFgxNURFSUwraVE9PQ==
  • Samprasoft
  • Augusta, ME

Job Description

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.

Job Tags

Similar Jobs

Global Force

Dental Assistant Job at Global Force

 ...Dental Assistant for IL Urgent temp role as and when needed on per diem basis at various locations in IL Locations: East Peoria IL 61611 Dunlap IL 61525 East Peoria IL 61611 Bloomington IL 61704 New Lenox, IL 60451 Evanston, IL 60201 Chicago... 

MyEdSpace

Senior Chemistry Teacher Job at MyEdSpace

 ...OverviewMyEdSpace is an education technology platform that connects the best teachers with students worldwide. Backed by $15m Series A funding, were scaling rapidly and seek a Senior Chemistry Teacher to lead our mission to make worldclass education accessible to all.... 

Flexsteel

Upholstery Pattern & Marker Designer CAD & Cut Files Job at Flexsteel

 ...revise patterns and cut files for upholstery production. The role involves using CAD software, setting match points, and generating markers for leather and fabric cutting. You will program cut files for multi-ply systems and assist with pattern development and... 

Cavallo Point

Housekeeping Room Attendant Job at Cavallo Point

Are you inspired by nature, fun and beauty? We invite youto joina friendly and innovative team providing world class service. As a Housekeeping RoomAttendant on the Cavallo Point Lodge team, you will enjoy a beautiful work environment overlooking the Golden Gate...

M&T Bank

Financial Consultant Job at M&T Bank

Overview:Support clients in achieving their financial goals through personalized investment and insurance solutions. Under the guidance of experienced Financial Advisors, build relationships, identify opportunities, and deliver needs-based recommendations that help clients...