Database Admin - USA

Quantiphi

2d • Onsite

About The Position

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

Requirements

• Experienced and highly skilled SQL Server Database Administrator (DBA)
• Deep expertise in SQL Server administration
• Deep expertise in AWS infrastructure
• Strong understanding of the performance and reliability demands of financial/trading systems
• Experience with SQL Server Profiler, Extended Events, DMVs, and Query Store
• Experience optimizing indexes, execution plans, and stored procedures
• Experience with Microsoft SQL Server (2019/2022)
• Experience managing multiple SQL Server instances across Development, UAT, and Production environments
• Experience with High Availability (HA) solutions including: Always On Availability Groups (AG), SQL Server Failover Cluster Instances (FCI), Log Shipping and Database Mirroring
• Experience with Disaster Recovery (DR) plans
• Experience managing SQL Server deployments on AWS EC2 instances
• Experience with AWS services such as: Amazon CloudWatch, AWS Backup, AWS VPC, Security Groups, IAM, Amazon S3
• Experience optimizing EC2 instance types for memory-intensive SQL workloads
• Experience managing SQL Server licensing in AWS environments (BYOL / License Included)
• Experience designing and implementing comprehensive backup strategies
• Experience automating backup processes
• Experience with SQL Server security best practices including encryption (TDE, Always Encrypted), auditing, and access controls
• Experience ensuring compliance with financial industry regulations (e.g., SOX, PCI-DSS, GDPR as applicable)
• Experience conducting regular vulnerability assessments and applying security patches
• Experience managing SQL Server certificates and encryption keys
• Experience setting up proactive monitoring and alerting for SQL Server health, performance, and availability
• Experience responding to and resolving P1/P2 database incidents
• Experience working closely with application developers, DevOps, and trading system architects
• Experience reviewing and approving database change requests and deployment scripts
• Experience maintaining comprehensive database documentation
• Experience participating in CAB (Change Advisory Board) meetings

Responsibilities

• 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.
• 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.
• 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.
• 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).
• 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.
• 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.
• Maintain comprehensive database documentation including architecture diagrams, runbooks, and SOPs.
• Participate in CAB (Change Advisory Board) meetings for production changes.

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed