Reporting to the Director, Analytics and Informatics Architecture, the Database Programmer supports and develops new and existing database systems within the BC Provincial Blood Coordinating Office (PBCO). Applying a broad range of information technology experience and knowledge, the Database Programmer draws on a high level of expertise in the management of any scale database environments, providing technical direction to help translate data business needs into requirement specifications. Plans, designs, and develops solutions, ensuring the integrity and quality of the data accessible through the PBCO applications. Plays a key role in the team by defining and implementing standards, performing security reviews, and providing the framework for database system development.
What you’ll do:
Develop and maintain the PBCO’s data models such as the Central Transfusion Registry (CTR) and Inherited Coagulopathy and Hemoglobinopathy Information Portal (iCHIP), describing data elements and how they are used. Write and code logical and physical data rules, specify constraints and apply security measures and policies for database access. Develop standards and guidelines to guide the use of databases and to protect vulnerable information.
Perform analysis/requirements, identify technical specifications, plan, design, develop, perform Quality Assurance (QA) and User Acceptance Tests (UAT), and prepare documentation for new and existing database systems. Assist in the architecture for database and application environments, including business and clinical systems, and corporate data warehouses.
Ensure overall data quality, integrity and security of information stored in electronic media to ensure exactness when used in clinical, research or day-to-day blood utilization management programs. Ensure the delivery and receipt of all electronic media meets current applicable provincial and national acts and regulations for the transfer of confidential health information.
Act as database administrator by providing standard systems management. Provide database support for the databases and associated application components in clinical and other areas of the organization, performing Extract, Transform, Load (ETL) processes and systems analysis.
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.
Assist in developing policies, procedures and best practices for database development, deployment and change control.
Provide assistance to PBCO users and stakeholders in Data Analytics for report building, optimization, schema and data interpretation.
Participate in project teams to ensure database development activities adhere to implementation standards and practices.
Assist the users to resolve data integrity issues to provide corrective actions as required.
Communicate with Managers, project stakeholders and team members to understand and clarify requirements and implementation of technical specifications.
What you bring:
A Bachelor’s degree in Engineering, Information Systems, Computer Science or related discipline, plus a minimum of five (5) years recent related experience in database architecture planning, design and development of multi-tiered, multi-threaded, high availability infrastructure.
Understanding and experience with Big Data technologies - Hadoop based data lake architecture, data pipeline development, ingestion frameworks is preferred.
Applied experience and knowledge using Scala/Python/SparkSQL for data management processes is preferred.
Experience using Business Intelligence and Visualization tools (ex: PowerBI, Tableau, SAP BusinessObjects) is an asset.
Knowledge of statistical inference and modelling using software such as R or SAS is an asset.
You also have:
Extensive knowledge of data structure, operating systems and networking protocols n-tier client server development including an understanding of object oriented and component based systems architectures.
Proven hands-on experience with Oracle including queries, PL/SQL, stored procedures, and when to use triggers/views, and SQL, XML, client/server and Web development.
Superior analytical and problem solving skills, including the ability to troubleshoot, comprehend, analyze and resolve complex issues and recommend innovative solutions.
Excellent interpersonal, oral and written communication skills with the ability to understand and effectively communicate technical information to non-technical staff.
Resourceful and well organized with demonstrated ability to manage time, exercise good judgment and initiative, and deal with frequent changes.
Ability to work with minimal supervision.
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
Location: 1867 W. Broadway Vancouver, BC
Closing date: Open until position is filled
Reference number: 102979E
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
We hire on the basis of merit and encourage all qualified applicants 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, backgrounds and experiences. We strive to create a safe and welcoming environment where everyone can come to work and be their best, authentic self.