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.

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.

Required Core Tech Stack:

We're looking for engineers with hands-on experience across most of the following technologies:

• Python Backend Development (3+ years)
• FastAPI (2+ years of production experience required)
• PostgreSQL
• MongoDB
• Redis
• Docker
• Celery or equivalent async task queues
• REST APIs & Microservices
• AWS/GCP
• GitLab CI/CD

The selected Sr. Backend engineer will ship the backbone that powers 4 million + learners in 64 countries—owning APIs that crunch 1 billion learning events & the AI that supports it with <200 ms latency.

What You'll Do:

At LearnTube, we’re pushing the boundaries to revolutionize how the world learns. As a Senior Backend Engineer, your roles and responsibilities will include:

• Shipping Micro-services – Build FastAPI services that handle ≈ 800 req/s today and will triple within a year (sub-200 ms p95).
• Power Real-Time Learning – Drive the quiz-scoring & AI-tutor engines that crunch millions of events daily.
• Design for Scale & Safety – Model data (Postgres, Mongo, Redis, SQS) and craft modular, secure back-end components from scratch.
• Deploy Globally – Roll out Dockerised services behind NGINX on AWS (EC2, S3, SQS) and GCP (GKE) via Kubernetes.
• Automate Releases – GitLab CI/CD + blue-green / canary = multiple safe prod deploys each week.
• Own Reliability – Instrument with Prometheus / Grafana, chase 99.9 % uptime, trim infra spend.
• Expose Gen-AI at Scale – Publish LLM inference & vector-search endpoints in partnership with the AI team.
• Ship Fast, Learn Fast – Work with founders, PMs, and designers in weekly ship rooms; take a feature from Figma to prod in < 2 weeks.

What makes you a great fit?

Must-Haves (Applicants without these skills are unlikely to move forward):

• 3+ yrs Python back-end experience (FastAPI)
• Strong with Docker & container orchestration
• Hands-on with GitLab CI/CD, AWS (EC2, S3, SQS) or GCP (GKE / Compute) in production
• SQL/NoSQL (Postgres, MongoDB) + You’ve built systems from scratch & have solid system-design fundamentals

Nice-to-Haves

• k8s at scale, Terraform,
• Experience with AI/ML inference services (LLMs, vector DBs)
• Observability: Prometheus, Grafana, OpenTelemetry

Why LearnTube?

• Build AI products at global scale – Your work will power learning experiences for 4M+ learners across 64 countries.
• Work directly with experienced founders – Collaborate closely with founders who are deeply involved in product and engineering decisions, giving you ownership and a direct impact on the product roadmap.
• Learn fast – Join a high-performing team where you'll own features end-to-end and solve challenging backend and distributed systems problems.
• Recognized AI startup – LearnTube is a Google Top 20 AI Startup and part of Google's AI First Startup Accelerator, with access to cutting-edge AI technology and mentorship.

Why Work With Us? 

At LearnTube, we believe in creating a work environment that’s as transformative as the products we build. Here’s why this role is an incredible opportunity:

• Cutting-Edge Technology: You’ll work on state-of-the-art generative AI applications, leveraging the latest advancements in LLMs, multimodal AI, and real-time systems.
• Autonomy and Ownership: Experience unparalleled flexibility and independence in a role where you’ll own high-impact projects from ideation to deployment.
• Rapid Growth: Accelerate your career by working on impactful projects that pack three years of learning and growth into one.
• Founder and Advisor Access: Collaborate directly with founders and industry experts, including the CTO of Inflection AI, to build transformative solutions.
• Team Culture: Join a close-knit team of high-performing engineers and innovators, where every voice matters, and Monday morning meetings are something to look forward to.
• Mission-Driven Impact: Be part of a company that’s redefining education for millions of learners and making AI accessible to everyone.

Job Description: Python-Azure AI Developer

Experience: 5+ years

Locations: Bangalore | Pune | Chennai | Jaipur | Hyderabad | Gurgaon | Bhopal

Mandatory Skills:

• Python: Expert-level proficiency with FastAPI/Flask
• Azure Services: Hands-on experience integrating Azure cloud services
• Databases: PostgreSQL, Redis
• AI Expertise: Exposure to Agentic AI technologies, frameworks, or SDKs with strong conceptual understanding

Good to Have:

• Workflow automation tools (n8n or similar)
• Experience with LangChain, AutoGen, or other AI agent frameworks
• Azure OpenAI Service knowledge

Key Responsibilities:

• Develop AI-powered applications using Python and Azure
• Build RESTful APIs with FastAPI/Flask
• Integrate Azure services for AI/ML workloads
• Implement agentic AI solutions
• Database optimization and management
• Workflow automation implementation

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.

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.

About Prêtture

We are India’s coolest SaaS ERP for Fashion, Lifestyle and Home Decor brands. Currently working across 100 brands like House of Masaba, Rahul Mishra, Raw Mango, Anamika Khanna and many others across India, helping them organise their end to end business workflow through our application.

We are currently working on new development and enhancement in the application and are hence looking forward to senior software developers.

The ideal candidate is a creative problem solver who understands the requirement and comes up with the solution keeping in mind the impact of the solution on existing code

Responsibilities

• Understand the problem statement and get the code done for the server side programming of our software including the database and other internal/external micro services communication
• Maintain the quality of code
• Impact analysis before actually writing any code
• Use the optimised SQL queries only

Qualifications

• At least 2-3 years' of experience using NodeJS and MySql/PostgreSQL (This is mandatory. Please do not apply in case of lesser experience in either NodeJS or MySQL/PostgreSQL)
• Bachelor's degree or equivalent experience in Computer Science

Office Location

 Navi Mumbai

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