PHP Developer

Key Responsibilities

Reporting & Analytics Development

• Design, develop, and maintain complex reporting solutions serving mission-critical emergency

response operations

• Build interactive dashboards and data visualizations that transform large datasets into

actionable insights

• Develop advanced analytics features including trend analysis, predictive metrics, and

operational intelligence

• Create self-service reporting capabilities enabling stakeholders to access critical data

independently

• Implement real-time and scheduled reporting systems with appropriate caching and

optimization strategies

SQL & Database Architecture

• Write and optimize complex SQL queries involving multiple joins, subqueries, CTEs, window

functions, and aggregations

• Review existing database architectures and identify performance bottlenecks and optimization

opportunities

• Design and implement database schema enhancements to support evolving reporting

requirements

• Develop and maintain stored procedures, functions, and views optimized for reporting

workloads

• Perform comprehensive query performance analysis and implement tuning strategies across

PostgreSQL and AWS Aurora environments

• Create efficient indexing strategies and data access patterns for large-scale datasets

• Establish data modeling best practices for dimensional and transactional reporting needs

Performance Optimization

• Conduct systematic performance analysis of reporting queries processing millions of records

• Implement query optimization techniques including execution plan analysis, index tuning, and

query refactoring

• Design and implement data aggregation strategies, materialized views, and summary tables for

improved performance

• Monitor and optimize database performance metrics including query response times, resource

utilization, and concurrency

• Develop ETL processes and data pipelines optimized for reporting and analytics workloads

• Implement caching strategies and data archival policies to maintain optimal system

performance

Technical Collaboration

• Partner with Product and stakeholder teams to translate business reporting requirements into

technical solutions

• Conduct code reviews focused on SQL quality, performance, and best practices

• Provide technical guidance to development teams on reporting architecture and database

optimization

• Document database schemas, reporting architectures, and optimization strategies

• Collaborate with DevOps on database infrastructure, monitoring, and scaling initiatives

Required Qualifications

Experience & Background

• 8+ years of software engineering experience with significant focus on reporting, analytics, or

business intelligence

• 5+ years of hands-on experience writing complex SQL in production environments

• 3+ years working with large-scale databases (millions+ records) and optimizing query

performance

• Proven track record developing enterprise reporting solutions and analytics platforms

• Experience conducting database architecture reviews and implementing performance

improvements

Technical Expertise - SQL & Databases

• Expert-level SQL proficiency including complex joins, subqueries, CTEs, window functions, and

advanced aggregations

• Deep PostgreSQL expertise with production experience in query optimization and performance

tuning

• Strong understanding of database internals including execution plans, indexing strategies, and

query optimization

• Experience with AWS Aurora or other cloud-based PostgreSQL solutions

• Proficiency in stored procedures, triggers, functions, and database programming

• Advanced knowledge of database design principles, normalization, and dimensional modeling

• Experience with database performance monitoring and profiling tools

• Strong programming skills in PHP (Yii framework or similar MVC frameworks preferred)

• Solid experience with Vue.js or similar modern JavaScript frameworks for building reporting

interfaces

What You'll Work With

• Databases: PostgreSQL, AWS Aurora, multi-tenant architectures

• Backend: PHP (Yii framework), RESTful APIs

• Frontend: Vue.js (Vue 2/3), modern JavaScript, data visualization libraries

• Infrastructure: AWS (RDS, Aurora, S3, Lambda), Postgres

• Tools: Git/GitHub, JIRA, Agile development workflows

Work Location

Hyderabad, India - On-site position with flexible working arrangements to accommodate both India

and onsite teams

Job Summary:

SiGa Systems are looking for a skilled and motivated Software Developer with expertise in NetSuite API and ODBC integrations. The ideal candidate will design, develop, and maintain robust data integration solutions to seamlessly move data between NetSuite and external database systems. This role demands a deep understanding of NetSuite’s data model, SuiteTalk APIs, ODBC connectivity, and strong programming skills for data manipulation and integration.

