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