Enhancing the Retail Experience.

Database Reliability Engineer

DevOps EngineerDevOps EngineerFull TimeRemoteTeam 51-200H1B No SponsorCompany Site LinkedIn

Location

Arizona + 16 more

Posted

59 days ago

Salary

$120K - $170K / year

Bachelor Degree3 yrs expEnglishAnsibleAzureCloudMy SQLSQLSSISTerraformUnix

Job Description

• 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

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