Systems Analyst Ii

4 weeks ago

Vancouver, Canada The City of Vancouver Full time

**Requisition ID**:40321

**Organization**

Located on the traditional, ancestral and unceded lands of the xʷməθkʷəy̓əm (Musqueam), Sḵwx̱wú7mesh (Squamish), and səlilwətaɬ (Tsleil-Waututh) Peoples, Vancouver has a commitment to becoming a City of Reconciliation. Vancouver consistently ranks as one of the world’s most liveable cities and is working towards being the greenest city in the world. Named among Canada's Top 100 Employers, BC's Top Employers, and Canada's Greenest Employers, the City of Vancouver seeks colleagues who can help shape and embody our core commitments to sustainability, decolonization, equity and outstanding quality of life for all residents.

Consider joining our committed team of staff and being part of an innovative, inclusive and rewarding workplace.

**Main Purpose and Function**

The Database Administrator is responsible for managing & administrating the City's databases including: data security; data backups & recovery; performance tuning and configuration; supporting the development and implementation of the data architecture; evaluating and coordinating the implementation of data management and the data dictionary; participating in the development of data migration planning; providing advice on data design; security and data architecture including advice related to the use of DBMS (SQL Server, DB2 and Oracle),.NET, Visual Basic and Java development environments; and use of existing software utilities.

**Specific Duties/Responsibilities**
- Manages the City's databases and data, including backups & recovery, security, performance tuning and configuration
- Performs Database administration, including monitoring, reporting, archiving, capacity planning, design, implementation, testing, maintenance, repair, and documentation
- Develops data architecture and ensures development projects consistently use the architecture; provides advice related to data design, definition, modeling, security and integrations
- Coordinates captured information by ensuring all modeling information is stored properly and that it is readily retrievable. Recommends methods which facilitate the capture and retrieval of data models
- Evaluates existing data security and recommends changes to ensure data is protected
- Maintains a good understanding of general business practices, functions and processes
- Other duties/responsibilities as assigned

**Minimum Position Requirements**

Education and Experience:

- Degree or diploma in Computer Science, with an emphasis on information systems management
- Minimum five years of working experience as a Database Administrator supporting or related experience

Knowledge, Skills and Abilities:

- Demonstrated knowledge of a specific database technology, e.g. Oracle, SQL Server, DB2
- Knowledge of implementing high availability solutions for Oracle and SQL Server
- Familiarity with specific operating system, e.g. Windows, Linux, Unix
- Knowledge of storage technologies, networking, server architecture and server virtualization
- Knowledge of data architecture design and modeling techniques
- Knowledge of program design concepts
- Knowledge of data security techniques and protocols
- Knowledge of current database & data integration platform trends, standards, and products in Information Technology
- Strong analytical and problem solving skills
- Excellent oral, written and presentation/facilitation skills, with ability to communicate at all levels within the organization
- Ability to work both independently and as a member of a team
- Ability to work under pressure, manage multiple priorities and respond to requests in a timely manner
- Ability to establish and maintain effective working relationships with a variety of internal and external contacts and team members to provide advice, information and assistance
- Proficiency in office productivity tools (e.g. Windows, Office, MS Project, etc.)
- Highly trustworthy; capable of handling business critical and sensitive information

**Business Unit/Department**:IT, Digital Strategy & 311 (1070)

**Affiliation**:Exempt

**Employment Type**:Regular Full Time

**Position Start Date**:March, 2024

**Salary Information**:Pay Grade RNG-080: $92864 to $116070 per annum

**Application Close: February 28, 2024**