• Key Responsibilities:1. NetSuite API DevelopmentDesign and implement custom integrations using NetSuite SuiteTalk REST and SOAP APIs.
• Develop efficient, scalable scripts using SuiteScript 1.0 and 2.x.
• Build and maintain Suitelets, Scheduled Scripts, User Event Scripts, and other custom NetSuite components.
• Troubleshoot and resolve issues related to NetSuite API connections and data workflows.
• 2. ODBC Data IntegrationSet up and manage ODBC connections for accessing NetSuite data.
• Write complex SQL queries and stored procedures for ETL (Extract, Transform, Load) processes.
• Design and execute data synchronization workflows between NetSuite and external databases (e.g., SQL Server, MySQL, PostgreSQL).
• Ensure optimal performance and data accuracy across systems.
• 3. Data Modeling & Database ManagementAnalyze NetSuite data models and design efficient schemas for target systems.
• Perform data mapping, transformation, and migration tasks.
• Ensure data consistency and integrity throughout integration pipelines.
• Monitor database performance and maintain system reliability.
• 4. Software Development & DocumentationWrite clean, maintainable, and well-documented code.
• Participate in code reviews and contribute to coding best practices.
• Maintain technical documentation, including API specs, integration flows, and data mapping docs.
• Use version control systems (e.g., Git) for collaboration and code management.
• 5. Collaboration & CommunicationWork closely with business analysts, project managers, and cross-functional teams to understand integration requirements.
• Provide technical guidance and regular progress updates to stakeholders.
• Participate actively in Agile development processes and contribute to sprint planning and retrospectives.

Role & Responsibilities:

• Individuals are responsible for all traditional development activities analysis, design, coding, testing, and documentation.
• Add new features to existing Windows and Web-based applications in Visual Studio 2019. Interacting with internal team.
• Transform business and design needs into innovative products.
• Drive all projects to completion within deadlines.
• Perform thorough testing to find issues ahead of time.
• Engineering software needs more precise analysis & coding skillset
• Enhance skillset by working with fortune 500 clients
• Interacting with internal team.

Qualifications:

• E in computer science or related fields.
• Hand on development experience with web & database technologies (MS SQL).
• Excellent programming & communication skills Strong problem solving, judgmental, and decision-making skills.
• Ability to work at the tactical and strategic levels of IT initiatives.
• Impressive hands-on experience in .Net technologies. Impressive hands-on experience and knowledge with C#, SQL, JSON, XML, Win Forms & MVC, Angular, JavaScript, jQuery , HTML/CSS.
• Self-Motivated, flexible & Innovative

Position: PHP Full Stack Developer

Responsibilities:

- Develop and manage web applications.

- Collaborate with a team of developers to maintain a high-quality codebase.

- Troubleshoot and debug issues with web applications.

- Coordinate work with other internal departments.

Requirements:

- Strong experience with Core PHP, Codeigniter, MySQL, JavaScript, HTML5, and CSS.

- Minimum 1 year of experience in Full Stack ERP/CMS development.

- Familiarity with front-end technologies such as HTML5, CSS3, JavaScript, JQuery, AngularJS, etc.

- Strong analytical and problem-solving skills.

Additional Preferences:

- Male candidates and immediate joiners are preferred.

Compensation:

- Salary range: 3 - 5 LPA (Indian Rupees), based on knowledge, skills, and assessment.

Route to Smile is a patient-centric, tech-oriented brand in the Healthcare space.

With a team of experts and a mission to continuously innovate, Route to Smile is revolutionizing the Healthcare industry by providing customized solutions to facilitate accurate and precise clinical outcomes and patient-specific care with a focus on technological service delivery.

As a part of their latest offerings, Route to Smile is leveraging leading technologies including IoT, Industry 4.0 and AI/ML to further enable healthcare professionals to improve patient engagement and drive overall practice growth.

We are looking for an enthusiastic and motivated individual who is willing to work in Java technologies, with experience on front-end languages and libraries (e.g. Angular, HTML/ CSS, JavaScript, XML, jQuery, Vue.js, React) and its related back-end languages (e.g. Java) and frameworks (e.g. Spring boot, Node.js, Spring MVC, Hibernate, Struts, etc.) and who are also willing to work in challenging environment.

