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

About the Role

Unico Connect is an AI-first technology partner that builds custom mobile, web, and AI products for clients across multiple geographies. We are hiring a Backend Engineer for a dedicated client engagement building an AI-powered application builder platform.

The backend is the operational core of the product: it manages user projects and sessions, coordinates long-running AI agent workloads, maintains project state, and serves as the integration layer between the frontend, the AI system, and the underlying infrastructure.

The mandatory requirement is hands-on production experience shipping Node.js services, with end-to-end ownership of API design, data modelling, and at least one production system involving background job processing or event-driven patterns.

Responsibilities

API and service development: Design and build REST APIs in Node.js with TypeScript. Cover authentication, session management, input validation, structured error handling, streaming responses (SSE, WebSockets), and rate limiting. Maintain clean API contracts that the frontend and AI system can rely on.

Database design and management: Own PostgreSQL schema design for product domains including user accounts, projects, file trees, session state, and generated artefacts. Write efficient queries, manage migrations, and optimise for read patterns that serve a real-time editor experience.

Caching strategy: Implement and maintain caching with Redis for session data, project state, and frequently read configuration. Design cache invalidation logic that keeps the editor experience consistent without stale reads.

Queue and background job management: Implement and operate background job infrastructure using BullMQ or equivalent. AI agent runs are long-running and stateful; handle retries, failure states, priority queues, and concurrency limits.

AI system integration: Build the integration layer between the backend and the AI agent system. Manage job dispatch, result handling, streaming output to the frontend, and error propagation.

Multi-tenancy and access control: Implement tenant data isolation, RBAC, and resource ownership enforcement across all API surfaces.

Observability and reliability: Instrument services with structured logging, metrics, and tracing. Write defensive code with sensible timeouts, fallback behaviour, and circuit breaking on external dependencies.

Testing and code quality: Write unit and integration tests for the services you ship. Review the work of peers and contribute to shared engineering conventions.

Requirements

• Hands-on production Node.js experience (mandatory) — must have personally shipped at least one feature area end to end in a production Node.js service, owning API design, data modelling, and testing.

• 3 to 5 years of professional backend engineering experience. Candidates with slightly less time but strong demonstrated ownership are welcome to apply.

• Strong Node.js and TypeScript. Production experience with Express, NestJS, or Fastify. Solid with async patterns, streaming, error handling, and building services that run reliably under sustained load.

• PostgreSQL depth. Schema design, query writing, indexing, and migrations on at least one production system.

• Redis and caching. Production experience using Redis for caching and session management. Understands cache invalidation trade-offs.

• Queue and background job systems. Hands-on with BullMQ, RabbitMQ, SQS, or equivalent. Experience managing retries, dead-letter queues, job priority, and concurrency control.

• AWS working knowledge. Comfortable with EC2, S3, RDS, SQS, and IAM. Familiar with Docker and basic deployment and environment management.

• Strong written and spoken English. Able to communicate clearly with engineers across disciplines and write precise technical documentation.

Nice to Have

Experience integrating with AI or LLM services (streaming responses, structured outputs, retry patterns); WebSocket or SSE implementation for real-time features; multi-tenant SaaS product experience; GraphQL; OpenTelemetry instrumentation; prior work on developer tools or editor-style products.

🚀 Hiring: Python Developer

⭐ Experience: 2+ Years

📍 Location: Mumbai

⭐ Work Mode:- 5 Days Work From Office

⏱️ Notice Period: Immediate Joiners

(Only immediate joiners & candidates serving notice period)

Looking for a skilled Python Developer with experience in Django / FastAPI and MongoDB / PostgreSQL.

⭐ Must-Have Skills:-

✅ 2+ years of professional experience as a Python Developer

✅Proficient in Django or FastAPI

✅Hands-on with MongoDB & PostgreSQL

✅Strong understanding of REST APIs & Git

Position: Microsoft .NET Full Stack Developer

Experience: 4–6 Years

Open Positions: 10

Location: PAN India (Final Round – Face-to-Face Interview)

Budget: Up to 15 LPA

Notice Period: Immediate joiners preferred

Key Responsibilities:

· Work on highly distributed and scalable system architecture

· Design, develop, test, and maintain high-quality software solutions

· Ensure performance, security, and maintainability of applications

· Collaborate with cross-functional teams and stakeholders

· Perform system testing and resolve technical issues

Required Skills:

· Strong experience in ASP.NET, C#, .NET Core, MVC

· Hands-on experience with SQL Server / PostgreSQL

· Experience in Angular / React (Frontend technologies)

· Knowledge of microservices architecture & RESTful APIs

· Familiarity with CQRS pattern

· Exposure to AWS / Docker / Kubernetes

· Experience with CI/CD pipelines (Azure DevOps, Jenkins)

· Knowledge of Node.js is an added advantage

· Understanding of Agile methodology

· Good exposure to cybersecurity and compliance

Technology Stack:

· Microsoft .NET technologies (primary)

· Cloud platforms: AWS (SaaS/PaaS/IaaS)

· Databases: MSSQL, MongoDB, PostgreSQL

· Caching: Redis, Memcached

· Messaging queues: RabbitMQ, Kafka, SQS

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        

Job Description: Backend Developer – Design Qandy

Who are we?

Design Qandy delivers personalised luxury interior design to India’s discerning homeowners and corporates. Led by highly admired luxury brand builders, internationally trained designers, world-class technology professionals and curated teams of turnkey project execution specailists. We seek perfection in design and are committed to bringing back trust and excitement in the design process.

