Database Reliability Engineer

Summary

Join RT², a company offering flexible, cutting-edge retail management solutions, as their Database Administrator. You will provide technical support for database development, implementation, and maintenance, ensuring security and integrity. Responsibilities include managing database performance, implementing security policies, and supporting migrations to cloud environments. You will design, implement, and maintain database systems, monitor health and performance, and automate operations. Collaboration with developers and DevOps teams is crucial. The role requires on-call support for urgent issues. RT² offers a remote, flexible work environment with competitive compensation and benefits.

Requirements

• Proven experience with SQL Server (2012–2022), Azure databases, and SQL on VMs
• 3+ 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
• 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

Responsibilities

• 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

Preferred Qualifications

Expertise in SSAS, SSIS, and SSRS, with exposure to Power BI preferred

Benefits

• Remote, flexible working options
• Competitive compensation
• Generous STI and LTI provisions
• Health, Dental and Vision Insurance
• Paid Annual Leave
• Paid Sick Leave
• 401K, and more