Database Administrator - Mississauga, Canada - Apex Group

Apex Group

Verified Company

Mississauga, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Database Administrator

Location:
Mississauga, ON, Canada

Date Posted:
Apr 19, 2023

Description

Database Administrator

Role Location:

Open

Department: IT
Employment Type: Permanent

The Role & Key Responsibilities:

The role of the Database Administrator will be responsible for the management of software development teams within the Apex and report to the DBA Manager.

The role of the database administrator is to be responsible for the performance, integrity and security of a number of core SQL databases.

The successful applicant will be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users.

They will take ownership of multiple test, development and production environments and be responsible for the maintenance of these environments to ensure all databases and servers are performing optimally.

Responsibilities:

Installation, administration and maintenance of multiple SQL Server instances.
Setup environments for use within the end to end software delivery lifecycle.
Define, design & implement control procedures.
Backup monitoring and continuous review of the backup strategy.
Troubleshoot and resolve issues quickly.
Performance monitoring and tuning.
Query tuning (Index maintenance and management, housekeeping, memory, CPU, Disk I/O etc.)
Planning and execution of Service Pack upgrades.
Work alongside project teams (analysts, developers, testers and implementation managers) during software release and patching.
Adhere to change management procedures.
Working closely with other team members.
Complete structured and systematic testing.
Track and report on regular tasks executed to ensure system availability maintaining a continuous improvement roadmap.
Proactively identify productivity opportunities.
Ensure correct procedures are adhered to as tasks are being progressed.
Experience in a Windows based 24/7 environment including 1st/2nd line support.
Involved in the design and build of new systems, including highavailability and disaster recovery solutions.

Skills Required:

Microsoft SQL Server 2016, 2019, Azure SQL.
T-SQL programming (4+ years)
SQL Server Integration Service
SQL Server Reporting Services
Experience in database design
Experience with source control
Knowledge of software engineering life cycle
Previous experience in designing, developing, testing, implementing and supporting software
Experience with Oracle preferable
3rd Level IT Qualification
SQL MSCE preferable.
The person should have leadership skills, great attention to detail and the passion to drive projects forward.
Excellent time management and decision making skills.
Excellent communication skills in both English written and verbal.
Background in the financial Industry preferable