IJP -Specialist Development PL/SQL

You are as unique as your background experience and point of view. Here youll be encouraged empowered and challenged to be your best self. Youll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day youll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals families and communities around the world.

Job Description:

Are you ready to shine

At Sun Life we empower you to be your most brilliant self.

Who we are

Sun Life is a leading financial services company with history of 150 years that helps our clients achieve lifetime financial security and live healthier lives.

We serve millions in Canada the U.S. Asia the U.K. and other parts of the world. We have a network of Sun Life advisors third-party partners and other distributors. Through them were helping set our clients free to live their lives their way from now through retirement. Were working hard to support their wellness and health management goals too. That way they can enjoy what matters most to them. And thats anything from running a marathon to helping their grandchildren learn to ride a bike.

To do this we offer a broad range ofprotection and wealth products and servicesto individuals businesses and institutions including:

• Insurance. Life health wellness disability critical illness stop-loss and long-term care insurance.

• Investments. Mutual funds segregated funds annuities and guaranteed investment products

• Advice. Financial planning and retirement planning services

• Asset management. Pooled funds institutional portfolios and pension funds

With innovative technology a strong distribution network and long-standing relationships with some of the worlds largest employers we are today providing financial security to millions of people globally.

Sun Life is a leading financial services company that helps our clients achieve lifetime financial security and live healthier lives with strong insurance asset management investments and financial advice portfolios. At Sun Life our asset management business draws on the talent and experience of professionals from around the globe.

Sun Life Global Solutions (SLGS)

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.

Drawing on our collaborative and inclusive culture we are reckoned as a Great Place to Work Top 100 Best Places to Work for Women and stand among the Top 11 Global Business Services Companies across India and the Philippines.

The technology function at Sun Life Global Solutions is geared towards growing our existing business deepening our client understanding managing new-age technology systems and demonstrating thought leadership. We are committed to building greater domain expertise and engineering ability delivering end to end solutions for our clients and taking a lead in intelligent automation. Tech services at Sun Life Global Solutions have evolved in areas such as application development and management Support Testing Digital Data Engineering and Analytics Infrastructure Services and Project Management.

We are constantly expanding our strength in Information technology and are looking for fresh talents who can bring ideas and values aligning with our Digital strategy.

Our Client Impact strategy is motivated by the need to create an inclusive culture empowered by highly engaged people. We are entering a new world that focuses on doing purpose driven work. The kind that fills your day with excitement and determination because when you love what you do it never feels like work. We want to create an environment where you feel empowered to act and are surrounded by people who challenge you support you and inspire you to become the best version of yourself. As an employer we not only want to attract top talent but we want you to have the best Sun Life Experience.

We strive to Shine Together Make Life Brighter & Shape the Future!

Roles & 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 requirements:

• 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.

Our engineering career framework helps our engineers to understand the scope collaborative reach and levers for impact at every job role and defines the key behaviors and deliverables specific to ones role and team and plan their career with Sun Life.

Technical Credentials: PL/SQL Developer

Primary Location: Gurugram/Bengaluru

Schedule: 12:00 PM to 08:30 PM

Job Category:

Posting End Date: