Browse
Employers / Recruiters

Database Administrator - Senior

Negotiable
Full-time
Continue
By pressing the button above, you agree to our Terms and Privacy Policy, and agree to receive email job alerts. You can unsubscribe anytime.
Job Title- RQ03446 - Database Administrator - Senior
Client -Ministry of Solicitor General
Start Date 2022-05-09
End Date 2023-04-05
Duration: 12 Months
Location Toronto

A note on Assignment Type :
This position is currently listed as "Onsite "; however, the consultant will be remote due to COVID-19 related Work from Home (WFH) direction. Once the I&IT cluster staff are required to return to the office, the resource under this request will be required to work onsite as well.


Must have:
Demonstrated experience working within database environments such as SQL Server 2012-2016 & Oracle 11g
Expert experience working with SQL Server databases in the cloud (Azure preferred specifically SQL Managed Instance and SQL Database)
Demonstrated experience working within operation systems environments such as Windows 10, Windows Server 2016 & 2019.
Expert experience in migrating Oracle database (11g) to SQL Server (2016/2019)
Expert experience in installing and configuring database servers (MS SQL 2016+) using various high availability technologies
Extensive experience in performance tuning and troubleshooting, monitoring, patching and optimization of the databases
Expert experiences in developing and adhering to strong security practices with regards to Authentication, Authorization and Encryption


Description
Scope:
The Office of the Public Client and Trustee (OPGT) requires a Database Administrator/Developer L3 with 9 + years' experience to perform the required data migration tasks from existing OPGT legacy applications to the new Dynamics 365 OPGT solution.

Deliverables:
Responsible for the creation and maintenance of SQL Server database & transaction processing environments related to the data migration tasks from existing OPGT legacy applications (mainly Oracle 11g) to SQL Server 2016/2019 backend databases.
Provide technical support for transaction processing, data access, performance tuning, and database recovery.
Provide strong technical knowledge and business subject matter expertise across a wide range of database technologies, with a primary focus on SQL servers.
Provide knowledge transfer to the business and other IT resources, and maintaining documentation

The Vendor's Personnel will also be required to:
  • Complete work and achieve milestones within the assigned deadlines;
  • Notify the Cluster/Ministry project Manager in writing of any issues or other material concerns related to the Assignment Deliverables, as soon as the he/she becomes aware of them;
  • Submit Deliverables for the Cluster/Ministry approval as they are completed;
  • Comply with the Ontario Government and the Cluster/Ministry security procedures and practices;
  • Comply with the Ontario Government and the Cluster/Ministry architecture/technology standards and best practices;
  • Comply with the Ontario Government and the Cluster/Ministry Conflict of Interest and Confidentiality Guidelines;
  • Provide knowledge and skill transfer to a designated Cluster/Ministry staff; and
  • Comply with the Ontario Government I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedures.

Skills
Experience and Skill Set Requirements
Mandatory Requirements:
  • 9+ years of proven working experience in Microsoft SQL Server technology and current on SQL Server releases (i.e. SQL Server 2012, 2014, 2016, 2017, 2019)
  • 5 + years' experience and expert knowledge of Oracle RDBMS 11-12 in a Windows environment and SQL Server RDBMS 2008-2016

Skills and Knowledge:
9+ years of proven working experience in Microsoft SQL Server technology and current on SQL Server releases (i.e., SQL Server 2012, 2014, 2016, 2017, 2019)
Solid experiences of migrating Oracle databases to SQL Server.
In-depth technical knowledge of SQL Server and Oracle database structure, transaction management and performance tuning
Experienced with data manipulation languages, data definition languages, physical database design, and application performance analysis & tuning
Install, configure and deploy MS SQL Server using automation and infrastructure as code and developautomation of the database processes, tasks and procedures
Experience of Operating Systems: Windows 10, Windows Server 2016 & 2019
Analytical, problem solving and decision-making skills; organizational, creativity and perseverance skills
Experience with relational database technologies
Knowledge and experience in the implementation of a mechanism for document generation and field-population from disparate data sources
Proficiency with user requirements, understanding business processes, and creating solutions based upon requirements
Excellent verbal and written communication skills
Highly developed interpersonal skills

