SQL Server DBA

Role Description s:
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| client 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.
• 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 of client 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| 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 projects/tasks in a timely fashion.

• Accreditations College University with emphasis on computer science and business or equivalent work experience.
• IT Industry accredit ions not required| but will be considered along with experience.

• Financial Services IT experience
• Broad experience with IP networking concepts - routers| firewalls| etc
• SQL Server Certification
• MongoDB
• Sybase
• PostGreSQL
• Teamwork - strong relationships with developers and business analysts| architecture operations
• Excellent communication and presentation abilities
• Effective time management skills and ability to work under deadlines and operational pressures

• Financial Services IT experience
• Broad experience with IP networking concepts - routers| firewalls| etc
• SQL Server Certification
• MongoDB
• Sybase
• PostGreSQL

• Postgre
  
  SQL:
  
  ORACLE SQL:
  
  Microsoft SQL Server 2019