
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:
We are seeking a skilled MERN Stack Developer to join our team. The ideal candidate will have 3 to 7 years of experience in developing web applications using the MERN stack (MongoDB, Express.js, React.js, Node.js). You will be responsible for designing and implementing innovative solutions to meet our company's needs. If you are passionate about technology and thrive in a fast-paced environment, we want to hear from you.
Responsibilities:
Develop and maintain web applications using the MERN stack.
Collaborate with cross-functional teams to define, design, and ship new features.
Write clean, efficient, and maintainable code.
Implement front-end interfaces using React.js.
Design and develop RESTful APIs using Node.js and Express.js.
Integrate third-party APIs as needed.
Optimize application performance for maximum speed and scalability.
Troubleshoot and debug issues that arise during development and in production.
Stay up-to-date with emerging technologies and best practices in web development.
Requirements:
Bachelor's degree in Computer Science, Engineering, or related field.
3 to 7 years of experience in web development.
Proficiency in the MERN stack (MongoDB, Express.js, React.js, Node.js).
Strong understanding of JavaScript, HTML, CSS, and related web technologies.
Experience with front-end frameworks such as Bootstrap or Material-UI.
Knowledge of state management libraries such as Redux or MobX.
Familiarity with version control systems (e.g., Git).
Excellent problem-solving and communication skills.
Ability to work independently and as part of a team.
Experience with Agile development methodologies is a plus.
Knowledge of GraphQL is a plus.
mavQ is seeking a motivated Consultant to join our team. You will be an integral member of the Professional Services team dedicated to work on the recently acquired mavQ’s Electronic Research Administration products built on a REST based Java platform running in Tomcat. The work is about 70% implementation and new development and 30% maintenance.
Work Location: Hyderabad, India.
What You will be doing:
- Work closely with the Business Analysts and Project Managers to implement the products on new customer sites
- Analyze client requirements and match with system functionality to develop SOWs.
- Develop tools and applications with producing clean, standardized, and scalable code
- Look into ways implementation tasks can be automated using appropriate tools and scripting
- Troubleshooting bugs and answering implementation questions from customers and the product teams.
- Collaborate with other cross-functional teams
- Ensure change management processes are followed
- Ensure software is up-to-date on latest versions of Apache Tomcat, Apache Solr and Java
What you will bring:
- Overall 2-5 Years of experience.
- Web development using Java, JavaScript, XML, XSLT, CSS, REST API, Apache Solr, Apache XSL-FO, Apache Tomcat
- Database knowledge of SQL, T-SQL
- Some ETL experience - Knowledge of Pentaho Business Intelligence / Pentaho Data Integration preferred.
- Basic understanding of upgrading Java applications running on Tomcat to newer versions of Java and Tomcat.
- Basic understanding of cloud computing & distributed systems.
- Basic understanding of command-line interfaces & shell
- Internally motivated, able to work proficiently both independently and in a team environment
- Strong communication skills with both internal team members and external business stakeholders
- Strong initiative to find ways to improve solutions, systems, and processes
- Experience with agile development methodologies including Kanban and Scrum
- Analytical mind with problem-solving aptitude
What we offer:
- Group Medical Insurance (Family Floater Plan - Self + Spouse + 2 Dependent Children)
- Sum Insured: INR 5,00,000/-
- Maternity cover upto two children
- Inclusive of COVID-19 Coverage
- Cashless & Reimbursement facility
- Access to free online doctor consultation
- Personal Accident Policy (Disability Insurance) -
- Sum Insured: INR. 25,00,000/- Per Employee
- Accidental Death and Permanent Total Disability is covered up to 100% of Sum Insured
- Permanent Partial Disability is covered as per the scale of benefits decided by the Insurer
- Temporary Total Disability is covered
- An option of Paytm Food Wallet (up to Rs. 2500) as a tax saver benefit
- Monthly Internet Reimbursement of upto Rs. 1,000
- Professional Development opportunities through various mavQ sponsored certifications on multiple technology stacks including Google Cloud, Amazon & others
Enterprise Minds, with core focus on engineering products, automation and intelligence, partners customers on the trajectory towards increasing outcomes, relevance and growth.
Harnessing the power of Data and the forces that define AI, Machine Learning and Data Science, we believe in institutionalizing go-to-market models and not just explore possibilities.
We believe in a customer-centric ethic without and people-centric paradigm within. With a strong sense of community, ownership, and collaboration our people work in a spirit of co-creation, co-innovation and co-development to engineer next-generation software products with the help of accelerators.
Through Communities we connect and attract talent that shares skills and expertise. Through Innovation Labs and global design studios we deliver creative solutions.
We create vertical isolated pods which has narrow but deep focus. We also create horizontal pods to collaborate and deliver sustainable outcomes.
We follow Agile methodologies to fail fast and deliver scalable and modular solutions. We constantly self-asses and realign to work with each customer in the most impactful manner.
Pre-requisites for the Role
1.Job ID-EMDF0120PS
- Primary skill:
- C#, JavaScript, CSS, JQuery /Angular 2 +(Angular version 2 or higher), Typescript
- Microsoft .Net (ASP.NET & ASP .NET CORE)
- MVC and WebAPI
- MS SQL
- Secondary skill:
Strong background in Microsoft Technologies and SDLC concepts. Should have experience in below technologies
MS SQL Server management Studio (SSMS) to develop database objects such as Stored Procedures, Functions, views, triggers, constraints etc. and look for performance tuning and Exception handling for these components
(Good to have)
Good to have: Understanding of MS Excel VBA /MS-access/ macro codes
4.Years of Experience: 5-8 Years
- Location:(Remote)
- Position-1
- Budget- Max 25 LPA
- NP- Immediate
B.E. (Computers) or equivalent candidate is required for this profile along with expertise In Java/ PHP Programming. We are looking for a thoughtful Java/ PHP Developer. Must have strong fundamentals. You will be joining the core team of a rapidly expanding company focusing on making Google Workspace- Cloud Telephony products. We are generally agnostic of language, technology or tools; we use whatever fits the bill best. However, we emphasize a lot on clean abstractions of code, loosely coupled services and good coding practices. You must possess the ability to work on projects without detailed instructions; being a self-starter and taking ownership is a crucial requirement for this role. Good Communication Skill is essential.
Responsibilities:
- Design and build applications on Java/ PHP
- Code review
- Guide team members
- Keeping the code optimized and readable.
- Coordination with team members and customer
- Coding, Bug fixes and unit testing
- Coordination with team members and customer
Who Should apply
- Candidate should have 2-4 year of work experience
- PHP/ Java Developer
- Having Good Communication Skills
Specific Skill Sets:
- We are looking for a candidate who can work flexibly
- Experience in working on any one of the MVC architectural pattern : Codeigniter / Laravel / Yii/ Struts 2 would be an added advantage
- Know your way around HTML, HTML5, CSS, CSS3, PHPScript, JQuery and frontend frameworks (such as Ember.js, React.js)
- Must have built SOAP / REST APIs / backends
- Knowledge of APIs and platform capabilities
- Past experience of shipping mobile products (live apps in Play Store a huge plus).
- Expertise in working on multithreaded apps, XML & JSON, and web services.
- Should be very strong in Computer Science fundamentals (such as threads, virtual memory, process stacks etc.)
- Should have worked on different data stores (RDBMS, No-SQL) and know when to use what, how to scale them etc.
- Ability to work on projects without detailed instructions; being a selfstarter and taking ownership is a crucial requirement for this role.
- Good communication skills is an essential advantage for collaborating with customers and the team.

