Sr SQL Server Functional / Application DBA Job Opening in New York, NY

Job Title: Sr. SQL Server Functional/Application DBA

City: NYC (Day 1 onsite)

Experience: 10+ years

Job Description:

•Must have 10+ years of experience working for US companies.

•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 working ‘Constantly’ with DB’s 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 experience.

•Proficient in MS SQL Server 2014 - 2019.

•SSIS Package creation and debugging skills.

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).