Discover

The Opportunity

Moncton, NB
Information Technology
Experienced
Full-time

Assumption Life is looking for a qualified Database Developer to join its Information Technology team. This individual is an IT specialist who designs and deploys one or more databases and is responsible for the consistency and ongoing accessibility of the data. This person designs stable and reliable databases according to the company's needs. Responsible for the development, testing and management of databases to help users and IT staff meet their needs.

This person collaborates with the DBA and performs the tasks necessary to ensure the proper functioning of the databases and the optimization of SQL queries in the production and development environments. This person will also be responsible for SQL security and SSIS module publishing and support.

What you'll do

Responsibilities

Coordination and Delivery:

  • Works closely with developers and SAFe teams to improve applications and establish best practices;
  • Receive maintenance or development requests and analyze submitted IT and technical requirements.
  • Solution Development;
  • Writes code for software patches and bug fixes;
  • Analyzes and codes reports for the various business lines;
  • Ensure accuracy of deliverables through testing and good communication with users;
  • Modify databases according to specific user needs;
  • Data analysis to ensure accuracy of changes to models and cubes.
  • Information distribution
    • Develop and generate SQL reports;
    • Provide and maintain database programming to support enterprise applications;
    • Create and manage reports using SSRS, Power BI, Excel or other programs as required;
    • Create ad-hoc reports as required;
    • Gather and translate business requirements into report designs
    • Troubleshoot the database and reporting environment

DBA support:

  • Troubleshooting of system errors
  • Monitoring and technical support for database systems and associated applications.
  • Support to different teams for the creation, maintenance and execution of database instructions.
  • Control of access permissions and privileges to databases
  • Ensures the proper daily operation of SQL production and data integrity for SSRS, Cube and other reports.
  • SQL server installation

What you'll need

Qualifications

  • Post-secondary degree in computer science or equivalent
  • Minimum of 3 years' experience as a DBA or a related field
  • Strong knowledge of SQL queries
  • Knowledge of SQL
  • Knowledge of SSIS, SSRS and SSAS
  • Strong oral and written communication skills (French and English), ability to communicate clearly and effectively with client or team members
  • Ability to coordinate requests and work of a project/request team
  • Excellent organizational and prioritization skills
  • Strong analytical skills and must possess excellent creative problem solving skills
  • Strong attention to detail and the ability to detect small errors or inconsistencies in code
  • Strong team player, able to work with interdisciplinary groups
  • Ability to follow instructions closely and accurately
  • Willingness to innovate and create cutting-edge programs

We're looking for

Core Skills

Databases SQL

A little bit about us

Assumption Life

At Assumption Life, we value the development of our employees in diversified and inclusive work teams that foster creative thinking and innovation.

Assumption Life is deeply committed to its community's development

Founded in 1903 in Massachusetts, Assumption Life is the result of a group of people who want to take their destiny into their own hands. Their goal was simple: to ensure the prosperity of Acadian families in New England. Since its inception, Assumption Life has continued to making difference beyond the borders of l'Acadie for all families across Canada. Our Company, which began as a great idea 116 years ago, is now one of the largest mutual life insurance and financial services companies in Canada. Today, this culture of generosity and commitment is demonstrated by our employees. Whether it is helping out at special events, raising funds for charities or, helping people in need, Assumption Life employees are very committed to their community and are always ready to help.

An employer of choice

We ensure competitive salaries, as well as performance-based bonuses, generous benefits and flexibility in our policies and practices to respond to the needs of our employees.

Assumption Life is committed to creating a diverse environment and is proud to be an equal opportunity employer. We extend employment regardless of race, color, ancestry, religion, sex, national or ethnic origin, sexual orientation, age, citizenship, marital status, family status, genetic characteristics, disability, gender identity or gender expression, status of a pardoned person, social condition or political activity. If you have a disability or special need that requires accommodation for an interview, please let us know by emailing [email protected]

Are you interested?

Work With Us

  • The opportunity to be part of a dynamic and high-performing team that adheres to the following values: leadership, collaboration, trust and commitment.
  • Training and development opportunities.
  • A comprehensive benefits package including a competitive salary, bonus, pension and benefits.
  • A dynamic location in downtown Moncton.
  • One paid day of volunteer work.
  • A gym located in the building.