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.

About the Role:

We’re looking for a Python Developer to build, optimize, and scale applications that power our trading systems. You’ll work on automation, server clusters, and high-performance infrastructure in a fast-paced, tech-driven environment.

What you’ll do:

• Build and test applications end-to-end.
• Automate workflows with scripts.
• Optimize system performance and reliability.
• Manage code versions and collaborate with peers.
• Work with clusters of 100+ servers.

What we’re looking for:

• Strong Python fundamentals (OOP, data structures, algorithms).
• Experience with Linux commands, Bash scripting.
• Basics of Numpy, Matplotlib, and PostgreSQL.
• Hands-on with automation and scripting tools.
• Problem solver with a focus on scalability & optimization.

Why Dolat?

• Work at the intersection of finance & tech.
• Opportunity to solve complex engineering problems.
• Learn and grow with a team of smart, collaborative engineers.

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.

Job Description   - Omniflow and Java Developer

Should have working experience between 6-8 years in Java development

Mandatory skills are good knowledge of object oriented concepts, experience of working on Spring boot application, should have worked on hibernate ORMS and candidate must have clear understanding of database concepts

Optional skills include knowledge of angular framework and postgreSQL database

Good to have knowledge of jBPM open source workflow

Qualifications

Master or Bachelor degree in Engineering/Computer Science /Information Technology

Additional Information

Skills and Competencies:
Strong documentation skills
Excellent communication skills, both written and verbal
Decision making and problem solving skills
Good organizational skills        

Key Responsibilities:

• SDLC development of product features, enhancements, UAT/production issues.
• Work with development team members for development of product features.
• Client-side and server-side development.
• Develop and manage well-functioning databases and application.
• Write/ design product APIs and write unit test cases.
• Follow standard agile scrum practices for software development.
• Peer review, pull requests, code refactoring and managing source code per standards and ensure quality. 

Required Experience & Skills:

• 5+ years of software development experience using Microsoft .Net technology stack.
• Strong experience in .Net, .Net Core, C#, Entity Framework, SQL server, JavaScript, jQuery, etc.
• Experience in using unit test framework e.g., xUnit, Moq.
• Experience in Web API development.
• Experience in Agile / SCRUM development process.
• Good to have experience in Domain driven design development and Microservice architecture.
• Excellent communication and teamwork skills
• Good to have knowledge and experience in ABP.IO framework, Angular 8+, PostgreSQL and AWS cloud service and CI/CD process.

• 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

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

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.

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)