Senior Database Architect & Performance Optimizer

REGED INC

Georgia

Remote

USD 100,000 - 165,000

Full time

7 days ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Fantastic medical, dental, vision

Life and 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 evolve our database landscape, including on-premise and Azure cloud platforms. You will design objects, optimize queries, and implement robust monitoring while aligning with security and compliance requirements.

You’ll collaborate with architecture, QA, and infrastructure teams to deliver scalable solutions. Ideal candidates bring 7+ years of database experience, strong SQL Server/HADR expertise, and proficiency with PowerShell,

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 innovatio 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 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 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 QA, application development, and infrastructure teams.
Work with several departments including Architecture, QA, Application Development, and Infrastructure to implement and maintain database and database code.