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

Senior Xano Developer

Visual Backend Development, APIs & AI-Assisted Build

📍 Mumbai (On-site) | Full-time | 3-5 years

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 Xano Developer who will build backend systems and APIs for our customer engagements on Xano, the visual backend development platform.

The mandatory requirement for this role is hands-on production backend engineering experience, including PostgreSQL data modelling and REST API design, in either a Node.js or Python environment.

Prior production work on Xano is strongly preferred.

The role is hands-on and customer-facing. You will own backend delivery across engagements: designing data models, building API flows in Xano, integrating third-party services, and partnering with frontend, mobile, and AI engineers on contracts and behaviour.

The work spans all three Xano build modes: no-code function stacks, custom code through Xano’s scripting and code blocks, and Xano’s AI assistance and agentic features.

A typical week includes a data model review for a new engagement, building a complex API flow in Xano, integrating a third-party webhook, and a customer working session on a new module.

Responsibilities:

Backend Delivery on Xano

Own end-to-end backend implementation on Xano: database schema, API endpoints, function stacks, background tasks, and integrations.

Ship production-ready work that meets customer requirements and engineering quality standards.

Build Across All Three Xano Modes

Use Xano’s no-code function stacks for standard CRUD and business logic.

Drop into custom code (JavaScript, Python through code blocks, expressions) where visual flows would be unwieldy.

Use Xano’s AI assistance and agentic features to accelerate routine build work.

Database Design on PostgreSQL

Own data model decisions for each engagement: table design, relationships, indexes, addons, and query performance.

Make schema choices that hold up as product usage grows and that map cleanly to the API contracts the client needs.

API Design and Integration

Design clean REST API contracts that the frontend, mobile, and third-party consumers can rely on.

Cover authentication, input validation, pagination, error handling, and rate limiting.

Integrate external services (payment gateways, messaging, storage, AI providers) through Xano’s connectors and custom requests.

Product Thinking and Solutioning

Translate fuzzy product asks from customers into concrete backend solutions.

Ask the right questions about edge cases, data lifecycle, multi-tenancy, and access control before building.

Push back on requirements that will cause pain later.

Customer Communication

Work directly with customers in discovery, design reviews, demos, and weekly working sessions.

Explain trade-offs in plain language, present options with clear recommendations, and write tight technical updates.

AI-Assisted Backend Development

Use Xano’s built-in AI features as well as external AI tools (Claude, Cursor, and similar) day to day for schema drafts, function stack scaffolding, query writing, integration setup, and review.

Develop strong instincts for when AI output is usable as-is and when it must be reworked.

Quality, Testing, and Reliability

Test the flows you ship.

Set up sensible error handling, logging, and alerts for the backend services you own.

Participate in incident response when something breaks in production.

Documentation and Handover

Document data models, API contracts, and non-obvious decisions inside Xano and in shared docs so the rest of the team and the customer can pick up the work without you in the room.

Continuous Learning

Track changes to the Xano platform, including new features, performance improvements, and AI capabilities.

Apply them to active engagements where they reduce build effort or improve product outcomes.

Requirements:

Hands-on Production Backend Engineering Experience (Mandatory)

Must have personally shipped backend systems to production for real users, with ownership of API design and data modelling.

POCs, coursework, and internal-only tools do not qualify.

3 to 5 Years of Professional Backend Engineering Experience

In either a Node.js or Python environment.

Candidates with slightly less time but strong demonstrated ownership are welcome to apply.

Strong PostgreSQL Skills

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

Able to reason about query performance and design data models that hold up under realistic product usage.

REST API Design and Integration Depth

Comfort designing API contracts that are clean, predictable, and easy for frontend, mobile, and third-party consumers to work with.

Experience integrating external services such as payment gateways, messaging providers, storage, and AI APIs.

Familiarity with at Least One Node.js or Python Backend Stack

Such as Express, NestJS, Fastify, FastAPI, Django, or Flask.

Comfort reading and writing application code outside of visual environments when the situation calls for it.

Product Thinking and Solutioning

Ability to take a fuzzy product brief, ask the right questions, and propose a backend design that is fit for purpose.

Strong instincts for what to build first, what to defer, and what not to build.

Strong Written and Spoken English Communication

Confident in customer working sessions and design reviews.

Comfortable writing precise technical documentation and explaining trade-offs to non-engineering stakeholders.

Cloud and Deployment Fundamentals

Working knowledge of at least one of AWS, GCP, or Azure: deploying services, reading logs, managing environments, and basic operational tasks.

Familiarity with Docker is a plus.

Bachelor’s Degree

