C2C Requirement for SQL Database Engineer – NJ – Day 1 Onsite

US staffing Inc; New Jersey; On-site; USD 120,000 - 170,000; Full time

Job summary

US staffing Inc. is seeking a SQL Database Engineer in New Jersey for an onsite, day-one role. The candidate will lead migrating over 20,000 MSSQL stored procedures to AWS RDS PostgreSQL and ensure seamless integration with .NET Core microservices.

The ideal candidate possesses 10+ years of experience, deep MSSQL and PostgreSQL expertise, and hands-on experience with AWS data services and migration tools. This position requires onsite work in NJ with close collaboration across DevOps and

Qualifications

• 10+ years of database engineering experience with MSSQL and PostgreSQL.
• Experience migrating 20K+ stored procedures to PostgreSQL on AWS.
• Strong knowledge of T-SQL to PL/pgSQL translation.

Responsibilities

• Analyze existing MSSQL structures (20K+ procedures, triggers, functions).
• Design migration frameworks using SCT and DMS.
• Translate T-SQL scripts to PL/pgSQL with data type conversions and set-based logic.
• Optimize SQL logic and remove obsolete procedures during migration.
• Coordinate with app/microservices teams to preserve business logic and API compatibility.
• Conduct data validation, performance tuning, and benchmarking for the new environment.
• Develop monitoring scripts and dashboards for migration progress and health checks.
• Collaborate with DevOps for AWS RDS configuration, backup, and scaling.

Skills

MSSQL to PostgreSQL Migration

AWS RDS PostgreSQL

PL/pgSQL

SQL performance tuning

Data migration tools

Tools

AWS SCT

AWS DMS

pgLoader

Terraform

Job description

Role :SQL Database Engineer

Location:NJ– Day 1 Onsite – Local or nearby

Exp: 10Years

Skills:MSSQL to PostgreSQL Migration (AWS RDS)

Job Description

Experience: 10+ years Overview We are looking for a highly skilled Data Engineer with strong expertise in MSSQL and PostgreSQL to lead the migration of over 20,000 stored procedures from legacy MSSQL databases to AWS RDS (PostgreSQL). The ideal candidate will have in-depth experience in analyzing complex stored procedures, optimizing SQL logic, and ensuring seamless integration with .NET Core–based microservices that rely on these data operations. This role requires strong hands-on experience with AWS data services, database migration tools, and the ability to ensure data compatibility for microservices deployed on AWS.

Key Responsibilities

• Analyze and understand the existing MSSQL database structure, including 20K+ stored procedures, triggers, and functions.
• Design and implement migration frameworks using AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS).
• Translate T‑SQL scripts to PL/pgSQL, handling data type conversions, control flows, cursors, temporary tables, and set-based logic.
• Identify redundant or obsolete procedures and optimize SQL logic during the migration.
• Work closely with application and microservices teams to ensure the translated procedures maintain business logic integrity and API compatibility.
• Perform data validation, performance tuning, and benchmarking to ensure the new PostgreSQL environment meets or exceeds legacy performance.
• Develop monitoring scripts and dashboards for migration progress, data validation, and post‑migration health checks.
• Collaborate with DevOps for AWS RDS configuration, backup, and scaling best practices.
• Contribute to infrastructure automation (Terraform / CloudFormation) for data environments on AWS.

Technical Skills Required

• Database Platforms: o Strong expertise in MSSQL – complex stored procedures, views, triggers, functions, and query optimization. o Advanced proficiency in PostgreSQL, with experience in PL/pgSQL, indexing, partitioning, and performance tuning. o Hands‑on experience with AWS RDS for PostgreSQL (provisioning, scaling, security, and maintenance).
• AWS Expertise: o Proficiency in AWS RDS, S3, Lambda, Glue, DMS, SCT, and CloudWatch. o Strong understanding of AWS networking, IAM, and data security best practices.
• Migration Tools: AWS Schema Conversion Tool (SCT), AWS Database Migration Service (DMS), pgLoader, or similar.
• Scripting & Automation: Python, Shell, or PowerShell for migration automation and data validation.
• Cloud & DevOps: Familiarity with AWS services (EC2, S3, CloudWatch, Lambda) for data pipelines and automation.
• Version Control: Git / Bitbucket for maintaining SQL scripts and migration versions.
• Monitoring & Validation: Strong SQL profiling, logging, and audit trail design.

Preferred

• AWS Certified Data Engineer / Database Specialty.
• Experience working withmicroservices-based systems and aligning data with APIs
• Familiarity with data modelling, normalization, and schema optimization for performance and scalability.
• Exposure to ETL pipelines and data transformation workflows.
• Exposure to containerized or serverless data workflows (ECS, Lambda).
• Understanding of .NET Core applications’ data access patterns (EF Core, Dapper, etc.) for alignment with backend teams.
• Knowledge of Agile methodologies and CI/CD integration for database deployments.

Soft Skills

• Strong analytical ability to refactor complex SQL logic and ensure business logic parity post‑migration.
• High attention to detail with data integrity and performance focus.
• Proactive approach toward identifying performance issues and improving query efficiency
• Excellent documentation and collaboration skills to work across application, DevOps, and data teams