Sr SQL Server Functional / Application DBA

Job Description

Job Description

Seeking Sr SQL Server Functional / Application DBA consultants to be part of a team that will ensure that the new database code meets company standards for readability, reliability and performance. Additionally :

• On a weekly basis, give developers are list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each.
• Design indexes for existing applications, choosing when to add or remove indexes
• Help developers improve the performance of queries that users complain about its performance by tweaking or modifying it
• Conduct SQL Server lunch-and-learn sessions for application developers.
• Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc)

Requirements

Must have 8+ years of experience working for US companies in the US.

Required

8+

Must have 4 + years of ‘Recent’ Banking experience (Since 2016).

Required

4+

Must have recent experience performing Level 3 support (The highest-level Support).

Required

These positions are for a ‘Global’ unit. Consultants must have experience (Constantly and On Average) working in a team environment with DB sizes of 30TB or more (Not Less).

Required

Experience working with large-scale enterprise application setup across Data centers.

Required

Must have a Minimum of 10+ years conducting general database administration tasks (e.g. DB implementation, DB code deployments, DB backups, creation of DB user accounts).

Required

10+

Minimum of 7+ years experience working as a SQL Server DBA.

Required

7+

Must have experience as an Functional & Application DBA.

Required

Must have at least 5 years administering database platform specific advanced features (e.g. clustering, encryption, logical / physical standby, ETL, replication) and performance optimizing server database servers and SQL code.

Required

Minimum of 5+ years experience working in a SQL DBA Role with multiple databases and SQL development issues.

Required

Proficient in MS SQL Server 2014 - 2019.

Required

SSIS Package creation and debugging skills.

Required

Stored procedure development and tuning.

Required

Data replication exposure.

Required

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