SQL Database Administrator

Quantiphi; New York (NY); On-site; USD 120,000 - 170,000; Full time

Job summary

Quantiphi is seeking an experienced SQL Server Database Administrator to manage, optimize, and secure mission-critical databases hosted on AWS EC2 for a high-availability trading environment. The role is based in New York and requires deep SQL Server, AWS, and HA/DR expertise.

You will collaborate with DevOps and trading-system teams, implement robust backup strategies, and participate in on-call rotations to maintain sub-millisecond performance and reliability.

Qualifications

• 7+ years of SQL Server DBA experience.
• Experience with AWS services and EC2.
• Strong HA/DR, backup, and recovery knowledge.
• Proficiency in security, auditing, and compliance practices.

Responsibilities

• Monitor and optimize SQL Server performance and latency.
• Install, configure, and manage SQL Server on AWS EC2 across environments.
• Design and implement HA solutions (Always On, log shipping, mirroring).
• Develop DR plans and test regular DR drills; ensure RTO/RPO targets.
• Design and maintain backup strategies and validate restores.
• Apply security best practices: encryption, access control, auditing.

Skills

SQL Server DBA

AWS EC2

HA & DR

Performance Tuning

Security & Compliance

Monitoring

Tools

SQL Server 2019/2022

AWS EC2

Job description

Quantiphi is an award-winning, AI-First digital engineering and consulting company focused on delivering high-impact Services and Solutions that help organizations solve what truly matters. We partner with enterprises to reimagine their businesses through intelligent, scalable, and transformative AI driving measurable outcomes at the very core of their operations.

Since our founding in 2013, Quantiphi has tackled some of the world’s most complex business challenges by combining deep industry expertise, disciplined cloud and data engineering practices, and cutting-edge applied AI research. Our work is rooted in delivering accelerated, quantifiable business value, not just technology for technology’s sake.

Headquartered in Boston, Quantiphi is a global organization with 4,000+ professionals serving clients across key industry verticals, including BFSI, Healthcare & Life Sciences, CPG, MFG, TME etc.

As an Elite and Premier partner to leading cloud and AI platforms such as NVIDIA, Google Cloud, AWS, and Snowflake, we build and deliver enterprise-grade AI services and solutions that create real-world impact.

Our industry recognition includes:

• 21x Google Cloud Partner of the Year awards in the last 8 years.
• 3x AWS AI/ML award wins.
• 3x NVIDIA Partner of the Year titles.
• 2x Snowflake Partner of the Year awards.
• Top analyst recognitions from Gartner, ISG, and Everest Group.
• Consecutive certifications as a Great Place to Work.

Be part of a trailblazing team that’s shaping the future of AI, ML, and cloud innovation.

Your next big opportunity starts here!

Work Location: New York

Experience Level:7+ years

Type: Full time

Role:

We are seeking an experienced and highly skilled SQL Server Database Administrator (DBA) to manage, maintain, and optimize our mission-critical SQL Server databases hosted on AWS EC2, supporting a high-availability, low-latency trading application. The ideal candidate will have deep expertise in SQL Server administration, AWS infrastructure, and a strong understanding of the performance and reliability demands of financial/trading systems.

Key Responsibilities:

Performance & Optimization

• Monitor and tune SQL Server performance using tools like SQL Server Profiler, Extended Events, DMVs, and Query Store.
• Identify and resolve query bottlenecks, index fragmentation, and blocking/deadlock issues.
• Optimize indexes, execution plans, and stored procedures to meet sub-millisecond latency requirements of the trading platform.
• Conduct regular performance benchmarking and capacity reviews.

Database Administration

• Install, configure, and maintain Microsoft SQL Server (2019/2022) instances on AWS EC2 environments.
• Manage multiple SQL Server instances across Development, UAT, and Production environments.
• Perform database capacity planning, storage management, and performance tuning.
• Implement and maintain database security, including user roles, permissions, and auditing.

High Availability & Disaster Recovery

• Design, implement, and manage High Availability (HA) solutions including:
  • Always On Availability Groups (AG)
  • Log Shipping and Database Mirroring
• Develop and maintain Disaster Recovery (DR) plans and conduct regular DR drills.
• Ensure RTO (Recovery Time Objective) and RPO (Recovery Point Objective) targets are consistently met.
• Manage SQL Server deployments on AWS EC2 instances, including instance sizing,
• EBS volume management, and network configuration.
• Leverage AWS services such as:
  • Amazon CloudWatch for monitoring
  • AWS Backup for automated backups
  • AWS VPC, Security Groups, IAM for access control
  • Amazon S3 for backup storage
• Optimize EC2 instance types (e.g., r5, x1e families) for memory-intensive SQL workloads.
• Manage SQL Server licensing in AWS environments (BYOL / License Included).

Backup & Recovery

• Design and implement comprehensive backup strategies (Full, Differential, Transaction
• Automate backup processes and store backups securely on Amazon S3.
• Perform regular backup validation and restoration testing.
• Ensure compliance with data retention policies.

Security & Compliance

• Implement SQL Server security best practices including encryption (TDE, Always Encrypted), auditing, and access controls.
• Ensure compliance with financial industry regulations (e.g., SOX, PCI-DSS, GDPR as applicable).
• Conduct regular vulnerability assessments and apply security patches.
• Manage SQL Server certificates and encryption keys.
• Set up proactive monitoring and alerting for SQL Server health, performance, and availability.
• Respond to and resolve P1/P2 database incidents with urgency, given the critical nature of the trading platform.
• Participate in on-call rotation for 24/7 support coverage.
• Maintain detailed incident logs and post-mortem reports.
• Work closely with application developers, DevOps, and trading system architects to support database design and schema changes.
• Review and approve database change requests and deployment scripts.
• runbooks, and SOPs.
• Participate in CAB (Change Advisory Board) meetings for production changes.

What is in it for you:

• Be part of the fastest-growing AI-first digital transformation and engineering company in the world
• Be a part of an energetic team of highly dynamic and talented individuals
• Exposure to working with fortune 500 companies and innovative market disruptors
• Exposure to the latest technologies related to artificial intelligence and machine learning, data and cloud