Agile Programming Methodologies, Application Programming Interface (API), Architectural Services, Auditing, Authentication, Best Practices, Caching, Communication Skills, Continuous Deployment/Delivery, Continuous Integration, Data Quality, Data Recovery, Database Extract Transform and Load (ETL), Database Optimization, Database Technology, Error Handling, Integration Testing, Metrics, Microservices, Microsoft .NET, Microsoft ASP.NET (Active Server Page), Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), OAuth, Operations Management, Pagination, Performance Tuning/Optimization, Problem Solving Skills, Production Support, Quality Assurance, REST (Representational State Transfer), Reporting Dashboards, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Scrum Project Management and Software Development, Static Analysis, Stored Procedures, Test Automation, Unit Test, User Interface Design, User Interface/Experience (UI/UX)
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 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.