Applications & Database Developer

Project: Application & Database Development

Job Title: Application Analyst / Engineer

Job Summary

The Application & Database Developer is responsible for designing, developing, and maintaining software applications and database systems that support business operations. This role involves full-stack development, database design, performance tuning, and close collaboration with cross-functional teams to ensure high-quality, scalable, and secure solutions.

Key Responsibilities

·        Application Development

o    Develop and maintain custom web, desktop, or mobile applications for manufacturing operations (e.g., MES, SPC, Equipment Tracking, Quality Management).

o    Integrate applications with factory systems such as ERP, MES, PLCs, and data historians.

o    Design APIs and interfaces for seamless data exchange between IT and OT systems.

o    Support the automation of manufacturing workflows, reporting, and analytics dashboards.

o   Generative AI for code development

·        Database Development

o    Design, build, and optimize relational databases (Oracle, PostgreSQL, SQL Server, etc.).

o    Develop complex SQL queries, stored procedures, triggers, and ETL scripts.

o    Manage database performance tuning, backup/recovery, and data integrity.

o    Collaborate with data engineers to structure data for analytics and reporting.

·        Operations & Support

o    Work closely with manufacturing engineers, process owners, and IT infrastructure teams to gather requirements and deliver scalable solutions.

o    Provide technical support for deployed applications and databases, including troubleshooting and enhancements.

o    Ensure compliance with cybersecurity, audit, and change management standards.

·        Continuous Improvement

o    Contribute to digital transformation projects such as predictive maintenance, AI/ML model integration, Agentic AI and BigData.

o    Identify automation opportunities and propose system improvements.

o    Document system architecture, workflows, and procedures.

Required Skills & Qualifications

·        Must Have

o   Bachelor's degree in computer science, IT, or related field

o  3–5 years of relevant experience in application support

o   Strong understanding of application architecture and databases

o   Proficiency in

§ Languages: Java, Python, C#, Node.js

§  Web Frameworks: .NET, Flask, JavaScript

§ Databases: Oracle, PostgreSQL, ETL, Stored Procedures, SQL Server

§  Integration: REST APIs, Kafka, MQTT

o   Excellent problem-solving and communication skills

o   Ability to communicate effectively in English (verbal and written)

o  Experience with data modeling, performance tuning, and version control (Git).

o   Familiarity with cloud and on-prem hybrid environments (GCP,Azure, AWS, etc.).

·         Good to Have

o   Experience with Rest API, Web backend, SQL and No-SQL databases

o   Experience with big data platforms and real-time data processing

o   Familiarity with DevOps tools and CI/CD pipelines

o   Experience working with cross-functional teams (e.g., manufacturing, engineering)

o   Ability to create user guides and training materials

o   Understanding of factory security, safety, and quality standards

·         Nice to Have

o   Knowledge of ITIL processes (Incident, Problem, Change Management)

o   Familiarity with cloud platforms (AWS, Azure)

o   Experience with monitoring tools (e.g., Zabbix)

o   Understanding of information security best practices and compliance standards

o   Experience in automation and process improvement initiatives