Database Administrator - Senior with Client : Ministry of Transportation

S M Software Solutions; Toronto; On-site; CAD 80,000 - 120,000; Full time

Job summary

A leading company seeks a Senior Database Administrator to support the Ministry of Transportation. This contract position requires expertise in Microsoft Azure technologies, database design, and performance tuning. The ideal candidate will flourish in a collaborative setting while contributing to critical data management and project deliverables.

Qualifications

• Expert experience with Microsoft Azure technologies required.
• Experience in database administration and SQL Server required.
• Must have data management skills and experience with CI/CD.

Responsibilities

• Design and optimize data/database CI/CD pipelines.
• Provision data in cloud environments per requirements.
• Prepare database changes and manage deployment processes.

Skills

Databases

SQL

PL / SQL

Microsoft SQL Server

Database Administration

Performance Tuning

Oracle

Shell Scripting

Education

Bachelor's Degree in Computer Science or related field

Job description

would like to present to you a new job opportunity and I think you may find it interesting.

If you are interested kindly send the following documents to emailprotected by MOnday June 09 6 : 00 PM EST if that interests you and matches your profile.

Without mandatory documents we cannot submit a candidate.

• Updated Resume in word format (Mandatory)
• References (Mandatory)
• Expected hourly rate (Mandatory)
• LinkedIn ID (Mandatory)

Job Title : Database Administrator - Senior

Client : Ministry of Transportation

Estimated End Date :

Business Days : 200.00

Extension : 250.00

Security Level : No Clearance Required

Must haves :

• Expert experience with Microsoft Azure technologies including Azure pipeline DACPAC storage account disk file share Azure key vault Azure portal virtual machine Azure DevOps Data Lake Data Lakehouse Azure monitoring tools.

Description

Scope of Services and Deliverables

• The Services and Deliverables to be provided by the Vendor will include the following :
• Participate in the review of project work request and maintenance release artefacts - Use Case System Requirement Specification etc.
• Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards.
• Design develop and optimize data / database CI / CD pipelines.
• Design logical and physical data models using Sybase Power Designer.
• Prepare database change in DACPAC and develop Azure CI / CD release pipeline to promote DACPAC.
• Promote database changes through Development Integration Testing QA UAT Production environments.
• Provision data in cloud environment according to requirements.
• Design develop and implement data conversation of VLD (Very large Data) of Online analytical processing (OLAP) and online transaction processing (OLTP) environments to Cloud Software-as-a-service (SaaS) Platform-as-a-service (PaaS) and Infrastructure-as-a-service (IaaS) environments.
• Design develop and implement fact / dimension model data mapping data warehouse data lake and data lakehouse.
• Plan configure maintain administrate tune performance of Oracle Microsoft Azure SQL database and Synapse database.
• Develop complex Oracle PL / SQL program SQL server stored procedure to fulfill project work request maintenance requirements.
• Optimize performance of PL / SQL program SQL server stored procedure.
• Monitor and analyze incident provide timely resolution.
• Perform reference data administration as required.
• Build and test database backup / recovery scripts.
• Build and test database automation scripts.
• Perform database administration including patching / upgrade monitoring performance tuning partitioning capacity planning OEM upgrade / enhancement achieving etc
• Document and resolve any database problems / issues.
• Provide effective knowledge transfer to Ministry staff at all stages of this assignment.

Experience and Skill Set Requirements

• Expert experience with Microsoft Azure technologies including Azure pipeline DACPAC storage account disk file share Azure key vault Azure portal virtual machine Azure DevOps Data Lake Data Lakehouse Azure monitoring tools.
• Experience with Cloud data platforms data management and data exchange tools and technologies.
• Experience with Data pipeline and workflow development orchestration deployment and automation.
• Experience in DataOPS principle best practice and implementation and Agile project development and deployment.
• Experience in Continuous Integration / Continuous Development / Deployment (CI / CD) and Data provisioning Automation.
• Experience with digital product data analysis data exchange data provisioning and data security.
• Experience with structured semi-structured unstructured data collection ingestion provisioning and exchange technological development.
• Experience with DataOPS performance monitoring and tuning.

Database Management- 40%

• Expert data / database administration experience e.g. Microsoft Azure SQL database and Synapse database Oracle IMS DB2 etc.
• Extensive experience with SQL Server Stored Procedure Oracle PL / SQL PL / 1 development and performance tuning.
• Experience with Azure SQL Oracle IMS / DB2 data replication.

If you are interested to learn more about this opportunity or if not please feel free to send over any names or forward this email to anyone who may be interested. Please check it out on our career site .

Note :

• Candidate is required to come in office - 3 days a week

Required Experience :

Senior IC

Key Skills

Databases,SQL,High Availability,PL / SQL,Solaris,Microsoft SQL Server,Database Design,Performance Tuning,MySQL,Shell Scripting,Database Administration,Oracle

Employment Type : Contract

Experience : years

Vacancy : 1

Create a job alert for this search