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.

🚀 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

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.

🔹 Mandatory Skills & Experience:

• Minimum 2–4 years of experience in software development.
• Strong proficiency in Flutter framework for cross-platform mobile app development (Android & iOS).
• Solid experience in PHP (Laravel / CodeIgniter preferred) for backend development.
• Proficient in creating and integrating RESTful APIs.
• Strong understanding of MySQL / PostgreSQL databases.
• Experience with version control tools (Git, GitHub, GitLab).
• Excellent debugging, analytical, and problem-solving skills.
• Ability to work collaboratively in a team environment with strong communication skills.

If interested kindly share your resume at 82008 31681

As a Node.js Developer, you will be responsible for:

Designing, developing, and maintaining server-side applications and systems using Node.js, a JavaScript runtime environment. Your expertise in backend development, JavaScript, TypeScript, and REST APIs will play an essential role in creating efficient and powerful server-side applications.

Responsibilities:

● Design and implement efficient, secure, and maintainable server-side code using Node.js.

● Collaborate with the front-end development team to integrate user-facing elements with server-side logic.

● Develop APIs for seamless data flow between the front-end and back-end.

● Optimize application performance and ensure high availability and scalability.

To succeed in this role – you should have the following:

● Minimum of 3-4 years of experience as a backend developer.

● Must have proven experience as a Back-End Developer, with a focus on Node.js.

● Proficiency in JavaScript, TypeScript, and related frameworks (Express.js, Hapi.js, etc.).

● Experience with RESTful API design principles.

● Experience with agile development methodologies.

● Familiarity with working with at least one of PostgreSQL or MongoDB.

● Familiarity with version control systems (Git)

● Strong communication skills and ability to work collaboratively in a team.

● Strong problem-solving skills and attention to detail.

Added bonus:

● Familiarity with frontend development technologies like HTML and CSS.

● Experience working with Docker, Github Actions, and other common CI/CD pipelines

● Knowledge about AWS components (S3, EC2, Cloudfront, Redis Clusters, etc.)

Education:

Bachelor's degree in Computer Science, Information Technology, or a related field

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