What you will be doing
About the Role:
This role owns a roughly 65TB Microsoft SQL Server estate running in a highly available, clustered configuration, supporting the Insightly CRM product directly. This is production database work for a live, customer-facing SaaS platform, not an analytics or reporting role.
What this role will do:
• Lead maintenance of the production SQL Server environment in an Always On availability group configuration, including failover handling, sync delay troubleshooting, and read replica load management
• Carry 24x7 on-call for SQL alerts, lead incident response and root cause analysis for query plan regressions, TempDB contention, and deadlocks or blocking
• Maintain database security: TDE, auditing, certificate and key rotation, and monitoring for anomalous access patterns
• Run quarterly cumulative update patching across environments, index and statistics maintenance, and partitioning and archiving on multi-terabyte databases without blocking production
• Own capacity planning for storage, CPU, and memory, and manage the recurring cycle of environment refreshes (staging, dev, QA)
• Review developers' T-SQL and schema changes before deployment, and advise on table and index design
• Support customer instance migrations between regions (sold as a service) and database prep for those moves
• Handle confidential or legally sensitive data requests when they arise, including from law enforcement, following established process
• Design and test disaster recovery for the database environment
This role owns a roughly 65TB Microsoft SQL Server estate running in a highly available, clustered configuration, supporting the Insightly CRM product directly. This is production database work for a live, customer-facing SaaS platform, not an analytics or reporting role.
What this role will do:
• Lead maintenance of the production SQL Server environment in an Always On availability group configuration, including failover handling, sync delay troubleshooting, and read replica load management
• Carry 24x7 on-call for SQL alerts, lead incident response and root cause analysis for query plan regressions, TempDB contention, and deadlocks or blocking
• Maintain database security: TDE, auditing, certificate and key rotation, and monitoring for anomalous access patterns
• Run quarterly cumulative update patching across environments, index and statistics maintenance, and partitioning and archiving on multi-terabyte databases without blocking production
• Own capacity planning for storage, CPU, and memory, and manage the recurring cycle of environment refreshes (staging, dev, QA)
• Review developers' T-SQL and schema changes before deployment, and advise on table and index design
• Support customer instance migrations between regions (sold as a service) and database prep for those moves
• Handle confidential or legally sensitive data requests when they arise, including from law enforcement, following established process
• Design and test disaster recovery for the database environment