Remote DB Administrator - Azure SQL & Performance

REGED INC; Milton (MA); Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

Medical benefits

Life insurance

Flexible schedules

401(k) plan

Career growth

Performance bonus

Job summary

REGED INC is seeking a Database Administrator to provide operational and application database services across on-premise and cloud environments. You will own incidents, monitor health, manage backups, and support performance & security requirements.

The role involves daily monitoring, handling alerts, and collaborating with teams to optimize queries and ensure efficiency, accuracy, and reliability. Strong T-SQL and cloud database experience are essential.

Qualifications

• 3+ years of database administration, development, or equivalent experience.
• Hands-on experience with Microsoft SQL Server 2016 or higher.
• Strong T-SQL skills including complex queries, stored procedures, transaction management, error handling, and dynamic SQL.
• Understanding of execution plans and query optimization techniques.
• Working knowledge of database backup, recovery, and HADR concepts.
• Familiarity with cloud database services in Azure such as Azure SQL MI, Azure SQL DB, or Azure SQL on VMs.
• Experience with database security administration such as user management, role assignment, and access controls.
• Ability to build and maintain SQL scripts, indexes, and complex queries for data analysis and operational use.
• Strong understanding of database structures, theories, principles, and practices for OLTP environments.
• Proven analytical ability and attention to detail in a production environment.
• Strong interpersonal, written, and oral communication skills.
• Ability to work collaboratively with development teams in a dynamic environment.
• Commitment to quality and accuracy.

Responsibilities

• Design, create, and maintain database objects including indexes, views, stored procedures, tables, and other schema elements in on-premise and cloud environments.
• Monitor and maintain database health by reviewing and responding to backup status, maintenance jobs, index health, and daily operational alerts.
• Perform database user and security management: create logins and users, manage roles and access privileges, and support compliance requirements.
• Plan, implement, and maintain backup, restore, and recovery procedures; verify backup success and support restore testing.
• Participate in investigation and resolution of database incidents including blocking, deadlocks, and performance degradation.
• Optimize existing queries and procedures; develop efficient T-SQL using execution plans, system views, and indexing best practices.
• Refresh development and test environment databases on a regular basis to support QA and development teams.
• Assist in building and maintaining database monitoring infrastructure for alerting, performance data collection, and operational visibility.
• Support implementation of database changes and code deployments; work with the Architecture team on coding standards for stored procedures, triggers, and schema design.
• Perform feasibility studies and effort estimates for new or revised database systems to address business needs.
• Install, upgrade, and maintain database instances required for development, testing, and production usage.
• General technical troubleshooting and consultation with Quality Assurance, Application Development, and Infrastructure teams.
• Work with multiple departments including Architecture, Quality Assurance, Application Development, and Infrastructure to implement and maintain database code and configurations.

Skills

SQL Server

T-SQL

Query optimization

Azure SQL

Database security

Backups & recovery

On-prem & cloud

Monitoring tools

Tools

SSMS

Grafana

SSIS

Job description

REGED INC is seeking a Database Administrator to provide operational and application database services across on-premise and cloud environments. You will own incidents, monitor health, manage backups, and support performance & security requirements.

The role involves daily monitoring, handling alerts, and collaborating with teams to optimize queries and ensure efficiency, accuracy, and reliability. Strong T-SQL and cloud database experience are essential.