Systems Analyst II

Job summary

The Database Administrator manages and maintains the City's on-premise and cloud-based database environments, ensuring data security, performance, and business continuity. They also develop data architecture, perform logical data modeling, and support cloud migration and modernization initiatives.

Job details

Requisition ID: 46366 Organization Vancouver is consistently ranked as one of the world’s most liveable and environmentally sustainable cities. Recognized among BC’s Top Employers and Canada’s Greenest Employers, the City of Vancouver is seeking colleagues who can help advance our core commitments to exceptional public service, sustainability, equity, and an outstanding quality of life for all residents. With a strong commitment to being a City of Reconciliation, we invite you to join our dedicated team and become part of an innovative, inclusive, and engaging workplace. A career with the City of Vancouver and within the broader public service, offers meaningful work where you play a key role in ensuring equitable access to services, upholding ethical governance, and supporting the needs of citizens with integrity and dedication. Main Purpose and FunctionThe Database Administrator is responsible for managing & adminstrating the City's on-premise and cloud-based 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, Azure SQL Database, Azure SQL Managed Instance, 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; ensures availability, reliability, business continuity and operational support of on-premises and cloud-based database environments• Performs Database administration, including monitoring, reporting, archiving, capacity planning, design, implementation, testing, maintenance, repair, and documentation• Supports cloud adoption, database migration, modernization and integration initiatives, including platform upgrades, high availability, disaster recovery and operational readiness• 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, maintains and governs enterprise metadata, data dictionaries and data definitions to support consistency, quality, stewardship and effective use of City data assets• 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 utilties 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 database compliance, resiliency and operational risks and recommends improvements to protect the confidentiality, integrity and availability of City dataMaintains a good understanding of general business practices, functions and processes• Other duties/responsibilities as assigned Minimum Position RequirementsEducation 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, Azure SQL Database and Azure SQL Managed Instance• 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 Affiliation: Exempt Employment Type: Regular Full Time Position Start Date: November, 2026 Salary Information: Pay Grade RNG-080: $102,960 to $128,961 per annum Application Close: September 18, 2026 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. The City of Vancouver acknowledges that it is situated on the unceded traditional territories of the xʷməθkʷəy̓əm (Musqueam Indian Band), Sḵwx̱wú7mesh Úxwumixw (Squamish Nation), and səlilwətaɬ (Tsleil-Waututh Nation).More about unceded traditional territories Before you click 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.

What you’ll do

The Database Administrator manages and maintains the City's on-premise and cloud-based database environments, ensuring data security, performance, and business continuity. They also develop data architecture, perform logical data modeling, and support cloud migration and modernization initiatives.

Requirements

Candidates must possess a degree or diploma in Computer Science with an emphasis on information systems management. A minimum of five years of working experience as a Database Administrator is required.

Listed skills

• Problem solving · Preferred
• Communication · Preferred
• Oracle · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Database Administration
• SQL Server
• Oracle
• Azure SQL Database
• Data Architecture
• Data Modeling
• Performance Tuning
• Backup And Recovery
• Cloud Migration
• Data Security
• Metadata Management
• High Availability
• Disaster Recovery
• Analytical Skills
• Problem Solving
• Communication
• Digital Media Strategy
• Program Design
• Urban Sustainability
• Resilience
• Ethical Standards And Conduct
• Planning
• Microsoft Access
• Java (Programming Language)
• .NET Framework
• Visual Basic (Programming Language)
• Archives
• Microsoft Azure
• Backup Devices
• Reconciliation
• Business Continuity
• Management
• Business Requirements
• Unix
• IT Capacity Management
• Compilers
• Computer Science
• Information Systems
• Information Technology
• Confidentiality
• Corporate Data Management
• Database Management Systems
• Data Dictionary
• Data Integration
• Data Management
• Data Migration
• IBM DB2
• Linux
• Operating Systems
• Development Environment

Job areas

• Technology
• Data & Analytics
• Software
• Government & Public Sector
• Systems Analyst
• Systems Analysts
• Computer Systems Analysts