Senior Database Architect — Remote & Growth Opportunities

REGED INC; Central City (KY); Híbrido; USD 100.000 - 165.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Medical, dental, vision plans

Life Insurance & Disability

Volunteer time off

Career growth opportunities

Performance bonuses

Descripción de la vacante

RegEd is seeking a Senior Database Administrator to join our data team. You will design, optimize, and maintain high-volume databases across on‑premise and cloud environments, ensuring performance, security, and reliability.

Responsibilities include optimizing complex SQL, implementing data retention strategies, and collaborating with Architecture, QA, and Infrastructure teams to uphold coding standards and incident response.

Formación

• 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.
• 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, 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.
• Experience with SSIS or other ETL tooling.
• Experience with SSRS or other managed reporting platforms
• Familiarity with Oracle, PostgreSQL, or MySQL.
• Familiarity with Azure Data Lake Storage, Synapse Analytics, or other cloud native platforms.

Responsabilidades

• 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 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 with 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 with encryption and masking.
• Advise on retention, tiering, and archiving for high-volume databases.
• Collaborate with Architecture, QA, and Infrastructure teams on database code.

Conocimientos

SQL

Azure

Database design

Performance tuning

OLTP/OLAP

Data security

Monitoring

Herramientas

SSMS

Grafana

Power BI

SSIS

SSRS

Azure Data Lake Storage

Synapse Analytics

Descripción del empleo

RegEd is seeking a Senior Database Administrator to join our data team. You will design, optimize, and maintain high-volume databases across on‑premise and cloud environments, ensuring performance, security, and reliability.

Responsibilities include optimizing complex SQL, implementing data retention strategies, and collaborating with Architecture, QA, and Infrastructure teams to uphold coding standards and incident response.