What will you do?

· Database 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.

· 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’s 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.

TECHNICAL SKILLS

· 11+ 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.

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.

· Hands-on experience with SQL Server installations and patching.

· Some knowledge of data-mapping and logical and physical data modeling.

· Knowledge of clustering, Always on / multi node clusters at the time of DR process.

· AWS cloud experience (EC2, EMR, S3, Kinesis, Dynamo, API (Application Programming Interface) Gateway & LAMDA)

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’s 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 – 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 See Less