Sr. SQL Server Functional /Application DBA
2 - 5 years
United States
Full-time
Remote
1 month ago
About the role
Work Location: Manhattan, NY
Duration: 1yr renewable contracts.
Start: ASAP
Positions: 4
Work Remote: NO. They want all consultants on site.
Work Status: Citizens, Green card.
Skills Need:
· Must have 10+ years of experience working for US companies in the US.
· Must have 4 + years of ‘Recent’ Banking experience (Since 2018).
· 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).
· Minimum of 8+ years experience working as a SQL Server DBA.
· Must have experience with Functional & Application DBA duties.
· Must have at least 8 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.
· Minimum of 8+ years experience working in a SQL DBA Role with multiple databases and SQL development issues.
· Proficient in MS SQL Server 2014 - 2022.
· Must have exposure to SQL Server 2025.
· SSIS Package creation and debugging skills.
· Stored procedure development and tuning.
· Data replication exposure.
The JOB:
· 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.
· Design indexes for existing applications, choosing when to add or remove
indexes.
· When users complain about the performance of a particular query, 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).
· Consultant must have experience: 1) Writing and improving SQL Server T-SQL queries for at least a year. You will be known amongst the office as the go-to person for T-SQL questions.
2) Designing tables and picking datatypes
o Using Profiler traces and other tools to find the most frequently run queries.
3) Using free tools like sp_BlitzIndex® and DMV queries to answer questions about
index usage.
5) On-call troubleshooting for SQL Server service outages.
6) Deciding whether clustering, log shipping, mirroring, replication, etc are the
right fit to solve a business problem.
Duration: 1yr renewable contracts.
Start: ASAP
Positions: 4
Work Remote: NO. They want all consultants on site.
Work Status: Citizens, Green card.
Skills Need:
· Must have 10+ years of experience working for US companies in the US.
· Must have 4 + years of ‘Recent’ Banking experience (Since 2018).
- Must have recent experience performing Level 3 support (The highest level Support).
- 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).
- Experience working with large-scale enterprise application setup across Data centers.
· 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).
· Minimum of 8+ years experience working as a SQL Server DBA.
· Must have experience with Functional & Application DBA duties.
· Must have at least 8 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.
· Minimum of 8+ years experience working in a SQL DBA Role with multiple databases and SQL development issues.
· Proficient in MS SQL Server 2014 - 2022.
· Must have exposure to SQL Server 2025.
· SSIS Package creation and debugging skills.
· Stored procedure development and tuning.
· Data replication exposure.
The JOB:
· 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.
· Design indexes for existing applications, choosing when to add or remove
indexes.
· When users complain about the performance of a particular query, 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).
· Consultant must have experience: 1) Writing and improving SQL Server T-SQL queries for at least a year. You will be known amongst the office as the go-to person for T-SQL questions.
2) Designing tables and picking datatypes
o Using Profiler traces and other tools to find the most frequently run queries.
3) Using free tools like sp_BlitzIndex® and DMV queries to answer questions about
index usage.
5) On-call troubleshooting for SQL Server service outages.
6) Deciding whether clustering, log shipping, mirroring, replication, etc are the
right fit to solve a business problem.
Skills
Information TechnologyComputer and Network Security