Note: The job is a remote job and is open to candidates in USA. Swyfft is reshaping the way home insurance and commercial package products are priced and bound, focusing on delivering exceptional customer service through technology. The Senior Database Administrator will oversee the health, performance, security, and reliability of the database estate, working hands-on with SQL Server and Azure SQL to ensure optimal operations.
Responsibilities
- Administer and maintain a variety of multi-terabyte databases across both SQL Server (on-premises and Azure VMs) and Azure SQL (PaaS) platforms
- Own backup, restore, and recovery. Design, automate, and regularly test backups to meet defined RPO and RTO targets, and lead recovery efforts when needed
- Monitor and tune database and query performance; diagnose and resolve bottlenecks, blocking, and indexing issues across high-volume transactional and analytical workloads
- Implement and maintain database security and data privacy controls, including access management, encryption, and auditing in line with our regulatory obligations
- Design, build, and maintain SSIS ETL packages and other data integration and data movement workflows
- Manage high availability and disaster recovery configurations (Always On availability groups, failover groups, geo-replication), and partner with development teams on schema design, query optimization, and safe deployment of database changes
Skills
- 8+ years of hands-on database administration experience, including significant time managing large-scale, production SQL Server environments
- Deep, hands-on expertise administering SQL Server in production at scale, including very large (multi-terabyte) databases
- Strong working knowledge of Azure SQL (PaaS) and the broader Azure data platform; equally comfortable operating in PaaS and IaaS/on-premises models
- Demonstrated mastery of performance tuning and execution plans, indexing strategy, wait statistics, and query optimization
- Solid command of backup/recovery, high availability, and disaster recovery design and testing, along with database security and data privacy practices (encryption, access control, auditing)
- Strong T-SQL skills and demonstrated experience with Azure SQL, SSIS, and database security and privacy controls
- Self-directed and dependable; you can be trusted to own critical systems with minimal oversight and serve as a credible second to our Director of Database Services
- Bachelor's degree in Computer Science, Information Systems, a related field, or equivalent experience required
- Relevant Microsoft data platform certifications (e.g., Azure Database Administrator Associate)
Benefits
- Medical, Dental, and Vision
- Short- and Long-Term Disability (Company Paid)
- Voluntary Long-Term Disability
- Employee Life & AD&D (Company Paid)
- Voluntary Employee, Spouse, and Child Life & AD&D
- Healthcare, Dependent Care and Transit FSA, and Healthcare Savings Account (HSA)
- 401K with a generous matching contribution and no vesting schedule
- 20 days of PTO annually (prorated based on hire date)
- Company Paid Holidays and 2 “Choose Your Own Holidays”
Company Overview
A simpler way to do home insurance. It was founded in 2014, and is headquartered in Morristown, New Jersey, USA, with a workforce of 51-200 employees. Its website is https://www.swyfft.com/.