Database Reliability Engineer

Real Time Technologies•Miami, FL

10h•$120,000 - $170,000•Remote

About The Position

Realtime technologies 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. Realtime 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.

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.
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.

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.