Job Description
Overview
The Database Engineer – Operations is responsible for the reliable operation of client data feeds and the overall health of our SQL Server environments, with a strong emphasis on SSIS workflows and T-SQL.
Responsibilities
- Own day-to-day operations of job feeds and ETL processes, with a strong focus on SSIS.
- Triage and resolve operational tickets related to jobs, data anomalies, and performance enhancements in a timely and structured manner.
- Develop and maintain notification/alerting strategies within SSIS and related workflows to detect and surface failures or performance degradation.
- Collaborate with project teams to ensure new or updated feeds adhere to defined architectural and operational standards.
- Operational Data Updates
- Analyze existing database structures (tables, views, stored procedures) and associated business rules to understand how data flows through trans...