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.

• 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

• 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

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

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

Key Skills Required :

1. Proficiency in Python 3.x based web and backend development
2. Solid understanding of Python concepts
3. Strong experience in building web applications using Django
4. Experience building REST APIs using DRF or Flask
5. Experience with some form of Machine Learning (ML)
6. Experience in using libraries such as Numpy and Pandas
7. Hands on experience with RDBMS such as Postgres or MySQL including querying
8. Comfort with Git repositories, branching and deployment using Git
9. Working experience with Docker
10. Basic working knowledge of ReactJs
11. Experience in deploying Django applications to AWS,Digital Ocean or Heroku

Responsibilities :

1. Understanding requirement and congributing to engineering solutions at a conceptual stage to provide the best possible solution to the task/challenge
2. Building high quality code using coding standards based on the SRS/Documentation
3. Building component based, maintainable, scalable and reusable backend libraries/modules.
4. Building & documenting scalable APIs on the Open Spec standard
5. Unit testing development modules and APIs
6. Conducting code reviews to ensure that the highest quality standard are maintained
7. Securing backend applications and APIs using industry best practices
8. Troubleshooting issues and fixing bugs raised by the QA team efficiently.
9. Optimizing code
10. Building and deploying the applications

1. Building REST API's & Services In Django Framework
2. Building reusable code and libraries for future use
3. Optimization of the application for maximum speed and scalability
4. Implementation of security and data protection
5. Design and implementation of the database schema
6. Design and implementation of data storage solutions
7. Implementing CI/CD pipeline

• Proficient knowledge of a back-end programming language Python
• Hands-on experience with Python Frameworks like Django
• Proficient knowledge of MySQL, PostgreSQL
• Creating database schemas that represent and support business processes (Relational & NoSQL)
• Understanding of queueing systems like Redis/AWS SQS
• User authentication and authorization between multiple systems, servers, and environments
• Data migration, transformation, and scripting
• Understanding differences between multiple delivery platforms such as mobile vs desktop, and optimizing output to match the specific platform
• Proficient understanding of code versioning tools, such as Git

• Experience in Docker
• HandsOn Knowledge with implementing CI/CD pipelines
• Experience in managing applications on AWS
• Management of hosting environment, including database administration and scaling application to support load changes
• Product wide application-level thinking on API and data modeling