Within the context of the Information Management/Information Systems (IMIS) shared services initiative between Vancouver Coastal Health (VCH) and Providence Health Care (PHC), the Senior Database Administrator, IMIS, is responsible for ensuring that the assigned databases are maintained at optimum levels to provide a stable platform and proper environment on which the supported applications can operate. These systems may be departmental, inter-departmental, corporate, multi-site or multi-hospital. The major area of support is for clinical, financial or patient care related systems. The work performed has a significant impact on the delivery of and use of computer services and resources to the organization. Technical aspects of the work involve ensuring the efficient operation of the unit including the immediate resolution of highly complex technical problems related to the design, installation and operation of operating and online systems software and computer equipment of various types. This position provides an advisory service to both internal and external users and maintains the performance targets of the major subsystem through regular monitoring and tuning activities. Project management, systems analysis, programming skills and techniques are required in order to manage assigned project work.
What you’ll do:
Provide technical support and ongoing systems administration by methods such as maintaining up-to-date knowledge of database software supplied by the manufacturers, monitoring key system performance indicators, planning and providing a stable production environment. Establish and document standards and procedures for use and operation of database software and utilities. Analyze current database software, proposed modifications and new versions/technologies for impact on existing applications and operating environment. Provide technical guidance and training to Information Systems personnel and user departments.
Act as database administrator by providing standard systems management services for different database technologies. Provide database support for the databases and associated application components in clinical, financial and other areas of the organization, performing systems analysis, assisting the users to resolve data integrity issues, interacting with systems vendors to provide corrective actions as required and developing application programs and reports.
Troubleshoot and resolve immediate problems for hospital departments by responding to reported operating difficulties or monitoring the system for key indicators through remote communications equipment or the local area network (LAN), communicating with vendor support analysts or third party remote monitoring service or Help Desk personnel, identifying, isolating and resolving problems, deriving suitable bypasses, fixes or specialized recovery techniques, and documenting the results using related reporting software.
Maintain system efficiency by monitoring system performance, performing system optimization, undertaking capacity planning, preparing recommendations and proposing hardware and software modifications that will enhance the operating and applications development environments. Maintain sample sets of installation programs that are used to test effects of new or modified operating system software and hardware and analyzing end results using the sample sets.
Conduct and/or participates in the evaluation of new technologies and software packages by reviewing and analyzing vendor supplied software, communicating with vendor analysts and determining optimum system configuration (software/hardware) required for the installation; analyze the vendor changes and enhancements to software by assessing the impact on existing production systems, systems design, programming standards, operating procedures and data backup.
Develop and implement software projects by methods such as detailing scope and defining systems requirements, translating requirements into logical, economical and practical systems designs, preparing detailed specifications, project plans, schedules and deliverables, and seeking approval and sign-off at the appropriate managerial level, producing all required documentation, developing system software backup, recovery and maintenance procedures, ensuring assigned tasks are completed according to the committed work plan and providing the related training as identified.
Develop system specific security guidelines, monitor, document and ensure that all user accounts meet the security standards set by Hospital policy by methods such as receiving and administering the authorization documents, identifying the user's specific application access and timeframes for access, and deleting user access per established protocols. Investigate and report possible misuse of computer resources.
Determine and define requirements for advanced database extensions (system programs, menus, maintenance scripts, etc.) using standard systems analysis techniques. Translate requirements into logical, economical, and practical systems designs. Implement designs by planning, programming, testing and installing system segments to ensure adequacy in meeting requirements.
Define systems requirements by using standard systems analysis techniques such as performing interviews and other data gathering activities. Translate requirements into logical, economical and practical systems designs by preparing detailed specifications such as flowcharts showing system linkage, data movement and resource requirements, documenting input handling, processing and output preparation specifications for each system function, and specifying file, report, and input formats. Plan and guide systems development and implementation activities including application programming by methods such as testing system segments to ensure adequacy in meeting requirements and providing user support, training and consultation services.
Provide work direction and lead hand support when implementing project plans by guiding and ensuring project staff are meeting the requirements of the project activities and implementation schedule.
Maintain working knowledge of current tools and techniques used in the information technology environment by methods such as researching on the Web and through trade journals the current and developing applications, meeting with vendors, and identifying and planning for the impact(s) of future changes.
Provide on-call service when required by consulting by telephone or working non-normal hours to resolve problems.
Performs other related duties as required or assigned.
What you bring:
Graduation from a recognized degree or diploma program in Computer Science or computer systems technology plus six years' recent related experience or an equivalent combination of education, training and experience.
Ability to plan, organize, problem solve and prioritize work.
Ability to communicate effectively both verbally and in writing.
Ability to deal with others effectively.
Physical ability to carry out the duties of the position.
Ability to write programs in related programming language.
Ability to utilize effectively related hardware and systems software.
Ability to function as a lead hand.
What’s in it for you:
Every PHSA employee enables the best possible patient care for our patients and their families. Whether you are providing direct care, conducting research, or making it possible for others to do their work, you impact the lives of British Columbians today and in the future. That’s why we’re focused on your care too – offering health, wellness, development programs to support you – at work and at home.
Join one of BC’s largest employers with province-wide programs, services and operations – offering vast opportunities for growth and development.
Access to more than 2,000 in-house training programs.
Enjoy a comprehensive benefits package, including municipal pension plan.
12 annual statutory holidays with generous vacation entitlement and accruement.
Perks include onsite fitness classes and discounts to 350 BC-wide recreational programs, travel, technology, car and bike sharing, and more.
Job type: Regular Full-Time
Union affiliation: Facilities Subsector
Location: 1795 Willingdon Ave. Burnaby, BC
Rate of pay: $43.35/hr
Closing date: Open until position is filled
Reference number: 102629E
The Provincial Health Services Authority (PHSA) is part of the Provincial Health Services Authority (PHSA). PHSA provides specialized health services to British Columbians, including cancer care, organ transplantation, pediatrics, emergency services, mental health and substance use services. Our values reflect our commitment to excellence and include: Respect people – Be compassionate – Dare to innovate – Cultivate partnerships – Serve with purpose. Learn more about PHSA and our programs: https://jobs.phsa.ca/programs-and-services
PHSA is committed to employment equity, encouraging all qualified individuals to apply. We recognize that our ability to provide the best care for our diverse patient populations relies on a rich diversity of skills, knowledge, background and experience, and value a safe, inclusive and welcoming environment.