SQL Server Database Engineer DBA Financial Domain

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Toronto; On-site; CAD 60,000 - 80,000; Full time

Job summary

A technology company in Toronto is seeking an experienced SQL Server Database Administrator with a minimum of 7 years of experience. The role involves engineering, designing, testing, and deploying database solutions, as well as administering SQL Server environments. Candidates must hold a SQL Server Certification and demonstrate strong knowledge of database performance and troubleshooting. This position requires strong analytical skills, teamwork, and adaptability in a fast-paced environment, along with the ability to provide 3rd level support and manage critical incident calls.

Qualifications

• Minimum 7 years experience in building and administering SQL Server environments (2016| 2019).
• SQL Server Certification is mandatory.
• Working knowledge of Cloud Computing and Azure VMWare Solution Technologies.

Responsibilities

• Engineer, design, build, test, and deploy quality database solutions involving SQL Server.
• Administer SQL database infrastructure full life cycle design to production support.
• Provide 3rd level on-call support on a rotational basis.

Job description

Essential Skills

• MongoDB
• Sybase
• MS SQL 2019
• PostgreSQL
• Oracle SQL

Role Description

• Requires Financial Services and IT experience
• Requires Broad experience with IP networking concepts – routers, firewalls, etc.
• The main responsibilities of this position are to engineer, design, build, test and deploy quality database solutions that involve SQL Server and are consistent with project objectives, client requirements and TDs technology architecture standards and departmental best practices.
• Administer SQL database infrastructure full life cycle design to production support.
• Troubleshooting and tuning of database and server performance issues.
• Utilize SQL subject matter expertise to design or re-use, configure and implement database solutions.
• Processes that maximize system availability, efficiency, effectiveness, integrity, security, recoverability and supportability, all while minimizing costs.
• Provide 3rd level on-call support on a rotational basis.
• Job may contain after hours support for project related work as well as scheduled changes.

Must Haves and Key Skills

• SQL Server Certification
• Minimum 7 years experience in building and administering SQL Server environments (2016| 2019)
• Working knowledge of Cloud Computing and Azure VMWare Solution Technologies.
• Working knowledge of various SQL technology points including building and administering Database backups using TSM, COMMVAULT and/or Veritas Netbackup.
• Demonstrated experience utilizing Database centric solutions to deliver High Availability and Disaster Recovery.
• Awareness of non-Database centric capabilities (AAG).
• Demonstrated experience with SQL Patching and automation use of tools such as PowerShell and Ansible.
• Minimum 7 years knowledge of Clustering fundamentals.
• Minimum 7 years knowledge of mission critical SQL performance experience.
• Working knowledge with storage subsystems Clear understanding of ITIL framework.
• 7 years working knowledge and solid understanding of access fundamentals.
• 7 years Enterprise environment experience - working on large-scale projects.
• 7 years Project-based work and support-related experience
• 7 years management of 100 servers and SQL Query performance tuning.
• Must be able to effectively represent DBA team on escalated incident management calls from operations.
• Understanding of TD Methodology of designing, building, deploying and Windows server solutions that involve best practices and are consistent with project objectives and client requirements.
• Provide management escalation for support calls including on-call after hours support. Ability to maintain a positive attitude while working with high demands and tight deadlines.
• Demonstrates experience involving strong communications skills (written and verbal), proven ability to effectively interact with individuals across business units and at various levels within the Bank (technical and business, including Management).
• Highly organized and possessing strong analytical skills.
• Open minded and highly adaptable with ability to work in a fast-paced demanding environment.
• Must be team-oriented with ability to work well with multiple teams in a cross-functional setup.

Experience Required

6-8 years