Sr. Database Engineer - Operations (Colombia)

Overview We are looking for someone who can support our current SSIS-based environment while also helping modernize our data integration approach over time. This role offers the opportunity to contribute to the evolution of our data stack, including future‑state work related to Azure Data Factory and broader ETL modernization efforts. The Database Engineer – Operations will support existing SSIS pipelines and play a key role in the team’s longer‑term modernization efforts toward Azure Data Factory and related ETL tools. Responsibilities
- Operational Support for Data Feeds – Own day‑to‑day operations of SSIS‑based ETL feeds, resolve tickets for jobs and data anomalies, and maintain alerting strategies aligned with architectural standards.
- Data Investigation and Operational Data Updates – Analyze database structures and business rules, then design and execute targeted SQL scripts for accurate, auditable data updates.
- Database Administration & Environment Management – Manage backups, restores, and environment refreshes; perform index/statistics maintenance; and contribute to capacity and scalability planning.
- Performance Tuning & Query Optimization – Review and tune T‑SQL queries, stored procedures, and views; analyze execution plans; and provide guidance on indexing and SQL best practices.
- Data Engineering & Integration – Develop and support ETL processes using SSIS and/or Azure Data Factory, ensuring data quality through validation, reconciliation, and error handling.
- Monitoring, Documentation, and Continuous Improvement – Implement monitoring/alerting for SQL Server and SSIS jobs, maintain runbooks, and propose tooling and process improvements.
- Collaboration and Support – Serve as SME for assigned clients/projects, partner across engineering and DevOps teams, and participate in on‑call rotation as needed. Qualifications – Technical Skills
- Excellent understanding of T‑SQL, including complex queries, stored procedures, functions, and views.
- 5+ years working with Microsoft SQL Server 2016 or above in a production environment.
- Hands‑on operational support for SQL Server, covering backups/restores and environment refreshes, index and statistics maintenance, disk configuration, and query/workload performance tuning.
- Strong experience with ETL tools, particularly SSIS, building and maintaining production pipelines and job feeds.
- Proven ability to analyze existing schemas and stored procedures and design targeted SQL scripts for safe, auditable operational data updates and exception handling.
- Familiarity with Git‑based source control and CI/CD tooling for database and ETL deployments.
- Experience with VB Script, C#, .NET, Azure Data Factory and Azure Cloud is a plus but not required. Qualifications – Soft Skills
- Advanced problem‑solving and communication skills, able to explain technical issues clearly to both technical and non‑technical stakeholders.
- Strong team player who collaborates effectively across engineering, operations, and business teams.
- Good time‑management skills, with the ability to balance reactive ticket work with proactive improvement initiatives.
- Great interpersonal skills and a service‑oriented mindset when working with internal and client stakeholders.
- Sense of ownership and pride in system reliability and the impact of your work on client and company success.
- Critical thinking and problem‑solving skills, especially under time pressure when resolving production issues. Education & Certifications
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent experience.
- MCSA, MCSE, or MCDBA certifications are a plus. About the Company Ansira is the leading marketing platform for brands that operate in distributed ecosystems. By orchestrating the entire brand‑to‑local value chain, Ansira synchronizes general companies’ internal and external teams across channels, markets and regions. Ansira leverages AI‑powered technology, vertical expertise, local insights and strategic partnerships to optimize marketing performance and empower partner growth at scale. #J-18808-Ljbffr Postúlate en Kit Empleo: kitempleo.com.co/empleo/1b587p