Database Analyst, Information Technology
7 months ago
Full-time, permanent
Position summary
The database analyst (DBA) reports to the information technology (IT) operations manager. You will be responsible for assisting in the designing, testing, planning, implementing, protecting, operating, managing and maintaining the College's databases. This will be done in conjunction with the senior database specialist and other IT personnel in order to ensure the stable operation of the organization's IT infrastructure. This includes the proactive planning and deployment of necessary upgrades, in terms of both hardware and software, to ensure the College can effectively carry out its obligations in a secure fashion.
You thrive in a fast-paced environment, managing multiple competing priorities and assignments. You have a solid understanding of the technical and theoretical principals required in order to support the management of a complex database environment.
Duties and responsibilities
**Duties include but are not limited to the following**:
- assist with schema design, code review, SQL query tuning
- install, implement and upgrade DBMS installations
- write and deploy SQL patches
- proactively and regularly make recommendations for system improvements
- collate, prepare and present statistical information for internal and external use
- define hardware and infrastructure standards in conjunction with owners and stakeholders.
- test network and server performance and provide statistics and reports; develop strategies for maintaining network and server performance.
- work with respective team members to develop and test DR and BCP plans.
- easily design and implement a business process into functional and efficient code
- implement and manage company data management practices and policies
Skills and qualifications
**Required skills and qualifications include**:
- Bachelor’s degree in computer science or a related information technology field
- 3+ years of experience with programming languages such PL/SQL coding
- 3+ years of experience in administering, managing and tuning databases
- 3+ years of experience with Oracle RAC, SQL Server or MySQL
- strong knowledge of Microsoft technologies including Active Directory, Windows server and desktop environments, SharePoint, Exchange, SQL, CRM, Dynamics AX
- functional knowledge of LAN/WAN protocols such as TCP/IP, DNS, DHCP, SMTP & SNMP
- strong understanding of high availability and disaster recovery principles, technologies and procedures
- solid experience with data center operations, VMware, phone systems and SAN environments
- expertise in SQL
- sense of ownership and pride in your performance and its impact on organization’s success
- advanced knowledge of database security, backup and recovery, and performance monitoring standards
- experience with SharePoint, NAV, Azure and/or High Availability would be an asset
- critical thinker and problem-solving skills
- team player
- process work accurately and in a timely manner
- good time-management skills
- great interpersonal and communication skills
- attention to detail - attends to details and pursues quality in the accomplishment of tasks, regardless of the volume of duties encountered
The compensation range for this position is $65,344 - $81,860 per year.
We thank all applicants for their interest; however, only those selected for interview will be contacted.
The College of Physicians and Surgeons of British Columbia has been recognized as one of BC’s top employers since 2011 and one of Canada’s top 100 employers since 2014. Our goal is to attract, develop and retain highly talented employees. We offer an excellent working environment including a hybrid work-from-home/in-office model, opportunities for personal and professional growth, and a comprehensive benefits package. The College welcomes all applicants and is dedicated to promoting a diverse, equitable and inclusive environment.
The College of Physicians and Surgeons of BC welcomes diversity, questions inequality and is committed to an inclusive and diverse workforce. We do not discriminate against any applicant regardless of race, colour, ancestry, place of origin, religion, martial status, family status, physical or mental disability, sex, sexual orientation, political belief, socio-economic background, criminal conviction.
The College is located on the unceded territory of the Coast Salish peoples, including the territories of the xʷməθkwəy̓əm, Skwxwú7mesh, and Səl̓ílwətaʔ/Selilwitulh Nations.
-
Database Analyst
7 months ago
Vancouver, Canada ZOMI Technology Ltd. Full timeEducation: College/CEGEP - Experience: 1 year to less than 2 years **Tasks**: - Collect and document user's requirements - Design and develop database - Research and document data requirements, data collection and administration policy, and data access rules - Conduct research and provide advice to other information systems professionals regarding the...
-
Database Analyst
7 months ago
Vancouver, Canada ZOMI Technology Ltd. Full timeEducation: - Expérience: **Education**: - College/CEGEP **Tasks**: - Design and develop database - Research and document data requirements, data collection and administration policy, and data access rules - Collect and document user's requirements **Screening questions**: - Do you have previous experience in this field of employment? **Experience**: -...
-
IT (Information Technology) Development Manager
6 months ago
West Vancouver, Canada Toonie Holding Inc. Full timeDurée de l'emploi: Permanent - Langue de travail: Anglais - Heures de travail: 40 hours per week - Education: - Expérience: **Education**: - College, CEGEP or other non-university certificate or diploma from a program of 3 months to less than 1 year - or equivalent experience **Tasks**: - Coordinate IT projects, including the design and deployment of...
-
Database Administrator/analyst
2 days ago
North Vancouver, Canada District of North Vancouver Full time**Database Administrator/Analyst**: **3 Year Temporary Full-Time** Home to vast parkland and attractions including Grouse Mountain, Lynn Canyon and Capilano Suspension Bridge, the District of North Vancouver is inspired by nature, and enriched by people. Designated one of **BC’s Top Employers **for 4 years, the District offers exciting professional...
-
Business Intelligence Database Analyst, Ph Data
7 months ago
Vancouver, Canada PHSA Full time**Business Intelligence Database Analyst, PH Data** BC Centre for Disease Control Vancouver, BC Are you ready to make a difference? The BC Centre for Disease Control, a dynamic Provincial Health Services Authority program, seeks passionate individuals to join us in providing provincial and national leadership in disease surveillance, detection, treatment,...
-
Analyst, Laboratory Information Systems
4 months ago
Vancouver, Canada PHSA Full time**Analyst, Laboratory Information Systems** PHSA Corporate Vancouver, BC In accordance with the Mission, Vision and Values, and strategic directions of PHSA safety, including both patient and employee safety, is a priority and a responsibility shared by everyone at PHSA’s Agencies/Divisions/Services, and as such, the requirement to continuously improve...
-
Information Technology
6 months ago
Vancouver, Canada Aritzia Full timeTHE TEAM The mission of the Technology Division Services Department is to ensure the seamless running of the day-to-day business initiatives by reducing churn and increasing productivity. THE OPPORTUNITY Aritzia is growing and our Technology Division Services team is growing with it. This is a unique opportunity to be part of the team responsible for the...
-
Database Analyst
7 months ago
Vancouver, Canada ABOMIS INNOVATIONS INC. Full timeEducation: Bachelor's degree - Experience: 2 years to less than 3 years **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy,...
-
Database Analyst
6 months ago
Vancouver, Canada ABOMIS INNOVATIONS INC. Full timeEducation: - Expérience: **Education**: - Bachelor's degree **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards and...
-
Data Analyst
3 weeks ago
Vancouver, British Columbia, Canada DataSeer Full timeJob SummaryDataSeer is seeking an experienced Data Analyst with expertise in database management to join our team. This role involves working closely with data administrators to develop and implement strategic blueprints for database deployment, ensuring the security and integrity of our organization's IT infrastructure.About the RoleIn this position, you...
-
Information & Segmentation Analyst
2 months ago
Vancouver, Canada BC Hydro Full time**A workplace powered by you** At BC Hydro, we’re working towards creating a cleaner and more sustainable future for all British Columbians and need people like you to help us. A career at BC Hydro is meaningful and provides you the opportunity to be part of a talented, inclusive, and diverse team. We offer a healthy work-life balance, competitive wages,...
-
Information Technology
4 weeks ago
Vancouver, Canada Pan American Silver Corp. Full timeEducation: - Expérience: - **Education**: - College/CEGEP - ** Work setting**: - General office - ** Tasks**: - Give access to computer networks - Respond to users experiencing difficulties with computer - Provide advice and training to users in response to identified difficulties - Collect, organize and maintain a problems and solutions log for use by...
-
Information Technology
4 months ago
Vancouver, Canada Pan American Silver Corp. Full timeEducation: College/CEGEP - Experience: 2 years to less than 3 years **Work setting**: - General office **Tasks**: - Give access to computer networks - Respond to users experiencing difficulties with computer - Provide advice and training to users in response to identified difficulties - Collect, organize and maintain a problems and solutions log for use by...
-
Information Technology
2 months ago
Vancouver, Canada Pan American Silver Corp. Full timeEducation: College/CEGEP - Experience: 2 years to less than 3 years - **Work setting**: - General office - ** Tasks**: - Give access to computer networks - Respond to users experiencing difficulties with computer - Provide advice and training to users in response to identified difficulties - Collect, organize and maintain a problems and solutions log for...
-
Analyst, Database
3 weeks ago
Vancouver, Canada DataSeer Full timeEducation: - Expérience: - **Education**: - Bachelor's degree - ** Work setting**: - Software company - ** Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure - Develop and implement a strategic blueprint to follow when deploying databases within their organization - Develop and maintain computer...
-
Information Technology
7 months ago
Vancouver, Canada Nuvollo Corp Full timeEducation: Bachelor's degree - Experience: 2 years to less than 3 years - or equivalent experience **Work setting**: - Help desk - On-site customer service **Tasks**: - Document technical requirements to ensure that products, processes and solutions meet business requirements - Provide advice on information systems strategy, policy, management and service...
-
Information Technology Support Analyst
3 weeks ago
Vancouver, Canada Finning Canada Full timeCompany: Finning International Inc. Number of Openings: 1 Worker Type: TemporaryPosition Overview: As a Platform Support Analyst II, you will be part of a global support team responsible for supporting and maintaining Finning’s digital platforms and suite of applications, performance metrics and related KPIs. These applications offer technical solutions to...
-
Information Security Analyst
4 months ago
Vancouver, Canada Concert Properties LTD. Full timeAbout Concert Properties Putting people first is at the heart of the Concert Properties story. We are deeply invested in improving the lives of the people who live and work in our communities, acknowledging that communities are more than just buildings. We focus on quality, consistency, and sustainability, and our business is driven by warm, passionate...
-
Systems Analyst
7 months ago
Vancouver, Canada School District #39 (Vancouver) Full time**THE ORGANIZATION**: VANCOUVER SCHOOL BOARD (SCHOOL DISTRICT 39) With deep gratitude and respect, we are honoured to be learning and unlearning on the ancestral and unceded lands of the xmkym (Musqueam), Swxwú7mesh Úxwumixw (Squamish) Nation, and slilwta (Tsleil-Waututh) Nation. At the VSB, we are proud to provide exceptional learning experiences for...
-
Information Technology
7 months ago
Vancouver, Canada Clean-Rite Drycleaners Corp Full timeEducation: - Expérience: **Education**: - Bachelor's degree - or equivalent experience **Work setting**: - Private company, corporation or industry - Information technology (IT) infrastructure **Tasks**: - Confer with clients to identify requirements - Document technical requirements to ensure that products, processes and solutions meet business...