SQL Server DBA

Investm Technology; New York (NY); Hybrid; USD 120,000 - 150,000; Full time

Job summary

A financial services company is seeking a seasoned Database Administrator to join their Global DBA team. The ideal candidate will have over 10 years of experience in database administration, specifically as a SQL Server DBA, along with recent experience in banking. Responsibilities include improving database performance, designing indexes, and providing on-call troubleshooting. Proficiency in MS SQL Server versions 2014-2019 and T-SQL is essential for this role. The position is based in New York, initially onsite for 1-3 months, then transitioning to remote work.

Qualifications

• 10+ years conducting general database administration tasks.
• 7+ years as a SQL Server DBA.
• 4+ years of recent Banking experience since 2016.

Responsibilities

• Participate on a Global DBA team to ensure code quality.
• Identify resource-intensive queries weekly and suggest performance improvements.
• Design indexes for applications.

Skills

Database administration

SQL Server DBA

Performance tuning

Database backup

SSIS

T-SQL

Tools

MS SQL Server 2014

MS SQL Server 2019

Job description

*********************Investment Banking Industry Experience is Mandatory******************

Work Authorization

• Green Card Holders and US Citizens
• H1B/TN/L2-EAD/H4-EAD
• C2C is fine

Location

• New York, NY (Onsite for first 1-3 months, then remote)

Qualifications

• 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).
• Must have 8+ years of experience working for US companies in the US.
• Minimum of 7+ years experience working as a SQL Server DBA.
• Must have 4+ years of Recent Banking experience (Since 2016).
• Must have recent experience performing Level 3 support (The highest level of Support).
• These positions are for a Global unit. Consultants must have experience (Constantly and On Average) working with DB sizes of 30TB or more (Not Less).
• Experience working with large-scale enterprise application setups across Data centers.
• Must have experience as a Functional & Application DBA.
• Must have at least 5 years of 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.

Responsibilities

• 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
• Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc)
• Writing and improving SQL Server T-SQL queries for at least a year. You will be known in the office as the go-to person for T-SQL questions
• Designing tables and picking datatypes
• Using Profiler traces and other tools to find the most frequently run queries
• Using free tools like sp_BlitzIndex® and DMV queries to answer questions about index usage
• On-call troubleshooting for SQL Server service outages
• Deciding whether clustering, log shipping, mirroring, replication, etc. are the right fit to solve a business problem