
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

Similar jobs
Job Description: React Native Developer – PHP
We are seeking a skilled React Native Developer with strong PHP expertise to join our development team. The ideal candidate should have hands-on experience in building and maintaining cross-platform mobile applications using React Native, along with strong backend development skills in PHP (Laravel/Core PHP).
The candidate will be responsible for developing mobile applications integrated with Education ERP systems and backend services. Experience working with REST APIs, MySQL, MongoDB, third-party integrations, and ERP modules will be highly preferred.
Key Responsibilities
- Design, develop, test, and maintain high-quality cross-platform mobile applications using React Native.
- Develop and maintain backend services and APIs using PHP, Laravel, and Core PHP.
- Integrate mobile applications with REST APIs, GraphQL services, and third-party platforms.
- Work closely with backend and frontend developers to ensure seamless integration between mobile applications and ERP systems.
- Develop mobile features related to Education ERP modules, including Admissions, Student Management, Attendance, Fees, LMS, Exams, HR, and Finance.
- Optimize application performance, responsiveness, scalability, and security.
- Implement secure authentication, authorization, push notifications, and API integrations.
- Work with databases such as MySQL, MongoDB, and PostgreSQL for data management and optimization.
- Integrate third-party services such as payment gateways, SMS, email, and notification services.
- Debug, troubleshoot, and resolve application and API-related issues.
- Participate in code reviews and follow coding standards and best practices.
- Collaborate with product managers, UI/UX designers, QA engineers, and other developers.
- Use Git/GitHub for source code management and participate in development and deployment processes.
- Stay updated with emerging technologies and recommend improvements to mobile and backend solutions.
Required Skills & Qualifications
- Strong hands-on experience in React Native mobile application development.
- Good knowledge of JavaScript and modern JavaScript concepts.
- Strong experience with PHP, including Laravel and Core PHP.
- Experience in developing and consuming REST APIs.
- Knowledge of MySQL, MongoDB, and PostgreSQL.
- Experience with mobile application features such as:
- Push Notifications
- Firebase Integration
- Authentication & Authorization
- API Integration
- Payment Gateway Integration
- Deep Linking
- App Performance Optimization
- Knowledge of HTML, CSS, JavaScript, and jQuery is preferred.
- Experience with Git/GitHub and version control systems.
- Familiarity with third-party integrations such as payment gateways, SMS, email, and cloud services.
- Understanding of mobile application security and performance optimization.
- Knowledge of Docker and CI/CD pipelines is a plus.
- Familiarity with cloud platforms such as AWS, Azure, or GCP is an advantage.
Preferred Experience
- Experience developing React Native applications for Education, ERP, SaaS, or enterprise platforms.
- Prior experience working with Education ERP solutions is highly preferred.
- Understanding of ERP modules such as Admissions, Student Management, Attendance, Fees, Exams, LMS, HR, Inventory, and Finance.
- Experience working with large-scale or high-traffic applications.
- Experience publishing and managing applications on the Google Play Store and Apple App Store.
- Strong debugging, problem-solving, and analytical skills.
- Ability to work independently and collaborate effectively with cross-functional teams.
- Good communication and teamwork skills.
Experience
- 3–6 years of professional software development experience.
- Minimum 2+ years of hands-on experience in React Native.
- Strong experience in PHP/Laravel backend development will be preferred.
Benefits
- Permanent Work From Home
- Opportunity to work on Education ERP and enterprise-level technology solutions
- Collaborative and growth-oriented work environment
- Opportunity to work with modern mobile and backend technologies
WALK-IN-Drive for PHP Developer for Lucknow on 13th July 2025 ie Sunday
Registration Link- https://shorturl.at/bfKwb
Location; Prithvi Ratan Heights, 4th floor, Plot No. 4, 3 Vijayant Khand, Gomti Nagar, Lucknow, U.P
Job Description for PHP Developer :
- Experience – 00- 2 yrs
- Qualification- MCA /B. Tech
- Job Nature - Permanent
- Skills - PHP, Java, MYSQL, CSS, Jquery
- Working days - 5
Description:
- Should have hands-on experience in Web Development
- Good understanding of PHP and Object-oriented programming paradigm.
- Able to understand project requirement and handle project independently.
- Strong learning capability.
- Having a good knowledge of Jquery.
- Framework experience would be beneficial.
- Should be comfortable to work with the team.
- Should be comfortable with work on any MVC based framework.
Skills required:
- Able to understand project requirement and handle project independently.
- Strong learning capability.
- Contribute in all phases of the development.
- Knowledge of PHP/CodeIgniter will be preferred.
- Basic Knowledge of JavaScript, Web Services.
- Sound knowledge of PHP, mysql, JQuery etc.
Perks & Benefits:
- Employees Family Health Insurance, EPF & ESIC.
- Employee Health Insurance.
- Late-night meal facility.
- Innumerable in house & outdoor party.
- Various compensations & bonuses.
- No dress code
- Festival Celebration
- Employees B'day celebration.
- Hobby club
- Mini Gym
- Cafeteria facility
Procedure for the interview will be as follows:-
1. Written Round
2. Technical F2F
3. HR Round
WALK-IN-Drive for PHP Developer for Lucknow on 13th July 2025 ie Sunday
Registration Link- https://shorturl.at/bfKwb
Location; Prithvi Ratan Heights, 4th floor, Plot No. 4, 3 Vijayant Khand, Gomti Nagar, Lucknow, U.P
Company Description
Gaea - Purpose First CRO Agency is dedicated to creating and nurturing purpose-driven brands. Inspired by the Greek goddess of Earth and life, Gaea focuses on helping brands align with their purpose, fostering authentic storytelling, meaningful connections, and sustainable growth. Gaea partners with founders and visionaries who aim to build brands that stand the test of time, prioritize substance over trends, and create lasting impact. With a philosophy rooted in conscious growth, Gaea empowers businesses to craft spaces of storytelling, community, and purpose, rather than merely sales-driven platforms.
Role Description
This is a full-time, on-site role for a Full Stack Developer with Shopify experience, based in Calcutta (in-office). The developer will be responsible for designing, developing, and maintaining both front-end and back-end components of web applications, with a focus on Shopify platforms. The role includes the creation and implementation of responsive, user-friendly interfaces, as well as developing and integrating robust back-end systems. Collaboration with cross-functional teams to align technical solutions with business goals will be a key aspect of this position.
📍 Kolkata (In-Office) | 💰 ₹35,000 – ₹45,000/month
Qualifications
- 3–5 years of hands-on experience with Shopify
- Expertise in Front-End Development, including proficiency in HTML, CSS, and JavaScript
- Experience in Back-End Web Development and Full-Stack Development, with an understanding of server-side programming and integration
- Proficient in Shopify development and theme customization
- Performance optimization (LCP, lazy loading, asset optimization)
- Responsive design & cross-browser compatibility
- Experience working with Shopify APIs / webhooks and headless architecture
- Exposure to tools like: Claude Code / OpenAI / Copilot and Automation tools (Zapier, n8n, etc.)
- Can clean up messy Liquid + JS-heavy themes
- Background in Software Development with a focus on creating scalable, efficient solutions
- Strong problem-solving and debugging skills
- Excellent communication and team collaboration skills
- Bachelor's degree in Computer Science, Software Engineering, or a related field is preferred
- Experience in e-commerce platform development is a plus
Why Join us ?
- Work on real-world eCommerce scale problems
- Exposure to modern Shopify + headless architecture
- Hands-on experience with AI-driven development workflows
- Opportunity to directly impact business metrics (conversion, revenue) + working with founders
MEAN STACK DEVELOPER
About Us:
VegEase is an innovative and fast-growing company in the F&V and FMCG sectors, driving digital transformation through technology. We’re seeking an experienced MEAN Stack Developer to join our team and contribute to building efficient, scalable web applications. Familiarity with the Electron framework is a plus, as we value candidates who can help bridge web and desktop application solutions.
Key Responsibilities:
• Develop, test, and deploy scalable applications using the MEAN (MongoDB, Express.js, Angular, Node.js) stack.
• Collaborate with cross-functional teams to define and design new features.
• Optimize applications for performance, security, and scalability.
• Write clean, modular, and well-documented code that adheres to best practices.
• Work with RESTful and WebSocket APIs to ensure seamless integration with backend services.
• Troubleshoot and resolve technical issues throughout the development lifecycle.
• Build cross-platform applications using Electron (a plus) to bridge web and desktop environments.
Requirements:
• Bachelor’s degree in Computer Science, Engineering, or a related field.
• 4+ years of hands-on experience with the MEAN Stack.
• Strong proficiency in front-end development with Angular and back-end development with Node.js and Express.js.
• Experience with MongoDB, including schema design and query optimization.
• Familiarity with Electron framework is a plus.
• Proficient understanding of code versioning tools, such as Git.
• Knowledge of cloud services like AWS or Azure is advantageous.
• Ability to work effectively in a team and independently.
• Excellent problem-solving skills and attention to detail.
Nice to Have:
• Experience with desktop application development using Electron.
• Knowledge of microservices architecture and containerization (Docker).
• Experience with CI/CD pipelines and Agile development methodologies
1. We are looking for full-stack/back-end developers with 2-4 years of web development experience.
2. Overall of 2+ years of expertise in at least one dynamic programming language and one MVC/MVT web framework, preferably Django.
3. Our ideal candidate will be able to build applications from scratch and deliver a complete project i.e. understand requirements, design architecture, write reusable code that follows basic coding standards, test, deploy and support/follow-up features.
4. As a start-up, we are keen to work with people who are passionate about technology and who love the speed, chaos, and versatility of start-ups
Skills and Qualifications:
1. 2-4 years of experience in building large-scale full-stack web applications and RESTful APIs.
2. Experience with AWS and AWS Serverless Application Model.
3. Experience in Python is preferred, but not mandatory.
5. Proficient with version control systems like Git or BitBucket.
6. Hands-on experience with front-end technologies - HTML5, CSS3, Bootstrap library & JavaScript/jQuery.
7. Knowledge of Angular 2/ReactJs is a plus.
8. Proficient in Databases like MySQL and familiar with caching techniques.
9. Familiarity with Docker and virtual environments is a plus.
10. Good understanding of CS fundamentals, data structures, and algorithms.
11. Bachelor’s/Master’s degree in Computer Science or related fields
12. Team player with strong work ethic; Detail and deadline-oriented; Take ownership of tasks.
Role:Full-Stack developer
Must have: Strong JavaScript Fundamentals
Qualifications:
2+ years of hands-on experience in writing secure, efficient, high-quality code and have a good understanding of JS.
Frontend:
- Develop frontend components on ReactJS with Redux as state management library
- Should have good knowledge of tailwind CSS
- Must have expertise in JavaScript, ES6, React-Redux, HTML/CSS
- Familiarity with build tools such as Webpack, Babel
- Experience with testing tools such as Jest
- Experience in web security and performance on mobile and desktop
- Familiarity with Git.
- Should be able to make mobile responsive designs
- Knowledge on PWA would be an added advantage
Backend:
- Develop backend APIs on Express.js and NodeJS
- Should be good with SQL database and perform DDL,DRL,DQL,DCL on database ,preferably PostgresDb.
- Should have familarity with ORM such as sequilize.
- Knowledge on server-less architecture is good
- Experience with monitoring tools web performance and caching techniques
- Experience working in agile methodology projects
- Should have knowledge of design patterns, design practices
- Should have the ability to design and write reusable code
- Ready to work in a challenging and fast-paced environment
- Experience in building Cloud Native applications
- Experience in test-driven development
What the candidate will do:
* Fast learner: We are looking for software engineers who thrive on learning new technologies and don't believe in one-size-fits- all solutions.
* A great teammate: Believe that you can achieve more on a team - that the whole is greater than the sum of its parts. You rely on other candidates feedback for continuous improvement.
Will be developing mobile and web applications using latest technology. Should be good in analysing requirements and translate into applications. Good in understanding application flows.
Tech Skills –
MEAN (MongoDB, Express, Angular/React, Node.js) – Expert level - at least 2-3 full sized projects
Cloud technology – Familiar with using cloud technology (AWS, GCP etc) – Intermediate – Should be able to interact with the services from cloud (e.g. firebase etc)
HTML, CSS, Bootstrap, Java script – Intermediate level - Good understanding of concepts and should be able to realize application screens based on the UI provided by designers
Mobile technology – Hybrid (ionic, Cordova, capacitor, flutter), Native (Android, iOS) – Beginner – Should have understanding of concepts, good with basics
Responsibilities
- Responsible to translate the design wireframe to WordPress/Opencart/
- Knowledge of multiple front-end languages and libraries (e.g. HTML/ CSS, JavaScript, XML, jQuery)
- Knowledge of multiple back-end languages (e.g. C#, Java, Python) and JavaScript frameworks (e.g. Angular, React, Node.js)
- Responsible for handling WordPress and its components / plugins upgrade , customization / creation of web application and portal development independently.
- Should have a strong understanding of Logic and Data Structure.
- Passion for best design and coding practices and a desire to develop new bold ideas.
- Code and modify custom applications using CMS Platforms.
- Responsible for both back - end and front - end development , including Modifying WordPress themes and plugins.
- Strong MySQL database skills.
- Comfortable working with front - end technologies (HTML , CSS , Jquery , JavaScript)
- Experience of CMS like Wordpress , Opencart , Magento.
- The candidate should have a strong understanding of industry trends and content management systems.
- Experience with responsive and adaptive design is strongly preferred.
- Also , an understanding of the entire web development process , including design , development , and deployment is preferred.
- Having experience of WooCommerce Customization , WooCommerce develops / modify add - ons , WooCommerce API , Wordpress / WooCommerce Webhooks , WooCommerce Payment Gateway development and Wordpress API.
- Skills -
- Core (Must understand and conversant to code on at least two of these technologies)
- Java 8+/ Spring Boot/Microservices
- Spark
- Scala
- Angular
- Javascript
- ElasticSearch
- Graph Database (Tinkerpop/Janusgraph)
- MySQL/Oracle
- AWS/Azure/GCP
- Secondary
- Version Control - Jira/Bitbucket/Git
- Build Tools - Maven/SBT/Gradle
- Security
- Agile/Scrum methodology
- Should be able to create and review designs/documents
- Must be able to clearly articulate situations, problems and communicate ideas and solutions
- Core (Must understand and conversant to code on at least two of these technologies)
- Must understand System Analysis and Design with understanding of Algorithms (implementation in any language is okay)
- Design optimal and performant solutions for product backlog items spanning technologies
- Work with Product Owner/Project Manager and UX lead for providing LoE estimates for Jira backlog items
- Lead and own delivery or work items (for self and team)
- 80% hands-on work items (self), 20% team responsibility
- Must be willing to learn new technologies, processes, business functions, (we measure this by OKR’s)
Qualifications and Skills
|
REQUIRED QUALIFICATIONS: |
|
Education |
No formal degree in any stream is required. |
|
Add additional details here: |
If you can understand code and write good software (and explain it to others), you have the required education we need for building products. |
|
Experience |
7-10 years’ relevant experience |
|
Add additional details here i.e. technical skills, and certifications |
hackerrank, Github repo details
|










