Database Administrator Senior

2iResourcing; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

An established industry player is seeking a Senior Database Administrator with expertise in Oracle and Microsoft SQL. This role involves administering and upgrading databases, utilizing Microsoft Azure technologies, and ensuring high availability for large relational databases. The successful candidate will work in a hybrid environment, collaborating with teams to design and implement robust database solutions. If you have a passion for database management and a knack for performance tuning, this opportunity offers a chance to make a significant impact in a dynamic setting.

Qualifications

• Expertise in Oracle and Microsoft SQL Database administration and upgrades.
• Experience with Azure technologies and CI/CD pipelines.

Responsibilities

• Administer and upgrade Oracle and Microsoft SQL databases.
• Design and implement large OLTP/OLAP databases.

Skills

Oracle Database Administration

Microsoft SQL Database Administration

Azure DevOps

CI/CD Pipeline

UNIX Shell Scripting

Performance Tuning

Tools

Microsoft Azure

Oracle PLSQL

Job description

RQ03871- Database Administrator Senior
Client: Ministry of Transportation
Period: 5 Months
Start Date: 10/27/2022
End Date: 03/31/2023
Location: Toronto
Working Hrs.: 7.25 Hrs. / day
Assignment Type: Hybrid

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

Must Haves:

1. Expert Oracle and Microsoft SQL Database administration and upgrade experience
2. Experience with Microsoft Azure technologies, including CI/CD pipeline, Azure DevOps, automation, storage account, file share, Azure key vault, Azure portal, Azure monitoring tools

Experience and Skill Set Requirements
Azure Technologies 30%

1. Experience with Microsoft Azure technologies, including CI/CD pipeline, Azure DevOps, automation, storage account, file share, Azure key vault, Azure portal, Azure monitoring tools.

Siebel Database 20%

1. Experience with Siebel database administration, performance tuning and Siebel data model.

Database and Systems Development 50%

1. Expert Oracle and Microsoft SQL Database administration and upgrade experience.
2. Extensive expert experience in designing/developing and implementing large OLTP/OLAP Oracle and Microsoft SQL databases.
3. Knowledge of and experience with Oracle and Microsoft SQL DBMS and tools.
4. Proven experience in designing and maintaining very large relational 7x24 availability databases.
5. Extensive experience with Oracle PLSQL coding.
6. Experience in application architecture, analysis, design, development and implementation of solutions in a multi-platform high volume transaction processing environment.
7. Proven experience with UNIX shell scripting.