SQL Server Database EngineerDBA Financial Domain

Toronto - Canada

Monthly Salary: CAD 10 - 10

Experience Required: 5years

Posted on: 18 hours ago

Vacancies: 1 Vacancy

Job Summary

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 ()

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

Required Skills:

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 afterhours 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 () 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 afterhours 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

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...