Know more about us on designqandy.com and https://instagram.com/designqandy?igshid=YmMyMTA2M2Y=

Our work culture?

We are a lean team of high performing go-getters, we take ownership in our roles and lead with knowledge. Debates and discussions are an important part of our culture and we encourage people to bring unique perspectives to their conversations. Most importantly, we love solving problems.

Each day is inspiring and we encourage you to apply for this role and experience it for yourself.

What would you be required to do?

·      Write code and tests, build prototypes, solve issues, profile, and analyze bottlenecks

·      Design performance gauging, building robust APIs to support mobile and desktop clients

·      Manage and optimize scalable distributed systems on the cloud

·      Optimization of web applications for performance and scalability

·      Develop automated tests to ensure business needs are met and allow for regression testing

·      Participate in the entire application lifecycle, focusing on coding and debugging

·      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

What skills we are looking for?

·      Good communication skill to communicate with stakeholders, project managers, quality assurance teams, Regularly and other developers regarding progress on the long-term technology roadmap

·      Curious and progressive mind to Create and maintain workflows with teams to provide visibility and to ensure workload balance for consistent visual designs

·      Good technical knowledge to Produce quality code, raising the bar for the whole team on quality and speed

·      Through analytical skills to Recommend system solutions by comparing advantages and disadvantages of custom development and purchase alternatives

Skills Needed:

·      PHP Laravel Framework, PHP Design Patterns.

·      Proficient in MySQL, PostgreSQL, MongoDB

·      APIs, REST API, SOAP API, API Security, Open APIs

·      Push Notifications, Laravel Events, Queue, Observers

·      Excellent foundation in computer science, algorithms, and web design

·      Experience writing highly secure web applications

·      Experience with core AWS web-enabling technologies

·      Growth mindset, challenging status quo to find new solutions and out-of-the-box ideas

·      Experience designing RESTful APIs, specifically for mobile apps

·      Computer science degree or equivalent experience

·      Experience leading a team

·      3-6 Years’ experience in back-end development.

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

• Writing efficient, reusable, testable, and scalable code
• Understanding, analyzing, and implementing – Business needs, feature modification requests, conversion into software components
• Integration of user-oriented elements into different applications, data storage solutions
• Developing – Backend components to enhance performance and receptiveness, server-side logic, and platform, statistical learning models, highly responsive web applications
• Designing and implementing – High availability and low latency applications, data protection and security features
• Performance tuning and automation of application
• Working with Python libraries like Pandas, NumPy, etc.
• Creating predictive models for AI and ML-based features
• Keeping abreast with the latest technology and trends
• Fine-tune and develop AI/ML-based algorithms based on results

Good proficiency in,

• Python frameworks like Django, etc.
• Web frameworks and RESTful APIs
• Core Python fundamentals and programming
• Code packaging, release, and deployment
• Database knowledge
• Circles, conditional and control statements
• Object-relational mapping
• Code versioning tools like Git, Bitbucket

Fundamental understanding of,

• Front-end technologies like JS, CSS3 and HTML5
• AI, ML, Deep Learning, Version Control, Neural networking
• Data visualization, statistics, data analytics
• Design principles that are executable for a scalable app
• Creating predictive models
• Libraries like Tensorflow, Scikit-learn, etc
• Multi-process architecture
• Basic knowledge about Object Relational Mapper libraries
• Ability to integrate databases and various data sources into a unified system
• Basic knowledge about Object Relational Mapper libraries
• Ability to integrate databases and various data sources into a unified system

Rajasthan Studio is looking for young and bright minds for its upcoming innovative, never-experienced-before app platform for virtual art experiences.

We are looking for programmers with problem-solving skills and critical thinking abilities for the position of Back End developer. Back End developers are responsible for creating a bridge between customers and business logic, optimizing applications for maximum efficiency, creating dashboards for internal teams, and maintaining brand consistency across the application, among other duties.

Backend Web Developers are responsible for managing the interchange of data between the server and the users. The role's primary focus will be the development of all server-side logic, definition, and maintenance of the central database, and ensuring high performance and responsiveness to requests from the front-end. A basic understanding of front-end technologies is necessary as well.

Responsibilities -

• Creating RESTful API/GraphQL to be consumed by Flutter developers
• Building reusable code and libraries for future use
• Optimization of the application for maximum speed and scalability
• Implementation of security and data protection
• Design and implementation of data storage solutions
• Participate in the entire application lifecycle, focusing on coding and debugging
• Write clean code to develop functional web applications
• Troubleshoot and debug applications
• Provide training and support to internal teams

Skill & Qualifications -

• Basic understanding of front-end technologies and platforms, such as JavaScript, HTML5, and CSS3
• Understanding accessibility and security compliances
• User authentication and authorization between multiple systems, servers, and environments
• Integration of multiple data sources and databases into one system
• Management of hosting environment, including database administration and scaling an application to support load changes
• Data migration, transformation, and scripting
• Setup and administration of backups
• Outputting data in different formats
• Understanding differences between multiple delivery platforms such as mobile vs desktop, and optimizing output to match the specific platform
• Creating database schemas that represent and support business processes
• Implementing automated testing platforms and unit tests
• Proficient understanding of code versioning tools, such as Git
• Proficient understanding of OWASP security principles
• Understanding of “session management” in a distributed server environment
• Knowledge of Yii framework - version 2 (preferred)