PL/SQL Developer

Sun Life

Established in the Philippines in 1991 and in India in 2006, Sun Life Global Solutions, (formerly Asia Service Centres), a microcosm of Sun Life, is poised to harness the regions potential in a significant way - from India and the Philippines to the world. We are architecting and executing a BOLDER vision: being a Digital and Innovation Hub, shaping the Business, driving Transformation and superior Client experience by providing expert Technology, Business and Knowledge Services and advanced Solutions. We help our clients achieve lifetime financial security and live healthier lives – our core purpose and mission.

Roles and Responsibilities :

• Design, develop and maintain database objects like complex PL/SQL functions, procedures, packages, etc.
• Build SQL queries and procedures for data maintenance/fixes, analysis of application and system data and ad hoc reporting. Optimize SQL queries for performance and scalability.
• Provide Production support for batch processes and troubleshoot issues in a time-sensitive environment. Monitor and manage job schedules using Autosys.
• Develop, analyze, and maintain application code written in high level programming languages (like Java, Microfocus COBOL). Build and maintain Shell scripts for application code execution.
• Collaborate with business analysts and QA teams to understand requirements and ensure robust solutions.
• Document solutions and procedures for support and knowledge sharing.

Key Skills :

• Strong knowledge of RDBMS and 5+ years of hands-on experience with SQL and PL/SQL development

• Strong logical reasoning and critical thinking. Should be able to develop algorithms for solving business problems.
• Strong debugging and analytical skills in real time incident resolution.
• Proficient in SQL optimization and database performance tuning.
• Proficiency in analyzing and developing code using one of the programming languages (like Java, C#, Python, COBOL, etc).
• Batch production support experience in enterprise environments
• Basic knowledge of Shell scripting and Unix or Linux OS.
• Must be open to work in late shifts for partial overlap with US team working in Central time zone until ready to work independently.
• Familiarity with Oracle Forms and reports.
• Experience in supporting IT systems pertaining to Insurance domain
• Exposure to Autosys or equivalent job schedulers.
• Experience working in Agile/Scrum environments.