Skip to main content

About the role

MS SQL Server SSIS with. Net Developer
Location: Charlotte, NC
Employment Type: Full-TimeMust Have Technical/Functional Skills
Primary Skill: MS SQL Server, SSIS / ETL,.NET / ASP.NET Core, C# / Web API, Angular 18/19
Experience: Minimum 10 years
Roles & Responsibilities:
  • Design and optimize SQL Server databases—schemas, indexes, views, stored procedures, and performant T SQL.
  • Develop and maintain SSIS ETL pipelines for data ingestion, transformation, validation, scheduling, and error handling.
  • Implement secure, scalable REST APIs with ASP.NET Core, including authentication/authorization (JWT/OAuth) and input validation.
  • Build modern Angular (18/19) UIs using standalone components, reactive forms, interceptors, guards, and RxJS/Signals for state.
  • Integrate Angular front-end with. NET back-end, ensuring secure token handling, robust error management, and efficient data flows.
  • Apply architectural best practices—SOLID, clean architecture, layered/microservices patterns, and reusable UI/component design.
  • Ensure data integrity and governance with auditing, logging, role-based access, and compliance for sensitive data (PII).
  • Optimize performance end-to-end—query tuning, ETL throughput, API latency, caching, pagination, and UI rendering.
  • Automate builds, tests, and deployments (CI/CD) using pipelines, unit/integration testing (xUnit/Jest/Cypress), and static analysis.
  • Monitor and observe systems with logging, tracing, metrics, dashboards, alerts, and RCA for incidents across SQL/ETL/API/UI.
  • Manage jobs and operations—SQL Server Agent tasks, maintenance plans, backups/restores, environment migrations (DEV/QA/PROD).
  • Collaborate in Agile/Scrum—participate in ceremonies, refine requirements, estimate work, and maintain delivery commitments.
  • Document solutions thoroughly—ER diagrams, API specs, SSIS runbooks, deployment guides, and operational playbooks.
  • Ensure security-by-design—OWASP practices, parameterized queries, secret management, API versioning, and least-privilege access.
  • Provide production support—triage issues, implement fixes, prevent regressions, and communicate clearly with stakeholders.

Matching similar jobs

JOB OVERVIEW

Experience level

Lead

Location

Charlotte, NC

Occupation

Software Developers

Industry

Computer Systems Design Services

Posted

10 days ago

Tired of running searches?

Rank the roles you'd take once, and matches like these arrive on their own.

CREATE PROFILE (opens in a new tab)