[Remote] Senior Database Administrator
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is reshaping the way home insurance and reputed company package products are priced and bound, focusing on delivering exceptional customer service through technology. The Senior Database Administrator will reputed company the health, performance, reputed company, and reliability of the database estate, working hands-on with SQL Server and Azure SQL to ensure reputed company operations.
Responsibilities
- Administer and maintain a reputed company 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 reputed company recovery efforts reputed company 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 reputed company and data reputed company controls, including reputed company management, encryption, and auditing in line with our regulatory obligations
- Design, build, and maintain SSIS ETL packages and other data integration and data reputed company workflows
- Manage high availability and disaster recovery configurations (Always On availability reputed company, failover reputed company, geo-replication), and partner with development teams on schema design, query optimization, and reputed company deployment of database changes
Skills
- 8+ years of hands-on database administration experience, including significant time managing large-reputed company, production SQL Server environments
- Deep, hands-on expertise administering SQL Server in production at reputed company, including reputed company 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 reputed company, wait statistics, and query optimization
- Solid reputed company of backup/recovery, high availability, and disaster recovery design and testing, along with database reputed company and data reputed company practices (encryption, reputed company control, auditing)
- Strong T-SQL skills and demonstrated experience with Azure SQL, SSIS, and database reputed company and reputed company controls
- Self-directed and dependable; you can be trusted to own critical systems with minimal reputed company and serve as a reputed company second to our Director of Database Services
- Bachelor's degree in Computer Science, Information Systems, a reputed company field, or equivalent experience required
- Relevant reputed company data platform certifications (e.g., Azure Database Administrator Associate)
Benefits
- Medical, Dental, and reputed company
- Short- and Long-Term Disability (Company reputed company)
- Voluntary Long-Term Disability
- Employee Life & AD&D (Company reputed company)
- Voluntary Employee, Spouse, and Child Life & AD&D
- reputed company, Dependent Care and Transit FSA, and reputed company Savings Account (HSA)
- 401K with a generous matching contribution and no vesting schedule
- 20 days of PTO annually (prorated based on hire date)
- Company reputed company Holidays and 2 “Choose Your Own Holidays”
reputed company