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 Consultant (Java / NodeJS + Temporal)

Experience : 5 to 12 Years

Location : Bengaluru, Chennai, Hyderabad, Pune, Mumbai, Gurugram, Coimbatore

Work Mode : Remote (Must be open to travel for occasional team meetups)

Notice Period : Immediate Joiners or Serving Notice

Interview Process :

• R1 : Tech Interview (60 mins)
• R2 : Technical Interview
• R3 : (Optional) Interview with Client

Job Summary :

We are seeking a Senior Backend Consultant with strong hands-on expertise in Temporal (BPM/Workflow Engine) and either Node.js or Java.

The ideal candidate will have experience in designing and developing microservices and process-driven applications, as well as orchestrating complex workflows using Temporal.io.

You will work on high-scale systems, collaborating closely with cross-functional teams.

Mandatory Skills :

Temporal.io, Node.js (or Java), React.js, Keycloak IAM, PostgreSQL, Terraform, Kubernetes, Azure, Jest, OpenAPI

Key Responsibilities :

• Design and implement scalable backend services using Node.js or Java.
• Build and manage complex workflow orchestrations using Temporal.io.
• Integrate with IAM solutions like Keycloak for role-based access control.
• Work with React (v17+), TypeScript, and component-driven frontend design.
• Use PostgreSQL for structured data persistence and optimized queries.
• Manage infrastructure using Terraform and orchestrate via Kubernetes.
• Leverage Azure Services like Blob Storage, API Gateway, and AKS.
• Write and maintain API documentation using Swagger/Postman/Insomnia.
• Conduct unit and integration testing using Jest.
• Participate in code reviews and contribute to architectural decisions.

Must-Have Skills :

• Temporal.io – BPMN modeling, external task workers, Operate, Tasklist
• Node.js + TypeScript (preferred) or strong Java experience
• React.js (v17+) and component-driven UI development
• Keycloak IAM, PostgreSQL, and modern API design
• Infrastructure automation with Terraform, Kubernetes
• Experience in using GitFlow, OpenAPI, Jest for testing

Nice-to-Have Skills :

• Blockchain integration experience for secure KYC/identity flows
• Custom Camunda Connectors or exporter plugin development
• CI/CD experience using Azure DevOps or GitHub Actions
• Identity-based task completion authorization enforcement

Job Description   - Omniflow and Java Developer

Should have working experience between 6-8 years in Java development

Mandatory skills are good knowledge of object oriented concepts, experience of working on Spring boot application, should have worked on hibernate ORMS and candidate must have clear understanding of database concepts

Optional skills include knowledge of angular framework and postgreSQL database

Good to have knowledge of jBPM open source workflow

Qualifications

Master or Bachelor degree in Engineering/Computer Science /Information Technology

Additional Information

Skills and Competencies:
Strong documentation skills
Excellent communication skills, both written and verbal
Decision making and problem solving skills
Good organizational skills        

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.

• Python knowledge: object-oriented programming: inheritance, abstract classes, dataclass, dependency injection, design patterns: comand-query, repository, adapter, hexagonal architecture, swagger/Open API, flask, connexion
• Experience on AWS services: lambda, ecs, sqs, s3, dynamodb, auroradb
• Experience with following libraries boto3, behave, pytest, moto, localstack, docker
• Basic knowledge about terraform, gitlab ci
• Experience with SQL DB

Responsibilities :

- Knowledge of Node.js and frameworks available for it {such as NestJS, Express, StrongLoop, etc.}

- Experience in Database, Postgres Preferred.
- Integration of user-facing elements developed by front-end developers with server-side logic
- Writing reusable, testable, and efficient code
- Design and implementation of low-latency, high-availability, and performant applications
- Implementation of security and data protection
- Integration of data storage solutions 
- Strong proficiency with JavaScript

We are hiring!!

JOB TITLE: Back-end Developer

EXPERIENCE: 3 - 7 years

LOCATION: Mumbai (Borivali East)

TIMINGS: Indian Shift Timings

TYPE OF WORKING: Work from office

NOTICE PERIOD: 1 month

Responsibilities

• Participate in the entire application lifecycle, focusing on coding and debugging
• Must have a clear understanding of Database
• Write clean code to develop functional web applications
• Troubleshoot and debug applications
• Perform UI tests to optimize performance
• Manage cutting-edge technologies to improve legacy applications
• Collaborate with Front-end developers to integrate user-facing elements with server-side logic
• Gather and address technical and design requirements
• Provide training and support to internal teams
• Build reusable code and libraries for future use
• Liaise with developers, designers and system administrators to identify new features
• Follow emerging technologies

Requirements

• Proven work experience as a Back-end developer
• Experience in Node.js language
• Familiar with building REST API
• In-depth understanding of the entire web development process (design, development and deployment)
• Hands on experience with programming languages like Java, Ruby, PHP and Python
• Working knowledge of CMS framework
• Familiarity with front-end languages (e.g. HTML, JavaScript and CSS)
• Excellent analytical and time management skills
• Teamwork skills with a problem-solving attitude

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