Database Admin - USA

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

Job summary

Quantiphi, a leading AI-first digital engineering and consulting company, seeks a seasoned SQL Server DBA to design, implement, and optimize database solutions for a high-availability trading platform hosted on AWS EC2. You will drive performance tuning, backup strategies, security controls, and compliance across development, UAT, and production environments.

You will collaborate with DevOps and trading system architects, conduct DR drills, monitor health, and lead infrastructure improvements

Qualifications

• Experience designing and tuning SQL Server performance, including indexing, query optimization, and capacity planning.
• Hands-on with high-availability architectures (Always On AG, Failover Cluster Instances) and disaster recovery planning.
• Proficiency in monitoring, incident response, and 24/7 on-call support for mission-critical databases.

Responsibilities

• Monitor and tune SQL Server performance using profiling and DMVs.
• Identify bottlenecks, optimize execution plans and stored procedures for low latency trading platform.
• Manage SQL Server on AWS EC2, including sizing, storage, security, and backups.

Skills

Performance & Optimization

High Availability & Disaster Recovery

Monitoring & Incident Management

Security & Compliance

Tools

Microsoft SQL Server (2019/2022)

AWS EC2

Amazon CloudWatch

AWS Backup

IAM

S3

EBS

Job description

While technology is the heart of our business, a global and diverse culture is the heart of our success. We love our people and we take pride in catering them to a culture built on transparency, diversity, integrity, learning and growth. If working in an environment that encourages you to innovate and excel, not just in professional but personal life, interests you- you would enjoy your career with Quantiphi!

About Quantiphi

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! For more details, visit: Website or LinkedIn Page.

Work Location: New York Experience Level: 7+ years Type: Full time Role:

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)
  • SQL Server Failover Cluster Instances (FCI)
  • 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.

AWS EC2 & Cloud Management

• 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 Log backups).
• 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.

Monitoring & Incident Management

• 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.

Collaboration & Documentation

• 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.
• Maintain comprehensive database documentation including architecture diagrams, 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
• If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!