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.
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
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.
What will you do?
- Administrative support of SQL Server : Monitoring, maintenance and housekeeping of SQL Server and Databases, SQL Jobs, User Access management and regular client requests. Writing and tuning SQL codes and highly customized jobs.
- Infrastructure support of SQL Server : server/instance installs (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.
- Support of application and upgrade database (Database Migration/ upgrade) from existing SQL versions to latest SQL Server versions.
- 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 resource utilization.
Technical Skills
- 10-15 Years of experience to lead Database administrator team with good experience on SQL and Oracle DB
- 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
- SQL Server Replication, Backup/ Restore, maintenance plans and DR recovery strategies.
- 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
- PowerShell scripting to automate DBA related tasks. Ability to understand existing automated tasks and tweak/troubleshoot them.
- General troubleshooting like assisting clients with various issues related to connectivity, permissions, access, distributed queries issues, suggesting solutions, best practices etc.
- SQL Server Security, adept in creating and maintain complex User and permission management environment using AD groups, DB roles, SQL ids and Proxy accounts.
- Experience with ETL tools such as PowerCenter Informatica using Crystal and WEBI reporting.
Interested candidates can please send their Updated Resume on with your CTC, Expected CTC and Notice Period details.