Database Administrator

**About Pacific Blue Cross**

Pacific Blue Cross (PBC) has been British Columbia's leading benefits provider for over 80 years. We are an independent, not-for-profit society with strong roots in BC’s health care system. We provide health, dental, life, disability, and travel coverage to 1 in 3 British Columbians through employee group plans and individual plans.We are fueled by a commitment to keep health care sustainable for all British Columbians. Through our PBC Health Foundation, we fund projects that improve health outcomes directly related to mental health and wellbeing as well as the prevention and/or management of chronic disease. We are interested in finding people who want to make a difference and who are looking to grow their career with us.

**Perks**
- Work-life balance with flexible working hours of 7 hours per day, Monday to Friday (i.e., 35 hours per week).
- Paid vacation starts at 3 weeks per year, and increases with years of service.
- Hybrid work environment (i.e., a combination of work from office and work from home days).
- Generous benefits, including extended health, dental, and these benefit premiums are 100% paid by PBC.
- Education allowance up to $1,000 per calendar year.
- Onsite gym, cafeteria, and access to virtual doctors/counsellors 24/7 via our Employee Family Assistance Program

**About the Position**
- We are searching for Temporary 6 months _Database Administrator_ to join our IaTS team.
- This position is unionized and part of the CUPE 1816 Bargaining Unit. This position is paid at hourly rates and receives wage increases in accordance with the Collective Agreement. The starting wage for this position is: $5,443 - $6,340 per month.

**Job Summary**

Under the broad managerial direction of the Manager, monitors operational integrity of all production data bases to ensure optimum functionality, minimize impact of data base failures and implement the best fix to resolve functionality problems within time, cost and other resource constraints. Designs and implements complete data base backup and restore strategies, standards and procedures for mainframe and distributed systems. Monitors data base performance to ensure user requirements are being supported and data bases are operating within established standards of functionality.

**Job Duties**

**_IaTS Systems Maintenance and Support: Database Administration_**

1. On an ongoing basis, monitors operational integrity of all production data bases to ensure optimum functionality and minimize impact of data base failures by:

- assessing current status of data bases operating in a variety of platforms including windows, linux and mainframe environments through the use of automated and other diagnostic tools;
- receiving referrals through the help desk and other escalation points for user-initiated trouble reports;
- consulting with vendors of third party software and hardware to assist in isolating cause of failures;
- predicting user and business impacts, evaluating priorities and implementing the best fix to resolve functionality problems within time, cost and other resource constraints;
- initiating emergency data restore and recovery procedures;
- installing vendor patches;
- customizing vendor procedures and tools where indicated to implement a work-around;
- identifying the need for changes and upgrades in data base components and related service level agreements with vendors and initiating the change management request process through the Manager.

**_Data Base Security, Backup and Recovery_**
- Designs and implements complete data base backup and restore strategies, standards and procedures for mainframe and distributed systems. Consults with Systems Programming Specialists to coordinate the design, execution and updating of mainframe data base backup procedures. Automates data base backups to improve reliability using a wide variety of system tools. Documents and updates backup and recovery standards and procedures. Monitors the execution of all daily backups to ensure completion.
- Supports the data base component of the Disaster Recovery Plan and participates in semi-annual Disaster Recovery tests to ensure major backup and recovery strategies are effective and operationally sound in the event of fire, flood or other threat to data base security.
- Maintains and monitors user authorization levels for data base access, and sets up new users.

**_Data Base Capacity and Performance Planning_**

5. Monitors data base performance to ensure user requirements are being supported and data bases are operating within established standards of functionality by:

- compiling and analyzing capacity and performance data using a variety of system generated reports, online response time, help desk feedback, historical performance data and recent system changes to identify variances from expected levels;
- consulting with other technical specialists such as Systems Programming Specialists, Applications Developers and vendors to dete