Postgresql Developer+ PHP

Role & responsibilities

We are seeking an exceptional Senior Software Engineer specializing in reporting and analytics to join our emergency response technology platform. This role demands a unique blend of advanced SQL expertise, database architecture proficiency, and hands-on reporting system development. You will be responsible for designing and optimizing complex reporting solutions that process millions of records, reviewing and enhancing database architectures for performance, and building scalable analytics platforms that empower Fire & EMS agencies with critical operational insights. The ideal candidate brings deep expertise in SQL optimization, proven experience with enterprise reporting tools, and a track record of transforming complex datasets into actionable intelligence.

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