bswift - Sr. Database Engineer- Cloud
Requirements
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related technical field, or an equivalent combination of education and experience. • 8+ years of hands-on SQL Server administration experience within enterprise production environments. • Deep expertise with SQL Server performance tuning, monitoring, troubleshooting, and optimization. • Extensive experience designing and supporting high availability and disaster recovery solutions, including Always On Availability Groups, clustering, replication, and disaster recovery testing. • Demonstrated success automating operational processes through scripting and Infrastructure as Code practices. • Experience supporting SQL Server environments running on AWS infrastructure, particularly EC2-hosted deployments. • Experience supporting highly available, business-critical systems with demanding SLA requirements. • Advanced SQL Server administration and performance tuning expertise. • Strong scripting and automation skills using PowerShell and T-SQL. • Experience with Terraform, CloudFormation, or other Infrastructure as Code tools. • Working knowledge of CI/CD pipelines, deployment automation, version control systems, and DevOps practices. • Experience with observability and monitoring tools including Idera, Redgate, CloudWatch, AppDynamics, Performance Insights, Extended Events, and SQL Profiler. • Strong analytical, troubleshooting, and problem-solving capabilities. • Excellent interpersonal, communication, and collaboration skills. • Ability to effectively prioritize work and manage multiple competing priorities in a fast-paced environment. • NICE TO HAVE (Preferred Education and Experience) • Experience implementing database CI/CD and schema versioning solutions such as Flyway, Liquibase, or SSDT. • Advanced experience with Infrastructure as Code frameworks, including Terraform and CloudFormation. • Experience supporting PostgreSQL, MySQL, Aurora, or DynamoDB environments. • Familiarity with AWS services including Glue, Lambda, OpenSearch, and Bedrock. • Knowledge of enterprise data modeling, schema design, and data architecture principles. • Experience in healthcare, insurance, financial services, or other highly regulated industries. • Exposure to AI/ML-enabled data platforms and modern data engineering practices.
Responsibilities
• The Senior Database Engineer (Cloud DBA) is responsible for the design, administration, optimization, automation, and reliability of enterprise database environments supporting mission-critical business applications. This role will lead initiatives to improve database performance, availability, security, and operational efficiency while helping transform traditional DBA practices into modern database engineering capabilities. • The ideal candidate combines deep SQL Server expertise with a strong engineering mindset, leveraging automation, Infrastructure as Code, cloud technologies, and DevOps principles to build repeatable and scalable database solutions. • WHAT YOU WILL BE RESPONSIBLE FOR (Essential Functions) • Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions. • SQL Server & Cloud Operations • Administer, optimize, and support SQL Server 2019+ environments hosted on AWS EC2. • Design, implement, and maintain high availability and disaster recovery solutions, including Always On Availability Groups, clustering, replication, and failover testing. • Perform and continuously improve operational processes including backups, restores, database refreshes, index maintenance, patching, and capacity planning. • Monitor database performance and troubleshoot issues using execution plans, query analysis, Extended Events, SQL Profiler, and enterprise monitoring tools. • Participate in production support and on-call rotations while driving long-term improvements that reduce incident frequency and operational risk. • Automation & Process Improvement • Identify, prioritize, and eliminate manual database administration tasks through automation and standardization. • Develop reusable automation solutions using PowerShell, T-SQL, SQL Agent, Terraform, CloudFormation, and other engineering tools. • Standardize platform management practices across environments to improve consistency, reliability, and scalability. • Promote database platforms as repeatable services rather than individually managed systems. • DevOps & Engineering Integration • Partner with application, platform, and DevOps teams to integrate database deployments into CI/CD pipelines. • Support version-controlled database development and deployment practices. • Contribute to schema versioning, release automation, and database change management initiatives. • Advocate for database best practices within application architecture and development workflows. • Support low-downtime or zero-downtime deployment strategies to improve release quality and stability. • Team Enablement & Collaboration • Mentor team members in automation, cloud technologies, operational excellence, and engineering best practices. • Contribute to the evolution of the database team from reactive operational support to proactive platform engineering. • Create and maintain documentation, standards, playbooks, and operational runbooks. • Collaborate with global database engineering resources, including India-based team members, to maintain consistent standards and operational practices. • Cloud & Platform Modernization • Support AWS database services including RDS, Aurora, PostgreSQL, MySQL, and DynamoDB as business needs evolve. • Participate in cloud migration, modernization, and platform transformation initiatives. • Evaluate and implement new database and platform technologies that improve scalability, performance, and operational efficiency. • Reliability, Security & Cost Optimization • Improve platform reliability through monitoring, alerting, performance baselining, and capacity planning. • Support service reliability initiatives, including SLIs, SLOs, incident reduction, and operational improvements. • Implement and maintain secure database practices including encryption, auditing, role-based access controls, and compliance requirements. • Optimize infrastructure utilization and storage costs through rightsizing, lifecycle management, and performance tuning. • Participation in an on-call support rotation is required. • Occasional travel may be required based on business needs. • Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
Benefits
• At bswift, we empower our employees to make a meaningful impact, innovate, and grow. Joining our team means stepping into a collaborative and dynamic environment that values creativity, initiative, and a passion for client success. We are dedicated to fostering an inclusive workplace that celebrates diversity and values each team member’s unique contributions. • Comprehensive Health Benefits: Access to health, dental, and vision plans to support your wellness and that of your family. • Competitive Compensation: A compensation package that recognizes your skills, experience, and contributions, including performance-based incentives for most roles. • Remote first, Office friendly environment! No time to commute? No problem! • Remote first, Office friendly environment! • Retirement Savings Plans: Options to help you plan for a secure financial future with employer-sponsored retirement savings programs. • Retirement Savings Plans • Professional Development: Opportunities for career growth, including training and access to resources to support your career progression. • Professional Development • Supportive Culture: A work environment that encourages collaboration, open communication, and creative problem-solving, where your voice and ideas are valued. • Supportive Culture • Employee Wellbeing Initiatives: Programs focused on mental health, financial planning, and wellness resources to help you thrive inside and outside of work. • Employee Wellbeing Initiatives • Make an Impact: At bswift, your work directly contributes to transforming how organizations approach benefits administration and client engagement. Join us to be part of an organization that is making a meaningful difference in the lives of our clients and their employees. • Make an Impact • Specific benefit offerings vary by position and may be subject to change. • Standard working hours are 8am-5pm Central Time, unless otherwise stated in the Job Description. • In the spirit of pay transparency, we are excited to share the base salary range for this position is $140,000-$160,000, exclusive of fringe benefits or potential bonuses. If you are hired at bswift, your final base salary compensation will be determined based on factors such as geographic location, skills, education, and/or experience. In addition to those factors – we believe in the importance of pay equity and consider internal equity of our current team members as a part of any final offer. Please keep in mind that the range mentioned above is the full base salary range for the role. Hiring at the maximum of the range would not be typical in order to allow for future & continued salary growth. We also offer a generous compensation and benefits package! • 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. • Pursue Excellence, Embrace Accountability, Deliver Superior Service, • Be A Great Place To Work • 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!
Apply in one click
Upload My Resume
Drop here or click to browse · Tap to choose · PDF, DOCX, DOC, RTF, TXT