Cutshort logo
Query optimization Jobs in Mumbai

11+ Query optimization Jobs in Mumbai | Query optimization Job openings in Mumbai

Apply to 11+ Query optimization Jobs in Mumbai on CutShort.io. Explore the latest Query optimization Job opportunities across top companies like Google, Amazon & Adobe.

icon
Mumbai
3 - 6 yrs
₹6L - ₹8L / yr
skill iconPostgreSQL
Query optimization
Stored Procedures
Database Design
SSAS
+12 more

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.

Read more
Remote, Hyderabad, Bengaluru (Bangalore), Chennai, Mumbai, Pune, Kolkata, NCR (Delhi | Gurgaon | Noida)
7 - 12 yrs
₹30L - ₹55L / yr
skill iconJava
skill iconPython
Engineering Management
Engineering Manager
skill iconPostgreSQL
+3 more

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.
Read more
Ashnik
Agency job
via InvokHR by Sandeepa Kasala
Bengaluru (Bangalore), Mumbai
5 - 15 yrs
₹7L - ₹20L / yr
skill iconPostgreSQL
Linux/Unix
Linux administration
Production support
Installation
+2 more

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

Read more
Reunion

at Reunion

1 recruiter
Kshitij Gupta
Posted by Kshitij Gupta
Mumbai
2 - 3 yrs
₹15L - ₹15L / yr
skill iconPython
skill iconDjango
skill iconFlask
Google Cloud Platform (GCP)
skill iconAmazon Web Services (AWS)
+3 more

Role Description

  • 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


What are we looking for in the candidate?

  • 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


What can you expect to gain from the role?

  • 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.)

Hiring Process

  1. CV screening
  2. Coding Test
  3. Technical Interview
Read more
InterProducTec Virtual Labs Pvt. ltd.
Krishnadas K
Posted by Krishnadas K
Navi Mumbai
2 - 5 yrs
₹5L - ₹12.5L / yr
skill iconMongoDB
CouchDB
NOSQL Databases
InfluxDB
skill iconJavascript
+5 more

We are looking for an expert Back-End Developer who is fluent in the latest server-side, web capabilities and technologies. This will include all aspects of the creative process from conceptualizing to completion including design, development, presenting ideas, and working with leadership to build on the InterProducTec brand values, etc.

 

Keywords:

Node. JS, Java Script, Couch DB, Mongo DB, Database designer, Cloud Computing, Deployment Management, IT Security, DBA, Database Architect, Data modeling, Data integration, InfluxDB, No SQL

 

Job Responsibilities:

  • Use your knowledge about High Availability, Load Balancing, Scalability, Distributed Computing in order to design database architectures and data structures that can grow with our business
  • Collaborate with Product, Engineering and Business teams to drive the architecture, design, development and deployment of our analytics and a reporting portal
  • Identify a n d address architecture challenges to ensure a robust, safe, securely accessible, highly available and highly scalable product that meets or exceeds customer and end- user expectations
  • Collaborate with leadership and technology teams on creative concepts, and then launch and shape the required design components for each presentation and/ or production
  • Able to work closely/ collaborate with multiple product development teams including software developers

 

Primary Skills:

  • Engineering in Computers or IT
  • 2-5 years of experience with J S
  • 2-5 years of experience with No SQ L (Couch DB / MongoDB)
  • Experience with Agile Software Development

Preferred Skills:

  • Knowledge in Software Deployment
  • Knowledge in IT Security for Web Services
  • Expert in using Revision Control Systems (git)
  • Must have outstanding communication a n d collaboration skill

 

Who We Are:

 

InterProducTec Virtual Labs Pvt. Ltd. (herein called ‘IPT’) is an Artificial Intelligence and IT company providing virtual support to production processes in varying areas of the food industry. Our intelligent sensor systems help our clients achieve the best quality and the most efficient production processes. IPT is backed by multiple experienced investors and industry savvy founders. Over 70 years of research & development are the foundation of our innovative high-tech solutions. Our headquarters in Munich (Germany), with offices in New York (U) and Mumbai (India) allow us to have a rapidly growing international client base.

 

IPT is proud to offer a value based ideal surrounding to develop your full potential in small teams. You may participate in driving innovations and game changing technology from day one. For our office in Mumbai, we are currently looking to fill the position of a Backend Developer to support our team.
Read more
Saasspot Technologies Pvt Ltd
Navi Mumbai, Mumbai
3 - 7 yrs
₹8L - ₹12L / yr
skill iconNodeJS (Node.js)
skill iconExpress
skill iconPostgreSQL
skill iconElastic Search
skill iconAmazon Web Services (AWS)
Amplispot, a product of SAASSPOT is a pre-configured marketing automation platform. A "Do It for Me" marketing where our expert's design, schedule & configure content and campaigns. Providing your agents/advisors with a bot-based platform to approve the content & campaigns. We endeavor to help organizations engage their existing and prospective customers via their network of agents/sub-brokers/advisors on the digital dimension. We are looking for energetic and committed folks ready to grow along with us and help us build an awesome product and a great organization.

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

 

