Systems Analyst II

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 Canadas Top 100 Employers, BCs Top Employers, and Canadas 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 Citys 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 Citys 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
• Develops data models and performs logical data modeling to support business requirements and related applications development projects; analyzes logical and conceptual models for their ability to meet business design and support business procedural changes; defines data elements comprising the data dictionary; maintains data dictionaries and issues data definitions
• Liaises with enterprise architects, database analysts, application developers and third party vendors to ensure the data models are incorporated into and make use of the corporate data model; participates in the development of data migration planning; provides advice in bridging existing databases to the logical data architecture including advice related to the use of language and compilers in development environment, and use of existing software utilities and identifiers requirement for new utilities
• 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

Where operationally appropriate and subject to change, the City of Vancouver has a Flexible Work Program. This program allows staff to work remotely 1 – 4 days a week from locations that are a daily commutable distance from their work at a City worksite. At this time this position is eligible to be part of the Flexible Work Program.

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.

Apply now

Once you start your application you can save your work and leave the applications page, however please remember to submit your profile to the specific job requisition before the posting closing date.

In addition to uploading your cover letter and resume, part of the application process may include answering application questions related to the preferred requirements of the role which may take approx. 5-10 minutes. Cover letters should express interest and highlight additional information relevant to the position and resumes should include a summary of skills and experience related to the position.