Database Developer

Information Technology, Calgary

Job Description

Information Technology

The Senior Database Developer is a technology professional who leads the design and development of database architecture. This individual brings leadership and influence with a focus on long-term quality and short-term results in the database domain.

What you will do:

  • Collaborate with the product and development teams to oversee the design of the application data models throughout the entire SDLC in order enhance Assent Compliance’s data solutions with focus on data quality, performance and scalability;
  • Provide technical leadership, mentorship to the application development team in all aspects of database design, creating and tuning queries, and other related activities;

  • Analyze and measure existing system’s design, performance, and/or implementation issues and work on short term plans, proofs of concepts, actual implementation to help circumvent or ideally, resolve the issues;

  • Design and implement data synchronization routines from/to source systems to/from master database system;

Who you are and what you bring:

  • 5+ years of experience working with MS SQL Server, and/or other enterprise RDBMS

  • 3+ years of experience in a lead role for the design of complex data models

  • 3+ years of recent hands on database development and tuning experience (stored procedures, functions, triggers and indexes etc.)

  • Demonstrated expertise with logical and physical database design, diagramming and query optimization of large enterprise databases using SQL Server and Oracle;

  • Demonstrated experience in implementing database functionality in an n-tier Web application environment; including excellent SQL skills in writing complex stored procedures, packages and triggers;