Systems Analyst II

Main purpose and function

Specific duties and responsibilities

• Manage databases and data, including backups, recovery, security, performance tuning, configuration, availability, reliability, and business continuity.
• Perform monitoring, reporting, archiving, capacity planning, design, implementation, testing, maintenance, repair, and documentation.
• Support cloud adoption, database migration, modernization, integration, upgrades, high availability, and disaster recovery.
• Develop data architecture and advise on data design, definitions, modeling, security, and integrations.
• Develop logical data models for business requirements and application development projects.
• Govern enterprise metadata, data dictionaries, and data definitions.
• Collaborate with architects, analysts, developers, and vendors on corporate data models and migration planning.
• Coordinate storage and retrieval of modeling information.
• Evaluate database compliance, resiliency, and operational risks and recommend improvements.

Minimum position requirements

• Degree or diploma in Computer Science with an emphasis on information systems management.
• At least five years of experience as a Database Administrator or in related work.
• Knowledge of Oracle, SQL Server, DB2, Azure SQL Database, or Azure SQL Managed Instance.
• Knowledge of high-availability solutions for Oracle and SQL Server.
• Familiarity with Windows, Linux, or Unix.
• Knowledge of storage, networking, server architecture, and virtualization.
• Knowledge of data architecture, modeling, data security, and integration platforms.
• Strong analytical, problem-solving, communication, and presentation skills.
• Ability to work independently, manage priorities, and maintain effective relationships.
• Proficiency with office productivity tools such as Windows, Office, and MS Project.

Salary information

• The position is paid CAD 102,960 to CAD 128,961 per annum under Pay Grade RNG-080.

Organization