RT² offers the most flexible cutting-edge Retail Management Solutions that encompass sales,
inventory management, frontline employee management and engagement, payments, business
intelligence, and digital automation tools for the wireless industry. We support Fortune 500
companies, unify their customer experience, and remove pain points across multiple retail touch
points. RT² prides itself on fostering a team-oriented culture and a dynamic work environment,
where team members are set up to make meaningful contributions across the organization.
Database Administrator - The Database Administrator will provide technical support for the development, implementation, and maintenance of an internal database. Maintains policies and procedures for ensuring database security and integrity. Implements data models, database designs, data access and table maintenance codes. Resolves database performance, capacity, replication, and distribution issues.
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.
Qualifications:
- 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.
- 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.
Our compensation structure considers various geographical markets within the United States. The base salary for this role reflects the typical expected earnings. However, the final compensation package will be determined by several factors, including your location, job-specific expertise, skills, experience, and other relevant job-related considerations.
What We Offer:
- A unique opportunity to shape the journey of RT²
- Working within a rapidly growing, game-changing business
- 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
Equal Opportunity Statement:
Realtime is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other protected status.
Similar Jobs
What We Do
Real Time Technologies Inc is a computer software company based out of 1517 N Main St, Royal Oak, Michigan, United States
