SQL Server Database Engineer / DBA - Financial Domain

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

Requirements

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