Database Administrator

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 installing and maintaining SQL Server databases, managing performance, implementing security policies, and supporting migrations to cloud environments. You will also create and optimize queries, administer SSAS, SSIS, and SSRS solutions, and collaborate with developers and DevOps teams. 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
• 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
• 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
• 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
• Exposure to Infrastructure as Code (IaC) tools, such as Terraform, Ansible, or ARM templates

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