Canada DBA Job

 
 


DBA Resources
 


Search dbajobs.ca

 

Senior MS SQL Server Database Analyst - SUN LIFE ASSURANCE COMPANY OF CANADA

More Database and SAP Jobs in Toronto, Ontario


Senior MS SQL Server Database Analyst, SUN LIFE ASSURANCE COMPANY OF CANADA

Toronto, ON, CANADA
Posted Mar 18, 2011 1 Position(s)
Senior MS SQL Server Database Analyst - INF02355
You believe life is about aiming high and making an impact. At Sun Life Financial, we work together, share common values and help each other grow and achieve goals.
With roots tracing back to 1865 in Canada, Sun Life Financial has grown to become an established and trusted name in insurance and financial services, with offices and operations in key markets around the world. We recognize that our growth, success and reputation for excellence are due in large measure to our talented and dedicated employees.

Enterprise Services, Working better together.

Our teams are dedicated to providing the services and technology our business partners need to help customers achieve lifetime financial security. Through innovation and collaboration, we're striving to continually find new and better ways to bring value to Sun Life. Enterprise Services has employees in Canada, Ireland, the U.S. and Asia. We partner closely with groups and individuals throughout Sun Life Financial to provide products and services that deliver business value.

Role Summary:
The Database Services Team within Data Management Services is looking for a qualified candidate for a Senior MS SQL Server Database Analyst position. Primary responsibilities will include support for a variety of MS SQL Server applications including vendor packages and in-house developed applications across multiple environments: production, development, user test and DR. The candidate will also be responsible for the following:
Main Accountabilities:
  • Interacting with clients and senior management on incident and problem resolution
  • Providing high-level estimates for major client initiatives
  • Assisting in database design for application development efforts
  • Coordinating various DMS initiatives
  • Providing mentoring and guidance to less experienced database administrators
  • Helping to establish and refine department standards and procedures
  • Streamlining existing processes
  • Developing innovative solutions around stability
  • Developing automation and improving efficiency
  • Performing in-depth analysis and suggesting solutions for performance bottlenecks
There is an expectation that support for certain client projects and DMS initiatives will require off-hours and weekend availability. The candidate will also participate in an on-call rotation approximately every five weeks. A company laptop, cell phone and VPN security token will be provided to facilitate remote support. Typical on-call activities include responding to routine monitoring alerts, production batch cycle failures, participation in major incident calls, and pre-arranged off-hours and weekend client support work.
Competencies:
  • Comprehensive understanding of MS SQL Server 2000/2005/2008 tools and technologies including: replication, security, encryption, recoverability, SSIS, analysis services
  • Strong knowledge of relational databases and relational database design
  • Working knowledge of ITIL concepts and best practices
  • Ability to work well in a team environment and adhere to Sun Life policies
  • Excellent oral and written communication skills
  • Strong analytical and problem solving skills
  • Ability to work with minimal supervision
  • Proven leadership and mentoring qualities
  • Ability to work collaboratively as part of a broader team to achieve goals
  • Must be results oriented, willing to take responsibility and accept accountability for actions
Supplementary Knowledge, Skills and Abilities:
  • Knowledge of IBM OPTIM archiving and data masking tools
  • Knowledge and practical experience with Zeke scheduling system
  • Experience with script programming (Windows Power Shell, VBScript, Perl)
  • Knowledge of IBM Tivoli Storage Management environment
Duties and Responsibilities:
  • Ensure availability and stability of HA production environments
  • Follow established company policies for ITIL processes (Change, Config, Incident, Problem)
  • Help establish and refine department standards, procedures and best practices
  • Review and streamline existing processes
  • Develop innovate solutions around stability, automation and efficiency
  • Coordinate and/or participate in various DMS initiatives
  • Assist clients with database design for application development efforts
  • Comply with Sun Life security standards and follow all SOX and audit requirements
  • Perform in-depth analysis and suggest solutions for performance bottlenecks
  • Provide high-level estimates for major client initiatives
  • Review individual workload and escalate to management if
  • Interact with clients and senior management on incident and problem resolution
  • Provide mentoring, guidance and training to less experienced database administrators
  • Assist DMS management with evaluation and hiring of new staff
  • Query design and stored procedure development using T-SQL
  • Support various disaster recovery and business continuity planning efforts
  • Perform basic DBA activities following established DMS processes and procedures (structure changes, code deployments, data copies, backup/restore processes, maintenance, security, optimization and tuning, capacity planning, job scheduler tasks, database creation and conversion tasks, database upgrades, etc.)
  • Keep current with the latest industry technologies and best practices
  • Participate in the on-call support model; involves weekend and after-hours support on a rotating basis
Technical Skills Required:
  • Academic Training
  • Bachelor degree in Computer Sciences or relevant education and experience
  • Certifications helpful but not mandatory
Work Experience:
  • Minimum 10 years experience in IT, with 3+ years in a Senior Database Administration/ Analyst position.
  • Minimum 5 years relevant work experience in a MS SQL Server DBA role
  • Experience with implementing, configuring, upgrading and administering MS SQL Server 2000/2005/2008 platforms
Sun Life Financial promotes equal opportunity employment.
We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.
Please visit us at www.sunlife.ca
Like to hear what some of our employees have to say about "Working at Sun Life"?
Check us out at: www.youtube.com/sunlifefinancial
Visit our 'Sun Life Careers' Facebook page:

Workopolis Job Category

: Insurance

Primary Location

: CA-ON-Toronto - GTA

Employee Status

: Regular-Full-time

Unposting Date

: 04-01-2011



Last updated on March 25, 2011