Bachelor’s degree in Computer Science, Information Technology, or a related engineering discipline.

Exceptional candidates with demonstrable production experience and strong portfolios may be considered without a formal degree.

Nice to Have

• Prior production experience on Xano, Bubble, Retool, or comparable visual or low-code backend platforms
• Full stack experience with React, Next.js, React Native, or Flutter
• Experience integrating LLM APIs (OpenAI, Anthropic, Google) into backend workflows
• Multi-tenant SaaS product experience
• Prior agency, consulting, or product-engineering experience

Technical Expertise:

• Strong proficiency in OOP concepts, C#, .NET Core, Entity Framework, React, SQL Server, PostgreSQL, Dapper, ADO.NET, LINQ, and Web API Development.
• Experience with event-driven architecture and messaging systems such as Kafka or Rabbit MQ.
• Excellent debugging, troubleshooting, and performance optimization skills.
• Expertise in database development including tables, views, stored procedures, triggers, and functions.
• Hands-on experience with unit testing frameworks (XUnit).
• Proficiency in JWT services, Git, and third-party API integration.
• Experience in code review and mentoring junior developers.
• Preferred Qualification:
• Bachelor’s Degree in Business, Marketing, Communications, or related field.

Java Developer – Job Description 

Wissen Technology is now hiring a Java Developer with hands-on experience in Core Java, algorithms, data structures, multithreading and SQL. 

We are solving complex technical problems in the industry and need talented software engineers to join our mission and be a part of a global software development team. 

A brilliant opportunity to become a part of a highly motivated and expert team which has made a mark as a high-end technical consultancy. 

Required Skills: 

• Exp. - 4 to 9 years. 

• Experience in Core Java and Spring Boot. 

• Extensive experience in developing enterprise-scale applications and systems. Should possess good architectural knowledge and be aware of enterprise application design patterns. 

• Should have the ability to analyze, design, develop and test complex, low latency client facing applications. 

• Good development experience with RDBMS. 

• Good knowledge of multi-threading and high-performance server-side development. 

• Basic working knowledge of Unix/Linux. 

• Excellent problem solving and coding skills. 

• Strong interpersonal, communication and analytical skills. 

• Should have the ability to express their design ideas and thoughts.

Database Administrator Lead - PostgreSQL

ABOUT Ashnik

Established in 2009, Ashnik is a leading open-source solutions and consulting company in South East Asia and India, headquartered in Singapore. We enable digital transformation for large enterprises through our design, architecting, and solution skills. Over 100 large enterprises in the region have acknowledged our expertise in delivering solutions using key open-source technologies. Our offerings form critical part of Digital transformation, Big Data platform, Cloud and Web acceleration and IT modernization. We represent EDB, Pentaho, Docker, Couchbase, MongoDB, Elastic, NGINX, Sysdig, Redis Labs, Confluent, and HashiCorp as their key partners in the region. Our team members bring decades of experience in delivering confidence to enterprises in adopting open source software and are known for their thought leadership.

THE POSITION

Ashnik is looking for talented and passionate people to be part of the team for an upcoming project at client location.

RESPONSIBILITIES

· Monitoring database performance

· Optimizing Queries and handle escalations

· Analyse and assess the impact and risk of low to medium risk changes on high profile production databases

· Implement security features

· DR implementation and switch over

QUALIFICATION AND EXPERIENCE

· Preferably have a working experience of 4 Years and more , on production PostgreSQL DBs.

· Experience of working in a production support environment

· Engineering or Equivalent degree

· Passion for open-source technologies is desired

ADDITIONAL SKILLS

· Install & Configure PostgreSQL, Enterprise DB

· Technical capabilities PostgreSQL 9.x, 10.x, 11.x

· Server tuning

· Troubleshooting of Database issues

· Linux Shell Scripting

· Install, Configure and maintain Fail Over mechanism

· Backup - Restoration, Point in time database recovery

· A demonstrable ability to articulate and sell the benefits of modern platforms, software and technologies.

· A real passion for being curious and a continuous learner. You are someone that invests in yourself as much as you invest in your professional relationships.

LOCATION: Bangalore & Mumbai

Experience: 7 yrs plus

Package: upto 20 LPA

Postgress developer cum database architect

5-7 years experience

Knowledge and experience, specifically PostGre

-           SQL

-           Query Optimization / Optimization strategies (in PostGre)

-           AWS - RDS Relational Databse Service

-           Optional: AWS – RDS API / PostGre API

Years of Experience:- 1.5+

Qualification:- BE Computer Engineering/MCA

Industry:- Software
Location:- Andheri