Database Administrator - Senior with Client : Ministry of Transportation

S M Software Solutions; Toronto; Hybrid; CAD 100,000 - 130,000; Full time

Job summary

A technology consulting firm in Toronto is seeking a Senior Database Administrator with expertise in Azure technologies to design and optimize data management systems. Responsibilities include developing CI/CD pipelines and data replication solutions while providing effective support and documentation. Candidates must have extensive experience with SQL Server and Azure SQL Database. This hybrid role requires 3 days of office attendance.

Qualifications

• Expert experience with Microsoft Azure technologies including Azure pipelines and DevOps.
• Expert database administration skills for cloud environments.
• Experience in CI/CD and data provisioning automation.

Responsibilities

• Participate in review of project work requests.
• Design, develop, and optimize data/database CI/CD pipelines.
• Implement data conversion of VLD for various environments.

Skills

Expert experience with Microsoft Azure technologies

Experience with cloud data platforms

Experience with data pipeline and workflow development

Expert data/database administration experience

Extensive experience with SQL Server Stored Procedures

Experience with data replication and DataOPS principles

Tools

Microsoft Azure SQL Database

Oracle

SQL Server

Sybase Power Designer

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)
• Visa Status (Mandatory)
• LinkedIn ID (Mandatory)

Job Title : Database Administrator - Senior

Client : Ministry of Transportation

Work Location : 87 Sir William Hearst Ave M3M 0B4 Toronto, Ontario, Hybrid

Estimated Start Date :

Estimated End Date :

Business Days : 200.00

Extension : 250.00

Hours per day or week : 7.25 hours per day

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 review of project work requests and maintenance release artifacts - Use Case, System Requirement Specification, etc.

Deliver detailed system design documents and 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 changes in DACPAC and develop Azure CI/CD release pipeline to promote DACPAC.

Promote database changes through Development, Integration Testing, QA, UAT, and Production environments.

Provision data in cloud environment per requirements.

Design, develop data loading, data conversion, data migration programs.

Implement data conversion of VLD (Very Large Data) for OLAP and OLTP environments to Cloud SaaS, PaaS, and IaaS environments.

Design, develop, and implement fact/dimension models, data mapping, data warehouse, data lake, and data lakehouse.

Plan, configure, maintain, and tune performance of Oracle, Microsoft Azure SQL Database, and Synapse Database.

Support cloud-based heterogeneous data replication solutions.

Develop complex Oracle PL/SQL programs and SQL Server stored procedures to fulfill project requirements.

Optimize performance of PL/SQL programs and SQL Server stored procedures.

Monitor, analyze incidents, and provide timely resolutions.

Perform reference data administration as required.

Build and test database backup/recovery scripts and automation scripts.

Perform database administration tasks including patching, upgrades, performance tuning, partitioning, capacity planning, OEM upgrades/enhancements.

Document and resolve database problems/issues.

Provide effective knowledge transfer to Ministry staff at all stages.

Experience and Skill Set Requirements

Cloud DataOPS- 40%

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 principles, best practices, and implementation, as well as Agile project development and deployment.

Experience in CI/CD and data provisioning automation.

Experience with digital product data analysis, exchange, security.

Experience with structured, semi-structured, unstructured data collection, ingestion, provisioning, and exchange technologies.

Experience with DataOPS performance monitoring and tuning.

Database Management- 40%

Expert data/database administration experience e.g., Microsoft Azure SQL Database, Synapse, Oracle, IMS, DB2.

Extensive experience with SQL Server Stored Procedures, Oracle PL/SQL development, and performance tuning.

Data Replication Pipelines- 20%

Experience with Azure SQL, Oracle, IMS, DB2 data replication.

Candidate is required to come to the office 3 days a week.