The candidate will be an integral member of a team that will employ the latest techniques and best practices in software development and utilize best-in-class tools and frameworks to build a first-of-their-kind cloud-agnostic, enterprise-class large-scale SaaS application.

• Responsible for building the architecture, key components, and middleware of the platform and developing fully multi-tenant systems
• Develop workflow management functions
• Develop REST APIs, as well as contribute to the overall API framework
• Implement solutions using iterative processes, Agile development methodologies and test-driven development
• Being a senior developer, you will also be required to lead a team of junior developers.

• 5 to 9 years of development experience with Java and related front-end and back-end technologies, and experience working in a distributed systems environment.
• Extensive experience in developing full stack end-to-end scalable and distributed applications.
• Experience in SaaS Application architecture & design and working with database modeling and design concepts. Understanding of database design and maintenance and experience with SQLite, PostgreSQL, and MySQL.
• Experience with developing loosely coupled design, Micro-services development, message queues, and customized application deployment using RESTful services, implementing REST APIs with Spring or JAX-RS.
• Working knowledge of either Spring boot, Spring MVC, Hibernate, Struts Framework, building REST based Web Services using Java EE Standards
• Have experience in single sign-on, multi-factor authentication and security background.
• Knowledge of Business Process Model and Notation (BPMN 2.0) workflow engines such as Activiti, jBPM, Orchestra, and Flowable, however not mandatory.

• Familiarity with databases (e.g. MySQL, MongoDB), web servers (e.g. Apache) and UI/UX design.
• Good understanding of HTML5, CSS3, JavaScript.
• Good familiarity with Linux operating system, managing Linux servers and using AWS (EC2, S3).
• Familiarity with administering, automating, and deploying to cloud-based environments such as AWS, Google Cloud Platform, or Azure, or working experience with Kubernetes.
• Should have used GIT.
• Understanding of search technologies such as Solr, ElasticSearch, and Lucene
• Have working knowledge in CI/CD pipelines (Concourse/Jenkins), and at times wear multiple hats to double up as Dev Ops
• Experience being part of product teams and in handling integrations, good at communication and teamwork skills.
• Strong emphasis on quality and the ability to deliver quickly and consistently.
• Self-driven and motivated to work with cutting edge technology.

Technical Skills

Front-end:

Mandatory Technical Skills: ReactJS, ES6, Context API, GraphQL, Redux, Payment Gateway
Not Mandatory skills: Redux saga, Gatsby, Git Pipeline, Deployment on Cloud AWS/Azure/Google

Back-end:

Mandatory Technical Skills: NodeJS, ES6, Express, Apollo Server, Send Grid Email, Twilio SMS, Payment Gateway,
Exception Management, Error Loggin, API Developement, API Security, PostGreSQL/MSSQL/MySQL, MongoDB/CouchDB
Not Mandatory: Docker Deployment, Git Pipeline, Auto Deployment, AWS/Azure/Google, NestJS

Job roles and responsibilities

• Design and implement key components of our technical infrastructure, including services supporting payments, lottery results, user management, and game mechanics
• Design and implement user-facing features for Web, iOS, and Android applications
• Take ownership of mission-critical functionality that is consumed by our mobile, web, and internal applications
• Work as a team with your peers, collaborating on architecture, mentoring teammates, and pushing our entire stack forward
• Stay up to date on the latest innovations in our industry and in our tech stack
• Integrating with and managing third-party APIs as well as designing and developing APIs for partners and peers
• Work with the product team to keep the roadmap realistic, on track, and groomed
• Capable of writing technical specs and documenting work
• Management of Jira, Git, AWS, Heroku, and other platform systems

Competencies and Skills Required

1. Requires excellent analytical, problem-solving, and good communications skills
2. Must be able to work effectively with business stakeholders
3. Able to understand requirements and implement complete business solutions for our industry
4. Must possess strong customer service skills
5. Excellent written and verbal communication
6. Must have excellent interpersonal skills