Apply Now

SQL Database Consultant

Brooklyn, NY, US • Posted 2 hours ago • Updated Just Now

Full Time

Part Time

On-site

Fitment

Dice Job Match Score™

🛠️ Calibrating flux capacitors...

Job Details

Skills

Windows Imaging Component
GP
Database Migration
Data Integrity
Backup Administration
Database Performance Tuning
Query Optimization
Management
Microsoft SQL Server
High Availability
Clustering
Microsoft SSRS
Data Analysis
Data Warehouse
Snow Flake Schema
Performance Monitoring
Red Gate
Microsoft SSIS
SQL
Job Scheduling
Servers
Database
Migration
Communication
Reporting
Collaboration
Microsoft Dynamics AX
Data Visualization
Tableau
Microsoft Power BI
Performance Tuning
Storage
Optimization
Public Sector

Summary

Job Title: SQL Database Consultant

Location: Brooklyn, NY (Hybrid 3 days onsite, 2 days remote)

Job Summary

STAFFXPERT LLC is seeking a SQL Database Consultant on behalf of our client in Brooklyn, NY. This role focuses on leading database migration, modernization, and performance optimization efforts within SQL Server environments. The ideal candidate will have strong experience in large-scale database migrations, high availability configurations, and post-migration support in enterprise settings.

Key Responsibilities

Lead migration of databases from SQL Server 2016/2019 to SQL Server 2022
Configure databases to ensure data integrity during migration (e.g., read-only setup, backups, and restoration)
Manage and configure user accounts, permissions, SQL jobs, SSIS packages, and linked servers
Migrate and validate SSRS reports and subscriptions in the upgraded environment
Collaborate with stakeholders to update data sources, jobs, and application compatibility
Implement and support Always On High Availability and clustering solutions
Perform database performance tuning, including indexing and query optimization
Provide post-migration (Hypercare) support and resolve user issues
Monitor database systems and ensure optimal performance and reliability
Track project progress, provide status updates, and manage scope changes

Required Qualifications

4+ years of experience with SQL Server database migration and administration
4+ years of experience with Always On High Availability and clustering
4+ years of experience with SSRS or similar reporting tools (e.g., Power BI)
4+ years of experience in data analysis and data warehousing concepts (star/snowflake schemas)
2+ years of experience with database performance monitoring tools (e.g., Redgate)
Strong experience with SSIS, SQL job scheduling, and linked servers
Proven ability to support enterprise-level database environments and migrations
Strong communication skills with experience in project reporting and stakeholder coordination

Preferred Qualifications

Experience with data visualization tools such as Tableau or Power BI
Knowledge of SAN performance tuning and storage optimization
Experience working in large-scale or public sector environments

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 91172109
Position Id: 2026-1805
Posted 2 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

SQL Database Consultant

Brooklyn, New York

•

Today

Trigyn's direct government client has an immediate long-term need for SQL Database Consultant in Brooklyn, NY. Tasks & Duties: ? Configure existing databases on SQL Server 2016/2019 to read-only mode to ensure data integrity during transition. ? Perform full database backups on SQL Server 2016/2019. ? Restore databases to the new SQL Server 2022 environment. ? Bring SQL Server 2022 databases online and decommission legacy instances by setting prior versions offline. ? Establish user accounts, p

Third Party, Contract

DOE

Database Cloud Engineer

New York, New York

•

17d ago

Title: Database Cloud Engineer (Database Migration to AWS) 7340 Location: New York City (100% Onsite) -Candidates local Rate: $70.00 $83.00/hr (W2 Only) Duration: 6 12+ Month Contract No Corp-to-Corp or 3rd Party Agencies We are seeking a Database Cloud Engineer with strong experience in database migration from on-prem environments to AWS. This role will focus on designing, deploying, and optimizing cloud-based database solutions while ensuring performance, scalability, and security. You will wo

Easy Apply

Contract

$70 - $83

Senior Database Administrator II

Remote or New York, New York

•

Today

Senior Database Administrator II Employment Type: Full-Time, Mid Level Department: Information Technology Contact Government Services is seeking a Senior Database Administrator to assist with administering all aspects of Microsoft SQL Server. CGS brings motivated, highly skilled, and creative people together to solve the government's most dynamic problems with cutting-edge technology. To carry out our mission, we are seeking candidates who are excited to contribute to government innovation, ap

Full-time

USD 114,816.00 - 165,845.33 per year

Database Engineer

New York, New York

•

Today

Company Description Job Description ABOUT OATH: The City of New York's Office of Administrative Trials and Hearings (OATH) is the nation's largest administrative tribunal, holding more than 250,000 trials and hearings a year. As the City's central, independent administrative law court, OATH adjudicates a wide range of matters filed by nearly every city agency, board and commission. OATH also houses the Center for Creative Conflict Resolution which provides mediation and restorative justice sup

Full-time

USD 250,000.00 per year

Search all similar jobs