Resume Evaluation Criteria:
Criteria 1: Database Administration = 50 points
Demonstrated experience working within database environments such as SQL Server 2012-2016 & Oracle 11g
Expert experience working with SQL Server databases in the cloud (Azure preferred specifically SQL Managed Instance and SQL Database)
Demonstrated experience working within operation systems environments such as Windows 10, Windows Server 2016 & 2019.

Criteria 2: Technical Skills = 40 points
Expert experience in migrating Oracle database (11g) to SQL Server (2016/2019)
Expert experience in installing and configuring database servers (MS SQL 2016+) using various high availability technologies
Extensive experience in performance tuning and troubleshooting, monitoring, patching and optimization of the databases
Expert experiences in developing and adhering to strong security practices with regards to Authentication, Authorization and Encryption

Criteria 3: Knowledge of Microsoft Dynamics 365 Solutions
Criteria 3 Points: 5 points
Criteria 3 Details:
Understanding of Microsoft Dynamics 365 ERP and CRM solution

Interpersonal Skills =5 points
  • Demonstrated communication and problem-solving skills



Last updated on Apr 5, 2022

See more

More jobs at pojdnw80b39b3ntfgwn4yb4jyt4x4z064338el3fkvabiv4hp8y45oqjqctk2pwu

Analyzing

Toronto, Ontario

 · 

30+ days ago

Toronto, Ontario

 · 

30+ days ago

Toronto, Ontario

 · 

30+ days ago

Ottawa, Ontario

 · 

30+ days ago

More jobs like this

Analyzing

Remote

 · 

30+ days ago

Business Analyst Junior
P
pojdnw80b39b3ntfgwn4yb4jyt4x4z064338el3fkvabiv4hp8y45oqjqctk2pwu

Toronto, Ontario

 · 

30+ days ago

Data Architect
6
6hjdnwe6452jxyopb8yrghazw5r3c707c9urp8igk5pjwt0ln301k8r8fwh0eg85

Sydney, Nova Scotia

 · 

30+ days ago

Database Administrator
9xjdnw687b7a7nvvdyut936kpjlgy0023blrozaecads0pdnwppcswnaaku8ji2g

Toronto, Ontario

 · 

30+ days ago

Azure Devs/Devops
S
svjdnwzkulao5hqo7t0ifgvj8s71sf01d7dtgdstyhdixakxt6ty85zljsdyhgz2

Toronto, Ontario

 · 

30+ days ago

Data Architect
D
dhjdnwh4qm62pb5vm2o4tbd72ej7oa01f47beu0d9d984ckrwi58r2ocg36n82t5

Toronto, Ontario

 · 

30+ days ago

Technical Support
Q
qvjdnwe572ghl7nxzooczu4p6c4c5a0430flsot5fdrnb6of92vtejcidf753nik

Windsor, Ontario

 · 

30+ days ago

SAP FICO Consultant - L3
X
xqjdnwum8oe935is790zhbfck1aprd003elonkucumk32wqir9sfoblyhmevqevo

Ottawa, Ontario

 · 

30+ days ago

Montreal, Quebec

 · 

30+ days ago

 · 

30+ days ago

Developed by Blake and Linh in the US and Vietnam.
We're interested in hearing what you like and don't like! Live chat with our founder or join our Discord
Changelog
🚀 LaunchpadNov 27
Create a site and sell services based on your resume.
🔥 Job search dashboardNov 13
Revamped job search UI with a sortable grid, live filtering, bookmarks, and application tracking.
🫡 Cover letter instructionsSep 27
New Studio settings give you control over AI output.
✨ Cover Letter StudioAug 9
Automatically generate cover letters for any job.
🎯 Suggested filtersAug 6
Copilot suggests additional filters above the results.
⚡️ Quick applicationsAug 2
Apply to jobs using info from your resume. Initial coverage of ~200k jobs in Spain, Germany, Austria, Switzerland, France, and the Netherlands.
🧠 Job AnalysisJul 12
Have Copilot read job descriptions and extract out key info you want to know. Click "Analyze All" to try it out. Click on the Copilot's gear icon to customize the prompt.
© 2024 RemoteAmbitionAffiliate · Privacy · Terms · Sitemap · Status