Position Summary
Interior Health is looking for an experience Senior Database Administrator to join our team on a full time relief basis until Sept 30th 2024, working out of our Kelowna location.
About the job:
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.
For this position, knowledge and experience of Center for Internet Security (CIS) Microsoft SQL Server Benchmarks, SQL Replication, and SQL Windows Failover Clustering is highly desired.
Qualifications
Education, Training and Experience:
Graduation from a recognized degree or diploma program in Computer Science, three years' recent, related experience or an equivalent combination of education, training and experience.
Skills and Abilities:
? Ability to communicate effectively both verbally and in writing.
? Ability to deal with others effectively.
? Ability to organize work.
? Ability to write programs in a variety of programming languages.
? Ability to operate related equipment.
? Physical ability to carry out the duties of the position.
Comments
This posting is covered by the Provincial Health Officer's mandatory COVID-19 vaccination orders and selected applicant(s) must comply.
Interior Health now offers assistance from an Aboriginal Employment Advisor. If you self-identify as Aboriginal (First Nations, Métis or Inuit) and if you would like assistance with internal career exploration, send your question via email to AboriginalEmployment@interiorhealth.ca to be redirected to the Employment Advisor. We invite applicants to self-identify as First nations, Métis, or Inuit within cover letters and/or resumes.