At the City of Vancouver, we are committed to recruiting a diverse workforce that represents the community we so proudly serve. Indigenous peoples, people of colour, 2SLGBTQ+ persons including all genders and persons with disabilities are encouraged to apply. Accommodations will be provided upon request during the selection process._ _Learn more about our commitment to diversity and inclusion.

  • Systems Analyst Ii

    2 months ago

    Vancouver, Canada University of British Columbia Full time

    Staff - Non Union Job Category M&P - AAPS Job Profile AAPS Salaried - Information Systems and Technology, Level D Job Title Systems Analyst II Department OCIO | Program Delivery Compensation Range $8,063.17 - $12,575.08 CAD Monthly The Compensation Range is the span between the minimum and maximum base salary for a position. The midpoint of the...

  • Systems Analyst Ii

    3 days ago

    Vancouver, Canada University of British Columbia Full time

    Staff - Non Union Job Category M&P - AAPS Job Profile AAPS Salaried - Information Systems and Technology, Level D Job Title Systems Analyst II Department OCIO | Program Delivery Compensation Range $8,063.17 - $12,575.08 CAD Monthly The Compensation Range is the span between the minimum and maximum base salary for a position. The midpoint of the...

  • Systems Analyst Ii

    3 weeks ago

    Vancouver, Canada University of British Columbia Full time

    Staff - Non Union Job Category M&P - AAPS Job Profile AAPS Salaried - Information Systems and Technology, Level D Job Title Systems Analyst II Department Learning Applications, Integrations and Analytics | Centre for Teaching, Learning and Technology Compensation Range $7,278.33 - $11,372.33 CAD Monthly The Compensation Range is the span between...

  • Systems Analyst Ii

    2 weeks ago

    Vancouver, Canada University of British Columbia Full time

    Staff - Non Union Job Category M&P - AAPS Job Profile AAPS Salaried - Information Systems and Technology, Level D Job Title Systems Analyst II Department Learning Applications, Integrations and Analytics | Centre for Teaching, Learning and Technology Compensation Range $8,063.17 - $12,575.08 CAD Monthly The Compensation Range is the span between...

  • Systems Analyst Ii

    1 week ago

    Vancouver, British Columbia, Canada University of British Columbia Full time

    Staff - Non UnionJob CategoryM&P - AAPSJob ProfileAAPS Salaried - Information Systems and Technology, Level DJob TitleSystems Analyst IIDepartmentOCIO | Program DeliveryCompensation Range$8, $12,575.08 CAD MonthlyThe Compensation Range is the span between the minimum and maximum base salary for a position. The midpoint of the range is approximately halfway...

  • Systems Analyst Ii

    4 weeks ago

    Vancouver, Canada University of British Columbia Full time

    Staff - Non Union Job Category M&P - AAPS Job Profile AAPS Salaried - Information Systems and Technology, Level D Job Title Systems Analyst II Department EMMS Sustainment Team | Customer Services & Informatics | Facilities Compensation Range $8,063.17 - $12,575.08 CAD Monthly The Compensation Range is the span between the minimum and maximum base...

  • Systems Analyst Ii

    1 week ago

    Vancouver, British Columbia, Canada University of British Columbia Full time

    Staff - Non UnionJob CategoryM&P - AAPSJob ProfileAAPS Salaried - Information Systems and Technology, Level DJob TitleSystems Analyst IIDepartmentEMMS Sustainment Team | Customer Services & Informatics | FacilitiesCompensation Range$8, $12,575.08 CAD MonthlyThe Compensation Range is the span between the minimum and maximum base salary for a position. The...

  • Systems (Integrations) Analyst Ii

    2 weeks ago

    Vancouver, Canada University of British Columbia Full time

    Staff - Non Union Job Category M&P - AAPS Job Profile AAPS Salaried - Information Systems and Technology, Level D Job Title Systems (Integrations) Analyst II Department OCIO | Integration Enablement Center Compensation Range $8,063.17 - $12,575.08 CAD Monthly The Compensation Range is the span between the minimum and maximum base salary for a...

  • Systems (Integrations) Analyst Ii

    2 weeks ago

    Vancouver, Canada UBC Full time

    Staff - Non Union Job Category M&P - AAPS Job Profile AAPS Salaried - Information Systems and Technology, Level D Job Title Systems (Integrations) Analyst II Department OCIO | Integration Enablement Center Compensation Range $8,063.17 - $12,575.08 CAD Monthly The Compensation Range is the span between the minimum and maximum base salary for a position....

  • Systems (Integrations) Analyst Ii

    1 week ago

    Vancouver, British Columbia, Canada UBC Full time

    Staff - Non UnionJob CategoryM&P - AAPSJob ProfileAAPS Salaried - Information Systems and Technology, Level DJob TitleSystems (Integrations) Analyst IIDepartmentOCIO | Integration Enablement CenterCompensation Range$8, $12,575.08 CAD MonthlyThe Compensation Range is the span between the minimum and maximum base salary for a position. The midpoint of the...

  • Business Analyst Ii

    4 weeks ago

    Vancouver, Canada University of British Columbia Full time

    Staff - Non Union Job Category M&P - AAPS Job Profile AAPS Salaried - Information Systems and Technology, Level D Job Title Business Analyst II Department OCIO | Automation Solution Delivery Compensation Range $8,063.17 - $12,575.08 CAD Monthly The Compensation Range is the span between the minimum and maximum base salary for a position. The...

  • Admission Systems

    2 months ago

    Vancouver, Canada University of British Columbia Full time

    Staff - Non Union Job Category M&P - AAPS Job Profile AAPS Salaried - Information Systems and Technology, Level D Job Title Admission Systems (Integrations) Analyst II Department OCIO | Integration Enablement Center Compensation Range $8,063.17 - $12,575.08 CAD Monthly The Compensation Range is the span between the minimum and maximum base salary...

  • Admission Systems

    1 day ago

    Vancouver, Canada University of British Columbia Full time

    Staff - Non Union Job Category M&P - AAPS Job Profile AAPS Salaried - Information Systems and Technology, Level D Job Title Admission Systems (Integrations) Analyst II Department OCIO | Integration Enablement Center Compensation Range $8,063.17 - $12,575.08 CAD Monthly The Compensation Range is the span between the minimum and maximum base salary...

  • Systems Analyst Ii

    1 week ago

    Vancouver, British Columbia, Canada Seaspan ULC Full time

    Systems Analyst II - HRIS:Duties and Accountabilities: Bridges the gap between functional HR/payroll teams in a multitude of businesses and align activities to work with developers to help them design, test and support integrations to various ERP systems and outside benefit providers. Responsible for system configurations, understanding business...

  • Systems Analyst Ii

    3 weeks ago

    Vancouver, Canada University of British Columbia Full time

    Staff - Non Union Job Category M&P - AAPS Job Profile AAPS Salaried - Information Systems and Technology, Level C Job Title Systems Analyst II Department Administrative Support | Department of Psychology Compensation Range $5,906.25 - $8,508.42 CAD Monthly The Compensation Range is the span between the minimum and maximum base salary for a...

  • Systems Analyst II

    4 weeks ago

    Vancouver, British Columbia, Canada UBC Full time

    Staff - Non UnionJob CategoryM&P - AAPSJob ProfileAAPS Salaried - Information Systems and Technology, Level DJob TitleSystems Analyst IIDepartmentEMMS Sustainment Team | Customer Services & Informatics | FacilitiesCompensation Range$8, $12,575.08 CAD MonthlyThe Compensation Range is the span between the minimum and maximum base salary for a position. The...

  • Systems Analyst II

    2 months ago

    Vancouver, British Columbia, Canada UBC Full time

    Staff - Non UnionJob CategoryM&P - AAPSJob ProfileAAPS Salaried - Information Systems and Technology, Level DJob TitleSystems Analyst IIDepartmentEMMS Sustainment Team | Customer Services & Informatics | FacilitiesCompensation Range$8, $12,575.08 CAD MonthlyThe Compensation Range is the span between the minimum and maximum base salary for a position. The...

  • Business Analyst Ii

    1 week ago

    Vancouver, British Columbia, Canada Best Buy Full time

    Business Analyst II (1 Year Contract) Are you excited to work at Canada's most visited multichannel retailer? Does implementing a warehouse management system and streamlining processes sound fun? As a business analyst II (intermediate), you will analyze business operations, share valuable inputs to your agile team, while providing exceptional change...

  • Business Analyst Ii

    1 week ago

    Vancouver, British Columbia, Canada Best Buy Full time

    Business Analyst II (1 Year Contract) Are you excited to work at Canada's most visited multichannel retailer? Does implementing a new and amazing digital search experience sound fun? As a business analyst II (intermediate), you will analyze business operations, share valuable inputs to your agile team, while providing exceptional change management and...

  • Systems (Integrations) Analyst II

    2 weeks ago

    Vancouver, Canada The University of British Columbia Full time

    Job SummaryThe Admission Systems Analyst II implements, integrates and supports complex or campus-wide vendor supplied applications.The incumbent may be assigned responsibilities for specific departments and will act as an advocate to champion the needs of those departments. This will include coaching business decision makers, understanding the impact of...