11+ Query optimization Jobs in Mumbai | Query optimization Job openings in Mumbai

Office Location: Goregaon Mumbai

Position description:

4+ years of experience in database development.

Primary Responsibilities:

• Understand requirements from front end applications developers
• Write advanced queries, stored procedures, cursors, functions & triggers
• Conduct code reviews
• Work with high-traffic application servers
• Complete understanding of various DB like Postgresql, Mongo DB, MySQL 
• Ability to identify root cause and mitigate issues
• Ability to lead a team of DB developers

Required Skills:

Mandatory: Passionate about sports, Problem solving, Team player, Target & Result oriented, Strong communication skills

Functional: Oracle SQL, PostgreSQL Development - TSQL, Advance Queries, Query Optimization, Stored Procedures, Triggers & Cursors, Database Design, Indexes, Joins, ETL tools like SSAS, SSIS, High Data Volume Processing, DB Backup/Recovery.

Job Title : Senior Backend Developer (Node.js + AWS + MongoDB)

Experience : 4+ Years

Location : Andheri, Mumbai (Work From Office)

About the Role :

We are looking for a highly skilled Senior Backend Developer with strong expertise in Node.js (NestJS), AWS, and MongoDB to join our growing engineering team.

This role requires someone who takes ownership, is proactive, and enjoys building scalable, high-performance backend systems in a fast-paced environment.

Key Responsibilities :

• Architect, design, and develop scalable backend services using Node.js (NestJS).
• Design and manage cloud infrastructure on AWS Services (EC2, ECS, RDS, Lambda, etc.).
• Develop and maintain high-performance database solutions using MongoDB.
• Work with Kafka, Docker, and serverless frameworks (SST) for efficient deployments.
• Optimize system performance, scalability, and reliability across services.
• Ensure application security, best practices, and compliance standards.
• Collaborate with cross-functional teams to deliver robust product features.
• Take end-to-end ownership of features from design to deployment.

Technical Requirements :

• 4+ years of backend development experience.
• 3+ years of hands-on experience with Node.js.
• 2+ years of hands-on experience with AWS.
• Strong experience with NestJS framework.
• Solid experience with MongoDB and database design.
• Experience with Kafka, Docker, and serverless architecture.
• Understanding of system design, scalability, and performance optimization.

Good to Have (Bonus Skills) :

• Experience with Python or other backend languages.
• Exposure to Agentic AI use cases or implementations.
• Strong understanding of security best practices.

What We’re Looking For :

• Curious mindset and eagerness to learn new technologies.
• Proactive problem solver with strong ownership attitude.
• Strong team player with effective communication skills.
• Positive, energetic, and passionate about building great systems.

Position: Python Developer

Location: Andheri East, Mumbai

Work Mode: 5 Days WFO

Availability: Immediate joiners only (or notice period completed)

What We're Looking For:

✅ 2+ years of solid Python development experience

✅ Django framework expertise - must have!

✅ FastAPI framework knowledge - essential!

✅ Database skills in MongoDB OR PostgreSQL

✅ Ready to work from office 5 days a week

Engineering Manager – Backend

Opportunity in this role / Why should you join us?

Series D funded supply chain startup.

Requirements

• Software engineering experience of greater than or equal to 7 years
• Experience managing a technical team of at least 3 people
• Exposure to consumer facing products
• Strong technical background and ability to contribute to design and review
• Familiarity with our tech stack or an analogous tech stack

Technologies Used

• Web application frameworks : Ktor, Spring Boot, Ruby on Rails, Node.js, Java Play, AWS Lambda
• Languages : Kotlin, Java, Ruby, Javascript, Python
• Datastores : PostgreSQL, Aerospike, Redis, DynamoDB, Amazon Redshift
• Communication : HTTP, Amazon SQS, Sidekiq, Amazon SNS
• Server management : Amazon ECS, Docker
• Design frameworks : Domain Driven Design, Clean Architecture, Layered Architecture

Roles and Responsibilities

This role requires a person to drive the engineering of a set of products by aligning with business and product

stakeholders and building and upskilling a team to aid in this. The responsibilities include:

Business and product alignment and planning

• Work closely with business and product stakeholders to understand and align with product initiatives and iterations.
• Help shape the engineering requirement by aligning with the product manager and fleshing out concepts and user flows.
• Formalize business requirements into roadmaps and sprints.

1. Product and system development

• Drive high level modeling and design for projects, also focusing on non-functional aspects, including but not limited to database design, communication protocols, deployment systems, etc.
• Drive adoption of design frameworks like domain driven design, clean architecture, etc., resulting in a robust layered architecture.
• Drive good code review practices, using the review process as a mentoring tool to upskill people.
• Ensure test coverage of systems, partly through unit and integration testing, and partly through blackbox testing by collaborating with the Quality Assurance team, via good testing practices.

1. Project Management

• Drive the execution of the project by delegating tasks effectively.
• Resolve blockers through technical expertise, negotiation and delegation.
• Estimate timelines and ensure adherence to them through effective sync-ups and course corrections.

1. Maintenance

• Formulate SLAs and oversee their adherence for the various systems, effectively tracking issues and performance inefficiencies.
• Performance monitoring and optimization for systems.
• Drive technical re-design, remodeling and refactoring of systems for robustness and sustainability.

1. Team Management

