Web 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

• Solid experience in PHP/Frameworks of PHP (Laravel,Codeignitor,etc)
• Excellent knowledge of JavaScript, jQuery
• Experience in working with REST APIs and AJAX
• Good understanding of database design and optimization
• Experience of responsive and mobile-first design platforms like Bootstrap
• Knowledge of version control systems like GIT
• In-depth understanding of Agile development process

Desired Candidate Profile and skill set:

• Minimum 2 years of relevant software development experience.
• Good Knowledge of E-commerce websites and WordPress
• Experience in ReactJs and Redux, React-Native would be a plus

PRIMARY RESPONSIBILITIES :-

• Should have develop professional applications in PHP using CodeIgniter.
• Additional advantage if worked on frameworks like Laravel and Zend
• Extensive knowledge with JavaScript, jQuery or Angular
• Advance Level SQL knowledge
• Additional advantage if familiar with Server Configuration and Monitoring
• Should have working on Git Repository
• Candidate should have exceptionally good debugging skills.
• Clear about Object Oriented Programming Concepts.

SECONDARY RESPONSIBILITIES :-

• Ability to work independently and take ownership of the project.
• Should be capable to work in a team.
• Must have strong communication skills.
• Should be enthusiasts and able to take challenge.

• C#
• ASP.NET MVC
• ASP.NET
• Core
• jQuery
• JavaScript
• Angular
• MS SQL Server
• JSON
• Web API

We are looking for a motivated PHP / Laravel developer to come join our team.

Responsibilities and Duties:

• Develop, record and maintain cutting edge web-based PHP applications on portal plus premium service platforms
• Build innovative, state-of-the-art applications and collaborate with the User Experience (UX) team
• Ensure HTML, CSS, and shared JavaScript is valid and consistent across applications
• Prepare and maintain all applications utilizing standard development tools
• Utilize backend data services and contribute to increasing existing data services API
• Lead the entire web application development life cycle right from concept stage to delivery and post-launch support
• Convey effectively with all task progress, evaluations, suggestions, schedules along with technical and process issues
• Document the development process, architecture, and standard components
• Coordinate with co-developers and keeps project manager well informed of the status of development effort and serves as a liaison between development staff and project manager
• Keep abreast of new trends and best practices in web development

Required Skills

• At least 1 of experience in PHP / Laravel developer
• BS/MS degree in Computer Science, Engineering
• In-depth knowledge of object-oriented PHP and Laravel 5, 7 PHP Framework
• Hands-on experience with SQL schema design, SOLID principles, REST API design
• Software testing (PHPUnit, PHPSpec, Behat)
• MySQL profiling and query optimization
• Creative and efficient problem solver