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. They are seeking a Senior Database Administrator to oversee the health, performance, security, and reliability of their database estate, working hands-on with SQL Server and Azure SQL to ensure optimal data management and service delivery.
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
- Reliable high-speed internet connectivity required
- Designated quiet work from home space
- Relevant Microsoft data platform certifications (e.g., Azure Database Administrator Associate) a plus
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