Query optimization Jobs 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.

Job Description

Should have working experience between 3-6 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.

 

 Minimum 4-8 years of experience in design and development J2EE based applications, database design (conceptual/ logical/ physical) and writing PL/ SQL queries/ stored procedures in PostgreSQL

• Preferred to have good knowledge and hands on experience on jBPM workflow platform. Experience in DROOLS rule engine will be an added advantage
• Expertise on Angular JS, Springboot, Hibernate, JQuery frameworks
• Hands on experience in building reports using Business Intelligence and Reporting Platform (BIRT)
• Knowledge around JBOSS (WildFly), Tomcat and other application servers
• Knowledge around source code repository Tortoise SVN
• Experience in building Multitenant products
• Conceptual knowledge around Continuous Integration/ Continuous Development using Jenkins
• Good analytical and logical thinking, prioritizing and organizing
• Team player with positive attitude
• Good written and verbal communication skills

 

 Key Responsibilities

• Analyse SRS to understand and estimate the requirements
• Analyse change requests and estimate the requirements
• Design, development, unit testing and deployment using jBPM platform and other underlying tools and frameworks mentioned above
• Database design, writing simple or complex PL/ SQL queries/ stored procedures/ Functions/ Triggers etc. using PostgreSQL database
• Analyse L2 support issues, identify and implement the workaround/ permanent solutions within stimulated SLA
• Preparation of release document for new projects, change requests and bug fixes
• Create and leverage technical knowledge repository

Experience- 3.5 to 6 Yrs

Location- Pune, Mumbai, Bangalore

Notice Period- Immediate to 15 days

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.

Job Summary
We are looking for a passionate backend developer with 2-3 years of experience who loves challenges and building something from ground-up. Past track record of building a statistical tool will be an advantage

Responsibilities and Duties
- Design of system and architecture for all features and problems
- Translate high level business problems into scalable design and code
- Maintain existing backend code and infrastructure
- Working with team to solve problems and discuss new ideas
- Smart system design smart having a balance between speed of implementation and scalability
- Ownership of projects or codes written

Qualifications and Skills
- Passion to work for startup and aptitude for fast learning
- In-depth understanding of Django and Django Rest Framework
- Expertise in python
- Basic machine learning knowledge, Company will help the candidate to upskill
- Ability to write clean, scalable, robust code
- Understanding of complete lifecycle of software development
- Basic knowledge of front-end development
- Good understanding of restful api design
- Working knowledge of AWS (EC2, RDS and Postgresql)
- Familiarity deploying SAAS solution with Amazon AWS and Docker (Kubernetes) etc

Position : Database Programmer:

 

Job Description / Required Skills

• Strong experience in Database design for complex web and mobile application, including writing complex store procedures, function, triggers and ad-hoc queries.
• Hands-on development experience with T-SQL.
• Strong experience on Database designing, normalization, optimization and performance tuning.
• Experience in advanced SQL programming, problem-solving and analytical skills.
• Experience in security, troubleshooting and optimizing the performance of databases and stored procedures.
• Experience in Refactoring/troubleshooting existing databases as needed.
• Deep understanding of referential integrity and indexing.
• Assisting with production database issues and helping to troubleshoot and isolate the root cause of issues and provide issue resolution by interacting with Developers.
• Ability to estimate development tasks accurately and meet agreed upon deadlines.
• Understanding of code promotion, version control and QA procedures.
• Good Communication skills.

 

Technical Skills:

• MySql, MS-SQL, SQL Server Management Studio and SQL Server Profiler.
• PostgreSQL
• DCL, DDL, DML Scripts.
• T-SQL, SSRS and SSIS
• OS Environments: Windows XP/Windows 7, Windows Server 2003/2008

 

Experience         :               3 to 4 years

Qualification       :               B. Tech/BE/MCA/MSC Computers

Location               :               Mumbai

We are looking for a Python Web Developer responsible for managing the interchange of data between the server and the users. Your primary focus will be the development of all server-side logic, ensuring high performance and responsiveness to requests from the front-end. You will also be responsible for integrating the front-end elements built by your co-workers into the application; therefore, a basic understanding of front-end technologies is necessary as well.

1. Writing reusable, testable, and efficient code
2. Design and implementation of low-latency, high-availability, and performant applications
3. Integration of user-facing elements developed by front-end developers with server side logic
4. Implementation of security and data protection
5. Integration of data storage solutions (may include databases, key-value stores, blob stores, etc.)

1. Expert in Python, with knowledge of Django and DjangoRestFramework
2. Familiarity with some ORM (Object Relational Mapper) libraries
3. Able to integrate multiple data sources and databases into one system
4. Understanding of the threading limitations of Python, and multi-process architecture
5. Basic understanding of front-end technologies, such as JavaScript, HTML5, and CSS3
6. Understanding of accessibility and security compliance for video streaming applications
7. Knowledge of user authentication and authorization between multiple systems, servers, and environments
8. Familiarity with event-driven programming in Python
9. Able to create database schemas that represent and support business processes
10. Strong unit test and debugging skills
11. Proficient understanding of code versioning tools (such as Git, Mercurial or SVN)
12. Familiarity with RESTful APIs
13. Knowledge of modern authorization mechanisms, such as JSON Web Token
14. Ability to understand business requirements and translate them into technical requirements

