Database Administrator

<div class="content-intro"><p></p> <p><strong><span data-contrast="auto">Want to be a bswifter?</span></strong><span data-ccp-props="{&quot;335559739&quot;:0}">&nbsp;</span></p> <p><em><span data-contrast="auto">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.</span></em><span data-ccp-props="{&quot;335559739&quot;:0}">&nbsp;</span></p> <p><span data-ccp-props="{&quot;335559739&quot;:0}">&nbsp;</span><em><span data-contrast="auto">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!</span></em><span data-ccp-props="{&quot;335559739&quot;:0}">&nbsp;</span></p> <p></p></div><p data-start="162" data-end="406">We are seeking a <strong data-start="179" data-end="211">Database Administrator (DBA)</strong> to support and enhance our <strong data-start="239" data-end="253">SQL Server</strong> and <strong data-start="258" data-end="287">AWS database environments</strong>, ensuring high performance, availability, scalability, and security across both production and non-production systems.This is a <strong data-start="418" data-end="448">hands-on, high-impact role</strong> 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.</p> <h1 data-section-id="1bv0md7" data-start="694" data-end="720"><strong data-start="696" data-end="720"><span class="TextRun MacChromeBold SCXW108392178 BCX0" lang="EN-GB" data-contrast="none"><span class="NormalTextRun SCXW108392178 BCX0">Key Responsibilities</span></span><span class="EOP Selected SCXW108392178 BCX0" data-ccp-props="{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335557856&quot;:16777215,&quot;335559738&quot;:240,&quot;335559739&quot;:0}">&nbsp;</span></strong></h1> <ul data-start="722" data-end="2345"> <li data-section-id="2otn4x" data-start="722" data-end="867">Manage day-to-day administration of <strong data-start="760" data-end="793">SQL Server 2019+ environments</strong>, ensuring optimal performance, availability, scalability, and security.</li> <li data-section-id="1rl6wo9" data-start="868" data-end="990">Design and maintain <strong data-start="890" data-end="929">scalable cloud architectures on AWS</strong>, including <strong data-start="941" data-end="987">MySQL RDS, Aurora PostgreSQL, and DynamoDB</strong>.</li> <li data-section-id="11da8y1" data-start="991" data-end="1225">Perform core DBA activities such as: <ul data-start="1032" data-end="1225"> <li data-section-id="pzq3gg" data-start="1032" data-end="1065">Database backups and restores</li> <li data-section-id="a1922e" data-start="1068" data-end="1093">Environment refreshes</li> <li data-section-id="k3tw3i" data-start="1096" data-end="1122">Data de-identification</li> <li data-section-id="3geh51" data-start="1125" data-end="1158">Always On Availability Groups</li> <li data-section-id="r68mdh" data-start="1161" data-end="1197">Index and statistics maintenance</li> <li data-section-id="1x2g5yi" data-start="1200" data-end="1225">Disk space management</li> </ul> </li> <li data-section-id="12mmdpl" data-start="1226" data-end="1408">Proactively monitor and optimize database performance through: <ul data-start="1293" data-end="1408"> <li data-section-id="rmvals" data-start="1293" data-end="1311">Query analysis</li> <li data-section-id="7efj8r" data-start="1314" data-end="1337">Indexing strategies</li> <li data-section-id="1jdxjuo" data-start="1340" data-end="1366">Execution plan reviews</li> <li data-section-id="10qua98" data-start="1369" data-end="1408">Profiling and continuous monitoring</li> </ul> </li> <li data-section-id="171p099" data-start="1409" data-end="1634">Architect and maintain <strong data-start="1434" data-end="1460">High Availability (HA)</strong> and <strong data-start="1465" data-end="1491">Disaster Recovery (DR)</strong> solutions, including: <ul data-start="1516" data-end="1634"> <li data-section-id="1dbtvj1" data-start="1516" data-end="1540">Multi-AZ deployments</li> <li data-section-id="1xb4ct0" data-start="1543" data-end="1558">Replication</li> <li data-section-id="1uo5omb" data-start="1561" data-end="1582">Automated backups</li> <li data-section-id="z0e579" data-start="1585" data-end="1611">Point-in-time recovery</li> <li data-section-id="kyrvki" data-start="1614" data-end="1634">Failover testing</li> </ul> </li> <li data-section-id="1kl00mp" data-start="1635" data-end="1768">Develop automation solutions using: <ul data-start="1675" data-end="1768"> <li data-section-id="17r6tji" data-start="1675" data-end="1700">SQL Server Agent Jobs</li> <li data-section-id="1w1rd2" data-start="1703" data-end="1727">PowerShell scripting</li> <li data-section-id="bb6pse" data-start="1730" data-end="1743">Terraform</li> <li data-section-id="1owbunr" data-start="1746" data-end="1768">AWS CloudFormation</li> </ul> </li> <li data-section-id="1g8hyjm" data-start="1769" data-end="1855">Build and maintain <strong data-start="1790" data-end="1811">ETL/ELT pipelines</strong> to support analytics and reporting needs.</li> <li data-section-id="gyryub" data-start="1856" data-end="1979">Troubleshoot database issues related to performance, blocking, and job failures using SQL queries and monitoring tools.</li> <li data-section-id="decdjl" data-start="1980" data-end="2080">Participate in <strong data-start="1997" data-end="2030">on-call rotations (PagerDuty)</strong> and respond to production incidents and alerts.</li> <li data-section-id="fpujom" data-start="2081" data-end="2175">Collaborate with development teams to ensure seamless data operations across environments.</li> <li data-section-id="1y3um6s" data-start="2176" data-end="2266">Support <strong data-start="2186" data-end="2208">release management</strong>, including database deployments and production changes.</li> <li data-section-id="1djoas1" data-start="2267" data-end="2345">Continuously improve database administration processes and best practices.</li> </ul> <h1 data-section-id="1dp64c8" data-start="2352" data-end="2388"><strong data-start="2354" data-end="2388">Required Skills and Experience</strong></h1> <ul data-start="2390" data-end="3138"> <li data-section-id="cg72bg" data-start="2390" data-end="2500">Extensive experience with <strong data-start="2418" data-end="2442">Microsoft SQL Server</strong> (administration, performance tuning, and optimization).</li> <li data-section-id="hh6yqk" data-start="2501" data-end="2584">Hands-on experience with <strong data-start="2528" data-end="2553">AWS database services</strong> (RDS, PostgreSQL, DynamoDB).</li> <li data-section-id="gejb03" data-start="2585" data-end="2665">Experience with database monitoring tools such as <strong data-start="2637" data-end="2646">Idera</strong> and <strong data-start="2651" data-end="2662">Redgate</strong>.</li> <li data-section-id="wmrc0s" data-start="2666" data-end="2752">Ability to work in <strong data-start="2687" data-end="2708">on-call rotations</strong> and handle critical production incidents.</li> <li data-section-id="pp3yy5" data-start="2753" data-end="2868">Strong proficiency in <strong data-start="2777" data-end="2796">SQL development</strong>, including complex stored procedures and performance troubleshooting.</li> <li data-section-id="578vp8" data-start="2869" data-end="2922">Working knowledge of <strong data-start="2892" data-end="2919">ETL tools and processes</strong>.</li> <li data-section-id="a6sqbn" data-start="2923" data-end="3035">Strong analytical and problem-solving skills with the ability to communicate technical concepts effectively.</li> <li data-section-id="ofz0zs" data-start="3036" data-end="3138">Experience in <strong data-start="3052" data-end="3078">production deployments</strong> and active participation in release management processes.</li> </ul> <h1 data-section-id="o15129" data-start="3145" data-end="3175"><strong data-start="3147" data-end="3175">Preferred Qualifications</strong></h1> <ul data-start="3177" data-end="3655"> <li data-section-id="q1osd5" data-start="3177" data-end="3260">Experience with AWS services such as <strong data-start="3216" data-end="3257">Bedrock, OpenSearch, Glue, and Lambda</strong>.</li> <li data-section-id="1vdpdun" data-start="3261" data-end="3356">Knowledge of <strong data-start="3276" data-end="3353">data modeling, schema design, and enterprise data architecture principles</strong>.</li> <li data-section-id="gib1xy" data-start="3357" data-end="3454">Exposure to <strong data-start="3371" data-end="3451">automation, DevOps practices for databases, and Infrastructure-as-Code (IaC)</strong>.</li> <li data-section-id="4e2mbv" data-start="3455" data-end="3550">Familiarity with <strong data-start="3474" data-end="3547">NoSQL databases, caching technologies, and event-driven architectures</strong>.</li> <li data-section-id="8br1ih" data-start="3551" data-end="3655">Experience working in <strong data-start="3575" data-end="3599">regulated industries</strong> such as healthcare, insurance, or financial services.</li> </ul> <h1 data-section-id="dysjtx" data-start="3662" data-end="3681"><strong data-start="3664" data-end="3681">Shift Timings</strong></h1> <ul data-start="3683" data-end="3711"> <li data-section-id="1dh2pzb" data-start="3683" data-end="3711"><strong data-start="3685" data-end="3711">2:30 PM – 11:30 PM IST</strong></li> </ul> <div class="x_elementToProof"><strong data-olk-copy-source="MessageBody">Why Join bswift?</strong></div> <div class="x_elementToProof">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.</div> <div> <div class="x_elementToProof">&nbsp;</div> <div class="x_elementToProof"><strong>Benefits of Working at bswift:</strong></div> </div> <div> <div class="x_elementToProof"><strong>Comprehensive Health Benefits</strong>: Medical, Accidental and Term Life Insurance coverage to support your wellness and that of your family.&nbsp;</div> </div> <div><strong>Competitive Compensation</strong>: A compensation package that recognizes your skills, experience, and contributions, including performance-based incentives for most roles.</div> <div> <div class="x_elementToProof"><strong>Hybrid work-model:&nbsp;</strong>With flexible working hours</div> </div> <div> <div class="x_elementToProof"><strong>Retirement Savings Plans</strong>: Options like Provident Fund and Gratuity&nbsp;to help you plan for a secure financial future with employer contribution</div> </div> <div><strong>Professional Development</strong>: Opportunities for career growth, including training and access to resources to support your career progression.</div> <div><strong>Supportive Culture</strong>: A work environment that encourages collaboration, open communication, and creative problem-solving, where your voice and ideas are valued.</div> <div><strong>Employee Wellbeing Initiatives</strong>: Programs focused on mental health, financial planning, and wellness resources to help you thrive inside and outside of work.</div> <div> <div class="x_elementToProof"><strong>Make an Impact</strong>: 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.</div> </div> <p>&nbsp;</p><div class="content-conclusion"><p></p> <p><em><span data-contrast="auto">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&nbsp;</span></em><strong><em><span data-contrast="auto">Pursue Excellence, Embrace Accountability, Deliver Superior Service, </span></em></strong><em><span data-contrast="auto">and strive to</span></em><strong><em><span data-contrast="auto"> Be A Great Place To Work</span></em></strong><em><span data-contrast="auto">. We take pride in having an engaged, collaborative team that goes the extra mile to get the job done right.&nbsp;</span></em><span data-ccp-props="{&quot;335559739&quot;:0}">&nbsp;</span></p> <p><span data-ccp-props="{&quot;335559739&quot;:0}">&nbsp;</span><em><span data-contrast="auto">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.</span></em><span data-ccp-props="{&quot;335559739&quot;:0}">&nbsp;</span></p> <p><em><span data-contrast="auto">If you have what it takes to join our award-winning culture, we’d love to hear from you!</span></em><span data-ccp-props="{&quot;335559739&quot;:0}">&nbsp;</span></p> <p></p></div>