MS SQL Server SSIS

Addison, TX - USA

Monthly Salary: Not Disclosed

Posted on: 3 hours ago

Vacancies: 1 Vacancy

Job Summary

Job :MS SQL Server SSIS
Location:Addison TX

Job Description

Must Have Technical/Functional Skills

Primary Skill: MS SQL Server SSIS / / 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 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 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.

Job :MS SQL Server SSIS Location:Addison TX Job Description Must Have Technical/Functional Skills Primary Skill: MS SQL Server SSIS / / Core C# / Web API Angular 18/19 Experience: Minimum 10 years Roles & Responsibilities Design and optimize SQL Server databases-schemas indexes views st...