**Job ID Number** R4074 **Employment Type** Full time **Worksite Flexibility** Hybrid **Job Summary** The PL/SQL will be responsible for coding and modifying websites and web applications, from layout to function and according to a client's specifications. **Job Description** We are seeking a highly skilled and experienced **PL/SQL Developer** to join our IT team. This position will be **full-time, remote, and is a contract position** for 12 months with a possible extension. **Remote but must live an hour away to attend occasional meetings.** Job City: Philadelphia Job State: Pennsylvania Job ZIP Code: 19102 **What You'll Do** + Participate in requirements analysis + Take direction from senior developers + Collaborate with internal teams to produce software + Write clean, scalable code + Perform unit test and prepare applications for deployment + Revise, update, refactor and debug code + Improve existing software + Create documentation as required + Provide production support + Provide third tier support to the help desk on assigned weekends and holidays if needed + Ability to work remotely and/or on-site **What You'll Need** + 5 years or more of proven experience as a PL/SQL Application Developer using Toad, SQL + Ability to create views, packages, functions, and stored procedures + Ability to work with collections + Ability to work with async processes + Interpret execution plans and optimize queries and functions + Ability to create complex DML and debug + Excellent troubleshooting and communication skills + Attention to detail is of the utmost importance + BS/BA in Computer Science, Engineering, or equivalent experience with at least 5 years of development experience **Physical Demands** + Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standards + Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc. + Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor **Reasonable Accommodation Statement** If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111. **Equal Employment Opportunity Policy Statement** It is the policy of CAI not to discriminate against any employee or applicant due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. It is also the policy of CAI to take affirmative action to employ and to advance in employment, all persons regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran, and to base all employment decisions only on valid job requirements. This policy shall apply to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including apprenticeship, at all levels of employment. Employees and applicants of CAI will not be subject to harassment due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. Additionally, retaliation, including intimidation, threats, or coercion, because an employee or applicant has objected to discrimination, engaged or may engage in filing a complaint, assisted in a review, investigation, or hearing or have otherwise sought to obtain their legal rights under any Federal, State, or local EEO law is prohibited.