Senior Database Administrator

Job title:

Senior Database Administrator

Company

Provincial Health Services Authority

Job description

Senior Database Administrator (Oracle)

BC Clinical & Support Services

Burnaby, BC

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 Oracle 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 Oracle database software supplied by the manufacturers, monitoring key system performance indicators, planning and providing a stable production environment. Establishes and documents 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. Provides 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. Provides 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 resolves 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. Maintains 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 participate 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; analyzes 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, monitors, documents and ensures 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. Investigates and reports possible misuse of computer resources.
• Determine and define requirements for advanced database extensions (system programs, menus, maintenance scripts, etc.) using standard systems analysis techniques. Translates requirements into logical, economical, and practical systems designs. Implements 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. Translates 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. Plans and guides 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.
• Perform other related duties as required or assigned.

What you bring

Qualifications

• 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.

Skills & Knowledge

• 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
• Commitment to upholding the shared responsibility of creating lasting and meaningful reconciliation in Canada as per TRC (2015) and BC’s Declaration on the Rights of Indigenous Peoples Act (2019).
• As a strong asset for consideration, we are looking for our successful candidate to have: Knowledge of social, economic, political and historical realities of settler colonialism on Indigenous Peoples and familiarity with addressing Indigenous-specific anti-racism, anti-racism and Indigenous Cultural Safety and foundational documents and legislative commitments (The Declaration Act, the Declaration Action Plan, TRC, IPS, Remembering Keegan, etc.).

What we bring

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, development, and recognition programs that honour the commitment and contribution of all employees.
• Access to professional development opportunities through our in-house training programs, including +2,000 courses, such as our San’yas Indigenous Cultural Safety Training course, or Core Linx for Leadership roles.
• Enjoy a comprehensive benefits package, including municipal pension plan, and psychological health & safety programs and holistic wellness resources.
• Annual statutory holidays (13) with generous vacation entitlement and accruement.
• PHSA is a remote work friendly employer, welcoming flexible work options to support our people (eligibility may vary, depending on position).
• Access to WorkPerks, a premium discount program offering a wide range of local and national discounts on electronics, entertainment, dining, travel, wellness, apparel, and more.

Job Type: Regular, Full-Time
Wage: $49.01/Hour
Location: 1795 Willingdon Ave Burnaby, BC V5C 6E3
Closing date: Applications are accepted until the position is filled.
Hours of Work: 0800-1600
Requisition #160761E

As per the current Public Health Order, full vaccination against COVID-19 is a condition of employment with PHSA as of October 26, 2021.

What we do

The Provincial Health Services Authority ( ) plans, manages and evaluates specialized health services with the BC health authorities to provide equitable and cost-effective health care for people throughout the province. 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:

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.

Reconciliation is an ongoing process and a shared responsibility for all of us. The BC Government unanimous passing of the Declaration on the Rights of Indigenous Peoples Act was a significant step forward in this journey—one that all health authorities are expected to support as we work in cooperation with Indigenous Peoples to establish a clear and sustainable path to meaningful and lasting reconciliation. True reconciliation will take time and ongoing commitment to work with Indigenous Peoples as we move toward self-determination. Guiding these efforts PHSA must uphold legislative obligations and provincial commitments found in the foundational documents such as including Truth & Reconciliation Commission’s Calls to Action (2015), In Plain Sight (2020), BC’s Declaration on the Rights of Indigenous Peoples Act (2019), United Nations Declaration on the Rights of Indigenous Peoples (UNDRIP), Reclaiming Power and Place Missing and Murdered Indigenous Women & Girls Calls for Justice (2019), the Declaration Act Action Plan and Remembering Keegan: A First Nations Case Study.
Labor Agreement Facilities Subsector
Requisition # 160761E-2413337
Work Site 1795 Willingdon Avenue, Burnaby
Job Type Regular, Full-Time
Salary/Rate $49.01 / Hour
FTE 1.00
Hours of Work 0800-1600
Work Days Mon, Tue, Wed, Thu, Fri
Expiry Date 22-Mar-2024

Expected salary

$49.01 per hour

Location

Burnaby, BC

Job date

Sat, 24 Feb 2024 00:57:33 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (un-jobs.net) you saw this job posting.