- 2+yrs of experience in Frontend Development
- 2yrs of experience in NodeJS Development
- AngularJS (v1.+) proficiency and web development experience using AngularJS
- Good hands on experience in HTML, CSS, JavaScript.
- Strong communication and problem-solving skills
- Desire to work in a fast-paced, results-driven agile environment with varied
Responsibilities:
- Use markup languages like HTML to create user-friendly web pages
Develop the frontend and Backend of the Application - Integration of the front-end and back-end aspects of the web application
- Constantly and consistently implementing new features and optimize existing ones from controller-level to UI Vigilantly and rapidly fix bugs
Note: Candidate will be working on developing applications using NodeJS
Essential Job Functions:
- Implement application components and systems according to department standards and guidelines.
- Work with product and designers to translate requirements into accurate representations for the web.
- Analyze, design, code, debug, and test business applications.
- Code reviews in accordance with team processes/standards.
- Understand and work with data in varying degrees of complexity and scale.
- Responsible for planning, processing and performing all jobs in an efficient manner.
- Provide assistance to testers and support personnel as needed to determine system problems.
- Resolve problems involved with integrating new technologies with systems.
* Essential functions are the basic job duties that an employee must be able to perform, with or without reasonable accommodation. The function is considered essential if the reason the position exists is to perform that function.
Supportive Job Functions:
- Remain knowledgeable of new emerging technologies and their impact on internal systems.
- Available to work on call when needed.
- Perform other miscellaneous duties as assigned by management.
*These tasks do not meet the Americans with Disabilities Act definition of essential job functions and usually equal 5% or less of time spent. However, these tasks still constitute important performance aspects of the job.
Knowledge, Skill, and Abilities:
- Experience using Python, JavaScript, and React.
- Experience with web services and RESTful APIs.
- Experience in cloud infrastructure
- Experience with Sql and NoSql databases
- Familiarity with modern CI/CD methods
- Ability to organize, prioritize, and handle multiple assignments on a daily basis.
- Strong and effective inter-personal and communication skills
- Ability to interact professionally with a diverse group of clients and staff.
- Must be able to work flexible hours on-site and remote.
- Must be able to coordinate with other staff and provide technological leadership.
- Ability to work in a complex, dynamic team environment with minimal supervision.
- Must possess good organizational skills.
Education, Experience, and Certification:
- Associate’s or bachelor’s degree preferred (Computer Science, Engineer, etc.), but equivalent work experience in a technology related area may substitute.
- 5+ years relevant experience, required. *
- Experience using version control daily in a developer environment.
- Experience with Python, JavaScript, and React is required.
- Experience using rapid development frameworks like Django or Flask.
- Experience using front end build tools.
4+ years of experience working in a relevant software engineering role.
Expertise in designing highly-scalable and performant micro-services and storage layers using common frameworks, languages, and infrastructure (e.g. Java, MySql, AWS, Docker).
Experience in frameworks such as Spring Framework, Spring Boot and Hibernate.
Familiar with front-end languages like Javascript with toolkits like Angular.js 4+
Experience in implementing and deploying micro-services in Cloud (eg: AWS).
Experience in CI/CD tools such as Kubernetes.
Experience in version control tools such as GIT, GitHub and BitBucket.
Familiar with testing frameworks such as JUnit, Selenium.
Familiarity with web security a plus.
SaaS /Internet company background: web-based, hosted on AWS.
Experience in an Agile and Scrum environment.
Experience working for a rapidly scaling start-up.
Comfortable with the web engineering lifecycle.
Passion for delivering high-quality web functionality with quick turnaround times.
Comfortable working in a fast-moving team environment.
Data-driven and strongly motivated by success and learnings through experiments and metrics analysis.
Responsibilities:
Design and implement scalable systems and infrastructures.
Measure your work thoroughly, analyze results and generate hypotheses to drive new product changes through A/B testing.
Setup monitoring and testing of your APIs and services to better understand real time health of your products.
Break-down complex problems into solvable pieces of work for other engineers.
Depending on your specialization, projects/initiatives may include: Security, scaling distributed systems, working on our core services related to user management, building out new verticals, guiding new engagement features, scaling traffic/imports/exports, managing APIs.








