SQL Database Administrator

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 #J-18808-Ljbffr Quantiphi