Senior Cloud DBA with Security Clearance (Remote/Hybrid)

REGED INC; East Windsor Hill (CT); Remote; USD 100,000 - 165,000; Full time

Benefits offered by this job

Medical/dental/vision plans

Life Insurance

Short-Term Disability

Long-Term Disability

Volunteer Time Off

Flexible schedules

Career growth opportunities

Performance bonuses

Job summary

RegEd is seeking a Senior Database Administrator to maintain and improve our database systems, both on-premise and in the cloud, with a focus on performance, security, and reliability. You will design objects, optimize queries, and lead incident resolution across a multi-department data team.

You will work in a flexible remote or hybrid model, collaborating with Architecture, QA, and Infrastructure to implement best practices and new data technologies. 7+ years' experience required.

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.
• Experience with cloud-based database systems in Azure using Managed Instance, Azure SQL Hyperscale, Azure SQL DB, and VMs.
• Extensive experience with 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.
• Experience with Always On Availability Groups, log shipping, and backup/recovery strategies.
• Experience with database monitoring platforms and dashboards 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.

Responsibilities

• Maintain and improve existing database systems and assist in design of new systems.
• Design, create, and maintain database objects in on-premise and cloud databases.
• Recommend database approaches to architecture and application staff.
• Drive innovation and improvement through newer data technologies.
• Work with Architecture 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 and development of efficient SQL code.
• Lead investigation and resolution of database incidents including blocking and deadlocks.
• Assist in building and maintaining database monitoring infra for alerts and dashboards.
• Support database security and compliance using TDE, data masking, etc.
• Advise on retention, tiering, and archive strategies for high-volume production databases.
• Collaborate with Architecture, QA, App Development, and Infra teams to maintain code.

Skills

7+ years database analysis

Senior Database Developer 4+ years

Advanced SQL 2016+

Azure cloud DB experience

Large databases 2+ TB

Complex procedures, functions, and Tr.

Execution plans and dynamic SQL

OLTP/OLAP performance tuning

Always On Availability Groups

Backup/Recovery strategies

Monitoring: SSMS/Grafana/PowerBI

SSIS/ETL tooling

SSRS/Reporting platforms

Oracle/PostgreSQL/MySQL

Azure Data Lake/Synapse

Tools

SSMS

Grafana

PowerBI

SSIS

SSRS

Azure SQL

Job description

RegEd is seeking a Senior Database Administrator to maintain and improve our database systems, both on-premise and in the cloud, with a focus on performance, security, and reliability. You will design objects, optimize queries, and lead incident resolution across a multi-department data team.

You will work in a flexible remote or hybrid model, collaborating with Architecture, QA, and Infrastructure to implement best practices and new data technologies. 7+ years' experience required.