Database Developer

Working within the Database team in our Vancouver office, the Database Developer will support the Database team on all department activities with PNI for both Austin and Vancouver.


  • Works with the Department Manager and Senior DBA on database management and maintenance

  • Works independently on projects, from requirement definition to final delivery and documentation

  • Works on internal and external client reports as well as ad-hoc reports

  • Resolves escalated operational and customer support issues

  • Monitors and acts on operational metrics

  • Monitoring backup/restore processes on both staging and production environment

  • SQL Server Agent Jobs management

  • Monitors and reports end-to-end service level performance

  • T-SQL programming (stored procedures, triggers, functions, views etc.)

  • Assisting in database development tasks

  • Azure SQL support and migration

Technical Requirements:

  • 4+ years of experience in a DBA and/or DB Development role

  • Experience with Windows 10 and Windows Server 2012 R2

  • Experience with MS SQL Server 2008 and/or 2014+

  • Proficient with SQL programming in a client / server environment

  • PowerShell scripting experience -desirable

  • Solid general knowledge of database and database management concepts

  • Experience with batch scheduling systems - desirable

  • Experience with Replication, SSIS, SSRS and ETL processes – desirable

  • Experience with Azure SQL - desirable

  • Technical Diploma or Bachelors in Computer Science, preferably with a business focus

  • Formal training in Database Administration  

  • Ability to provide off-hour DB support on rotation as required

  • Excellent verbal and written English communication skills

  • Ability to work independently with minimal supervision

  • Ability to handle multi-projects / tasks

  • Ability to work on multiple hardware and software platforms