Responsibilities:
- Creates physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery
Must Have Experience:
- Experience with major database management systems (DBMS) such as Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2
- Experience managing cloud-hosted or hybrid databases (e.g., Azure SQL, Amazon RDS, Google Cloud SQL) alongside legacy on-premises mainframes and enterprise servers
- Experience Cloud (Azure or AWS), Cyber Security, Enterprise and Solution Architecture, Java, Microsoft .Net,
- Experience with SQL Server, Oracle, Cloud Databases (Structured and Unstructured, SQL MI, Azure Blob, Cosmos DB etc.)
Technical Skills (40%)
- Experience with major database management systems (DBMS) such as Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2
- Experience managing cloud-hosted or hybrid databases (e.g., Azure SQL, Amazon RDS, Google Cloud SQL) alongside legacy on-premises mainframes and enterprise servers
- Experience with Agile methodologies
- Experience with conceptual, logical, and physical data modeling, schema design, and enterprise data architecture to support large-scale public applications
- Experience with onPrem and Cloud connections using Mulesoft or similar tools
- Experience Cloud (Azure or AWS), Cyber Security, Enterprise and Solution Architecture, Java, Microsoft .Net,
- Experience with SQL Server, Oracle, Cloud Databases (Structured and Unstructured, SQL MI, Azure Blob, Cosmos DB etc.)
- Experience with Rest APIs & Integrations, Web/Lite Apps
Experience (40%)
- Experience with cloud platforms such as Azure, Dynamics 365, Power Platform
- Experience Implementing strict role-based access control (RBAC), data masking, row-level security, and transparent data encryption (TDE) at rest and in transit
- Ensuring adherence to provincial data privacy and security mandates
- Designing, testing, and executing enterprise backup strategies, point-in-time recovery, geo-replication, and business continuity failover drills
- Experience with Agile methodologies including using kanban/task boards
- Hands-on experience leading major database version upgrades, cross-platform migrations, and consolidation projects without disrupting agency services
- Experience with SQL, PL/SQL, T-SQL, and shell scripting (Bash, PowerShell, Python) for automation, stored procedures, and triggers
- Experience with large government applications
Communication Skills (20%)
- Strong communication skills to prepare documentation, including but not limited to; reports, reviews, assessments
- Ability to present ideas and suggestions clearly and effectively and in a user friendly manner; maintain a high level of customer service to both internal and external clients
- Ability to communicate designs and development in clear and understandable manner
