SQL DBA / ETL( Need Local to NYC Only)

Title: Senior SQL Server Functional / Application DBA V2014 - 2019

Positions: 2

Work Remote: NO. They want all consultants on site. Remote after 6 months.

Skills Need:

• Must have 12+ years of experience working for US companies in the US.
• Must have 5 + 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 working with Data Warehouses.
• 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 an 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.

The JOB:

• Credit Suisse is seeking consultants that will participate on a Global' DBA team. The team will ensure that the new database code meets company standards for readability,
  reliability, and performance.
• 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.