Sr. SQL Server Administrator

Robotic Technologies Automation; New York (NY); On-site; USD 96,000 - 152,000; Full time

Job summary

Robotic Technologies Automation in Lower Manhattan, NY is seeking a Senior SQL Server Administrator to lead SQL Server administration, production support, and HA/DR initiatives. The role requires hands-on expertise in SQL Server, performance tuning, and automation, with exposure to AOAG and ETL processes.

The contract spans 12 months with possible extension. On-site in Lower Manhattan, NY, the position offers a challenging environment and opportunities to optimize mission-critical databases.

Qualifications

• Strong hands-on experience with SQL Server administration and HA/DR.
• Experience with performance tuning and index optimization.
• Proficient in PowerShell, T-SQL and batch scripting.
• Experience with SSIS and ETL jobs.

Responsibilities

• Manage SQL Server instances, production support, and incident response.
• Implement HA/DR solutions and backups.
• Tune performance, indexes, and query plans.
• Automate tasks using PowerShell.

Skills

SQL Server administration

Production support

Performance tuning

High Availability/Disaster Recovery

Batch scripting

Documentation

Tools

SQL Server

SSIS

SQL Server Agent

PowerShell

T-SQL

AOAG

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: Sr. SQL Server Administrator
Location: Lower Manhattan, NY
Duration: 12 Months + Extension
Bill Rate: $86/hour
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Work Authorization: US-Citizen, H-1B, OPT-EAD, GC-EAD

Job Description

• We are looking for an experienced Senior SQL Server Administrator with strong hands-on expertise in SQL Server administration, production support, performance tuning, and High Availability/Disaster Recovery (HA/DR) solutions.

Key Required Skills:

• SQL Server Installation, Configuration, Patching & Upgrades.
• Stored Procedures, Views, Triggers & Query Troubleshooting.
• Performance Tuning, Indexing & Execution Plan Analysis.
• SSIS, ETL Support & SQL Server Agent Jobs.
• Backup & Recovery Strategies (Full, Differential & Transaction Log).
• SQL Server Always On Availability Groups (AOAG).
• High Availability & Disaster Recovery (HA/DR).
• PowerShell, T-SQL & Batch Scripting.

Highly Preferred Skills:

• Direct INGRES to SQL Server Migration experience.
• Knowledge of Ingres SQL, database objects and data types.
• Utilities / T&D (Transmission & Distribution) Domain Experience
• Legacy Database Modernization.
• Database Design, Data Modeling & Source Control.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.