Overview
Develop, maintain and support SQL-based database objects and batch processes for Sun Life Global Solutions, with SQL, SSIS or Informatica as core skills.
What you'll do
- Develop and maintain database objects such as complex SQL functions, procedures and packages.
- 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.
- Collaborate with business analysts and stakeholders to understand requirements and ensure robust solutions.
- Document solutions and procedures for support and knowledge sharing.
What you'll need
- Bachelor's degree in computer science, engineering, or a related field.
- Strong knowledge of RDBMS and 5+ years of hands-on experience with SQL and SQL Server Integration Services (SSIS) or Informatica.
- Strong logical reasoning and critical thinking.
- Ability 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 debugging an issue.
- Batch production support experience in enterprise environments.
- Basic knowledge of shell scripting and Unix or Linux OS.
- Problem-solving: ability to identify, analyze and resolve some technical issues.
- Communication: ability to communicate effectively both orally and in writing.
- Computer proficiency: working knowledge of computer hardware, software, and internet technologies.
- Organization and time management: ability to plan, organize and manage time effectively.
- Teamwork: ability to work effectively with others and contribute to a team environment.
- Adaptability: willingness to learn on the job new technologies and skills; must be curious.
Nice to have
- Familiarity with PL/SQL, AWS, Snowflake.
- Experience in supporting IT systems pertaining to the insurance domain.
- Exposure to Autosys or equivalent job schedulers.
- Experience working in Agile/Scrum environments.
- Oracle certifications.
Details
- Location: Sun Life Global Solutions Private Limited, Bengaluru.
- Schedule: 1:30 PM to 10:00 PM.
- Job category: IT - Application Development.
Read the full description and apply on the company’s own careers page.