Senior SQL Server/Application DBA

New York, NY (ONSITE)

12+ Months

$60/HR on W2

***** US CITIZENS AND GREEN CARD HOLDERS ONLY. LOCAL CANDIDATES PREFERRED *****

FINANCIAL EXPERIENCE IS MANDATORY

Key Responsibilities:

• Collaborate with a global DBA team to ensure that new database code adheres to high standards for readability, reliability, and performance.
• Provide weekly performance insights by identifying the top 10 most resource-intensive queries and suggesting optimization strategies.
• Design and optimize indexes for existing applications, and offer actionable recommendations when users report performance issues.
• Conduct SQL Server lunch-and-learn sessions to support application developers.
• Advise on efficient database designs, including table structures, datatypes, stored procedures, and functions.
• Engage in on-call troubleshooting for SQL Server service outages and determine the best high availability strategies (e.g., clustering, log shipping, mirroring, replication).

Required Skills & Experience:

• Finance Experience: Demonstrated experience working within the financial services sector is essential.
• Database Administration:
• Minimum of 10+ years in general database administration (implementation, code deployments, backups, and user account creation).
• At least 7+ years as a SQL Server DBA with 5+ years focusing on advanced platform features (clustering, encryption, standby configurations, ETL, replication, and performance optimization).
• Proven track record in administering databases with sizes of 30TB or larger is absolutely required.

Technical Expertise:

• Proficient with MS SQL Server 2014 through 2019, including SSIS package creation and debugging, stored procedure development/tuning, and data replication techniques.
• Extensive experience in Level 3 (highest level) support within a banking environment (at least 4+ years since 2016).
• Adept at using performance tools (e.g., Profiler traces, sp_BlitzIndex®, DMV queries) and skilled in both SQL development and troubleshooting.

Additional Requirements:

• Must have 8+ years of experience working with U.S. companies within the United States.
• This opportunity is open only to U.S. citizens or legal permanent residents (Green Card holders).