
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 Title: Full Stack Developer (Node.js + React.js)
📍 Location: Gurgaon (On-site)
🕒 Experience: 5+ Years
🕒 Working Days: 5 Days(Mon-fri)
Job Summary:
We are hiring a passionate and experienced Full Stack Developer proficient in Node.js and React.js for our client. The ideal candidate should have solid experience in designing scalable systems, writing optimized code, implementing role-based access control, handling task prioritization, and building robust web applications.
Key Responsibilities:
- Design scalable user management systems with role-based access and authentication.
- Develop backend services and REST APIs using Node.js.
- Build dynamic and optimized front-end applications using React.js and Redux.
- Handle async operations, task queues, and implement retry and prioritization logic.
- Optimize React components for performance using hooks and memoization.
- Ensure secure and scalable system design with proper error handling and authorization flows.
- Apply JavaScript concepts like closures, event loop, and async patterns in real-world scenarios.
- Collaborate with DevOps for basic CI/CD and deployment processes.
Mandatory Technical Skills:
- Frontend: React.js, Redux, JavaScript (ES6+)
- Backend: Node.js, Express.js
- Authentication & Authorization: JWT, OAuth2, Role-Based Access Control (RBAC)
- Task Management: Async/Await, Promises, Retry Mechanisms
- Database: MongoDB or PostgreSQL
- Version Control: Git
Soft Skills:
- Strong problem-solving and system design skills
- Ability to work independently and in a collaborative team
- Clear communication of technical ideas
- Ownership of tasks and components end-to-end
Focus Areas:
- System Design (User Management, Fault Tolerance, Load Distribution)
- JavaScript Core Concepts (Closures, Scope, Event Loop)
- React Optimization & Hooks
- Node.js Architecture & Async Programming
- Task Prioritization and Retry Logic
Principal Software Engineer
Opportunity in this role / Why should you join here?
You will enjoy working with us if you are looking to work in a stimulating, flexible, open environment. You will experience ownership and independence at the same time providing technical solutions that work.
You will be part of the madness and thrill of growing the business from scratch. You get to make decisions, fail fast and learn fast. You get to contribute, add value to the organization by thinking like an entrepreneur. You are supported by the best talent in the industry and work with creative teams. You are rewarded as you go on proving yourself.
Requirements:
- Bachelor's degree in Computer Engineering/Computer Science or related field
- At least 6+ years of experience with at least 4 years of software application design experience
- Strong analytical and problem solving skills
- A full stack generalist with experience in both front-end and back-end technologies
- Proven experience in high-level programming languages, like Java and Development of scalable Web Applications and Web Services
- Experience in JavaScript frameworks like Angular, React, NodeJS
- Passion for delivering products end-to-end, from ideation to implementation
- Proven experience building complex web applications and micro services
- Strong experience with Spring Boot stack (spring cloud, spring-data)
- Extensive experience in developing and consuming REST APIs
- Experience in PHP is a plus advantage
Responsibilities:
- Participate in design reviews and recommend improvements
- Provide technical guidance in software design and development activities
- Recommend new technologies to ensure quality and improve productivity
- Support in all phases of SDLC and ensure delivery of high-quality products
- Analyse business requirements and design/develop most effective technical solution
- Analyse and troubleshoot application issues in a timely fashion
- Work with other engineers in planning, prioritising and executing assigned tasks within deadlines
x• Work with QA team in preparing test cases and assist in automation
- Mentor other Engineers as and when required
- Assist in maintenances and upgrades of existing software applications
- Assist in risk assessment and mitigation activities.
- Assist in technical audits and make sure to implement audit recommendations.
JOB DESCRIPTION :
COMPANY DESCRIPTION
Gurucul is transforming enterprise security with user behavior and predictive analytics. If you enjoy
working in a fast-paced, rapidly growing and progressive environment, this is the position for you.
Gurucul offers competitive compensation packages and full benefits for all full-time employees.
JOB DESCRIPTION: Technical Lead
Seeking a Java Technical Lead Developer, who will create scalable multi-tier web applications in an agile
software development environment. Applicant should have significant hands-on experience in designing
and coding server components.
The ideal candidate must be able to design and develop enterprise-scale information security software
in collaboration with the engineering team in India and with their counterparts in the US.
SKILLS AND QUALIFICATIONS
- 8 to 14 years experience working as a Java developer on Web/EE applications, ideally multi-tenant SaaS products and at least 3 years as a tech lead.
- Expert in core Java development and Java EE technologies.
- Solid experience building server-side components for enterprise applications.
- Good understanding of browser-side development using any one of the frameworks like Angular, React etc.
- Good understanding of Single-page applications architecture.
- Good understanding of HTML/HTML5, CSS/CSS3, Javascript and object-oriented javascript Should be well versed with server-side and client-side design patterns and anti-patterns.
- Experience using Spring and Hibernate in a commercially available software product.
- Good experience in MVC Architecture like Grails, Spring MVC, Servlets and JSP API programming.
- Exposure to maven/Gradle build script.
- Exposure/Experience with Hadoop and related big data technologies.
- Experience with Git/Gitlab.
- Experience in JMS, Kafka, and Logstash would be considered an added advantage.
- Good understanding of REST APIs and JSON.
- Expert in RDBMS like MySQL 8, SQL, SQL query design, tuning, and experience working with very large databases.
- Experience in multi-threading, and building cluster-aware applications.
- Strong communication skills.
- BS/MS degree in Computer Science, Engineering or related discipline.
- Experience with DevOps pipelines using tools like Jenkins, Gitlab, and Nexus would be a big plus.
- Experience in working in SCRUM as a scrum master.
WHAT TO EXPECT
- Provide inputs in the architecture and design of enterprise applications targeting Fortune 500 companies.
- Development of web-based Enterprise Applications using cutting-edge technologies.
- Gain an insight into enterprise security challenges as it relates to information/Application and infrastructure protection.
- Work closely with a brilliant team based in the USA and India that has successfully launched several software companies.
LOCATION
- The position is based in Pune (India)
About the role
We are looking for strong experience in understanding HTML5, CSS3, JavaScript, Core PHP, MySQL. Must have outstanding coding skills, Strong understanding of business logic and has a good learning curve.
Responsibilities
• Basic Knowledge in PHP Frameworks like CodeIgniter, Core PHP, Laravel, Symphony etc.
• Hands-on experience in Apache, Xampp, and Wamp Servers.
• Basic CMS Knowledge if any (Joomla/WordPress/Drupal).
• Strong Knowledge if OOPS Concepts in PHP.
• Implementing Payment Gateways as per project requirements like (E.g.: PayUMoney, PayPal, Paytm, Razor Pay)Capturing values to database, email notifications for pending/Failed and success payments.
• Knowledge of different Project Lifecycles.
Requirements
• Bachelor’s or Master’s degree in computer science or software engineering.
• Minimum 2+ year of experience developing projects/applications using PHP.
• Good communication verbal skills along with Process oriented.
• Strong debugging skills and the ability to easily and quickly read and modify existing code.
Location & Commitments
Permanent full-time role based at our Ahmedabad, Gujarat office Monday – Friday.
Salary Package
No bar for the right candidate.
We are looking for a Full Stack Developer to produce scalable software solutions. You’ll be part of a cross-functional team that’s responsible for the full software development life cycle, from conception to deployment. As a Full Stack Developer, you should be comfortable around both front-end and back-end coding languages, development frameworks, and third-party libraries. You should also be a team player with a knack for visual design and utility.
What you’ll do:
• Work with development teams and product managers to ideate software solutions
• Design client-side and server-side architecture
• Build the front-end of applications through appealing visual design
• Develop and manage well-functioning databases and applications
• Write effective APIs
• Test software to ensure responsiveness and efficiency
• Troubleshoot, debug and upgrade software
• Create security and data protection settings
• Build features and applications with a mobile responsive design
• Write technical documentation
What you’ll need:
• Proven experience as a Full Stack Developer or similar role
• Experience as a node.js developer
• Experience as a React Native Developer
• Experience in handling build systems, deployments, and cloud systems
• Experience developing desktop and mobile applications
• Knowledge of multiple front-end languages and libraries (e.g. JavaScript, XML, jQuery)
• Knowledge of multiple back-end languages (e.g. C#, java, etc) and JavaScript
frameworks (e.g. Angular, React, Node.js)
• Familiarity with databases (e.g. MySQL, MongoDB), web servers (e.g. Apache)
• Excellent communication and teamwork skills
Job Description
1. JavaScript, ReactJs, Node.js, Express.js, MongoDB, Web-Services
2. Working Experience of Ajax,Json
3. Rest/ SOAP API Integration
4. Good Logical and Analytical and communication Skills
5. Should have knowledge of CI/CD.
6. Must have experience in writing unit test cases and good in TDD approach.
7. Should have basic knowledge of HTML5 and CSS.
8. Ensuring high performance of applications on mobile/desktop
9. Knowledge of Jenkins, GIT, Docker, Linux (Basic)
10. Writing tested, idiomatic, and documented JavaScript, HTML and CSS
11. Coordinating the workflow between the design team, the HTML coder, and yourself
12. Communicating with internal/external web services.
GOOD TO HAVE
1. Experience with Amazon web services, DocumentDB, etc.
2. Understanding of Ecommerce applications.
3. Understanding of fundamental design principles behind a scalable application.
4. Creating database schemas that represent and support business processes Implementing automated testing platforms and unit tests Proficient understanding Roles and Responsibilities
5. Design client-side & server-side architecture
6. Build the front-end of application through appealing visual design
7. Test software to ensure responsiveness and efficiency
8. Troubleshoot, debug and upgrade software
9. Build features and applications with a mobile responsive design
10. Ability to work effectively under very tight deadline pressure.
11. Analyze issues, recommend alternatives, and implement the best recommendation
12. Prioritize tasks and responsibilities while managing multiple, competing priorities









