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.

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.

We are looking for an expert Back-End Developer who is fluent in the latest server-side, web capabilities and technologies. This will include all aspects of the creative process from conceptualizing to completion including design, development, presenting ideas, and working with leadership to build on the InterProducTec brand values, etc.

Node. JS, Java Script, Couch DB, Mongo DB, Database designer, Cloud Computing, Deployment Management, IT Security, DBA, Database Architect, Data modeling, Data integration, InfluxDB, No SQL

 

• Use your knowledge about High Availability, Load Balancing, Scalability, Distributed Computing in order to design database architectures and data structures that can grow with our business
• Collaborate with Product, Engineering and Business teams to drive the architecture, design, development and deployment of our analytics and a reporting portal
• Identify a n d address architecture challenges to ensure a robust, safe, securely accessible, highly available and highly scalable product that meets or exceeds customer and end- user expectations
• Collaborate with leadership and technology teams on creative concepts, and then launch and shape the required design components for each presentation and/ or production
• Able to work closely/ collaborate with multiple product development teams including software developers

 

• Engineering in Computers or IT
• 2-5 years of experience with J S
• 2-5 years of experience with No SQ L (Couch DB / MongoDB)
• Experience with Agile Software Development

• Knowledge in Software Deployment
• Knowledge in IT Security for Web Services
• Expert in using Revision Control Systems (git)
• Must have outstanding communication a n d collaboration skill

 

Who We Are:

 

InterProducTec Virtual Labs Pvt. Ltd. (herein called ‘IPT’) is an Artificial Intelligence and IT company providing virtual support to production processes in varying areas of the food industry. Our intelligent sensor systems help our clients achieve the best quality and the most efficient production processes. IPT is backed by multiple experienced investors and industry savvy founders. Over 70 years of research & development are the foundation of our innovative high-tech solutions. Our headquarters in Munich (Germany), with offices in New York (U) and Mumbai (India) allow us to have a rapidly growing international client base.

 

IPT is proud to offer a value based ideal surrounding to develop your full potential in small teams. You may participate in driving innovations and game changing technology from day one. For our office in Mumbai, we are currently looking to fill the position of a Backend Developer to support our team.

We are hiring!!

 

JOB TITLE: Back-end Developer

EXPERIENCE: 3 - 7 years

LOCATION: Mumbai (Borivali East)

TIMINGS: Indian Shift Timings

TYPE OF WORKING: Work from office

NOTICE PERIOD: 1 month

 

Responsibilities

 

• Participate in the entire application lifecycle, focusing on coding and debugging
• Must have a clear understanding of Database
• 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 language
• 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, Ruby, PHP and Python
• Working knowledge of CMS framework
• Familiarity with front-end languages (e.g. HTML, JavaScript and CSS)
• Excellent analytical and time management skills
• Teamwork skills with a problem-solving attitude

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

 Responsibilities :    

• 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

We are looking for an experienced Back-end developer to join our IT team. You will be responsible for the server-side of our web applications.

If you have excellent programming skills and a passion for developing applications or improving existing ones, we would like to meet you. As a Back-end developer, you’ll work closely with our engineers to ensure system consistency and improve user experience.

Ultimately, you should be able to develop and maintain functional and stable web applications to meet our company’s needs.

• 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
• Liaise with developers, designers and system administrators to identify new features
• Follow emerging technologies

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

Birla Gold and Precious Metals Ltd. are currently hiring for an PHP Developer for its office based at Andheri West. Job responsibilities :- Experience in frameworks knowledge (MVC) like Laravel - Proficient in object oriented PHP programming - Database experience of the following : Postgre SQL, MySQL or MS SQL Server (Preferably My SQL). - Object-oriented application building experience in a professional Agile/Scrum environment Qualication :- BE/ B Tech/ M Tech/ MCA degree holder with 3+ years of experience in PHP Development. Salary : Upto 55k per month About us : Birla Gold & Precious Metal Limited (BGPML) is a unique company born out of the great Indian wisdom of investing in Gold for a secure future. BGPML is in the primary business of Jewellery Retail and E-Commerce. It is a 100% subsidiary of KSS Limited (formerly known K Sera Sera Limited), a listed entity in Bombay Stock Exchange (BSE) and National Stock Exchange (NSE).BGPML prides itself for creating brand Cherish Gold a Virtual Jewellery mall with over thousands of brilliantly crafted and intricately created, eye dazzling designs, manufactured by Best Jewellery Houses of India. All Gold & Diamond products sold on Cherishgold.com are of the highest quality and Hallmark Certified. Cherish Gold has an Easy Return & Exchange Customer Friendly Policy. Cherish Gold can be accessed through multiple platforms like: Apps, Portal, Regional Managers, Ambassadors, Contact Centers or its beautiful and welcoming Physical Stores. All Products Purchased on Cherishgold.com have Doorstep Delivery. For further details you can visit us at www.birlagold.com

Who we are? A smart tech company that places more focus on lateral thinking and uses common sense to create innovative models and create an impression at the world stage. From being an absolute no paper usage to being the most desired organisation to work with and create the perfect partners for business and perfect workplace for any professional. We intend to change the way business will be conducted and managed henceforth What is Eazo? An integrated app for logistics - Supply chain needs to evolve. There are many pieces that needs to be brought together to drive an effective model which now Eazo has designed using it’s ecosystem while tapping in to the largest workforce imagined.

At least 3 years of relevant DBA experience running production DBs with high up-times Proficient in Linux OS and a very good hand on Linux commands Excellent in concepts for both RDBMS and NoSQL DBs Proven excellent technical skills on Postgres, MySQL & (NoSQL DBs is a +) Implement and maintain database security Database tuning and performance monitoring Expertise in DB Clustering Conduct and provide technical DB + application level consultation to application development team Provide direction in capacity planning, performance improvement, and storage management in partnership with Systems and Engineering Development teams