Senior Database Architect & Performance Lead - Remote

REGED INC; Yuma (AZ); Remote; USD 100,000 - 165,000; Full time

Benefits offered by this job

Fantastic and comprehensive medical, d

Job summary

RegEd is seeking a Senior Database Administrator to maintain and enhance our on‑prem and cloud databases. You will design, tune performance, write complex SQL, and respond to incidents. Join a data‑driven team delivering scalable solutions across our distributed environment.

You will work with Architecture, QA, and Infrastructure to implement robust database code, monitoring, and security. A remote‑friendly role with opportunities for hybrid collaboration is available.

Qualifications

• 7+ years database analysis, programming or similar experience.
• Minimum 4 years’ experience as a Senior Database Developer or equivalent
• Extensive hands‑on experience in SQL 2016 and higher
• Hands on experience with cloud‑based database systems in Azure using Managed Instance, Azure SQL Hyperscale, Azure SQL DB, and VMs.Extensive experience dealing with multiple large (2+ TB) databases
• Experience writing complex database procedures, functions and triggers
• Understanding of execution plans, system views, and dynamic SQL
• Strong understanding of database structures, theories and practices
• Proven strong innovate and analytical ability with extensive implementation skills
• Proven success in performance optimization for OLTP and OLAP applications
• Experience with SQL Server HADR technologies, including Always On Availability Groups, log shipping, and backup/recovery strategies.
• Experience with database monitoring platforms and dashboard tools such as SSMS, Grafana, PowerBI, or other third‑party tools.
• Proficiency in PowerShell for script automation, tooling, and operational workflows.
• Experience with Git or other version‑control change management processes.

Responsibilities

• Design, create, and maintain database objects. This includes all database physical and logical primary objects such as indexes, views, procedures, etc. in on premise and cloud databases.
• Recommend database approaches and design to architecture and application staff
• Drive innovation and improvement through implementation of newer data technologies
• Work with the Architecture team to establish coding standards for stored procedures, triggers, and logical and physical schema design.
• Review and approve complex structural changes to the database
• Optimization of existing queries and procedures as well as development of efficient, optimal SQL code.
• Lead investigation and resolution of database incidents including blocking and deadlocks.
• Assist in building and maintaining database monitoring infrastructure for alerting, performance collection, and operational dashboards.
• Support database security and compliance requirements using TDE, data masking, and other encryption tools.
• Advise on and implement data retention, tiering, and archive strategies for high-volume production databases.
• General technical troubleshooting and consultation with quality assurance, application development, and infrastructure teams.
• Work with several departments including Architecture, Quality Assurance, Application Development, and Infrastructure to implement and maintain database and database code

Skills

SQL 2016+

Azure Managed Instance

Azure SQL Hyperscale

Azure SQL DB

VMs

Complex SQL

PowerShell

Git

Stored procedures & triggers

Always On/HA

Tools

SSMS

Grafana

PowerBI

SSIS

Liquibase

Flyway

Oracle

PostgreSQL

MySQL

Job description

RegEd is seeking a Senior Database Administrator to maintain and enhance our on‑prem and cloud databases. You will design, tune performance, write complex SQL, and respond to incidents. Join a data‑driven team delivering scalable solutions across our distributed environment.

You will work with Architecture, QA, and Infrastructure to implement robust database code, monitoring, and security. A remote‑friendly role with opportunities for hybrid collaboration is available.