Database Analyst, Information Technology
6 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
6 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 Information Architect
3 weeks ago
Vancouver, British Columbia, Canada Cascadia Skincare Full timeCascadia Skincare is seeking a skilled Database Information Architect to design, develop, and implement efficient data management systems. The ideal candidate will have expertise in database administration, data modelling, and warehousing, with a strong focus on data security and access control.Key Responsibilities:Collect and analyze data to identify areas...
-
Database Analyst
6 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
5 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...
-
Data Quality Analyst
2 weeks ago
Vancouver, British Columbia, Canada Saba Software (Canada) Inc. Full timeAbout the RoleWe are seeking an experienced Data Quality Analyst to join our team at Saba Software (Canada) Inc. in Canada.Job SummaryThe successful candidate will be responsible for ensuring the accuracy and integrity of our data, as well as developing and maintaining our databases. This is a permanent position with a salary range of CAD $70,000 - $90,000...
-
Database Developer
3 months ago
Vancouver, Canada Azad Technology Partners Full timeAZAD Technology Partners is seeking a Database Developer for a full-time, W2 Contract position based in Minneapolis, MN. Schedule: Full-time, 40 hours/week, Hybrid (In office / remote telework schedule) Assignment Duration: 12 Months with possibility of extending. Compensation & Benefits: Compensation is between $40.00 - $50.00 hourly. Benefits include...
-
Business Intelligence Database Analyst, Ph Data
6 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
2 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...
-
Database Analyst
6 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,...
-
Information Technology
5 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
5 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 Expert
2 weeks ago
Vancouver, British Columbia, Canada AIRSWIFT TECHNOLOGY LIMITED Full timeAbout the RoleWe are seeking a highly skilled Data Analyst to join our team at AIRSWIFT TECHNOLOGY LIMITED. As a key member of our financial department, you will play a crucial role in helping us drive business growth and success.Job SummaryThe successful candidate will be responsible for analyzing complex financial data, preparing company outlooks, and...
-
Database Engineer
2 months ago
Vancouver, Canada Yeah! Global Full timeNote: Thisposition does not offer any visasponsorship.We areseeking a talented Database Engineer to design build and maintainthe backbone of our data infrastructure ensuring it is reliablescalable and optimized forperformance.JobSummary:As aDatabase Engineer you will be responsible for the architecturedevelopment and maintenance of database systems that...
-
database analyst
6 months ago
Vancouver, Canada ABOMIS INNOVATIONS INC. Full timeEducation: Bachelor's degreeExperience: 2 years to less than 3 yearsTasksDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesCollect and document user's...
-
Information Security Analyst
6 months ago
Vancouver, Canada PHSA Full time**Information Security Analyst / Server Administrator** **Talent on Demand** **Vancouver, BC** The Information Security Analyst / Server Administrator primary focus will be the deployment, maintenance, and monitoring of the server infrastructure related to the security tools and platforms in use at PHSA. The Analyst monitors the IT environment, and...
-
PeopleSoft Systems Analyst
3 months ago
Vancouver, Canada Azad Technology Partners Full timeAZAD Technology Partners is seeking a PeopleSoft Systems Analyst for a full-time, Remote, W2 Contract position.Schedule: Full-time, 40 hours/week, Remote within the continental USAssignment Duration: 3 Months with a high possibility in extending to 1 yearCompensation & Benefits: Compensation is between 53.00 - 58.00 hourly. Benefits include a Co-paid...
-
database analyst
6 months ago
Vancouver, Canada ABOMIS INNOVATIONS INC. Full timeEducation: Expérience: EducationBachelor's degreeTasksDesign and develop databaseOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesCollect and document user's requirementsComputer and...
-
Information & Segmentation Analyst
2 weeks 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,...
-
Healthcare Information Analyst
3 weeks ago
Vancouver, British Columbia, Canada BC Centre for Excellence in HIVAIDS Full timeJob SummaryThe Data Analyst at the BC Centre for Excellence in HIV/AIDS will be responsible for analyzing healthcare information from various sources, including patient care, financial, and demographic data. This involves developing and preparing information products for staff and requiring the ability to analyze healthcare data from conceptualization...
-
Senior Database Systems Developer
2 weeks ago
Vancouver, British Columbia, Canada Cascadia Skincare Full timeJob DescriptionCascadia Skincare is seeking a highly skilled Database Analyst to join our team. As a key member of our IT department, you will be responsible for designing, developing, and maintaining databases to support our business operations.Key Responsibilities:Data Collection and Analysis: Collect data to identify areas for improvement within our...