Senior SQL Server DBA

Location:

Toronto

Required Skill:
Postgre

SQL~ORACLE SQL~Microsoft SQL Server 2019

Essential

Skills:

Financial Services IT experience Broad experience with IP networking concepts - routers, firewalls, etc SQL Server Certification Mongo

DB Sybase PostGreSQL

Experience : 6-8 years

Job Description Accountabilities The main responsibilities of this position are to Consult, engineer, design, build, test, deploy quality database solutions that involve SQL Server and are consistent with project objectives, client requirements, clients 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.

In addition, the candidate is expected to have the following support skills Must Haves (Key Skills) Minimum 7 years experience in building and administering SQL Server environments (2016, 2019) Working knowledge of Cloud Computing and Azure VMWare Technologies Working knowledge of various SQL technology points including building and administering Database backups using TSM, COMMVAULT andor 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, ansible.

Minimum 7 yrs knowledge of Clustering fundamentals Minimum 7 yrs knowledge of mission critical SQL performance experience Working knowledge with storage subsystems Clear understanding of ITIL framework 7 yrs working knowledge and solid understanding of access fundamentals.

7 yrs Enterprise environment experience - working on large-scale projects.

7 yrs Project-based work and support-related experience 7 yrs management of 100 servers SQL Query performance tuning.

Must be able to effectively represent DBA team on escalated incident management calls from operations.

Understanding clients 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, 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.

Self-motivated, with strong sense of ownership and urgency to deliver projectstasks in a timely fashion.

Specific Educational Requirements Accreditations College University with emphasis on computer science and business or equivalent work experience.

IT Industry accreditions not required, but will be considered along with experience