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.

Key Skills
- 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

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

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.

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

Primary Responsibilities:

• 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

Knowledge Skills and Abilities: Must have:

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

If you find the above Job Description matching with your skills & experience and only if you can join in a maximum of 10 days, please revert to this email with your interest, specifying your current/ last drawn salary & expectations

We are a Uniserved is at heart a curated marketplace, where we provide our customers (Small and medium-sized System Integrators and Hardware Distributors) with validated skilled resources in various technologies like Enterprise Telephone, Information Security, Cloud Applications etc. We also provide our freelance partners (Small companies and freelancers with the above-mentioned skills) with access to the infrastructure and credibility of an established setup Job Description We are looking for a Django developer to join the team developing the Uniserved ISM (infrastructure Services Management) product. We are looking for someone who has the following technical skills: - 2-3 years experience in Python Development. - 2-3 years experience in Django Web Services (REST) implementation. - Experience with Postgresql - Should be comfortable on Git and have used it regularly Good to Have skills: - Familiar with Linux working environment. - Familiarity with nginx,gunicorn. - Ability to work on projects with the Agile Team. - Experience in using AWS(Amazon Web Services) with at least one service/product. We are looking for the following non-negotiable personality traits: - Dedication to completing the task on hand - Ability to solve problems and more importantly when to ask for help We have a fun working environment, with a startup vibe, even though we are a four year old company. We can promise you continual challenges and an excellent opportunity for growth. Will explain in greater detail during the interview.

# DEVELOPMENT AT CODALYZE : - You'll help create and build beautiful, scalable, reliable and robust software that matters using modern JavaScript and software development best practices (Agile, TDD, Continuous Delivery). As a developer for Codalyze, you'll be joining a diverse community of people who are passionate about modern JavaScript and its ability to change the world. You'll get to work on a wide range of projects, using the latest JS frameworks building for the web & mobile, working with a tight knit team of talented individuals. # YOUR IMPACT AND GROWTH : - Opportunity to work with one of the most exciting modern JavaScript software companies; placed in Powai, Mumbai. - You'll be a part of a small impactful team - because we use agile/scrum, you- ll be personally involved in decisions on how we- ll build out our products for our clients. # HOW WE WORK : You'll join a tightly-knit team consisting of JS Developers who collaborate to build web and mobile apps (React Native) for our clients. Most projects are new and won' t require you to deal with a lot of legacy code. We work with modern JavaScript across a range of frameworks and technologies, on the client as well as on the server: React, NodeJS,, VueJS, TypeScript, ES6, Babel, Flux. (You don't need to be proficient with all of those things to start). Our approach to making software stresses teamwork and close interaction with our clients. We rely on a well thought-out process based on Scrum, continuous delivery, and test-driven development. This process allows us to build software in a way that sets you up for success, allowing you to exercise your creativity and building software that matters without all the red tape, hierarchy and politics. We avoid sharply defined roles: everyone gets to partake in all aspects of their project and to try their hand at new things. Our developers do not just develop: they also help our clients think through product features, contribute to design, and test. We work for many clients in an exciting range of industries: consumer internet, cryptocurrency, online games, education and fin-tech. We have worked with both startups and enterprises # WHAT YOU BRING TO THE TEAM : - 2-3 years experience of web application development using JavaScript (NodeJS / Postgres / VueJS) - Solid understanding of JavaScript - backend architecture, writing optimal database queries - Prior experience in cryptocurrency space is preferred, candidates who have built online games will be preferred - Experience in animations using requestAnimationFrame and canvas APIs is a plus - Solid understanding of styling responsive websites using CSS, SCSS. Bonus points if you have an eye for design. (BTW, all our designers can code.) - Great interpersonal skills - we are a close knit team and work together to solve problems. - A desire to follow a software development process that helps you sleep better at night. - Great problem solver and ability to reinvent oneself - We are always looking at ways we can do things better, sometimes there is no path to follow. - Proactive and self starter - we hire folks that have a deep desire to do better and be better, you won't be micromanaged in this role. (We want to hear your voice.) - Passionate about learning - You- ll help identify new technologies and approaches to problems. (Web development and especially JS is always evolving.) # ABOUT US : Based out of Powai, Mumbai, Codalyze is a diverse community of people committed to using modern JavaScript and software development best practices to build beautiful web & mobile applications for our clients. We are dedicated to helping startups and enterprises move to the modern web. We specialize in using modern JavaScript frameworks (such as AngularJS, React, and Node.js) and a UX-driven development process to build next-generation web applications that deliver a compelling user experience for significantly less development effort compared to legacy server-side web development techniques. Our agile development process, built around continuous delivery, ensures clients are never more than a moment away from jumping on the next business opportunity or responding to the next market event.

Job Description We are looking for an experienced MySQL database administrator who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. You will also be responsible for orchestrating upgrades, backups, and provisioning of database instances. You will also work in tandem with the other teams, preparing documentations and specifications as required. Responsibilities Provision MySQL instances, both in clustered and non-clustered configurations Ensure performance, security, and availability of databases Perform database administration tasks, including automation, performance monitoring and tuning, and query optimization. Prepare documentations and specifications Handle common database procedures, such as upgrade, backup, recovery, migration, etc. Profile server resource usage, optimize and tweak as necessary Collaborate with other team members and stakeholders Skills and Qualifications Strong proficiency in MySQL database management Decent experience with recent versions of MySQL Understanding of MySQLs underlying storage engines, such as InnoDB and MyISAM Experience with replication configuration in MySQL(Master slave, Master-Master) Knowledge of de-facto standards and best practices in MySQL Create and Manage MySQL users with proper permissions. Proficient in writing and optimizing SQL statements. Automate day to day regular tasks. Strong knowledge in MySQL Binlog and point in time recovery. Tuning MySQL servers configurations as per the workload. Decent experience in Linux Administration. Knowledge of MySQL features, such as its event scheduler Ability to plan resource requirements from high level specifications Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc. Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases Proficient understanding of code versioning tools such as (Git / Mercurial / SVN) The below qualifications are adds Plus: Public cloud platform (AWS/Azure/GCP). Knowledge in AWS RDS and Aurora. Python scripting. Query Tuning.

We need a strong Ruby on Rails developer who has as strong understanding of Rest API's and also a experience on Node.js is plus point. Database understanding and AWS deployment is a must.

Need a developer who knows python, reactjs and postgres