Website Saskatchewan Blue Cross

Posting ID              S2020

Position                 Contract or Term Full Time

Saskatchewan Blue Cross®, one of Saskatchewan’s Top Employers, is currently recruiting for a full time Senior Database Programmer to work in the Information Systems & Technology (IS&T) Department located in our Saskatoon office.

This is a contract, or term employment position, for up to 1 year in duration with the possibility of extension.  The successful candidate will have the opportunity to work remotely within Canada.

DUTIES & RESPONSIBILITIES

  • Provide support to internal team members and end users, in collaboration with the rest of the development team
  • Design, develop, implement, and optimize database systems; ensure data quality, integrity, privacy and security
  • Design and develop data synchronization between Microsoft SQL and IBM i DB2 databases
  • Research/analyze data processing functions, methods and procedures
  • Optimize database and data cube performance
  • Create complex functions, scripts, stored procedures and triggers to support data conversion, transformation, and synchronization
  • Create and maintain scheduled and ad hoc reports for teams across the business
  • Resolve database and application related issues in the incident queue and document resolution as required 
  • Provide work estimates and progress updates in a timely manner; identify and propose improvements for application systems 
  • Work as part of a team to develop new functions, applications, and technical specifications to respond to changing needs, while ensuring adherence to the department’s development standards 
  • Regular review and assess developmental goals, accomplishments and priorities to meet personal, departmental and organizational objective
  • Communicate the business value of technical solutions
  • Perform other related projects and duties as required

QUALIFICATIONS & SKILLS

  • Completion of a bachelor’s degree in Computer Science and a minimum of 10 year related experience.  An equivalent combination of training and experience will be considered

  • Required experience:
    • CLR triggers, stored procedures, SQL profiler, transaction management 
    • Demonstrated expert level knowledge of DML, DDL, TCL, DCL
    • Demonstrated experience with Linked Servers and OPENQUERY
    • Expert in SQL Server database optimization

  • Preference will be given to candidates with direct experience in: 
    • Experience with SQL Server Filestream
    • Data ETL and migration using SQL scripts and SSDT
    • Working knowledge of SSRS
    • Development experience with DB2
    • Database access protocols including ODBC, OLE-DB, ADO.NET  
    • Version control tools, and CI/CD; agile development practices and methodologies 
    • Working knowledge of .NET console application in either C# of VB.NET
    • A solid grasp of MSDTC
    • Microsoft SQL server related certifications
  • Experience with cloud-based IDE, MVC pattern, and low code application development would be considered an asset
  • Strong analytical and problem-solving skills with the ability to understand and document program requirements 
  • Ability to collaborate and work cooperatively with others, as well as independently with minimal supervision 
  • Must have strong organizational skills with the ability to manage multiple tasks and set priorities within established guidelines and time constraints 
  • Service focused with strong written and verbal communication skills and the ability to explain concepts and technical details to various audiences

HOW TO APPLY

Our people make the difference. If you enjoy a collaborative environment, enjoy a challenge and learning, and are looking for the opportunity to be part of a great team, please apply online at www.sk.bluecross.ca or submit your resume and cover letter by Thursday, October 29, 2020 quoting Posting ID S2020 to:

Human Resources

Saskatchewan Blue Cross

PO Box 4030

516 Second Avenue North

Saskatoon, SK  S7K 3T2

E-mail: careers@sk.bluecross.ca

Fax: 306.667.5443

To apply for this job email your details to careers@sk.bluecross.ca

Senior Database Programmer