Dev Ops Engineer

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.