Role Summary
The Dev/Ops Engineer (Internal Systems & Automation) is responsible for developing, integrating,
and supporting internal systems across the organization. This unique role bridges development and
operations, with ownership over APIs, SQL environments, data pipelines, and custom application
support. The primary objectives are to ensure data reliability, streamline automation, and facilitate
seamless system interoperability.
Core Responsibilities
1. API & Integration Engineering
2. Design, build, manage, and optimize REST and SOAP API integrations.
3. Maintain robust authentication, error handling, and monitoring across all integrations.
4. Document integration workflows and enforce best-practice security standards.
5. SQL Development & Database Engineering
6. Design and maintain SQL tables, views, stored procedures, and database schemas.
7. Optimize query performance and troubleshoot data integrity issues.
8. Support analytics, business intelligence, and dashboard reporting needs.
9. ETL & Data Pipeline Management
10. Build and maintain data pipelines using Azure Data Factory, Azure Pipelines, and related
Azure services.
11. Implement ETL/ELT workflows for both internal and external systems.
12. Monitor pipeline performance, handle failures, manage alerts, and optimize throughput.
13. Ensure data quality, transformation accuracy, and consistent delivery across environments.
14. Application Support & Custom Development
15. Troubleshoot and support existing code and integrations, including JavaScript and PHP.
16. Assist with the maintenance of custom applications and internal automation workflows.
17. Perform root-cause analysis across APIs, middleware, pipelines, and databases.
18. Dev/Ops & Automation
19. Identify manual processes and automate them using scripts, APIs, and Azure services.
20. Maintain CI/CD processes for integrations and scripts via Azure Pipelines.
21. Implement logging, monitoring, alerting, and operational runbooks to ensure reliability.
22. Documentation & Cross-Team Collaboration
23. Maintain comprehensive technical documentation, diagrams, and operational procedures.
24. Collaborate with IT, Operations, and Leadership teams to define requirements and deliver
solutions.Required Skills & Experience
1. Programming & Integration
2. Functional proficiency in JavaScript and PHP.
3. Strong understanding of REST and SOAP API design, authentication protocols, and
JSON/XML formats.
4. SQL & Data Engineering
5. Expertise in SQL development, database schema design, indexing, and performance
tuning.
6. Experience with SQL Server, MySQL, or PostgreSQL platforms.
7. Azure Data & Automation
8. Required experience with Azure Data Factory (ADF), ETL/ELT pipeline development, Azure
Pipelines, and Azure DevOps concepts.
9. Skill in monitoring pipelines, debugging failures, and optimizing performance.
10. Systems & Troubleshooting
11. Ability to perform root-cause analysis across APIs, pipelines, data models, and codebases.
12. Thorough understanding of integration architecture and operational reliability.
Preferred Experience
• Experience with Git or other version control systems.
• Familiarity with Azure Functions or Logic Apps.
• Experience supporting business intelligence and reporting teams.
• Understanding of cloud infrastructure concepts, particularly Azure networking and security.
