Senior Database Architect - Remote | Performance & Scale

REGED INC; Alton (IL); Hybrid; USD 100,000 - 165,000; Full time

Benefits offered by this job

Medical, dental & vision plans

Life Insurance

Disability plans

Volunteering Time Off

401(k) plan

Career growth opportunities

Performance bonuses

Job summary

RegEd is seeking a Senior Database Administrator to maintain and improve DBA systems, design new data solutions, and ensure high availability and performance. You will work within a data team to manage on-premise and cloud databases, respond to incidents, and implement best practices across architecture, QA, and infrastructure.

You will design, optimize, and secure SQL code, monitor performance, and collaborate on data retention and archival strategies while aligning with regulatory and security

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 databases (2+ TB).
• Experience writing complex database procedures, functions and triggers.
• Understanding of execution plans, system views, and dynamic SQL.
• Strong understanding of database structures, theories, principles 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 across on-premise and cloud databases.
• Recommend database approaches and design to architecture and app staff.
• Drive innovation through newer data technologies.
• Establish coding standards for stored procedures, triggers, and schema design.
• Review and approve complex structural changes to the database.
• Optimize existing queries and procedures; develop efficient SQL code.
• Lead investigation and resolution of database incidents and escalations.
• Build and maintain database monitoring infrastructure for alerts and dashboards.
• Support database security and compliance using encryption tools.
• Advise on data retention, tiering, and archive strategies for high-volume production databases.
• Collaborate with Architecture, QA, Applications, and Infra teams to implement database solutions.

Skills

Database design

SQL development

Query optimization

OLTP/OLAP performance tuning

Azure SQL / cloud databases

Data security & encryption

Scripting with PowerShell

Monitoring & dashboards

Tools

SSMS

Grafana

PowerBI

Azure Managed Instance

Azure SQL Hyperscale

Job description

RegEd is seeking a Senior Database Administrator to maintain and improve DBA systems, design new data solutions, and ensure high availability and performance. You will work within a data team to manage on-premise and cloud databases, respond to incidents, and implement best practices across architecture, QA, and infrastructure.

You will design, optimize, and secure SQL code, monitor performance, and collaborate on data retention and archival strategies while aligning with regulatory and security