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 description:

Job Title: PHP Developer

Location: Mumbai

Experience: 3–5 years

Immediate Joiners

Role & Responsibilities:

• Develop and maintain robust, scalable web applications using the Laravel framework.
• Collaborate with cross-functional teams to define, design, and deliver new features.
• Ensure the performance, quality, and responsiveness of applications.
• Identify and correct bottlenecks and fix bugs.
• Help maintain code quality, organization, and automation.
• Write clean, secure, and efficient code while following best practices.
• Build and maintain APIs and third-party integrations.
• Troubleshoot and debug application issues in development and production environments.
• Manage and optimize MySQL databases and queries.
• Participate in daily stand-ups, code reviews, and agile ceremonies.

Required Skills:

• Strong experience in developing web applications using Laravel (v8 or higher).
• Solid understanding of MVC architecture and OOP principles.
• Experience working with MySQL, including database design and query optimization.
• Hands-on knowledge of Eloquent ORM, migrations, seeders, and factories.
• Proficiency in PHP, HTML, CSS, JavaScript, and frontend libraries (like Bootstrap).
• Familiarity with RESTful APIs and API security best practices.
• Experience with version control systems such as Git.
• Understanding of application hosting, deployment, and CI/CD pipelines.
• Good analytical, problem-solving, and communication skills.
• Ability to work independently and take ownership of projects.

Preferred Skills:

• Knowledge of Docker, Kubernetes, or similar tools for containerization.
• Familiarity with AWS, Azure, or other cloud service providers.
• Understanding of SEO-friendly website development.
• Exposure to AI tools (e.g., ChatGPT, GitHub Copilot, or similar) to assist in coding, debugging, documentation, or productivity.
• Exposure to Agile/Scrum development methodologies.

Role Overview:

As a Backend Developer at LearnTube.ai, you will ship the backbone that powers 2.3 million learners in 64 countries—owning APIs that crunch 1 billion learning events & the AI that supports it with <200 ms latency.

Skip the wait and get noticed faster by completing our AI-powered screening. Click this link to start your quick interview. It only takes a few minutes and could be your shortcut to landing the job! -https://bit.ly/LT_Python

What You'll Do:

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

• Ship 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:

• 2+ 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)
• Go / Rust for high-perf services
• Observability: Prometheus, Grafana, OpenTelemetry

About Us: 

At LearnTube, we’re on a mission to make learning accessible, affordable, and engaging for millions of learners globally. Using Generative AI, we transform scattered internet content into dynamic, goal-driven courses with:

• AI-powered tutors that teach live, solve doubts in real time, and provide instant feedback.
• Seamless delivery through WhatsApp, mobile apps, and the web, with over 1.4 million learners across 64 countries.

Meet the Founders: 

LearnTube was founded by Shronit Ladhani and Gargi Ruparelia, who bring deep expertise in product development and ed-tech innovation. Shronit, a TEDx speaker, is an advocate for disrupting traditional learning, while Gargi’s focus on scalable AI solutions drives our mission to build an AI-first company that empowers learners to achieve career outcomes. We’re proud to be recognised by Google as a Top 20 AI Startup and are part of their 2024 Startups Accelerator: AI First Program, giving us access to cutting-edge technology, credits, and mentorship from industry leaders.

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.

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.

Job Details:-

Designation - Backend Developer

Urgently required. (NP of maximum 15 days)

Location:- Mumbai

Experience:- 2-4 years.

Package Offered:- Rs.4,00,000/- to Rs.7,00,000/- pa.

Experience required in Node.js & PostgreSQL

Backend Developer

Job Description

Responsibilities

• Participate in the entire application lifecycle, focusing on coding and debugging
• Must have a clear understanding of Databases
• 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, AWS, Postgres
• 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
• Working knowledge of CMS framework
• Familiarity with front-end languages (e.g. HTML, JavaScript)
• Excellent analytical and time management skills
• Teamwork skills with a problem-solving attitude

Years of Experience:- 1.5+

Qualification:- BE Computer Engineering/MCA

Industry:- Software
Location:- Andheri