Jobs via Dice
Sr SQL Server Functional /Application DBA
Location: 26th Street and Madison, NYC, New York - 10010
Work type: Onsite
Duration: 1 year - renewable contracts
Mode of Interview: Virtual
Type: Contract
Industry: Financial Services
USC • W2/C2C
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.
On a weekly basis, provide developers with a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance for each.
Design indexes for existing applications, choosing when to add or remove indexes.
Help developers improve the performance of queries that users report as slow by tweaking or modifying them.
Conduct SQL Server lunch-and-learn sessions for application developers.
Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc.).
Must have 8+ years of experience working for US companies in the US.
Must have 4+ years of recent Banking experience (since 2016).
Must have recent experience performing Level 3 support (the highest-level Support).
Experience working in a global unit with large DB sizes (30TB or more) and in a team environment.
Experience working with large-scale enterprise applications across data centers.
Minimum of 10+ years conducting general database administration tasks (e.g., DB implementation, code deployments, backups, user management).
Minimum of 7+ years experience as a SQL Server DBA.
Must have experience as a Functional & Application DBA.
At least 5 years administering database platform features (e.g., clustering, encryption, standby, ETL, replication) and performance optimization.
Minimum of 5+ years experience in a SQL DBA role with multiple databases and SQL development issues.
Proficient in MS SQL Server 2014 - 2019.
SSIS package creation and debugging skills.
Stored procedure development and tuning.
Data replication exposure.
Seniority level
Mid-Senior level
Employment type
Contract
Job function
Information Technology
Industries
Software Development
Referrals increase your chances of interviewing at Dice by 2x.
Get notified about new Application Database Administrator jobs in New York, NY.
#J-18808-Ljbffr
Work type: Onsite
Duration: 1 year - renewable contracts
Mode of Interview: Virtual
Type: Contract
Industry: Financial Services
USC • W2/C2C
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.
On a weekly basis, provide developers with a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance for each.
Design indexes for existing applications, choosing when to add or remove indexes.
Help developers improve the performance of queries that users report as slow by tweaking or modifying them.
Conduct SQL Server lunch-and-learn sessions for application developers.
Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc.).
Must have 8+ years of experience working for US companies in the US.
Must have 4+ years of recent Banking experience (since 2016).
Must have recent experience performing Level 3 support (the highest-level Support).
Experience working in a global unit with large DB sizes (30TB or more) and in a team environment.
Experience working with large-scale enterprise applications across data centers.
Minimum of 10+ years conducting general database administration tasks (e.g., DB implementation, code deployments, backups, user management).
Minimum of 7+ years experience as a SQL Server DBA.
Must have experience as a Functional & Application DBA.
At least 5 years administering database platform features (e.g., clustering, encryption, standby, ETL, replication) and performance optimization.
Minimum of 5+ years experience in a SQL DBA role with multiple databases and SQL development issues.
Proficient in MS SQL Server 2014 - 2019.
SSIS package creation and debugging skills.
Stored procedure development and tuning.
Data replication exposure.
Seniority level
Mid-Senior level
Employment type
Contract
Job function
Information Technology
Industries
Software Development
Referrals increase your chances of interviewing at Dice by 2x.
Get notified about new Application Database Administrator jobs in New York, NY.
#J-18808-Ljbffr