Job Description

You are as unique as your background, experience and point of view. Here, you\xe2\x80\x99ll be encouraged, empowered and challenged to be your best self. You\'ll 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, you\'ll 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.:Principal SQL Support EngineerAre 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, we\xe2\x80\x99re helping set our clients free to live their lives their way, from now through retirement. We\xe2\x80\x99re working hard to support their wellness and health management goals, too. That way, they can enjoy what matters most to them. And that\xe2\x80\x99s anything from running a marathon to helping their grandchildren learn to ride a bike.To do this, we offer a broad range of protection and wealth products and services to 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 world\xe2\x80\x99s 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\xe2\x80\x99 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 \xe2\x80\x93 our core purpose and mission.We strive to Shine Together, Make Life Brighter & Shape the Future!What will you do?

• Support of SQL Server batches & jobs : Monitoring, maintenance and housekeeping of SQL Server batches, jobs, stored procedures , adhoc scripts , SSIS packages and Databases, Writing and tuning SQL codes and highly customized jobs.
• Infrastructure support of SQL Server: Support the DBAs in server/instance migrations (stand-alone and clustered), service-pack upgrades, hot fixes, client tool installs, readiness programs, new feature exploitation, research and development.
• BI support of SSIS and SSRS: Deployment, Security, performance tuning, Creating and enforcing Standards & best practices, automate repetitive tasks, designing, troubleshoot and diagnose issues with SSIS, SSRS.
• Communicate and collaborate effectively with architects, peer designers, Business consultants and business to understand technical issues and recommend holistic solutions.
• Monitor database performance, identify bottlenecks, and optimize artifact utilization.
• Should be flexible to support Nightly batch/On-call/Weekend Upgrades, Implementations and rostered Night shift if required.

• Role Definition:

• I Design and development delivery within projects that is efficient, functional, and maintainable.
• Apply analysis skills to understand and assess the impact of infrastructure and technical changes within the environment.
• I will create required design and development documentation and participate in both design and code reviews.
• I understand the software requirements and ensure it\xe2\x80\x99s translated into good quality production - ready code basis provided design & instructions.
• I understand the defined scope and timelines and deliver quality deliverable within the estimated time.
• I attend and actively participate in the team ceremonies.
• I support critical batches and reports.

• TECHNICAL SKILLS

• 11+ Years of experience to lead SQL Data Support Engineer team with good experience on SQL.
• Proficient in designing, developing and supporting complex ETL pipeline (using SSIS and Informatica)
• Proficient in designing, developing and supporting complex reports (using SSRS, Crystal and WEBI)
• SQL Server Concepts like SQL Architecture, Indexes, T-SQL skills & DMV.
• Database Maintenance/ Support tasks and lower level monitoring using tools like profiler, DMV, Perfmon
• Troubleshooting & diagnose issues with both SSIS & SSRS (Deploy, design, Security, Tuning, Creating and enforcing Standards & best practices, automate)
• Understanding of system tables, stored procedures, functions, triggers & SQL tuning
• General troubleshooting like assisting clients with various issues related to connectivity, permissions, access, distributed queries issues, suggesting solutions, best practices etc.
• Good knowledge of data-mapping and logical and physical data modeling.
• AWS cloud experience (EC2, EMR, S3, Kinesis, Dynamo, API (Application Programming Interface) Gateway & LAMDA)

Good to Have

• Knowledge of Performance Tuning by analyzing, optimizing and rewriting/re-designing SQL codes.
• Knowledge of SQL Server database tuning using Profiler, Index Tuning Wizard, Dynamic Management Views and Functions (DMVs), and other third-party tools.
• Knowledge of clustering, Always on / multi node clusters at the time of DR process.

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 one\xe2\x80\x99s role and team and plan their career with Sun Life.Your scope of work / key responsibilities:

• Collaborates effectively

• Drives collaboration among team members in his/ her function
• Presenting a supportive, united front when appropriate.
• Communicates Confidently

• Communicates crisply and candidly.
• Communicates effectively across audiences (reporting managers, peers, business partners)
• Balances talking and listening to foster candid dialogue.
• Focuses on the Customer

• Raises concerns and recommends potential solutions for those processes that negatively impact the customer service experience or the fair treatment of customers.
• Helps employees understand the impact of their work on the customer/ client.
• Organizes own work to meet agreed upon deadlines.
• Focuses on surfacing underlying customer issues / concerns and identifying root causes.
• Takes Accountability

• Takes steps to understand decision making processes and procedures \xe2\x80\x93 uses this understanding in developing work plans
• Escalating issues or redirecting enquiries in a timely and efficient fashion.
• Following up with customers when we say we will and delivering on our commitments.
• Works under general supervision on day-to-day matters.
• Understands our Business

• Enhances understanding about the business of SLF (e.g. products and services, org structure, key competitors)
• Understands how his/her role relates to the Business Unit/ Function\'s objectives

Technical Credentials: MCSE or MCSA certified in SQL Server (Preferred)Primary Location: BangaloreSchedule: 12:00 PM to 08:30 PM/ US rotational shiftJob Category: IT - Application DevelopmentPosting End Date: 29/08/2024

Sun Life Financial