1199SEIU Benefit and Pension Funds
PL/SQL Developer ( Hybrid)
5 days agoWhat's your preference?
Job Description
- Req#: 11006
Responsibilities
· Develop, modify, and test complex database objects in Oracle PL/SQL and PostgreSQL, with additional development work in Java.
· Participate in the migration of Vitech V3 Core Admin benefits administration software (running on-premises in Oracle Database 11gR2) to Vitech V3locity (running in AWS on Aurora PostgreSQL).
· Convert and test the conversion of database components from Oracle PL/SQL to PostgreSQL.
· Collaborate with business analysts to understand and implement business requirements.
· Perform significant business analysis to ensure the software meets the needs of the organization, including as documenting requirements, mapping and program logic, designing solutions, and testing.
· Develop and maintain system documentation, including technical specifications, data mapping, program logic and flowcharts.
· Utilize automated software testing tools to ensure the quality and reliability of the applications.
· Provide technical support and troubleshooting for Vitech V3 Core Admin and Vitech V3locity.
· Learn and master database schema of complex third-party enterprise applications.
· Understand and interpret customer requirement and develop solutions to meet requirements
Qualifications
· Bachelor’s Degree in Computer Science or equivalent experience.
· Minimum of three (3) years’ experience as an PL/SQL developer required; proficiency in PL/SQL and/or PostgreSQL (ideally both).
· Experience with Oracle Database 11gR2 and/or AWS Aurora PostgreSQL (ideally both).
· Some knowledge of Java programming.
· Experience with AWS services and cloud migration would be helpful.
· Experience with automated software testing tools valuable.
· Experience in Application Development with knowledge of software development life cycle and secure coding methodologies.
· Knowledge of database tuning and optimizing the performance of complex database procedures and packages very helpful.
· Excellent verbal and written communication skills
· Must be able to manage priorities and handle simultaneous demands; willingness to work in a fast paced and demanding environment.
· Experience in employee benefits, healthcare payer operations, or defined-benefit pension administration a plus.
About the company
Providing healthcare, pension, financial and social services, training, child care and more to 1199SEIU members. Contact us at (646) 473-9200.
Notice
Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.
Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.
An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report. NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.