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.

Responsibilities

• Build reusable code and libraries for future use.
• Writing reusable, testable, and efficient code
• Own & build new modules/features end-to-end independently.
• Collaborate with other team members and stakeholders.
• Work in an agile environment to rapidly build high-quality and robust features.
• Participate in DevOps.
• Implementation of security and data protection.

Required Skills

• Master in Node.js and frameworks available for it. (Nest.js / Loopback / AdonisJS)
• Excellent understanding of ES6 and OOP.
• Good understanding of SQL & No-SQL Databases. (MySQL / PostgreSQL)
• Understanding the nature of asynchronous programming and its quirks and workarounds.
• Open Source and DevOps enthusiast.
• Comfortable with Test Driven Development.
• Can learn and adapt fast, as well as identify and solve problems.

Bonus Skills

• Hands-on with TypeScript

Job Perks

• Get to work with a highly passionate team of engineers.
• Open and embracing culture towards the latest hot technologies.
• A high level of freedom & responsibility.

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

• 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

• 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.

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