Oracle Developer

Qualifications • Minimum of 10 years and maximum of 15 years of working experience in total • Strong PL/SQL Development Skills • Proficient in database development utilizing partitions, dbms jobs, packages, procedures, function and Oracle user defined types • Proficient in working with UI teams/applications and using cursors, XML, JSON etc • Strong experience in developing end-to-end jobs as part of ETL. Strong experince in Datawarehouse and OLAP • Strong SQL and PL/SQL tuning skills • Data analysis skills to debug, trace, and fix performance problems • Familiarity with Oracle Exadata • Familiarity with SingleStore/ Mysql is a big plus • Experience with Python, exposure to DB connect libs and others like requests, json, pandas etc • Oil and Gas Industry experience. Benefits Healthcare Insurance: Synectics offers eligible employees and their dependents healthcare coverage through BlueCross BlueShield of Illinois. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics. Premiums are subsidized by Synectics. Dental Insurance: Synectics offers eligible employees and their dependents a dental plan through MetLife. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics. Vision Insurance: Synectics offers eligible employees vision insurance through VSP. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics.401(k) Plan: The Synectics Inc. Investment Savings Retirement Plan. Synectics offers all employees who are 21 years of age or older the opportunity to invest in the 401(k) Plan on the first enrollment date that is at least 30 days after employment begins. Enrollment dates are each January 1st, April 1st, July 1st, and October 1st. Technical Certification Bonus: Synectics is pleased to award its employees a bonus of up to $500 for an approved professional certification. In determining the bonus amount, Synectics will consider the cost of the test(s) for any certification relating to your current position, achieved during your employment with us. Only one Certification Bonus per calendar year may be awarded per employee. Only current, active employees will be eligible to receive this bonus. It will be awarded 90 days after the Synectics office has received documentation confirming the successful completion of the certification. Synectics is an equal opportunity employer.