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 : Node.js Developer / Backend Developer

Experience : 4+ Years

Job Location : Mumbai – Andheri

Work Mode : Work From Office (5 Days a Week)

Job Type : Full-time Opportunity

Role Overview :

We are seeking an experienced Node.js / Backend Developer to design, develop, and maintain scalable backend systems.

The ideal candidate will have strong hands-on experience with Node.js, Nest.js, relational and NoSQL databases, and AWS cloud services.

You will work closely with frontend developers, DevOps, and product teams to deliver secure, high-performance, and reliable backend solutions.

Mandatory Skills : Node.js, Nest.js, MongoDB, PostgreSQL, AWS, REST API development, strong backend fundamentals.

Key Responsibilities :

• Design, develop, and maintain scalable backend applications using Node.js & Nest.js

• Build and manage RESTful APIs and backend services

• Work with MongoDB and PostgreSQL for efficient data storage and retrieval

• Develop cloud-ready applications and deploy them on AWS

• Ensure application performance, security, and scalability

• Write clean, well-documented, and maintainable code

• Participate in code reviews and follow best engineering practices

• Troubleshoot, debug, and optimize existing applications

• Collaborate with cross-functional teams for end-to-end delivery

Required Skills & Qualifications :

• 4+ years of experience in Backend / Node.js development

• Strong hands-on experience with Node.js and Nest.js

• Experience working with MongoDB and PostgreSQL

• Good understanding of AWS services (EC2, S3, RDS, etc.)

• Experience building RESTful APIs

• Understanding of backend architecture, design patterns, and best practices

• Strong problem-solving and debugging skills

• Familiarity with version control systems (Git)

Good-to-Have Skills :

• Experience with microservices architecture

• Knowledge of Docker and CI/CD pipelines

• Exposure to message queues or event-driven systems

• Basic understanding of frontend-backend integration

• Python knowledge: object-oriented programming: inheritance, abstract classes, dataclass, dependency injection, design patterns: comand-query, repository, adapter, hexagonal architecture, swagger/Open API, flask, connexion
• Experience on AWS services: lambda, ecs, sqs, s3, dynamodb, auroradb
• Experience with following libraries boto3, behave, pytest, moto, localstack, docker
• Basic knowledge about terraform, gitlab ci
• Experience with SQL DB

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

• We are looking to add a Software Engineer to contribute to the development, upgradation and management of our back end services for our website / PWA / app / chatbot / internal tools.
• You will be part of a lean team with a very steep learning / growth opportunity while working on and exploring some of the cutting edge technologies
• This is a full-time role in Mumbai with flexible working hours (including WFH)
• You will be working closely with the founder and be involved in strategic decisions such as back end architecture, tech stack selection, hiring, etc.
• We have multiple products in the pipeline and we need a strong team player who can contribute shoulder-to-shoulder with the existing team in the software development process.
• CTC offered: upto Rs. 22 Lakhs

• Must have qualities: logical & independent thinker; problem solver; result oriented; takes ownership; ability to work indepenently with end-to-end output delivery; ability to structure the code (to avoid rework in future)
• Experience in writing production quality code in NodeJS, Python, Java, or Ruby on Rails
• Hands on experience in design web application using ExpressJS, Koa, Django
• Experience in designing and developing REST API. Familiarity with GraphQL is a plus.
• Proficient in dealing with SQL and NoSQL databases like MySQL, PostgreSQL MongoDB, Elasticsearch.
• Experience with in-memory databases like Redis or MemCache; webserver like Apache, Nginx.
• Experience in stress testing and unit testing and familiarity with testing platforms is a plus
• Proven experience in implementing user authentication and authorization in distributed systems.
• Capability to integrate multiple data sources and databases into one system.
• Experience in designing and developing scalable system.
• Working experience with one of the cloud services like GCP, AWS , Digital Ocean, Azure, etc.
• Knowledge of low-code / no-code tools to expedite production is a plus
• Engineering degree; Computer Science preferably + minimum 2 years of work experience as a Back End Engineer (NOTE: Please do not apply if you do not meet this criteria)
• Clear communication, strong inter-personal skills

• Experience of a lifetime by disrupting the antiquated tech of Real Estate
• Steep learning curve with opportunity to
• Opportunity to generate immense wealth for yourselves from the equity allocation
• A good cash salary
• Standard perks (health insurance, medical benefits etc.)

1. CV screening
2. Coding Test
3. Technical Interview

About Sportz Interactive

Sportz Interactive (SI) works with its clients and partners to revolutionize the sports fan experience across consumption points by creating best-in-class, kickass products. SI was founded in 2002 as a B2B sports content business. Through the years, it gained immense reputation for its state-of-the-art hosted solutions, digital simulators, match centers and fantasy games. Sportz Interactive has a fantastic reputation in the online sports community, having worked with clients across the globe including the likes of The International Cricket Council, STAR Sports, Yahoo!, AOL, Eurosport, Castrol, Web 18, NDTV, Nimbus, Times of India, Rediff.com and Singtel amongst others. 

Sportz Interactive provides in-depth sports information and content and specializes in product development for the web, mobile and other interactive platforms. 
http://www.sportzinteractive.net/">www.sportzinteractive.net 

Designation: Senior Associate 

Office Location: Goregaon East, Mumbai

Position description:

3+ 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.

Years of Experience:- 1.5+

Qualification:- BE Computer Engineering/MCA

Industry:- Software
Location:- Andheri

We are building a global content marketplace that brings companies and content

creators together to scale up content creation processes across 50+ content verticals and 150+ industries. Over the past 2.5 years, we’ve worked with companies like India Today, Amazon India, Adobe, Swiggy, Dunzo, Businessworld, Paisabazaar, IndiGo Airlines, Apollo Hospitals, Infoedge, Times Group, Digit, BookMyShow, UpGrad, Yulu, YourStory, and 350+ other brands.
Our mission is to become the world’s largest content creation and distribution platform for all kinds of content creators and brands.

Our Team

We are a 25+ member company and is scaling up rapidly in both team size and our ambition.

If we were to define the kind of people and the culture we have, it would be -

a) Individuals with an Extreme Sense of Passion About Work

b) Individuals with Strong Customer and Creator Obsession

c) Individuals with Extraordinary Hustle, Perseverance & Ambition

We are on the lookout for individuals who are always open to going the extra mile and thrive in a fast-paced environment. We are strong believers in building a great, enduring

a company that can outlast its builders and create a massive impact on the lives of our

employees, creators, and customers alike.

Our Investors

We are fortunate to be backed by some of the industry’s most prolific angel investors - Kunal Bahl and Rohit Bansal (Snapdeal founders), YourStory Media. (Shradha Sharma); Dr. Saurabh Srivastava, Co-founder of IAN and NASSCOM; Slideshare co-founder Amit Ranjan; Indifi's Co-founder and CEO Alok Mittal; Sidharth Rao, Chairman of Dentsu Webchutney; Ritesh Malik, Co-founder and CEO of Innov8; Sanjay Tripathy, former CMO, HDFC Life, and CEO of Agilio Labs; Manan Maheshwari, Co-founder of WYSH; and Hemanshu Jain, Co-founder of Diabeto.
Backed by Lightspeed Venture Partners