Database Administrator

bswift LLC; Bengaluru; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

bswift is seeking an experienced Database Administrator to join our India engineering team. This role owns the health, performance, and reliability of our SQL Server and AWS database environments, including Always On across production and non-prod systems.

This hands-on position emphasizes automation over manual toil, cloud-native data stack, and collaboration with US-based teams to advance platform modernization and data pipelines.

Qualifications

• 5+ years of Microsoft SQL Server administration, including performance tuning and production operations.
• Expertise with SQL Server Always On Availability Groups and HA/DR architecture.
• Strong automation mindset with scripting and IaC experience.
• Solid experience with AWS database technologies (RDS/MySQL/PostgreSQL, Aurora, DynamoDB, SQL Server on EC2).
• Experience with database monitoring tools such as Idera or Redgate.
• Ability to participate in on-call rotation and manage production incidents.
• Strong SQL development skills, including complex stored procedures and execution plans.
• Knowledge of ETL/ELT tools and data pipelines (AWS Glue a strong plus).
• Experience with production deployments and release management processes.
• Clear communication and ability to work across teams and time zones.
• Comfort working in a distributed, cross-timezone team environment with US counterparts.

Responsibilities

• Core Database Engineering and performance tuning across SQL Server environments.
• Admin day-to-day SQL Server 2019+ operations for production and lower environments.
• Backups, restores, environment refreshes, data de-identification, Always On management.
• Troubleshoot performance issues, blocking, deadlocks, and failed jobs using queries and tools.
• Participate in on-call rotation via PagerDuty during the off-shift window.
• Design and maintain cloud-based architectures on AWS (RDS, Aurora, DynamoDB, EC2 SQL Server).
• Architect high availability and DR solutions with multi-AZ and replication.
• Contribute to cloud-native data platform evolution (Glue, Lambda, OpenSearch, Bedrock).
• Increase automation using SQL Agent Jobs, PowerShell, Terraform, CloudFormation.
• Support release management and database deployments in production.
• Document standards, runbooks, and operational processes.
• Build and maintain ETL/ELT pipelines to support analytics and data ops.
• Collaborate with US teams to align on architectural standards.

Skills

SQL Server Admin

Always On/HA-DR

Automation (PowerShell)

AWS DB (RDS/Aurora/DynamoDB)

Monitoring (Idera/Redgate)

On-call incidents

SQL development

ETL/ELT (AWS Glue)

Deployments & release mgmt

Communication & teamwork

Distributed team work

Tools

AWS Glue

PowerShell

Terraform

CloudFormation

Job description

At bswift we’ve been transforming benefits administration since 1996, making it simpler, smarter, and more human. Our state-of-the-art, cloud-based technology and services empower employees to understand, manage, and love their benefits. From downtown Chicago, and remotely across the country, we serve thousands of companies and millions of people nationwide, reducing administrative burdens and freeing HR teams to focus on creating thriving, people-first workplaces.

We’re looking for motivated and goal-driven individuals who share our passion for delivering excellence and creating solutions that make a difference. The reward is a fun, flexible and creative environment with ample opportunity for professional and personal growth. If you love the bswift values of pursue excellence, embrace accountability, deliver superior service, and be a great place to work, we want to hear from you!

About bswift

bswift is a leading benefits administration technology company, delivering modern, cloud-based solutions to employers and health plans across the United States. Our platform supports millions of employees and processes some of the most complex benefits transactions in the industry. As bswift continues to scale and modernize its data platform, we are building a world-class database engineering team — and our India team is a critical part of that vision.

Position Summary

We are seeking an experienced Database Administrator to join bswift’s growing India team. This is a high-impact, hands-on role that owns the health, performance, and reliability of our SQL Server and AWS database environments during the off-shift window — a critical coverage period for our production systems.

You will join bswift’s India engineering team and partner closely with both local engineering colleagues and the US-based database architecture and engineering team. This is not just a maintenance role — you will actively contribute to platform modernization initiatives, automation efforts, cloud architecture improvements, and data pipeline development as bswift evolves its data infrastructure.

We are looking for someone who brings a product and engineering mindset to database work — someone who defaults to automation over manual process, thinks about scalability and reliability proactively, and is eager to grow their skills on a modern cloud-native data stack.

Key Responsibilities

