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.

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.
as Postgres, MySQL or MongoDB. Candidates must have an understanding of Microservices and deploying of applications to cloud infrastructure such as AWS, Azure or GCP using git, Docker and
CI/CD pipelines. Candidates must be open to learning new technologies and must be problem solvers.
The job being offered is with a leading Indian Bank as a Client-side deployment where the candidates would be working directly at the Client’s location, reporting directly to the Client’s team leads. The job entails working on exciting new projects at scale.
- 2-5 years of experience in building API services using NodeJS Express and related
frameworks
- Expert level understanding of NodeJS asynchronous runtime
- Expert level understanding of Javascript concepts on callbacks and closures
- Experience with Postgres, NoSQL, Redis, and Firebase real-time database
- Experience with AWS services like Elastic Beanstalk, Cloudfront, S3, EC2, Lambda,
API Gateway, SQS, etc
- Understanding of patterns and techniques for building scalable back-end
infrastructure including caching, rate limiting, authentication, and authorization
schemes.
- Experience in building highly scalable and high throughput services with
millisecond response times
- Experience working in a collaborative team environment
- Excellent communication & interpersonal skills
- Willingness to learn and pick up new technology along with patience to mentor
Bonus skills -
- Experience with ElasticSearch, Puppeteer
- Experience writing unit tests
Role - Lead- Backend Engineering
Work Mode- Hybrid
Location- Thane, Mumbai.
About the Company:
Ventura is an omnichannel trading and investment platform with a network of branches, sub-brokers and Digital Channels. Founded in 1994, the company is now entering the next phase of growth by pivoting to a digital-first approach and strengthening its direct-to-consumer franchise. The company has now carved out a separate fintech vertical tasked with digital transformation using cutting-edge technology and bringing in fresh talent.
Job Description:
We are looking for a Backend Engineering lead whose highly talented individuals come from diverse backgrounds and are looking to solve real client problems at scale. We are looking for passionate techies with skills primarily around AWS and the latest tech stack who are aspiring for a fast-track career.
Join us if you like to:
· Build out a next-gen fintech product from ground 0
· Opportunity to influence the design of the product
· Flexible and Hybrid work environment running out of Slack
· Flat org structure
· Stay up-to-date on industry trends and emerging technologies
We’ll need you to bring:
· Bachelor's degree in Engineering or Master's degree in CS/ IT.
· 7+ years of experience
· Clean coding skills around C++/Python/NodeJS/Go.
· Knowledge of Redis.
· Experienced in SQL with Postgres and Good to have Influx DB.
· Knowledge of NGINX or any other API gateway.
· Strong AWS skills, techies with certifications from AWS are particularly encouraged to apply - AWS API Gateway, Route53, Lambda, EC2, RDS, SQS, CloudWatch, Cognito, QuickSight
Demonstratable experience around writing testable code, working with git, doing peer-level code review, daily standups, and generally championing software excellence
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
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


Positions : 2-3
CTC Offering : 40,000 to 55,000/month
Job Location: Remote for 6-12 months due to the pandemic, then Mumbai, Maharashtra
Required experience:
Minimum 1.5 to 2 years of experience in Web & Backend Development using Python and Django with experience in some form of Machine Learning ML Algorithms
Overview
We are looking for Python developers with a strong understanding of object orientation and experience in web and backend development. Experience with Analytical algorithms and mathematical calculations using libraries such as Numpy and Pandas are a must. Experience in some form of Machine Learning. We require candidates who have working experience using Django Framework and DRF
Key Skills required (Items in Bold are mandatory keywords) :
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. Some form of experience with NLP and Deep Learning using any of Pytorch, Tensorflow, Keras, Scikit-learn or similar
8. Hands on experience with RDBMS such as Postgres or MySQL
9. Comfort with Git repositories, branching and deployment using Git
10. Working experience with Docker
11. Basic working knowledge of ReactJs
12. Experience in deploying Django applications to AWS,Digital Ocean or Heroku
KRAs includes :
1. Understanding the scope of work
2. Understanding and adopting the current internal development workflow and processes
3. Understanding client requirements as communicated by the project manager
4. Arriving on timelines for projects, either independently or as a part of a team
5. Executing projects either independently or as a part of a team
6. Developing products and projects using Python
7. Writing code to collect and mathematically analyse large volumes of data.
8. Creating backend modules in Python by building or reutilizing existing modules in a manner so as to provide optimal deliveries on time
9. Writing Scalable, maintainable code
10. Building secured REST APIs
11. Setting up batch task processing environments using Celery
12. Unit testing prepared modules
13. Bug fixing issues as reported by the QA team
14. Optimization and performance tuning of code
Bonus but not mandatory
1. Nodejs
2. Redis
3. PHP
4. CI/CD
5. AWS

