Senior Manager, Reliability Engineering
The Home Depot
JavaJavaScriptNode.jsPythonRubyRuby on RailsSpringSQL
Database Reliability Engineer
RT²
full-time
Posted on:
Location Type: Remote
Location: Remote • Arizona, Colorado, Florida, Idaho, Kansas, Massachusetts, Missouri, Nevada, New Jersey, New York, North Carolina, Ohio, Oregon, Pennsylvania, Texas, Virginia • 🇺🇸 United States
Visit company websiteSalary
💰 $120,000 - $170,000 per year
Job Level
Mid-LevelSenior
Tech Stack
AnsibleAzureCloudMySQLSQLSSISTerraformUnix
About the role
- Install, update, and maintain SQL Server database software across multiple versions (2012–2022).
- Manage database performance by developing protocols, monitoring systems, and resolving processing and programming issues.
- Implement database security policies and disaster recovery (DR) procedures to ensure data integrity and accessibility.
- Support database migrations from on-premises to cloud environments, with a focus on Azure databases and SQL in cloud/Azure.
- Design, implement, and maintain highly available and performant SQL Server and MySQL database systems.
- Monitor database health, performance, and capacity using industry-standard tools and custom scripts.
- Automate routine database operations and deployments using Infrastructure as Code (IaC) and CI/CD pipelines.
- Upgrade SQL Server versions and optimize systems for performance and reliability.
- Create and optimize queries, stored procedures, and indexing strategies.
- Maintain and administer SSAS, SSIS, and SSRS solutions for reporting and analytics.
- Provide guidance and support to developers, including schema design, code review, and query tuning.
- Collaborate with DevOps to install, configure, and manage SQL Server instances and databases in hybrid environments.
- Design, deploy, and maintain SQL Server availability groups across data centers.
- Develop and maintain database standards, documentation, and failover runbooks.
- Automate database maintenance tasks and processes to improve efficiency.
- Be available for on-call support to address urgent database issues.
Requirements
- Proven experience with SQL Server (2012–2022), Azure databases, and SQL on VMs.
- 3+ years of Terraform/Ansible/Powershell experience
- Experience with Azure SQL, Azure Managed Instances, and on-prem SQL Server.
- Hands-on experience with disaster recovery (DR) solutions for SQL Server.
- Expertise in SSAS, SSIS, and SSRS, with exposure to Power BI preferred.
- Demonstrated ability to migrate on-premises databases to cloud environments, including Azure.
- Strong skills in updating SQL Server versions and implementing new database systems.
- Proficiency in SQL query language, query optimization, and troubleshooting.
- Strong experience with PowerShell scripting for automation and configuration management.
- Exposure to Infrastructure as Code (IaC) tools, such as Terraform, Ansible, or ARM templates.
- Advanced knowledge of database security, performance tuning, and backup/recovery standards.
- Familiarity with dimensional and relational data modeling concepts.
- Strong programming skills, including experience with PL/SQL coding.
- Experience with Unix and PowerShell scripting for database management tasks.
- Knowledge of emerging database technologies and the ability to recommend and implement solutions.
- Excellent problem-solving skills and attention to detail.
- Strong communication skills to collaborate effectively with technical and non-technical teams.
Benefits
- Competitive compensation
- Generous STI and LTI provisions
- Health, Dental and Vision Insurance
- Paid Annual Leave
- Paid Sick Leave
- 401K and more
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQL ServerAzure databasesMySQLTerraformAnsiblePowerShellSSASSSISSSRSPL/SQL
Soft skills
problem-solvingattention to detailcommunication
