Job Title: Database Administrator - Senior

Location: Toronto, Ontario, Canada

Work Model: Onsite

Duration: 11 months

Extension: 1 Time

Must Haves

- 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.)

Description / Responsibilities / Skills

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

General Skills:

- Experience in monitoring and enforcing database rules
- Experience in Incident, Change and Configuration Management procedures
- Experience in the use of information retrieval packages and proficiency with query languages
- Experience with one or more communications protocols

Desirable Skills:

- Experience with distributed data systems
- Experience with middleware and gateways
- Experience with researching and implementing cyber security vulnerability remediations
- Experience with Computer Aided Software Engineering (CASE) tools
- Knowledge and understanding of Information Management principles, concepts, policies and practices

Additional Responsibilities/Skills for Data Warehouse including Oracle OBIEE





- Subject matter expert in database design of the data warehouse or data marts.

Experience & Skill Set Requirements

Technical Skills (40%)

- 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 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%)

- Robust 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

📌 Database Administrator (Toronto)
🏢 InnosysTech
📍 Toronto