Senior SQL Database Administrator
Posted 15ds ago
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior SQL Database Administrator managing SQL Server platforms for Hamilton, focusing on automation and performance engineering in a remote role.
Responsibilities:
- 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.
- 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.
- 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.
- 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).
Requirements:
- 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.
- Relevant experience valued over formal education.
- Microsoft certifications (e.g. Azure Database Administrator Associate, legacy MCSE) are desirable but not mandatory.
Benefits:
- 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




