• Core Database Engineering
• Proactively tune and optimize database performance through query analysis, indexing strategies, execution plan review, profiling, and continuous monitoring.
• Own day-to-day administration of SQL Server 2019+ environments, ensuring performance, availability, scalability, and security across production and lower environments.
• Execute core database engineering functions: backups, restores, environment refreshes, data de-identification, Always On availability groups, index and statistics maintenance, and space management.
• Troubleshoot and resolve issues related to performance, blocking, deadlocks, and failed jobs using SQL queries and monitoring tools (Idera, Redgate).
• Participate in on-call rotation via PagerDuty and respond to database alerts and incidents during the off-shift window.
• Design, maintain, and optimize cloud-based database architectures on AWS, including MySQL RDS, Aurora PostgreSQL, DynamoDB, and SQL Server on EC2.
• Architect and maintain high availability and disaster recovery solutions, with deep expertise in SQL Server Always On Availability Groups, multi-AZ deployments, replication, automated backups, point-in-time recovery, and failover testing.
• Contribute to the evolution of bswift’s cloud-native data platform, including work with AWS Glue, Lambda, OpenSearch, and Bedrock as the platform matures.
• Bring a product and engineering mindset to database operations — automation is the default, not the exception. We expect this person to actively reduce manual toil through scalable, repeatable solutions.
• Implement and expand automation using SQL Agent Jobs, PowerShell scripting, Terraform, and CloudFormation to improve reliability and reduce operational overhead.
• Participate in release management, including database deployments and production change execution.
• Contribute to the improvement and documentation of database administration standards, runbooks, and operational processes.
• Build, enhance, and maintain ETL/ELT pipelines (including AWS Glue) to support analytics, reporting, and data operations.
• Collaborate with US-based engineering, DevOps, and analytics teams across time zones to ensure smooth data operations and alignment on architectural standards.
• Partner with development teams to support schema design, query optimization, and best practices in a distributed team model.

Required Skills & Experience

• 5+ years of hands-on Microsoft SQL Server administration, including performance tuning, optimization, and production operations.
• Deep expertise with SQL Server Always On Availability Groups and HA/DR architecture.
• Strong automation mindset — demonstrated track record of building scripted, repeatable solutions rather than relying on manual processes (PowerShell, SQL Agent, IaC).
• Solid experience with AWS database technologies, including RDS (MySQL/PostgreSQL), Aurora, DynamoDB, and SQL Server on EC2.
• Experience with database monitoring and diagnostic tools such as Idera and Redgate.
• Demonstrated ability to participate in on-call rotation and manage critical production incidents.
• Strong SQL development proficiency, including complex stored procedures, performance troubleshooting, and execution plan analysis.
• Functional knowledge of ETL/ELT tools and data pipeline processes (AWS Glue experience a strong plus).
• Experience performing production deployments and participating in structured release management processes.
• Strong problem-solving skills with the ability to communicate technical concepts clearly to both technical and non-technical stakeholders.
• Comfort working in a distributed, cross-timezone team environment with US-based counterparts.

Preferred Qualifications

• Experience with AWS-native data services including Glue, Lambda, OpenSearch, and Bedrock.
• Knowledge of data modeling, schema design, and enterprise data architecture principles.
• Exposure to Infrastructure-as-Code (Terraform, CloudFormation) and database DevOps practices.
• Familiarity with NoSQL, caching technologies (e.g., ElastiCache/Redis), or event-driven architectures.
• Experience working in a regulated industry such as healthcare, insurance, or financial services.
• Knowledge of or interest in AI/ML-integrated data workflows as bswift expands its data platform capabilities.

Shift Timing

Shift: 2:30 PM - 11:30 PM IST

At bswift, our mission is clear: Become the preeminent benefits administrator through exceptional people, innovative technology, and delighted customers. And our values are at the heart of everything we do to accomplish that mission. We Pursue Excellence, Embrace Accountability, Deliver Superior Service, and strive to Be A Great Place To Work . We take pride in having an engaged, collaborative team that goes the extra mile to get the job done right.

bswift has been regularly named one of Chicago’s Best and Brightest Companies to Work For®, as well as one of the Nation’s Best and Brightest Companies to Work For® year after year. We offer a fun, flexible, and creative environment where you can grow both professionally and personally.