Job Description
Job DescriptionSeeking 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)
RequirementsMust 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