Remote Database Administrator - SQL, Security & Performance

REGED INC; Williamstown (NJ); Híbrido; USD 85.000 - 120.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Med/Dental/Vision plans

Life Insurance

Volunteer time off

Career growth opportunities

Performance bonuses

Descripción de la vacante

RegEd, a market-leading RegTech provider, seeks a Database Administrator (DBA) to support operational and application databases. You will own incidents, monitor backups, and maintain health across on-premise and cloud environments, designing objects and supporting performance and security requirements.

You will collaborate with Architecture, QA, Applications, and Infrastructure teams to implement changes and ensure data integrity.

Formación

• 3+ years in 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.
• Knowledge of database backup, recovery, and high availability/ disaster recovery concepts.
• Familiarity with Azure cloud database services (Azure SQL MI/DB/VM).
• Experience with database security administration (user management, roles, access controls).
• Ability to build and maintain SQL scripts, indexes, and complex queries for data analysis.
• Solid understanding of OLTP database concepts and best practices.
• Familiarity with monitoring/dashboard tools (SSMS, Grafana).
• Experience with SSIS or other ETL tooling.
• Experience with SSRS or other reporting platforms.
• Familiarity with Oracle, PostgreSQL, or MySQL.
• Relevant degree or experience can substitute for education requirements.

Responsabilidades

• Design, create and maintain database objects (indexes, views, stored procedures, tables) in on-prem and cloud environments.
• Monitor and maintain database health, backups, maintenance jobs, and index health.
• Manage database users, roles, and access controls; support compliance requirements.
• Verify backup success and conduct restore testing.
• Investigate and resolve database incidents including blocking, deadlocks, and performance issues.
• Refresh development and test environment databases regularly for QA.
• Assist in building and maintaining database monitoring infrastructure for alerting and visibility.
• Support changes and deployments; coordinate with Architecture on coding standards for procedures, triggers, and schema design.
• Perform feasibility studies and effort estimates for new/revised database systems.
• Install, upgrade, and maintain database instances for development, testing, and production.
• Troubleshoot and consult with QA, Apps, and Infrastructure teams.
• Collaborate across Architecture, QA, Apps, and Infrastructure to implement and maintain database code/configurations.

Conocimientos

Database administration

MS SQL Server

T-SQL

Backup & recovery

Azure SQL

Database security

SQL scripting

OLTP concepts

Monitoring tools

ETL (SSIS)

Reporting

Other DB platforms

CS/IT degree

Educación

CS/IT degree or equivalent

Herramientas

SSMS

Grafana

Azure SQL MI

Azure SQL DB

Azure SQL on VMs

Descripción del empleo

RegEd, a market-leading RegTech provider, seeks a Database Administrator (DBA) to support operational and application databases. You will own incidents, monitor backups, and maintain health across on-premise and cloud environments, designing objects and supporting performance and security requirements.

You will collaborate with Architecture, QA, Applications, and Infrastructure teams to implement changes and ensure data integrity.