Stop looking for jobs far away from home. We have daily job offers published just for you!

Senior Database Analyst

Sun Life

This is a Contract position in Toronto, ON posted September 10, 2017.

Distributed Database Technologies has members in Canada and India supporting a wide range of distributed applications. The core hours for this position are 9:00 – 16:00 EST to ensure proper crossover between North American and Indian team members. All team members must have the ability to handle 7X24 rotational on-call duties, after hour change support and disaster recovery support (will require cell phone, laptop and guaranteed coverage from home).
Main Accountabilities:

  • Hadoop administration and all related technologies.
  • NoSQL (MongoDB) administration.
  • Open Source (PostgreSQL) database administration
  • Performance Tuning in all related platforms
  • Manage small and medium size infrastructure projects. Participate in projects throughout the entire project lifecycle, and define, manage and track project deliverables using defined technologies.
  • Maintain up-to-date documentation and procedures for all supported database related platforms
  • Define and document requirements in cooperation with other Database Administrators and Developers
  • Develop SQL stored procedures and functions to support internal processes and improve system performance
  • Develop scripts to support the operations of Windows and Unix based platforms
  • Support project development following documented standards, policies and procedures (Change Management Process)
  • Participation in a rotational on-call schedule
  • Occasional participation in after-hours and weekend support of production implementations, infrastructure activities, and various disaster recovery exercises
  • Working closely with other team members, technical/team leads, management, specialized IT areas and application support teams to ensure consistent delivery and quality of database services
  • Define, document and implement consistent standards and procedures.
  • Evaluation of functionality and features within related database products.
  • Contribute ideas for best practice improvements, process improvement, and innovative solutions.

Qualifications:

  • University level degree in Computer Science or related information technology degree/diploma
  • Multi specialized; proficient in Database Development, Web Development, ETL and Reporting
  • Understand, can describe and can put into action database concepts.
  • Ability to lead
  • Excellent verbal and written communication skills
  • Ability to work independently and in teams
  • Passion for database administration as a career.
  • Strong organizational skills with the ability to handle several tasks efficiently
  • Ability to contribute solutions that meet or exceed business requirements.
  • Willingness to share ideas and speak up in small, medium and large sized groups.
  • Willingness to provide on-call support and trouble shooting

Assets:

  • High academic credentials.
  • Strong SQL skills that include a thorough understanding of system tables, stored procedures, functions, triggers, and SQL tuning
  • Knowledge of Web development, Extract, Tranform and Load (ETL) and Report development.
  • Database tuning experience
  • Microsoft Powershell or Unix scripting languages
  • Experience with database administration tools
  • Knowledge of database backup and recovery strategies (including DR strategies)
  • Knowledge of replication, mirroring, log shipping and maintenance strategies
  • Some knowledge of data-mapping and logical and physical data modeling

SLF1
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.

Persons
with disabilities who need accommodation in the application process, or those
needing job postings in an alternative format, may e-mail a request to

  • LI-AG1

We thank all applicants for showing an interest in this position. Only
those selected for an interview will be contacted.
Apply