We’re looking for people to join our cause – to simplify the visual web with really smart but simple visual tools. A technology startup founded by IITians and   backed by some of the most reputable media companies as customers, we offer a rare opportunity to join a thriving, fast-paced, multi-cultural environment and be part of a truly exciting journey. You will be at the forefront of innovation, joining the only Artificial Intelligence startup in India that have successfully deployed several CV/ML solution for several large media companies and now focusing on solving problems of  global market.

Tessact is an Artificial Intelligence (AI) and data analytics startup established in July 2016 that helps in transforming businesses using powerful video recognition technologies built on most advanced machine learning systems. The company redefines the way contextual insights are to be used for

media production, digital advertising, consumer experience creation and news analytics

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)

FreightCrate Technologies:

FreightCrate Technologies is a Logistics Technology company that aims to transform international shipping through innovative and cost-effective tech solutions that can mutually benefit exporters, importers and logistics service providers.  
Our web-platform, FreightCrate offers online tech-enabled quote and shipment management solutions for export and import businesses to and from more than 50,000 global locations.
We have had more than 50 media coverages including Entrepreneur, Maritime Gateway, Cargotalk, BW Disrupt, INC42, Silicon India, Tech Observer and several other newspapers and online magazines.

Our vision is to utilize cutting edge technology, engineering, deep learning and artificial intelligence to create an intelligent freight management system that can automate and optimize international trade operations for global businesses.


FOUNDERS:

Samir Lambay is the Co-Founder and CEO with an MSc in Shipping, Trade and Finance from Cass Business School, London, UK with Distinction.
Samir has worked in the shipping and logistics industry across both family businesses and multinational companies. His most recent job was at DB Schenker Logistics (Part of Deutsche Bahn Group - Fortune 200) where he was the youngest Vertical Manager globally and won two awards including Vertical Manager of the year and a Global Award.


Ruchi Dogra is a Co-Founder & Director and is in charge of sales and marketing. She has worked for over 15 years across the top 3 logistics/supply chain companies globally. She set-up the hotel, wines and beverages vertical at Kuehne & Nagel and DB Schenker. Her latest assignment was at DHL Global Forwarding where she worked as a Vertical Manager for Engineering and Manufacturing; handling top Indian and multinational accounts including several Fortune 100 companies. She brings with her an extensive knowledge in strategy, sales, operations and customer service.


Title
Software Developer

Description

The Software Developer’s role is to develop new innovative programs to optimize and automate user experiences by creating high-quality, innovative and fully performing software that complies with coding standards and technical design.
Should be familiar with the software development life cycle (SDLC) from preliminary system analysis to tests and deployment. 

Compensation

As this is a new business the compensation is negotiable and we will make an offer depending on the experience of the candidate.

Responsibilities

• Design flowcharts, layouts and documentation to identify requirements and solutions
• Produce clean, efficient code based on specifications
• Execute full software development life cycle (SDLC)
• Integrate software components and third-party programs and API’s
• Troubleshoot, debug and upgrade existing software
• Gather and evaluate user feedback
• Recommend and execute improvements
• Create technical documentation for reference and reporting


Skill Sets:

• PHP/Python
• AWS & Cloud-computing
• Mysql/PostgreSql
• Memcache/Redis
• Frontend technologies HTML, CSS, JS, ReactJS, Vue.js
• Frameworks like Django
• DevOps
• ELK
• Tools like Datadog, NewRelic, etc
• Shell-scripting 
• Setting & managing dev/beta/prod environments
• Tools like Jenkins, Chef, Puppet, Ansible, etc.
• Knowledge of Solr/Elastic search will be an advantage

Personal Requirements:

• Min of 3+ years of Hands on experience in Web development, algorithm design, implementation, architecture design, product management, databases and UI/UX in consumer facing applications.
• Experience on projects involving engineering and algorithmic functions, machine learning, deep learning and artificial intelligence is very advantageous.
• Creative self-starter who is comfortable with both taking initiative and working in teams.
• Previous experience working on logistics technology products is advantageous but not mandatory.
• Strong communication skills.
• Willingness to learn and utilize emerging technologies.
• Sincere passion to use disruptive technologies that can be globally significant.

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

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

B.Tech. in Computer Science or MCA. 3 to 5 years of experience in delivering high-quality applications. Strong proficiency with JavaScript In-depth knowledge and hands-on experience on Node.js and frameworks available for it like Express JS etc. Expert in Relational Databases MySQL, PostgreSQL. In-depth knowledge and hands-on experience on Mongo DB Experience in Redis, Memcache. Understanding fundamental design principles behind a scalable application The knack of adhering to best practices Ability to work independently as well as in a team. Ability to deal with constantly changing technology. Proficient understanding of code versioning tools, GIT preferred. Experience with AWS Platform is a plus.