RealPort is a digital brokerage platform that provides small institutional investors around the
globe with access to single-asset infrastructure investments, sponsored by highly reputable
asset managers. Low minimum investment tickets and reduced fees allow small investors to
build customized, diversified co-investment portfolios across multiple sectors and risk categories
like their larger counterparts. In-depth risk analysis provided by RealPort’s exclusive analysis
partner Scope offers greater control and improved transparency on individual and portfolio risk.
Asset managers benefit from global access to professional investors and an improved time-/
cost- efficient fundraising process through RealPort's all-on-one platform.
We are:
● innovative problem solvers
● transparent
● trustworthy
● pragmatic
● dependable
● diverse,
... and are looking for a talented and dedicated Senior Python Developer with experience
building complex applications to join our team to work on an innovative FinTech platform.
You will be working alongside our Product and Technology teams in our Mumbai office.
You have a good understanding of:
● Python 3
● node.js
● PostgreSQL
● API / REST
● Django 2x and Django Rest Framework
● Supervisor
● Jenkins
● AWS
● Linux (Ubuntu)
● boto3.
Ideally, you have:
● Min. 5-8 years of experience building web application engines
● University degree from a reputable university
● Excellent communication skills in English and knowledge of European languages
(German and/or French preferred) is an added bonus
● Experience in banking/financial API integrations
● Familiarity with blockchain (open zeppelin, ERC223, truffle, solidity, solidity-coverage,ganache-cli, mocha-js).
You job will consist of the following:
● Deliver smooth functionality of the application while working closely with the Front end team
● Build efficient back-end features in Python
● Help design and implement functional requirements
● Manage testing and bug fixes
● Ultimately, you’ll build highly responsive web applications that align with our business
needs.
Others consider you to be/have the following:
● Excellent at communicating with different people from different walks of life and
cultures/work and communicate across multiple time zones
● Excellent demeanor, manners, and communication skills
● Exceptional organizational skills with great attention to detail
● Open/transparent, but trustworthy and trusting
● Ability to work independently and handle high volumes of work
● Ability to work on complex and uncertain topics independently
● Solution-oriented
● Strong analytical skills
● Critical, but positive and constructive
● Efficient, dependable, and accountable
● Discreet
Benefits:
● Work on a ground-breaking product at the forefront of FinTech innovation on a global
basis
● Opportunity to work with open-minded, experienced, talented, cross-functional, and
cross-cultural teams along with an innovative network of partners who are some of the
biggest companies in the industry
● Opportunity to travel for work
● Learn from teams with 15+ years product development experience
● Competitive salary package

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


FreightCrate Technologies is a Logistics Technology company that aims to transform international shipping through innovative and cost-effective tech solutions that can mutually benefit exporters, importers and logistics service providers.
Our web-platform, FreightCrate offers online tech-enabled quote and shipment management solutions for export and import businesses to and from more than 50,000 global locations.
We have had more than 50 media coverages including Entrepreneur, Maritime Gateway, Cargotalk, BW Disrupt, INC42, Silicon India, Tech Observer and several other newspapers and online magazines.
Our vision is to utilize cutting edge technology, engineering, deep learning and artificial intelligence to create an intelligent freight management system that can automate and optimize international trade operations for global businesses.
FOUNDERS:
Samir Lambay is the Co-Founder and CEO with an MSc in Shipping, Trade and Finance from Cass Business School, London, UK with Distinction.
Samir has worked in the shipping and logistics industry across both family businesses and multinational companies. His most recent job was at DB Schenker Logistics (Part of Deutsche Bahn Group - Fortune 200) where he was the youngest Vertical Manager globally and won two awards including Vertical Manager of the year and a Global Award.
Ruchi Dogra is a Co-Founder & Director and is in charge of sales and marketing. She has worked for over 15 years across the top 3 logistics/supply chain companies globally. She set-up the hotel, wines and beverages vertical at Kuehne & Nagel and DB Schenker. Her latest assignment was at DHL Global Forwarding where she worked as a Vertical Manager for Engineering and Manufacturing; handling top Indian and multinational accounts including several Fortune 100 companies. She brings with her an extensive knowledge in strategy, sales, operations and customer service.
Title
Software Developer
Description
The Software Developer’s role is to develop new innovative programs to optimize and automate user experiences by creating high-quality, innovative and fully performing software that complies with coding standards and technical design.
Should be familiar with the software development life cycle (SDLC) from preliminary system analysis to tests and deployment.
Compensation
As this is a new business the compensation is negotiable and we will make an offer depending on the experience of the candidate.
Responsibilities
• Design flowcharts, layouts and documentation to identify requirements and solutions
• Produce clean, efficient code based on specifications
• Execute full software development life cycle (SDLC)
• Integrate software components and third-party programs and API’s
• Troubleshoot, debug and upgrade existing software
• Gather and evaluate user feedback
• Recommend and execute improvements
• Create technical documentation for reference and reporting
Skill Sets:
• PHP/Python
• AWS & Cloud-computing
• Mysql/PostgreSql
• Memcache/Redis
• Frontend technologies HTML, CSS, JS, ReactJS, Vue.js
• Frameworks like Django
• DevOps
• ELK
• Tools like Datadog, NewRelic, etc
• Shell-scripting
• Setting & managing dev/beta/prod environments
• Tools like Jenkins, Chef, Puppet, Ansible, etc.
• Knowledge of Solr/Elastic search will be an advantage
Personal Requirements:
• Min of 3+ years of Hands on experience in Web development, algorithm design, implementation, architecture design, product management, databases and UI/UX in consumer facing applications.
• Experience on projects involving engineering and algorithmic functions, machine learning, deep learning and artificial intelligence is very advantageous.
• Creative self-starter who is comfortable with both taking initiative and working in teams.
• Previous experience working on logistics technology products is advantageous but not mandatory.
• Strong communication skills.
• Willingness to learn and utilize emerging technologies.
• Sincere passion to use disruptive technologies that can be globally significant.

