Senior Database Administrator

Interior Health is looking for a Senior Database Administrator to join the team on a full time permanent basis from our Kelowna location.

What We Offer

• Employee & Family Assistance Program
• Employer paid training/education opportunities
• Employer paid vacation
• Medical Services Plan
• Employer paid insurance premiums
• Extended health & dental coverage
• potential Municipal Pension Plan
• Work-life balance
  
  

About The Position

In accordance with established vision and values of the organization, the Senior Database Administrator performs a variety of duties to ensure the provision of effective development, implementation, maintenance and support of database systems throughout Interior Health according to established policies, procedures and standards.

Typical Duties And Responsibilities

• Conducts feasibility studies for computerization by determining user department requirements; examining and identifying problems with existing systems and recommending modifications to and/or new systems; provides details of estimated implementation costs including associated staffing requirements.
• Plans, designs, implements, documents and supports relational database systems such as Microsoft SQL Server.
• Works collaboratively with Information/Application development staff to analyse requirements and develop new and/or change existing logical and physical database architectures to achieve optimal database design.
• In conjunction with Information/Application development staff, creates and implements efficient database objects such as tables, queries, views, stored procedures, jobs, functions and scripts using industry standard languages, techniques and tools such as SQL.
• Collaborates with technical teams within DH to ensure database infrastructure is optimized.
• Develops and implements best practices for database access, security, performance, and tuning in accordance with established business processes.
• Develops, implements, and maintains change control and testing processes for new server/database development and modifications to existing servers/databases.
• Monitors database servers and system objects, including stored procedures and execution times to implement efficiency improvements and proactively address performance issues using industry standard database techniques and tools.
• Codes new programs and changes to existing programs from specifications; tests, modifies and maintains programs as needed.
• Develops and implements policies and procedures relating to regular server and database maintenance to ensure the stability and reliability of data access across the organization.
• Performs capacity planning including allocating system storage and planning for future storage requirements.
• As a member of the team, provides support and advice to peers and DH professionals in the development and support of database architecture across Interior Health.
• Liaises with vendors to ensure that server, database, software and systems issues are resolved.
• Performs other related duties as assigned.