Sr. SQL Server Administrator

MACHINE LEARNING TECHNOLOGIES LLC; New York (NY); On-site; USD 98,000 - 139,000; Full time

Job summary

MACHINE LEARNING TECHNOLOGIES LLC in New York, NY is seeking a Sr. SQL Server Administrator for a 12-month engagement in Lower Manhattan. The role focuses on SQL Server installation, configuration, patching and upgrades, along with high-availability strategies and disaster recovery planning.

You will manage backups, performance tuning, AOAG, WSFC, and complex query troubleshooting. Expertise in PowerShell, T-SQL and ETL support with SSIS will be highly regarded for reliable data operations in a

Qualifications

• Strong Microsoft SQL Server administration and engineering expertise.
• Experience with installation, configuration, patching and upgrades.
• Proficient in stored procedures, views, triggers, and query troubleshooting.
• Skilled in performance tuning, indexing, and execution plan analysis.
• Experience with SSIS, ETL support, and SQL Server Agent jobs.
• Backup and recovery planning for full, differential, and log backups.
• Knowledge of SQL Server Always On Availability Groups (AOAG) and WSFC.
• PowerShell, T-SQL and batch scripting for automation.
• Understanding of HA/DR and disaster recovery strategies.
• Security: logins, roles and permissions management.

Skills

SQL Server Admin

Installation & Upgrades

Query Troubleshooting

Performance Tuning

AOAG

WSFC

Backup & Recovery

PowerShell

T-SQL scripting

Security & Permissions

Tools

SQL Server

SSIS

Windows Server

PowerShell

Job description

Job ID: J55072

Job Title: Sr. SQL Server Administrator

Location: Lower Manhattan, NY

Duration: 12 Months + Extension

Domain Exposure: Pharmaceuticals

Client: To Be Discussed Later

Employment Type: W-2, 1099, C2C

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

Bill Rate: $86/hour

Key Required Skills

• Strong Microsoft SQL Server Administration & Engineering.
• 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).
• Windows Server Failover Clustering (WSFC).
• High Availability & Disaster Recovery (HA/DR).
• PowerShell, T-SQL & Batch Scripting.
• Blocking, Deadlocks, Troubleshooting & Root Cause Analysis.
• SQL Server Security, Logins, Roles & Permissions.

Highly Preferred Skills

• Direct INGRES to SQL Server Migration experience.
• Knowledge of Ingres SQL, database objects and data types.
• Schema/Object Migration & Database Dependency Analysis.
• Data Migration, Reconciliation & Post-Migration Validation.
• Utilities / T&D (Transmission & Distribution) Domain Experience
• Legacy Database Modernization.
• Database Design, Data Modeling & Source Control.
• Migration Testing, Cutover & Production Stabilization

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.