Senior Database Administrator - SQL Server

Senior Database Administrator - SQL Server

On behalf of our client in the Banking Sector, PROCOM is looking for a Senior Database Administrator - SQL Server.

Senior Database Administrator - SQL Server – Job Description

Responsible for database setup and management, data cleansing and appending, query analysis, database modeling, segmentation and profiling

Maintain database dictionaries and integrate systems through database design

Write SQL queries to export / validate / analyze counterparty data

Monitor changes in data to ensure data integrity

Code logical and physical database descriptions and specify identifiers of database to management system

Implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure

Prepare and test change requests when required

Verify / check / compare client counterparty data from the counterparty databases to internal reports and spreadsheets

Produce internal and regulatory reports on a regular or ad hoc basis

Senior Database Administrator - SQL Server – Mandatory Skills

Bachelor’s degree in Information Technology or Computer Science

Strong background in Banking / Financial services

10+ years working experience in an IT function at a large organization

10+ 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)

In-depth technical knowledge of database and transaction management technologies and operating systems

Experienced with data manipulation languages, data definition languages, physical database design, and application performance analysis & tuning

• Experience in providing L3 / L4 support in troubleshooting SQL server performance related issues.

Expert knowledge to analyze performance issue, identify tuning opportunities, implement improvements and advise developers on SQL Server

Intermediate knowledge of support and maintaining SQL server

Good understanding of gitHub, DevOps and deployment automation

Strong documentation, written and verbal communication skills

Proficient interpersonal skills to be able to interface effectively with a broad range of contacts; from technical staff to management

Proficient organizational skills with the ability to handle multiple concurrent activities and to work successfully under pressure

Senior Database Administrator - SQL Server - Assignment Start Date

ASAP – 12 months to start

Senior Database Administrator - SQL Server - Assignment Location

Toronto, ON – Work Hybrid