SQL Server DBA

Role Descriptions : 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 solutionsprocesses 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 AzureVMWare 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 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

Other Qualifications Skills 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

Essential Skills

Financial Services IT experience

Broad experience with IP networking concepts - routers| firewalls| etc

SQL Server Certification

MongoDB

Sybase

PostGreSQL

Skills

PostgreSQL~ORACLE SQL~Microsoft SQL Server 2019