JOB DESCRIPTION

Are you ready to make an impact at DTCC

Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development At DTCC, we are at the forefront of innovation in the financial markets. We are committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to creating a workplace that looks like the world that we serve.

The Information Technology group delivers secure, reliable technology solutions that enable DTCC to be the trusted infrastructure of the global capital markets. The team delivers high-quality information through activities that include development of essential, building infrastructure capabilities to meet client needs and implementing data standards and governance.

Pay and Benefits:

Competitive compensation, including base pay and annual incentive
Comprehensive health and life insurance and well-being benefits, based on location
Pension / Retirement benefits
Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee).

The Impact you will have in this role:

As a Lead Database Engineer, you will lead with strategic vision that focuses on engineering, standardization, automation, security, and resilience of Microsoft SQL Server platforms supporting enterprise and mission‑critical applications. By combining SQL Server administration expertise with an engineering mindset, you will improve platform stability, scalability, and operational efficiency.

Your Primary Responsibilities:

Engineer, administer, and support Microsoft SQL Server database platforms across production and non-production environments
Design and implement standardized DBA patterns for build, configuration, patching, and upgrades
Lead database provisioning, refreshes, migrations, and lifecycle management activities
Own platform-level reliability, availability, and performance outcomes
Engineer and support HA/DR solutions using Always On Availability Groups
Participate in DR design reviews, failover testing, and recovery validation
Proactively monitor SQL Server health, capacity, and performance
Perform query tuning, index strategy optimization, and tempdb configuration
Partner with application teams to address systemic performance issues
Engineer and enforce SQL Server security standards (roles, permissions, least privilege)
Implement and support encryption in transit and at rest (TLS, TDE, certificates)
Support vulnerability remediation, audits, and regulatory compliance initiatives
Develop and maintain automation using PowerShell, T‑SQL, and Ansible (or similar tools)
Build reusable scripts and tooling to reduce manual effort and operational risk
Create and maintain engineering runbooks, SOPs, and platform documentation
Provide L3 support for complex production issues with strong RCA ownership
Participate in on-call rotations and planned change activities
Collaborate with infrastructure, cloud, security, and application engineering teams
Mentor junior DBAs and contribute to team upskilling

Qualifications:

Minimum of 6 years of related experience
Bachelor's degree preferred or equivalent experience

Talents Needed for Success:

Strong hands-on experience as a SQL Server DBA in an engineering-focused team
T-SQL programming & RDBMS experience
Proficiency in PowerShell & Python
Basic Ansible skills
CI/CD experience (GitLab, Bitbucket, Jenkins)
Familiarity with Agile/Scrum & JIRA
Knowledge of ITSM processes & ServiceNow
Exposure to cloud or hybrid SQL platforms (Azure SQL, AWS RDS)
Familiarity with monitoring and observability tools
Strong analytical and problem-solving skills
Experience in the financial services industry is good to have

Lead SQL Server Database Engineer