Lead - SQL Server

Our products are built on Windows .NET and SQL Server and managed in AWS. Our web Ux stack is built on jQuery, and we use AngularJS. Our middle tier is in C#, and we build our infrastructure on an extensive set of Restful APIs. We build native iOS and Android apps using Flutter and Dart. Our platform infrastructure is built in .NET Core and deployed on RHEL Enterprise Linux using Docker and Kubernetes. We use Python extensively for data processing workloads and Tableau for analytics dashboards for select infrastructure components. We use Redshift, Aurora, Redis Elasticache, Lambda, and other AWS products to build and manage our complete service, moving towards serverless components. We deal with billions of API calls, millions of records in databases, and terabytes of data to be managed with all services we build that have to run 24x7 at 99.99% availability.

What will I be doing

• Analyze, troubleshoot, and resolve complex performance issues across SQL Server instances.
• Conduct query optimization and index tuning using execution plans, statistics, partitioning, and advanced performance techniques.
• Design and maintain efficient indexing strategies (clustered, non-clustered, filtered, covering, and columnstore indexes).
• Monitor, maintain, and fine-tune SQL Server instances for high availability and scalability.
• Leverage SQL Server 2019 features.
• Lead efforts on capacity planning, performance benchmarking, and stress testing.
• Collaborate with application development teams to review queries and ensure performance-oriented coding standards.
• Work with DBA teams to design high-performance backup, restore, replication, and disaster recovery solutions.
• Leverage tools such as Profiler, Extended Events, DMVs, Query Store, and Performance Monitor to identify bottlenecks.
• Stay current with new SQL Server features, cloud database offerings (Azure SQL, AWS RDS), and industry trends.

What skills do I need

• 7+ years of experience in managing SQL Server Database instances
• Very Strong experience in SQL Server 2019
• Experience in developing highly available, massively scalable, distributed database systems (preferably on AWS/Azure)
• Very strong in Performance Tuning
• Can work in a fast-paced, ever-changing, start-up environments
• Strong logical, Analytical, and problem-solving skills
• Excellent communication skills