MS SQL server DBA

Derex Technologies Inc•Jersey City, NJ

7h•Onsite

About The Position

The MS SQL Server DBA will administer, engineer, support, and troubleshoot Microsoft SQL Server environments across production and non-production systems. The role includes building and configuring new environments and maintaining business-critical databases, as well as supporting SQL Server running on Windows Server across internal networks. The DBA will manage database performance, security, maintenance, backups, and recovery. The role also involves designing and supporting high-availability and disaster-recovery solutions, including Always On Availability Groups and Windows Server Failover Clustering; conducting recovery and failover exercises; and maintaining procedures and runbooks. The DBA will automate and maintain database and application operations with PowerShell, T-SQL, and batch scripts, support application releases, document database configurations and procedures, and collaborate with application, development, testing, network, and infrastructure teams. This position is five days onsite in New York City. Candidates must be local to New Jersey or New York City. Interviews are in person.

Requirements

8+ years of experience.
Strong Microsoft SQL Server administration and engineering experience.
Strong experience with stored procedures, views, triggers, and query troubleshooting.
Experience with performance tuning, indexing, and execution-plan analysis.
Experience managing SQL Server security, logins, roles, permissions, and database access.
Experience supporting SSIS and ETL processes.
Experience supporting SQL Server on Windows Server and familiarity with Windows/Active Directory authentication, service accounts, ports, and firewall rules.
Experience with SQL Server backups, recovery strategies, and high-availability and disaster-recovery solutions, including Always On Availability Groups and Windows Server Failover Clustering.
Experience with PowerShell, T-SQL, and batch scripting.
Must be local to New Jersey or New York City and available to work onsite five days a week.
Must be available for an in-person interview.

Responsibilities

Install, configure, maintain, patch, and upgrade SQL Server environments across production and non-production systems.
Build and configure SQL Server environments and provide ongoing administration and support for existing business-critical databases.
Troubleshoot stored procedures, views, triggers, and queries; perform performance tuning, indexing, and execution-plan analysis.
Manage SQL Server security, including logins, roles, permissions, and database access.
Develop, support, and troubleshoot SSIS and ETL processes, including failed jobs, connectivity problems, data-processing issues, and performance problems.
Maintain databases through monitoring, health checks, index and statistics maintenance, integrity checks, SQL Server Agent job support, and capacity and storage management.
Troubleshoot and resolve database incidents, outages, blocking, deadlocks, failed jobs, and performance issues, including root-cause analysis.
Support SQL Server on Windows Server across internal networks, including service accounts, Windows/Active Directory authentication, ports, and firewall rules.
Work with network and infrastructure teams to resolve firewall and connectivity issues between users, application servers, and database servers.
Develop and maintain backup and recovery strategies using full, differential, and transaction log backups.
Design, implement, administer, support, and troubleshoot SQL Server high-availability and disaster-recovery solutions.
Implement and support SQL Server Always On Availability Groups and Windows Server Failover Clustering.
Support multi-node and multi-datacenter Availability Group architectures, including synchronous and asynchronous commit modes.
Support WSFC quorum configurations, including File Share Witness and Cloud Witness.
Support and troubleshoot log shipping and other applicable SQL Server disaster-recovery technologies.
Conduct periodic disaster-recovery exercises, failover testing, and failback testing to validate recoverability and operational readiness.
Develop, test, maintain, and improve HA/DR procedures and disaster-recovery runbooks.
Understand business Recovery Point Objective and Recovery Time Objective requirements and ensure database recovery strategies support them.
Use PowerShell, T-SQL, and batch scripting to automate and maintain databases and applications on servers, including maintenance, deployments, monitoring, and alerts.
Support application releases, including database changes, deployment, and post-release checks.
Document database designs, configurations, support procedures, and runbooks.
Work with application, development, and testing teams on defect triage and fixes.