• Typically manage a team of 3 - 6 members and a portfolio of 3 - 6 products.
• Do periodic assessment of reportees, chart their career growth paths and train them.
• Recruit members into the team by collaborating effectively with the recruitment team.

Product Overview

You will be contributing to products concerning both customers and partner drivers. Product sectors

include:

• Growth : You’ll build tools to help boost user growth on the platform including our industry bestdriver on-boarding, training and certification system, referral system, and lead managementmmodels.
• Lifecycle Management : Build tools to help users engage with the platform better, which includes rewards and recognition module, subscription service, account management tools, partner and customer wallets and payout modules, and churn detection systems among others.
• Transaction Experience : You’ll help deliver the most delightful booking experience to our customers and drivers. As part of this team, you’ll be responsible for our core booking system, pricing and payment systems, location tracking and filtering services, fraud prevention systems, and in-app ticketing and support among others.
• Fulfilment : As part of the fulfilment team, you’ll work on systems which ensure high degree of ride fulfilment on the platform. Tools including allocation methodologies and system, dynamic pricing, dynamic partner routing, and partner re-activation tools among others.
• Enterprise Solutions : You’ll help Porter’s enterprise customers achieve delivery excellence. You’ll build tools for contract management, fleet management, fleet and route optimisation tools, alerting and monitoring tools, and analytics suite among others.

Key Skills Required :

1. Proficiency in Python 3.x based web and backend development
2. Solid understanding of Python concepts
3. Strong experience in building web applications using Django
4. Experience building REST APIs using DRF or Flask
5. Experience with some form of Machine Learning (ML)
6. Experience in using libraries such as Numpy and Pandas
7. Hands on experience with RDBMS such as Postgres or MySQL including querying
8. Comfort with Git repositories, branching and deployment using Git
9. Working experience with Docker
10. Basic working knowledge of ReactJs
11. Experience in deploying Django applications to AWS,Digital Ocean or Heroku

Responsibilities :

1. Understanding requirement and congributing to engineering solutions at a conceptual stage to provide the best possible solution to the task/challenge
2. Building high quality code using coding standards based on the SRS/Documentation
3. Building component based, maintainable, scalable and reusable backend libraries/modules.
4. Building & documenting scalable APIs on the Open Spec standard
5. Unit testing development modules and APIs
6. Conducting code reviews to ensure that the highest quality standard are maintained
7. Securing backend applications and APIs using industry best practices
8. Troubleshooting issues and fixing bugs raised by the QA team efficiently.
9. Optimizing code
10. Building and deploying the applications

• Team with top-notch engineers, product managers, program managers, DevOps and QA following agile development methodologies
• Review functional requirements, providing technical feedback on feasibility and architectural approach and framework.
• Design and develop web / mobile applications
• Create Prototype and/or Proof of Concepts (POCs) when necessary
• Act in a technical leadership capacity: Mentor junior engineers and new team members, perform code reviews and apply technical expertise to challenging programming and design problems
• Utilize Agile Development, SCRUM / Pair / Extreme Programming methodologies
• Design and develop supporting components and microservices for the backend tiers focusing on fault-tolerance and scalability in a multi-tenant enterprise environment
• Maintain and improve the functionality and performance of the existing web applications
• Help shape and execute the technical roadmap to develop next generation features; integrate corporate- and product-level architecture principles and goals into the teams project work through designs, implementation strategies, and project planning.
• Drive a culture of quality, technical curiosity, continuous improvement, and evidence-based data driven decision making in the organization.
• Execute other Duties as assigned

• 3+ years of experience developing Backend, API and data-based applications/software
• Experience with one of the major relational databases (MySQL, Oracle, Postgres) and NoSQL databases (Mongo DB, Cassandra, Dynamo DB or such)
• Expert object-oriented programming experience using Java
• Strong OO design and programming skills in Java, Hibernate, JPA, Spring Boot
• Worked in Maven, JPA, REST services, Postman
• Working knowledge on Spring Security / Spring Batch / ZUUL / Eureka / Hysterix
• Exposure with Frontend technologies (React.js, Angular or Ruby-on-Rails)
• Require experience and Strong understanding of entire Software Development Life Cycle (SDLC), Agile (Scrum), Software design/architecture process, unit testing & Test-Driven Development (TDD)
• Experience with web services (consuming or creating)
• Experience managing Cloud infrastructure (resources and service) in AWS, Azure and/or GCP
• Strong knowledge of SOA, object-oriented programming, design patterns, multi-threaded application development
• Experience in reporting and analytics, queuing and real-time streaming systems
• Git or similar distributed SCM tools experience.

As a Senior Software Engineer you have complete ownership of building out the Docexa product along with product people and the rest of the engineering team. This role will act as a great springboard to accelerate career growth & transition into a Tech Lead level role.

Your daily life

• Architecting of the whole platform
• Development of server-side logic
• Building new services and APIs
• Developing core business logic
• Maintenance of current APIs
• Improving the performance and reliability of our systems as we scale

Must-have skills

• You’ve been building web applications professionally for 4+ years
• You’re proficient in PHP 7, Laravel, and PostgreSQL
• You possess strong OOP and design pattern knowledge
• You are familiar with modern technology systems: AWS, load balancers, Kafka queues, caching, etc.
• You write understandable, testable and easy to maintain code
• You’ve the ability to build RESTful APIs
• Explaining complex technical concepts to designers, support team, and fellow engineers is not a problem for you
• Well versed with the fundamentals of computer science and distributed systems