Remote SQL Server DBA – Performance & Security Expert

REGED INC; East Windsor Hill (CT); Teletrabalho; USD 85 000 - 120 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Fantastic benefits package

Volunteering Time Off

401(k) plan

Career growth opportunities

Performance bonuses

Flexible schedules

Resumo da oferta

RegEd is hiring a Database Administrator to own and operate our on-prem and cloud database environments. You will monitor health, manage backups, optimize queries, and ensure security and compliance across production, development, and QA environments.

The role emphasizes ownership, cross-team collaboration, and a commitment to reliability in a fast-paced RegTech setting. Remote or hybrid work arrangements are available for qualified candidates.

Qualificações

• 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.

Responsabilidades

• 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.

Conhecimentos

3+ years

Microsoft SQL Server

T-SQL

Execution plans

Backup & recovery

Azure SQL (cloud)

Security administration

SQL scripting

OLTP

Collaboration

Formação académica

B.E./B.S. in Computer Science or related field

Ferramentas

SSMS

Grafana

SSIS

SSRS

Git

Oracle

PostgreSQL

MySQL

Descrição da oferta de emprego

RegEd is hiring a Database Administrator to own and operate our on-prem and cloud database environments. You will monitor health, manage backups, optimize queries, and ensure security and compliance across production, development, and QA environments.

The role emphasizes ownership, cross-team collaboration, and a commitment to reliability in a fast-paced RegTech setting. Remote or hybrid work arrangements are available for qualified candidates.