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.

Technical Expertise:

• Strong proficiency in OOP concepts, C#, .NET Core, Entity Framework, React, SQL Server, PostgreSQL, Dapper, ADO.NET, LINQ, and Web API Development.
• Experience with event-driven architecture and messaging systems such as Kafka or Rabbit MQ.
• Excellent debugging, troubleshooting, and performance optimization skills.
• Expertise in database development including tables, views, stored procedures, triggers, and functions.
• Hands-on experience with unit testing frameworks (XUnit).
• Proficiency in JWT services, Git, and third-party API integration.
• Experience in code review and mentoring junior developers.
• Preferred Qualification:
• Bachelor’s Degree in Business, Marketing, Communications, or related field.

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.

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.

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

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

Your 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. You will also be responsible for integrating the front-end elements built by your co-workers into the application. Therefore, a basic understanding of front-end technologies is necessary as well.

• 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

• Strong proficiency with JavaScript & OOPS
• Knowledge of Node.js and frameworks available for it 
• Understanding the nature of asynchronous programming and its quirks and workarounds
• Good understanding of server-side CSS preprocessors 
• Basic understanding of front-end technologies, such as HTML5, and CSS3
• Understanding accessibility and security compliance
• User authentication and authorization between multiple systems, servers, and environments
• 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
• Knowledge of AWS will be preferable