Read more
Software development
Bengaluru (Bangalore), Pune, Mumbai, Noida
5 - 10 yrs
₹5L - ₹15L / yr
skill iconPostgreSQL

Postgress developer cum database architect

5-7 years experience


Knowledge and experience, specifically PostGre

-           SQL

-           Query Optimization / Optimization strategies (in PostGre)

-           AWS - RDS Relational Databse Service

-           Optional: AWS – RDS API / PostGre API

Read more
Rajasthan Studio

at Rajasthan Studio

1 recruiter
Amita Tambe Irani
Posted by Amita Tambe Irani
Mumbai, Jaipur, Jajpur
2 - 10 yrs
₹7L - ₹15L / yr
skill iconPHP
Yii
RESTful APIs
GraphQL
skill iconJavascript
+6 more

Rajasthan Studio is looking for young and bright minds for its upcoming innovative, never-experienced-before app platform for virtual art experiences.

 

We are looking for programmers with problem-solving skills and critical thinking abilities for the position of Back End developer. Back End developers are responsible for creating a bridge between customers and business logic, optimizing applications for maximum efficiency, creating dashboards for internal teams, and maintaining brand consistency across the application, among other duties.

 

Backend Web Developers are responsible for managing the interchange of data between the server and the users. The role's primary focus will be the development of all server-side logic, definition, and maintenance of the central database, and ensuring high performance and responsiveness to requests from the front-end. A basic understanding of front-end technologies is necessary as well.

 

Responsibilities -

  • Creating RESTful API/GraphQL to be consumed by Flutter developers
  • Building reusable code and libraries for future use
  • Optimization of the application for maximum speed and scalability
  • Implementation of security and data protection
  • Design and implementation of data storage solutions
  • Participate in the entire application lifecycle, focusing on coding and debugging
  • Write clean code to develop functional web applications
  • Troubleshoot and debug applications
  • Provide training and support to internal teams

 

Skill & Qualifications -

  • Basic understanding of front-end technologies and platforms, such as JavaScript, HTML5, and CSS3
  • Understanding accessibility and security compliances
  • User authentication and authorization between multiple systems, servers, and environments
  • Integration of multiple data sources and databases into one system
  • Management of hosting environment, including database administration and scaling an application to support load changes
  • Data migration, transformation, and scripting
  • Setup and administration of backups
  • Outputting data in different formats
  • Understanding differences between multiple delivery platforms such as mobile vs desktop, and optimizing output to match the specific platform
  • Creating database schemas that represent and support business processes
  • Implementing automated testing platforms and unit tests
  • Proficient understanding of code versioning tools, such as Git
  • Proficient understanding of OWASP security principles
  • Understanding of “session management” in a distributed server environment
  • Knowledge of Yii framework - version 2 (preferred)
Read more
uFaber Edutech

at uFaber Edutech

6 recruiters
Tejaswi  Huded
Posted by Tejaswi Huded
Remote, Mumbai
3 - 6 yrs
₹10L - ₹15L / yr
skill iconDjango
skill iconPython
MySQL
skill iconPostgreSQL
skill iconMongoDB
+3 more
Max CTC - 15 Lacs fixed
Work Ex 3 - 6 yrs
Qualifications Graduation (BE / B Tech / BCA/MCA/BSC) with specialisation in Computer Science is Preferred or B.E / B Tech
Notice Period - Immediate or max 20 days or candidates with BUY OUT OPTION

Targetted Sector / Industry - IT, Ecommerce / Product startups, Edu Tech companies

Location : Kurla Mumbai, willing to relocate (if your not from Mumbai)

Should have a high performance Laptop + Internet Connection(Currently to start working remotely)

About the Company uFaber is a well-funded EduTech startup, founded by serial entrepreneurs from IIT Bombay. Technology has changed almost every aspect of our life but the way we learn is still the same. We know that we have chosen a very complex and difficult problem to solve but if problem is not challenging, what's the fun! We are building a team of super smart and high IQ people

Skills Required :

1) Hands on experience in python - django / flask / django restful API frameworks
- Having worked as an individual contributor - developing the project / product end to end from scratch
- Having worked as a backed/fullstack developer
- Having worked on high user base products / apps(min 10 - 20k) users
- Having solved or worked on production issues after the product release
- Having lead a team of 2-4 developers(DESIRED, not mandatory)
2) Good understanding of HTML / CSS | SCSS / Javascript / jQuery, responsive web design using bootstrap
3) Basic understanding of MVC, JavaScript development (Angular is a big bonus)
4) Understanding of code versioning tools, such as Git
5) Management of hosting environment, including database administration (preferebly relational databases MySQL, Postgres, etc)
6) Strong theoritical and practical knowledge of the work - the fundamentals must be clear.
7) Smart, confident and good communication skills.

