Analyst

Email this Job
Employer - Sun Life Financial
Category - it-software
Job title - Analyst

Job Description

You are as unique as your background, experience and point of view. Here, you’ll 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.

Job Description:

DBAs use specialized software to store and organize data. The role includes capacity planning, installation, configuration, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery and general support of the databases. Role also requires deploying, supporting and troubleshooting of ETL and Reporting components

PRIMARY OBJECTIVES
Resolution of reported service requests, pro-active and reactive performance analysis related to databases
Carry out Database migrations, upgrades, patching and evaluation/roll out of new database related tools
Troubleshooting, monitoring and diagnose issues with SQL Server Database engine, SSIS, SSRS, SQL codes and highly customized jobs.
Adherence to documented standards and procedures while doing database related activities like change management.

TASKS, DUTIES & RESPONSIBILITIES
Support Areas
Database Administrative support of SQL Server versions 2008 – 2016: 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 versions 2008 – 2014: 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.
Incident Management: Knowledge of Incident management process and participation in a rotational on-call schedule to support off hours production incidents
Occasional participation in after-hours and weekend support of production implementations, infrastructure activities, and various disaster recovery exercises
Maintaining up-to-date documentation and procedures for all supported applications and environments.
Maintaining 99.99% availability for all production environments.
Evaluation of functionality and features with newer versions of the SQL Server DBMS/ database related tools
Pro-active and reactive performance analysis, monitoring, troubleshooting and resolution of issues.
Monitoring and support of nightly production batch cycles (SQL Jobs and SSIS Packages).
Regular review of database maintenance/ support tasks and performance improvement procedures
Work Planning/Escalation: Organizing and monitoring personal workload and escalating to manager when issues arise
Continuous Improvement: Sharing ideas for process improvement and innovative solutions to known problems

KNOWLEDGE, SKILLS & ATTITUDES
In

analyst, analyst-jobs-in-gurgaon
Job Location Gurgaon, Haryana
Date Posted 14 Feb 2020
Employer Email --No Email
Click here to Apply

Jobseeker's Please Note: Please do not make any payment in any bank account or wallet in our Name, We don't charge any money to jobseekers
For More details please Click Here