Want to be a bswifter? 

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! 

We are seeking a Database Administrator (DBA) to support and enhance our SQL Server and AWS database environments, ensuring high performance, availability, scalability, and security across both production and non-production systems.This is a hands-on, high-impact role ideal for professionals who enjoy managing large-scale databases, solving complex data challenges, modernizing legacy systems, and collaborating with Engineering, DevOps, and Analytics teams to ensure smooth and efficient data operations.

Key Responsibilities 

• Manage day-to-day administration of SQL Server 2019+ environments, ensuring optimal performance, availability, scalability, and security.
• Design and maintain scalable cloud architectures on AWS, including MySQL RDS, Aurora PostgreSQL, and DynamoDB.
• Perform core DBA activities such as:
  • Database backups and restores
  • Environment refreshes
  • Data de-identification
  • Always On Availability Groups
  • Index and statistics maintenance
  • Disk space management
• Proactively monitor and optimize database performance through:
  • Query analysis
  • Indexing strategies
  • Execution plan reviews
  • Profiling and continuous monitoring
• Architect and maintain High Availability (HA) and Disaster Recovery (DR) solutions, including:
  • Multi-AZ deployments
  • Replication
  • Automated backups
  • Point-in-time recovery
  • Failover testing
• Develop automation solutions using:
  • SQL Server Agent Jobs
  • PowerShell scripting
  • Terraform
  • AWS CloudFormation
• Build and maintain ETL/ELT pipelines to support analytics and reporting needs.
• Troubleshoot database issues related to performance, blocking, and job failures using SQL queries and monitoring tools.
• Participate in on-call rotations (PagerDuty) and respond to production incidents and alerts.
• Collaborate with development teams to ensure seamless data operations across environments.
• Support release management, including database deployments and production changes.
• Continuously improve database administration processes and best practices.

Required Skills and Experience

• Extensive experience with Microsoft SQL Server (administration, performance tuning, and optimization).
• Hands-on experience with AWS database services (RDS, PostgreSQL, DynamoDB).
• Experience with database monitoring tools such as Idera and Redgate.
• Ability to work in on-call rotations and handle critical production incidents.
• Strong proficiency in SQL development, including complex stored procedures and performance troubleshooting.
• Working knowledge of ETL tools and processes.
• Strong analytical and problem-solving skills with the ability to communicate technical concepts effectively.
• Experience in production deployments and active participation in release management processes.

Preferred Qualifications

• Experience with AWS services such as Bedrock, OpenSearch, Glue, and Lambda.
• Knowledge of data modeling, schema design, and enterprise data architecture principles.
• Exposure to automation, DevOps practices for databases, and Infrastructure-as-Code (IaC).
• Familiarity with NoSQL databases, caching technologies, and event-driven architectures.
• Experience working in regulated industries such as healthcare, insurance, or financial services.

Shift Timings

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

If you have what it takes to join our award-winning culture, we’d love to hear from you!