RT²

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 website
✨ AI Apply
Apply

Salary

💰 $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