Senior Database Administrator (DBA)

Senior Database Administrator (DBA)

BC Renal

Vancouver, BC

In accordance with the Mission, Vision and Values, and strategic directions of Provincial Health Services Authority patient safety is a priority and a responsibility shared by everyone at PHSA, and as such, the requirement to continuously improve quality and safety is inherent in all aspects of this position.

Reporting to the Manager of Development, the Senior Database Administrator works within the BC Renal PROMIS team to provide technical expertise and services in the planning, management, and delivery of BC Renal’s provincial PROMIS application and other BC Renal health care and business applications infrastructure, with an emphasis on management and administration of the PROMIS platform infrastructure, and underlying Oracle relational database platforms, running on the SUN/SPARC Solaris and HP’s HP-UX operating systems. The Senior Database Administrator provides second and third level support for Service Desk and Application Support Teams, related to hardware and operating systems.

What you’ll do

• Oversees the architecture, design, implementation, and support of a number of health and business applications, with a focus on the technical platform, which typically have an Oracle relational database running on SUN/Sparc – Solaris operating system.
• Provides technical consultation for all Oracle databases. Responsible for overall stability, maintainability, and business continuity of the Oracle database infrastructure and platform layers to mission-critical standards. Coordinates and /or performs installation, upgrade, or patching activities for vendor platforms.
• Supports various layered products incorporated into vendor supplied solutions considered middleware, including but not limited to Weblogic, Java virtual machines, interface engines, proprietary code installers, management and monitoring toolsets and internet servers.
• Provides leadership to monitoring teams to assess first alert and surveillance monitoring services in order to identify specific and actionable opportunities to determine/develop remediation actions. Monitors, resolves incidents, and constructs support documentation related to the Oracle database products and middleware (platform) layer with emphasis on vendor supported products.
• Manages and maintains SUN/Sparc - Solaris operating systems, including installations and upgrades, installing patches, tuning, development and maintenance of shell scripts. Implements approved changes to the standard database products and related tools such as upgrades to the Oracle version, installing Oracle service patches, layering on business value added products such as dataguard.
• Ensures that due consideration for business continuity and disaster recovery planning is applied to the Oracle Server/ Data Repository infrastructure.
• Supports the Database Architect in maintaining the quality of logical data models, developing the logical data model and implementing the physical database.
• Designs database security plans.
• Creates and maintains DBMS plans to ensure infrastructure capacity and software releases meets PROMIS current and future business needs.
• Delivers metrics specific to service delivery, for example, measures performance improvements obtained through a scheduled re-indexing of the DBMS. Monitors database performance to meet Service Level Agreements.
• Resolves DBMS incidents escalated from the Service Desk and/or escalates these to appropriate vendor and partner contacts for resolution.
• Participates in determining DBMS requirements for new applications and advises Project Managers and Team Leads on standards, service levels, change requirements, and time lines. Provides technical expertise and direction to PROMIS Business Analysts and Quality Assurance teams in the application testing process, with emphasis on technical consultation for the platform.
• Performs backups and recoveries, performance monitoring, performance optimization, disk space utilization, software installation and upgrades, logical and physical data modeling, development of stored procedures, triggers, views, loaders and other database objects, ETL procedures, interfacing and installation and upgrade and support of the Solaris Operating system. Gathers information regarding performance issues and determines what to forward to the Manager/Director for consideration.
• Leads staff training in the use and implementation of application platforms, Oracle software, Solaris system administration, as well as related tools, and best practices.
• Liaises with other information systems groups by networking to ensure awareness of new developments within the health IT community and industry, exchanging information and maintaining currency. Participates in projects and meetings on an ad hoc basis, as required.

What you bring

Qualifications

• A level of education, training, and experience equivalent to a Bachelor’s degree in Computer Science and a minimum of seven 7) years of experience in management of large database implementations with minimum of two years’ experience performing Oracle DBA and system administration responsibilities in SPARC/Solaris environment.
• At least one (1) year experience working on a large project team with other technical staff. Certifications for Oracle Database Administration and Solaris System Administration and familiarity with the Cerner or other health care clinical suite of applications.
• Ability to keep skills set up to date with new technologies as they are introduced to the workplace.
• Effective interpersonal, verbal, and written communication skills.
• Ability to write programs in a variety of programming languages such as Korn shell scripts, SQL Plus, ANSI SQL and Perl.
• Ability to analyze issues arriving at decisive actions in stressful situations.
• Versed in data repository and metadata best practices.
• Ability to work independently and organize workload and priorities.
• Ability to transfer knowledge and skills to other department staff.
• Ability to provide clear and concise system documentation and procedures for other staff.
• Physical ability to perform job.

Skills & Knowledge

• 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 impacting indigenous communities and familiarity with Indigenous Cultural Safety and anti-racism and accompanying reports (BC DRIPA, TRC, 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

Salary Range: $86,398 - $124,197 /year. The starting salary for this position would be determined with consideration of the successful candidate’s relevant education and experience, and would be in alignment with the provincial compensation reference plan. Salary will be prorated accordingly for part time roles.
Location: 1200 Burrard St, Vancouver, BC V6Z 2C7
Closing date: Applications accepted until position is filled
Hours of Work: 0830-1630 (Monday to Friday)
Requisition # 161014E

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 (PHSA) 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: 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.

Reconciliation is an ongoing process and a shared responsibility for all of us. The BC Governments’ unanimous passage 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 lasting reconciliation. True reconciliation will take time and ongoing commitment to work with Indigenous Peoples as they move toward self-determination. Guiding these efforts Crown agencies must remain focused on creating opportunities that implement the Truth and Reconciliation Commission Mandate.

ATTN: PHSA Employees:

To be considered as a PHSA employee (internal applicant) for this position, you must apply online via your internal profile at http://internaljobs.phsa.ca  

Please note the internal job posting will no longer be accessible after the expiry date of March 5, 2024. If the internal job posting has expired, please contact the Internal Jobs Help Desk and advise that you would like to be considered as a late internal applicant for this position. Please do not apply for the external job posting.

If you have not registered your internal profile, a password is required to log in for the first time. To obtain your password, please contact the Internal Jobs Help Desk at 604-875-7264 or 1-855-875-7264. Please note regular business hours are Monday – Friday (excluding stats), 8:30am to 4:30pm. For inquiries outside of regular business hours, please email the Internal Jobs Help Desk at internaljobshelpu@phsa.ca and a Help Desk Representative will contact you the next business day.