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.