What you are suppose to do :

1. Plan and execute the long term development roadmap.
2. Code high quality web and mobile apps in django and angular.

Max CTC - 15 Lacs fixed
Work Ex 3 - 6 yrs
Qualifications Graduation (BE / B Tech / BCA/MCA/BSC) with specialisation in Computer Science is Preferred or B.E / B Tech
Notice Period - Immediate or max 20 days or candidates with BUY OUT OPTION
Targetted Sector / Industry - IT, Ecommerce / Product startups, Edu Tech companies
Location : Mumbai, willing to relocate
Read more
ROCKETBOX

at ROCKETBOX

2 recruiters
Anmol Chopra
Posted by Anmol Chopra
Mumbai
1 - 4 yrs
₹6L - ₹8L / yr
skill iconRuby on Rails (ROR)
skill iconPostgreSQL
skill iconMongoDB
skill iconRedis
skill iconJavascript
+3 more
Technical Overview We are primarily a rails shop with postgres/postgis, mongodb and redis at database layer and leverage AWS via chef for infrastructure. It may be evident from our choice of tools and our current team composition that we are here for the long haul and intend to grow aggressively. We value agile methodologies like code reviews, extensive test suite, continuous integration, extensive testing, frequent deployments, scrum and the best standard practices. You will be working alongside one of the best teams who write crisp clean code. Who are we looking for? We’re searching for a strong, friendly, flexible, and seasoned people to strengthen our engineering team. We value curiosity and eagerness to learn. When presented with a challenge, you question until you are clear what the problem is and then do whatever it takes to get the task done. You need to be crisp and detailed oriented, and willing to own an outcome and run with it, without somebody telling you exactly how to get there. We believe that is what it takes to build a high performing team. Working here means being part of a team that works hard, fast and cleverly to keep growing at rocket speed. 1) You are an experienced Rails developer, designed and delivered production ready apps. 2) Your code is modular, readable and unit-tested. You are proud of what you have built. 3) Comfortable and productive in a unix-like shell environment 4) You excel in a team environment by collaborating with or supporting your peers. You love to teach and you are not afraid to learn & implement something new 5) Follows the latest updates in the ruby community. 6) You have good demonstrable knowledge of front-end technologies like JS, jQuery. 7) You have experience with RESTful APIs and have been part of developing on in the past 8) You are an SQL ninja and have a working knowledge of NoSQL (Redis, MongoDB) 9) You are interested in or experienced with at least one another programming language/ framework and can explain why that language is worthwhile. If that’s you, your responsibilities will be 1) Take ownership of a product, maintain the existing product, work independently, always ensuring the code quality is of the highest standard 2) Find solutions to seemingly difficult problems and implement them in code What you can expect from us 1) Fun-loving, motivated co-workers who you would love working with 2) An environment where you are encouraged to question, experiment, take the risk and push the envelope. 3) Opportunity and resources to do your best work and pursue your dreams Please apply along with the latest resume and a link to your project portfolio or github profile if you would like to discuss this role further. You can still apply if you don’t satisfy some of the requirements. We prefer candidates who can join us immediately or ones with a short notice period. Work Location: Mumbai Compensation: 6-8 LPA Contact: [email protected]
Read more
Eazo Logistics Technology Pvt Ltd
Nikhil Gangurde
Posted by Nikhil Gangurde
Navi Mumbai
2 - 6 yrs
₹4L - ₹6L / yr
Web Service Definition Language (WSDL)
AWS CloudFormation
Database Design
Object Oriented Programming (OOPs)
Relational Database (RDBMS)
+2 more
Who we are? A smart tech company that places more focus on lateral thinking and uses common sense to create innovative models and create an impression at the world stage. From being an absolute no paper usage to being the most desired organisation to work with and create the perfect partners for business and perfect workplace for any professional. We intend to change the way business will be conducted and managed henceforth What is Eazo? An integrated app for logistics - Supply chain needs to evolve. There are many pieces that needs to be brought together to drive an effective model which now Eazo has designed using it’s ecosystem while tapping in to the largest workforce imagined.
Read more
Get to hear about interesting companies hiring right now
Company logo
Company logo
Company logo
Company logo
Company logo
Linkedin iconFollow Cutshort
Why apply via Cutshort?
Connect with actual hiring teams and get their fast response. No spam.
Find more jobs
Get to hear about interesting companies hiring right now
Company logo
Company logo
Company logo
Company logo
Company logo
Linkedin iconFollow Cutshort