Première détection par notre source: il y a 29 jours
RQ00620 - Sr. Database Administrator
@ Source Code
Toronto, Ontario
En bref
Source Code is hiring a Senior Database Administrator on a 6-month contract (125 business days) with possible extension, for up to 5 days a week onsite at 525 University Avenue, Toronto, at the hiring manager's discretion. The role supports the Ontario health agency's migration of products to Azure cloud and the maintenance of SQL Server and Azure Synapse platforms.
Responsabilités :
- Install, configure, secure and maintain SQL Server, with a focus on SQL Managed Instance
- Manage SQL databases on Azure Cloud, including Always On and clustering
- Lead database disaster recovery design, implementation and monitoring
- Resolve performance issues, deadlocks and data problems
- Support the long-term data warehouse and analytics strategy
Résumé des exigences :
- 7 to 9 years of SQL Server experience (Azure and on-premises)
- 5 years with Azure Synapse Analytics
- 5 years managing Azure SQL dedicated pool, Data Lake and serverless
- AZ-900, DP-900 and DP-300 certifications
Outils et compétences
Source et dates
Type de source non vérifié · manatal
- Date publiée par l’employeur
- Non fourni
- Première détection par notre source
- 2026-10-12
- Mise à jour du dossier source
- 2026-10-12
Ces dates décrivent le dossier source, pas une vérification en direct du recrutement. Consultez l’offre originale.
Détails du poste
| Niveau | Senior |
| Domaine | Données et analytique |
| Expérience | 7 an(s) et plus |
| Déplacements | avion : aucun · route : aucun |
| Milieu de travail | Bureau |
| Position | Surtout assis |
| Exigences physiques | physique faible · ordinateur élevé |
| Langues | English |
| Permis et certifications | AZ-900, DP-900, DP-300 |
Résumé et détails rédigés par l’IA à partir de l’offre; l’offre de l’employeur fait foi.
Source Code
| Champ | Valeur |
|---|---|
| Offres sur Jobsy | 656 |
RQ00620 - Sr. Database Administrator
6-month contract (125 business days)- possible extension
Up to 5 days onsite ( subject to HM's discretion) - 525 University Avenue Toronto
Background:
The Database Administrator will support the next phase of the modernization strategy, OH is committed to migrate appropriate products to Azure Cloud platform and identifying opportunities to improve and mature existing processes both on cloud as IAAS and PAAS from database administration and cloud engineering perspective. As the Agency makes progress towards a more efficient and stream-lined health system, an investment in MS Azure/Synapse platforms and requires maintenance and operation support to sustain growth.
Qaulifications:
- At least 7- 9 years of proven working experience as a SQL Server(Azure and on-prem)
- At least 5 year proven experience working experience Azure Synapse Analytics
- Must have extensive experience with SQL server 2012/14/16/19 on Windows and Linux operating system.
- At least 5 years of experience managing Azure Sql dedicated pool, Data Lake and Server less.
- Must has experience on Azure Managed Instance and Azure Sql database
- Demonstrated understanding of performance tuning and analysis in an Microsoft SQL Server environments
- Must have MS Azure Fundamentals (AZ-900T00), Microsoft Azure Data Fundamentals(DP-900) and Administering Microsoft Azure SQL Solutions(DP-300) certification
Desired Skills:
- Experience with distributed data systems
- Exerience with middleware and gateways
- Experience with researching and implementing cyber security vulnerability remediations
- Awareness of emerging IT trends and directions
- Experience with Computer Aided Software Engineering (CASE) tools
- Knowledge and understanding of Information Management principles, concepts, policies and practices Experience in Database Administration, Maintenance Optimization
- Additional Responsibilities/Skills for Data Warehouse including Oracle OBIEE
- Subject matter expert in database design of the data warehouse or data marts
- Experience and expert knowledge in technology and/or application required including installation, configuration, maintenance, upgrade (technology stack) and cloning
Required Skills:
- Additional Skills for Case Management and ERP
- Experience in designing/developing an automated data distribution mechanism Knowledge and understanding of object-oriented analysis and design techniques.
- Experience in developing enterprise architecture deliverables (e.g. models) based
- Knowledge and understanding of Ontario Government Enterprise Architecture processes and practice
- Knowledge and understanding of Information Management principles, concepts, policies and practices
- Experience in impact analysis, implementation planning and implementation of technology or suite specific patches, maintenance packs and releases, and technology stack patch sets and releases
- Experience in technical design, planning and implementation of specific technology or suite Experience with database administration and vendor support services
- Experience and Skill Set Requirements.
Deliverables:
- Responsible to support the installation, configuration, security, operation, and maintenance of SQL Servers for new servers builds with special focus on Sql Managed Instance.
- Responsible for the development, execution and analysis of database expansions, re-organization and purging of Sql 2019
- Participates in the long-term technical strategy and architecture for the Data Warehouse and Analytics Data Hub
- Develops systems and processes to monitor data quality or integrity, diagnose problems and implement solutions.
- Provides expertise in the support of complex cross-platform database migrations and data governance activities.
- Responsible of SQL high availability options (Log Shipping, DB Mirroring, DB Clustering)
- Resolves and debugs complex reporting and analytic application problems
- Participates in the creation and maintenance of the Enterprise Data Strategy Plan
- Responsible for managing the SQL databases on Azure Cloud, SQL Always-On and Clustering.
- Provides knowledge and direction assistance to support a hybrid environment of on premise and cloud-based database environments.
- Configure, manage, monitor and maintain database server performance, health, availability and security.
- Provide feedback and recommendations to management for best course of action where needed
- Participates in problem analysis and resolution, for example tuning of sql query, deadlocks, data problems, access times, application recoveries, etc
- Performs software review, evaluation, recommendations, design and implementation for database management tools.
- Leads database disaster recovery design, implementation and monitoring.
- Patching, and database backup including testing and execution of SQL and Oracle database backup and recovery processes
- Provide guidance and reference to Tier 1 and Tier 2 Service Desk resources, as well as Tier 3 team members
Must Haves:
- At least 7- 9 years of proven working experience as a SQL Server(Azure and on-prem)
- At least 5 years of proven experience working with Azure Synapse Analytics
- Must have extensive experience with SQL server 2012/14/16/19 on Windows and Linux operating system.
- At least 5 years of experience managing Azure SQL dedicated pool, Data Lake and Serverless.
Nice-to-Have:
- Public Sector experience
Journal
Visible seulement par vous. Conservé sur cet appareil, et dans votre compte une fois connecté.