Senior Database Administrator — Remote & Growth Opportunities

REGED INC; Clayton (MO); Hybride; USD 100 000 - 165 000; Plein temps

Avantages offerts par ce poste

Medical, dental, vision

Life insurance

Disability coverage

Volunteer time off

Flexible schedules

Career growth opportunities

Performance bonuses

Résumé du poste

RegEd is seeking a Senior Database Administrator to maintain and enhance our database systems, both on‑premises and in the cloud. You will design objects, optimize queries, and lead incident resolution while collaborating with the Architecture and Data teams.

The role emphasizes security, data retention, and scalable database solutions across large production environments. A strong Azure SQL and OLTP/OLAP background is essential for success.

Qualifications

• 7+ years database analysis, programming or similar experience.
• 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 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.

Responsabilités

• Maintain and improve existing database systems; assist in design and development of new systems.
• Design, create, and maintain database objects in on‑premise and cloud databases.
• 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; respond to alerts within SLA time.
• Collaborate with Architecture to establish coding standards for stored procedures and schemas.
• Build and maintain database monitoring infrastructure for alerts and dashboards.
• Support database security and compliance with encryption tools and data masking.
• Advise on retention, tiering, and archive strategies for high-volume production databases.
• Work with multiple departments to implement and maintain database code.

Connaissances

SQL Expertise

Cloud Azure

Large databases

Performance tuning

OLTP/OLAP

SSIS/ETL

SSRS/Reporting

Always On

Monitoring tools

Data security

Outils

SSMS

Grafana

PowerBI

Azure SQL

Description du poste

RegEd is seeking a Senior Database Administrator to maintain and enhance our database systems, both on‑premises and in the cloud. You will design objects, optimize queries, and lead incident resolution while collaborating with the Architecture and Data teams.

The role emphasizes security, data retention, and scalable database solutions across large production environments. A strong Azure SQL and OLTP/OLAP background is essential for success.