Senior SQL Database & Data Warehouse Architect

Nanosoft Consulting Talent Page; Hamilton Township (NJ); Hybrid; USD 100,000 - 130,000; Full time

Job summary

A leading consulting firm based in Hamilton Township, NJ, is seeking an experienced Database Manager to lead the architecture, design, and maintenance of relational/SQL databases. The ideal candidate will have over 7 years of experience in database management, including SQL Server and BI Stack. This hybrid role requires strong collaborative skills and the ability to effectively manage complex data systems. Candidates should have a Bachelor's degree in Computer Science or a related field. Opportunities to work with AWS and modern technologies are advantageous.

Qualifications

• 7+ years of database design, SQL/TSQL development experience.
• 1-2+ years experience on AWS RDS.
• Strong expertise in SQL Server and relational database architecture.

Responsibilities

• Design and maintain relational/SQL databases and data warehouse solutions.
• Implement OLTP schemas and testing plans to validate data integration.
• Work collaboratively with developers and project managers.

Skills

Database modeling

SQL Server scripting

SQL development (SSMS)

Microsoft BI Stack (SSIS, SSAS)

Report development using SSRS

Developing Restful APIs

Analyzing hierarchical data

Education

Bachelors degree in Computer Science or a related field

Tools

AWS RDS

GitHub

JIRA

.Net Core

Docker/Kubernetes

Job description

A leading consulting firm based in Hamilton Township, NJ, is seeking an experienced Database Manager to lead the architecture, design, and maintenance of relational/SQL databases. The ideal candidate will have over 7 years of experience in database management, including SQL Server and BI Stack. This hybrid role requires strong collaborative skills and the ability to effectively manage complex data systems. Candidates should have a Bachelor's degree in Computer Science or a related field. Opportunities to work with AWS and modern technologies are advantageous.