Senior SQL Server DBA: On-Prem & Azure Performance & Build

ConsultNet Technology Services and Solutions; City of White Plains (NY); On-site; USD 130,000 - 150,000; Full time

Benefits offered by this job

CI/CD familiarity

SQL as code mindset

Job summary

ConsultNet Technology Services and Solutions in White Plains is seeking a Senior SQL Server DBA to own performance, integrity, and scalability across on-premises SQL Server and Azure SQL. You will assess an existing environment and optimize it, rather than merely maintaining what exists.

You will monitor bottlenecks, tune queries, design ETL pipelines with Azure Data Factory and SSIS, implement security controls, and manage backups, geo-replication, and high availability.

Qualifications

• 5+ years of SQL Server DBA experience with at least 3 years focused on Azure SQL.
• Strong T-SQL — complex queries, stored procedures, triggers, and views.
• Hands-on Azure Data Factory and/or SSIS experience for ETL pipeline work.

Responsibilities

• Monitor, diagnose, and resolve performance bottlenecks across SQL Server and Azure SQL Database and Managed Instance environments.
• Optimize queries, indexing strategies, execution plans, stored procedures, and database configurations.
• Design, build, and maintain ETL pipelines using Azure Data Factory and SSIS.
• Assess an existing environment and implement proper structure, security, and best practices where they are lacking.
• Manage backup and recovery strategies, geo-replication, failover groups, and high availability configurations.
• Implement and enforce schema-level security, data masking, encryption, and access controls.
• Collaborate with security teams to ensure database security standards are applied correctly.
• Conduct regular performance reporting, capacity planning, and data lifecycle management.

Skills

Azure SQL

SQL Server DBA

T-SQL

Azure Data Factory

SSIS

Performance tuning

Security & encryption

Backup & recovery

Capacity planning

Tools

SSIS

Azure Data Factory

Job description

ConsultNet Technology Services and Solutions in White Plains is seeking a Senior SQL Server DBA to own performance, integrity, and scalability across on-premises SQL Server and Azure SQL. You will assess an existing environment and optimize it, rather than merely maintaining what exists.

You will monitor bottlenecks, tune queries, design ETL pipelines with Azure Data Factory and SSIS, implement security controls, and manage backups, geo-replication, and high availability.