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

Responsibilities

• Build reusable code and libraries for future use.
• Writing reusable, testable, and efficient code
• Own & build new modules/features end-to-end independently.
• Collaborate with other team members and stakeholders.
• Work in an agile environment to rapidly build high-quality and robust features.
• Participate in DevOps.
• Implementation of security and data protection.

Required Skills

• Master in Node.js and frameworks available for it. (Nest.js / Loopback / AdonisJS)
• Excellent understanding of ES6 and OOP.
• Good understanding of SQL & No-SQL Databases. (MySQL / PostgreSQL)
• Understanding the nature of asynchronous programming and its quirks and workarounds.
• Open Source and DevOps enthusiast.
• Comfortable with Test Driven Development.
• Can learn and adapt fast, as well as identify and solve problems.

Bonus Skills

• Hands-on with TypeScript

Job Perks

• Get to work with a highly passionate team of engineers.
• Open and embracing culture towards the latest hot technologies.
• A high level of freedom & responsibility.

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.

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

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