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.

Essential Duties and Responsibilities

Operational Support for Data Feeds
- 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.

Data Investigation and Operational Data Updates
- Analyze existing database structures (tables, views, stored procedures) and associated business rules to understand how data flows through transactional and reporting processes.




- Design and execute targeted SQL scripts to implement business rule-driven updates when needed.
- Ensure all operational data updates are accurate, auditable, and aligned with business rules, coordinating with business and engineering stakeholders as necessary.
- Document patterns and repeatable approaches for common operational scenarios, and where possible, feed these back into process or system improvements (including opportunities for additional UI or automation where appropriate).

Database Administration & Environment Management
- Configure and manage backups and restores, including regular environment refreshes from in coordination with engineering and QA teams.
- Perform index and statistics maintenance to address fragmentation and support consistent query performance.
- Monitor and maintain database health, including capacity management, log growth, etc.
- Contribute to capacity and scalability planning for expanding data volumes and new client workloads.

Performance

📌 Sr. Database Engineer (Medellín)
🏢 SproutLoud Latam
📍 Medellín