Senior Database Architect & Performance Optimizer

REGED INC; Elm (PA); Hybrid; USD 100,000 - 165,000; Full time

Benefits offered by this job

Medical plan

Life Insurance

Disability coverage

Volunteer time off

401(k) plan

Career growth opportunities

Performance bonuses

Job summary

RegEd is hiring a Senior Database Administrator to maintain and enhance database systems, shape new designs, and support the data team. The role focuses on SQL development, performance tuning, and cloud-based databases in Azure, with attention to security and compliance.

You will collaborate with Architecture, QA, and Infrastructure, driving improvements and ensuring SLAs are met. A service-oriented mindset and strong ownership are essential.

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
• 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, log shipping, and backup/recovery
• 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 in on-premise and cloud databases
• Recommend database approaches and design to architecture 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 including deadlocks
• 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 databases
• Collaborate with Architecture, QA, Development, and Infrastructure teams
• Work with multiple departments to implement and maintain database code

Skills

SQL proficiency

OLTP/OLAP

PowerShell

Git

Database performance tuning

Cloud databases (Azure)

Data security & encryption

Tools

SSMS

Grafana

PowerBI

Git

Job description

RegEd is hiring a Senior Database Administrator to maintain and enhance database systems, shape new designs, and support the data team. The role focuses on SQL development, performance tuning, and cloud-based databases in Azure, with attention to security and compliance.

You will collaborate with Architecture, QA, and Infrastructure, driving improvements and ensuring SLAs are met. A service-oriented mindset and strong ownership are essential.