Senior SQL Performance Engineer (Florham Park, NJ)

The Matlen Silver Group, Inc.; Florham Park (NJ); On-site; USD 110,000 - 160,000; Full time

Job summary

The Matlen Silver Group, Inc. is seeking a seasoned SQL Database Engineer in New Jersey to design, optimize complex SQL databases, stored procedures, views, and data structures, ensuring reliability and performance. Deep knowledge of SQL Server and data modeling is required.

You will lead data migration projects, enforce security, backup and disaster recovery, and maintain high availability across production systems and ERP integrations, while collaborating with analytics teams.

Qualifications

• Experience designing and maintaining complex SQL databases.
• Proficiency in SSIS/ETL and data integration.
• Strong focus on data governance, security, and high availability.

Responsibilities

• Design and develop complex SQL queries, stored procedures, views, and functions.
• Optimize SQL Server performance through query tuning, indexing, partitioning, and monitoring.
• Manage and support production SQL databases, ensuring high availability, reliability, and data integrity.
• Design and maintain scalable database schemas and data structures.
• Develop, support, and troubleshoot SSIS/ETL solutions for data migration, transformation, and integration.
• Implement database security, backup, recovery, replication, and disaster recovery strategies.
• Lead data migration and integration initiatives across multiple systems and platforms.
• Ensure data governance, quality, compliance, and reporting accuracy.
• Provide technical leadership and support for database management, reporting, and ERP integrations.

Skills

SQL

Stored procedures

Views

Functions

Query tuning

Indexing

Partitioning

Monitoring

SSIS

ETL

Data migration

Data integration

Database security

Backup

Recovery

Replication

Disaster recovery

Data governance

Reporting

ERP integrations

Database design

High availability

Data integrity

Technical leadership

Job description

Location New Jersey, United States Sector HR & Personnel

Key Responsibilities:

• Design and develop complex SQL queries, stored procedures, views, and functions.
• Optimize SQL Server performance through query tuning, indexing, partitioning, and monitoring.
• Manage and support production SQL databases, ensuring high availability, reliability, and data integrity.
• Design and maintain scalable database schemas and data structures.
• Develop, support, and troubleshoot SSIS/ETL solutions for data migration, transformation, and integration.
• Implement database security, backup, recovery, replication, and disaster recovery strategies.
• Lead data migration and integration initiatives across multiple systems and platforms.
• Ensure data governance, quality, compliance, and reporting accuracy.
• Provide technical leadership and support for database management, reporting, and ERP integrations.