Sr SQL Server Funtional /Application DBA V2014 - 2019

Job Description

Job DescriptionSeeking consultants that will participate on a Global' DBA team. The team will ensure that the new database code meets company standards for readability, reliability, and performance. Each week give developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each. Additionally:

• Design indexes for existing applications, choosing when to add or remove indexes.
  
• Help developers improve the performance of that query by tweaking it or modifying indexes.
  
• Conduct SQL Server lunch-and-learn sessions for application developers.
  
• Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc).
  

RequirementsSkills
Required /Preferred
Years
Candidate Experience
Experience working for US Companies within the US
Required
8+

Banking experience post 2016
Required
4+

Recent Level 3 support experience
Required
5

Recent experience working in a team environment with DB sizes of 30TB or more
Required
5

Experience working with large-scale enterprise application setup across data centers
Required
5

Experience conducting general database administration tasks (DB implementation, DB code deployments, DB backups, creation of DB user accounts)
Required
10

Experience working as a SQL Server DBA
Required
7

Experience working as a Functional & Application DBA
Required
5

Experience administering database platform specific advanced features (clustering, encryption, logical/physical standby, ETL, replication) and performance optimizing server databases servers and SQL code.
Required
5

Experience working in a SQL DBA role with multiple databases and SQL development issues.
Required
5

Proficient in MS SQL Server 2014-2019
Required
5

SSIS Package creating and debugging skills
Required
5

Stored procedure development and tuning.
Required
5

Data replication exposure
Required
5



Benefits

Benefit Package includes:

• Paid Sick Time
  

• Insurance for Medical, Dental, Vision and Life Available
  

• 401(k) including Employer Match
  

• HSA, Short-term & Long-term Disability Available
  

• We are an EEO/Veterans/Disabled employer