Overview
On Site
$80 - $100
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)
Skills
SQL Server Functional
Application DBA
DB sizes of 30TB
Data centers
DB code
DB backups
DB user accounts
SQL Server DBA.
ETL
MS SQL
SSIS
Job Details
REQUIREMENT
Position: 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
Work Type: Onsite
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. 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)
- 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).
- 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 7+ years experience working as a SQL Server DBA.
- Must have experience as a Functional & Application DBA.
- 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.
- Minimum of 5+ years experience working 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.