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.

Responsibilities

  • 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