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: Backend Developer – Design Qandy

Who are we?

Design Qandy delivers personalised luxury interior design to India’s discerning homeowners and corporates. Led by highly admired luxury brand builders, internationally trained designers, world-class technology professionals and curated teams of turnkey project execution specailists. We seek perfection in design and are committed to bringing back trust and excitement in the design process.

Know more about us on designqandy.com and https://instagram.com/designqandy?igshid=YmMyMTA2M2Y=

Our work culture?

We are a lean team of high performing go-getters, we take ownership in our roles and lead with knowledge. Debates and discussions are an important part of our culture and we encourage people to bring unique perspectives to their conversations. Most importantly, we love solving problems.

Each day is inspiring and we encourage you to apply for this role and experience it for yourself.

What would you be required to do?

·      Write code and tests, build prototypes, solve issues, profile, and analyze bottlenecks

·      Design performance gauging, building robust APIs to support mobile and desktop clients

·      Manage and optimize scalable distributed systems on the cloud

·      Optimization of web applications for performance and scalability

·      Develop automated tests to ensure business needs are met and allow for regression testing

·      Participate in the entire application lifecycle, focusing on coding and debugging

·      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

What skills we are looking for?

·      Good communication skill to communicate with stakeholders, project managers, quality assurance teams, Regularly and other developers regarding progress on the long-term technology roadmap

·      Curious and progressive mind to Create and maintain workflows with teams to provide visibility and to ensure workload balance for consistent visual designs

·      Good technical knowledge to Produce quality code, raising the bar for the whole team on quality and speed

·      Through analytical skills to Recommend system solutions by comparing advantages and disadvantages of custom development and purchase alternatives

Skills Needed:

·      PHP Laravel Framework, PHP Design Patterns.

·      Proficient in MySQL, PostgreSQL, MongoDB

·      APIs, REST API, SOAP API, API Security, Open APIs

·      Push Notifications, Laravel Events, Queue, Observers

·      Excellent foundation in computer science, algorithms, and web design

·      Experience writing highly secure web applications

·      Experience with core AWS web-enabling technologies

·      Growth mindset, challenging status quo to find new solutions and out-of-the-box ideas

·      Experience designing RESTful APIs, specifically for mobile apps

·      Computer science degree or equivalent experience

·      Experience leading a team

·      3-6 Years’ experience in back-end development.

• Writing efficient, reusable, testable, and scalable code
• Understanding, analyzing, and implementing – Business needs, feature modification requests, conversion into software components
• Integration of user-oriented elements into different applications, data storage solutions
• Developing – Backend components to enhance performance and receptiveness, server-side logic, and platform, statistical learning models, highly responsive web applications
• Designing and implementing – High availability and low latency applications, data protection and security features
• Performance tuning and automation of application
• Working with Python libraries like Pandas, NumPy, etc.
• Creating predictive models for AI and ML-based features
• Keeping abreast with the latest technology and trends
• Fine-tune and develop AI/ML-based algorithms based on results

Good proficiency in,

• Python frameworks like Django, etc.
• Web frameworks and RESTful APIs
• Core Python fundamentals and programming
• Code packaging, release, and deployment
• Database knowledge
• Circles, conditional and control statements
• Object-relational mapping
• Code versioning tools like Git, Bitbucket

Fundamental understanding of,

• Front-end technologies like JS, CSS3 and HTML5
• AI, ML, Deep Learning, Version Control, Neural networking
• Data visualization, statistics, data analytics
• Design principles that are executable for a scalable app
• Creating predictive models
• Libraries like Tensorflow, Scikit-learn, etc
• Multi-process architecture
• Basic knowledge about Object Relational Mapper libraries
• Ability to integrate databases and various data sources into a unified system
• Basic knowledge about Object Relational Mapper libraries
• Ability to integrate databases and various data sources into a unified system

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)

Years of Experience:- 1.5+

Qualification:- BE Computer Engineering/MCA

Industry:- Software
Location:- Andheri

• Team with top-notch engineers, product managers, program managers, DevOps and QA following agile development methodologies
• Review functional requirements, providing technical feedback on feasibility and architectural approach and framework.
• Design and develop web / mobile applications
• Create Prototype and/or Proof of Concepts (POCs) when necessary
• Act in a technical leadership capacity: Mentor junior engineers and new team members, perform code reviews and apply technical expertise to challenging programming and design problems
• Utilize Agile Development, SCRUM / Pair / Extreme Programming methodologies
• Design and develop supporting components and microservices for the backend tiers focusing on fault-tolerance and scalability in a multi-tenant enterprise environment
• Maintain and improve the functionality and performance of the existing web applications
• Help shape and execute the technical roadmap to develop next generation features; integrate corporate- and product-level architecture principles and goals into the teams project work through designs, implementation strategies, and project planning.
• Drive a culture of quality, technical curiosity, continuous improvement, and evidence-based data driven decision making in the organization.
• Execute other Duties as assigned

• 3+ years of experience developing Backend, API and data-based applications/software
• Experience with one of the major relational databases (MySQL, Oracle, Postgres) and NoSQL databases (Mongo DB, Cassandra, Dynamo DB or such)
• Expert object-oriented programming experience using Java
• Strong OO design and programming skills in Java, Hibernate, JPA, Spring Boot
• Worked in Maven, JPA, REST services, Postman
• Working knowledge on Spring Security / Spring Batch / ZUUL / Eureka / Hysterix
• Exposure with Frontend technologies (React.js, Angular or Ruby-on-Rails)
• Require experience and Strong understanding of entire Software Development Life Cycle (SDLC), Agile (Scrum), Software design/architecture process, unit testing & Test-Driven Development (TDD)
• Experience with web services (consuming or creating)
• Experience managing Cloud infrastructure (resources and service) in AWS, Azure and/or GCP
• Strong knowledge of SOA, object-oriented programming, design patterns, multi-threaded application development
• Experience in reporting and analytics, queuing and real-time streaming systems
• Git or similar distributed SCM tools experience.

As a Senior Software Engineer you have complete ownership of building out the Docexa product along with product people and the rest of the engineering team. This role will act as a great springboard to accelerate career growth & transition into a Tech Lead level role.

Your daily life

• Architecting of the whole platform
• Development of server-side logic
• Building new services and APIs
• Developing core business logic
• Maintenance of current APIs
• Improving the performance and reliability of our systems as we scale

Must-have skills

• You’ve been building web applications professionally for 4+ years
• You’re proficient in PHP 7, Laravel, and PostgreSQL
• You possess strong OOP and design pattern knowledge
• You are familiar with modern technology systems: AWS, load balancers, Kafka queues, caching, etc.
• You write understandable, testable and easy to maintain code
• You’ve the ability to build RESTful APIs
• Explaining complex technical concepts to designers, support team, and fellow engineers is not a problem for you
• Well versed with the fundamentals of computer science and distributed systems