MS SQL Server SSIS with Net
Job Description
Must 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 databasesschemas, 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 practicesSOLID, 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-endquery 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 operationsSQL Server Agent tasks, maintenance plans, backups/restores, environment migrations (DEV/QA/PROD).
Collaborate in Agile/Scrumparticipate in ceremonies, refine requirements, estimate work, and maintain delivery commitments.
Document solutions thoroughlyER diagrams, API specs, SSIS runbooks, deployment guides, and operational playbooks.
Ensure security-by-designOWASP practices, parameterized queries, secret management, API versioning, and least-privilege access.
Provide production supporttriage issues, implement fixes, prevent regressions, and communicate clearly with stakeholders.
Must 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 databasesschemas, 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 practicesSOLID, 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-endquery 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 operationsSQL Server Agent tasks, maintenance plans, backups/restores, environment migrations (DEV/QA/PROD).
Collaborate in Agile/Scrumparticipate in ceremonies, refine requirements, estimate work, and maintain delivery commitments.
Document solutions thoroughlyER diagrams, API specs, SSIS runbooks, deployment guides, and operational playbooks.
Ensure security-by-designOWASP practices, parameterized queries, secret management, API versioning, and least-privilege access.
Provide production supporttriage issues, implement fixes, prevent regressions, and communicate clearly with stakeholders.
Easy Apply