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. This role will support existing SSIS pipelines while also playing a key role in the team’s longer-term modernization efforts. We are looking for someone who is excited by the opportunity to help shape future-state ETL architecture, including the transition toward Azure Data Factory and more modern data integration capabilities. Support and enhance current SSIS workflows while contributing to ongoing modernization efforts toward Azure Data Factory and related ETL tools.
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 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.
Background / Experience
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.
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.
This role is part of the Inclusive Talent Program and is open to all candidates. ANSIRA encourages applications from persons with disabilities. Reasonable accommodations are available throughout the recruitment process. ANSIRA is an equal opportunity employer. We are committed to inclusive hiring and providing reasonable accommodations throughout the recruitment process. All applicants will be considered based on qualifications, regardless of disability status.
