Source Code
RQ00620 - Sr. Database Administrator
6-month contract Sr. DBA supporting Ontario Health's Azure cloud migration—managing SQL Server (on-prem and Azure), Azure Synapse Analytics, Azure SQL dedicated pools, Data Lake, and Serverless environments with a focus on installation, performance tuning, high availability, and disaster recovery.
- Compensation
- Not disclosed
- Location
- Toronto, ON, Canada
- Work setup
- Hybrid
- Seniority
- Senior
- Employment
- Contract
- Experience
- 5+ years
- Category
- Devops
- Posted
Skills
Must have
- 7–9 years SQL Server experience (Azure and on-prem)
- 5 years Azure Synapse Analytics experience
- SQL Server 2012/14/16/19 on Windows and Linux
- 5 years managing Azure SQL dedicated pool, Data Lake, and Serverless
- Azure Managed Instance and Azure SQL Database experience
- Performance tuning and analysis in MS SQL Server environments
- AZ-900, DP-900, and DP-300 certifications
- Designing/developing automated data distribution mechanisms
- Object-oriented analysis and design techniques
- Enterprise architecture deliverables development
- Ontario Government Enterprise Architecture processes and practice
- Information Management principles, concepts, policies and practices
- Impact analysis and implementation of patches, maintenance packs, and releases
- Technical design, planning and implementation of technology stack
- Database administration and vendor support services experience
Nice to have
- Distributed data systems experience
- Middleware and gateways experience
- Cyber security vulnerability remediation research and implementation
- CASE tools experience
- Oracle OBIEE experience
- SME in data warehouse or data mart database design
- Technology installation, configuration, maintenance, upgrade, and cloning
- Public Sector experience
Full description
RQ00620 - Sr. Database Administrator6-month contract (125 business days)- possible extensionUp to 5 days onsite ( subject to HM's discretion) - 525 University Avenue TorontoBackground:
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