Senior SQL Database Administrator

Senior SQL Database Administrator

Located in the US or Bermuda, the Senior SQL Database Administrator is responsible for the engineering, automation, performance, and reliability of the organization's SQL Server platforms.

This role goes beyond traditional DBA operations and focuses on automation, Infrastructure-as-Code, self-healing platforms, and proactive performance engineering. The successful candidate will be a hands-on expert who builds scalable, secure, and highly available SQL environments across on-premises and cloud platforms.

This role reports to the SQL Database Manager.

What You Will Do

Database Engineering & Operations

• Design, deploy, and operate highly available and resilient SQL Server environments (Standalone, Failover Cluster Instances, Always On Availability Groups).
• Own the end-to-end lifecycle of SQL Server instances: build, patch, upgrade, decommission.
• Ensure database platforms meet availability, performance, security, and recoverability requirements.
• Act as a senior escalation point for complex database incidents and performance issues.

Automation & Platform Engineering (Core Focus)

• Design and implement automation-first DBA processes, minimizing manual intervention.
• Build and maintain automation using:
• PowerShell
• T-SQL
• CI/CD pipelines (Azure DevOps, GitHub Actions, or equivalent)
• Automate:
• SQL builds and configuration
• Patching and upgrades
• Backups, restores, and DR testing
• Monitoring, alerting, and health checks
• Implement Infrastructure as Code (ARM, Bicep, Terraform, DSC where applicable) for database platforms.
• Promote "DBA as a service" capabilities for engineering teams.

Performance, Tuning & Reliability

• Lead advanced performance troubleshooting and query optimization.
• Analyze execution plans, wait statistics, and IO patterns.
• Design and implement indexing, partitioning, and data-growth strategies.
• Proactively identify and remediate performance and capacity risks.
• Support performance testing and release readiness for critical applications.

Security & Compliance

• Implement and maintain SQL security best practices:
• Least privilege access
• Encryption (TDE, TLS, Always Encrypted where applicable)
• Auditing and logging
• Support compliance with organizational and regulatory requirements (e.g. SOX, ISO 27001, internal security standards).
• Work closely with security teams to address vulnerabilities and hardening requirements.

Cloud & Hybrid Platforms

• Operate SQL Server across on-premises and cloud environments:
• Azure SQL Managed Instance / Azure SQL DB
• SQL Server on Azure IaaS (VMs)
• Optimize cost, performance, and availability in cloud platforms.
• Support migration and modernization initiatives (on-prem → cloud, lift-and-shift, re-platform).

Collaboration & Leadership

• Partner with application, data, and platform engineering teams to design database-friendly architectures.
• Provide guidance and mentoring to junior DBAs and engineers.
• Contribute to standards, patterns, and documentation for database engineering.
• Participate in architecture and design reviews for new systems.

What You Require for the Role

Essential

• Extensive hands-on experience as a Senior SQL Server DBA in production environments.
• Deep expertise in:
• SQL Server internals
• T-SQL development
• Performance tuning and troubleshooting
• Strong automation and scripting skills (PowerShell essential).
• Experience implementing CI/CD pipelines for database and platform changes.
• Proven experience operating high-availability and disaster-recovery SQL solutions.
• Strong understanding of Windows Server and underlying infrastructure.

Desirable

• Experience with Azure SQL (Managed Instance, Azure SQL DB).
• Experience with Terraform, ARM, or Bicep for database infrastructure.
• Familiarity with monitoring platforms (e.g. Azure Monitor, SQL Sentry, Redgate, Prometheus).
• Experience supporting large-scale or mission-critical platforms.
• Exposure to DevOps / SRE practices applied to data platforms.

Qualifications & Certifications

• Relevant experience valued over formal education.
• Microsoft certifications (e.g. Azure Database Administrator Associate, legacy MCSE) are desirable but not mandatory.

Personal Attributes

• Strong engineering mindset with a bias for automation.
• Calm and methodical under pressure.
• Pragmatic problem solver with attention to detail.
• Collaborative, proactive, and continuously improving.

What Success Looks Like

• Manual DBA tasks are eliminated or heavily automated.
• Database environments are stable, predictable, and well-monitored.
• Incidents are rare, and recovery is fast and well-rehearsed.
• Engineering teams can safely consume database services at scale.

What You Can Expect From Us

At Hamilton, we offer a vibrant, entrepreneurial and collaborative workplace shaped by our values: Be Smart, Be Sensible, Be Open and Be More.

Our employees consistently say they would recommend Hamilton as a great place to work — a testament to the inclusive, supportive, and empowering culture we've built together. We embrace individuality, value diverse perspectives, and recognize the unique contribution each person makes to our continued success.

Hamilton offers a competitive salary with an annual performance-based target bonus and a comprehensive benefits package, to include:

• Hybrid working
• Matching 401K plan
• Medical, dental, vision, life, disability
• Generous time off (including parental leave)
• Continued support for professional development
• Gym subsidy
• My day (additional days leave for personal interests/wellness/charity work)

In good company.

Hamilton (NYSE: HG) underwrites specialty insurance and reinsurance risks on a global basis through its wholly owned subsidiaries. Its three underwriting platforms: Hamilton Global Specialty, Hamilton Select and Hamilton Re, each with dedicated and experienced leadership, provide access to diversified and profitable business around the world.

Headquartered in Bermuda, Hamilton has over 600 employees with key underwriting operations in London, Bermuda, the US and Dublin. We work collaboratively, we share a passion for the service and results we deliver, and we know that what we do each day is meaningful – to our customers and our business. We believe we are 'In good company.' with everyone we interact with.