Senior Database Programmer

  • Location:
    Saskatoon
  • Department:
    Information Systems and Technology
  • Posting ID:
    S2020
  • Position type:
    Term

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
Application deadline:
Apply Now