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.
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
Job Description
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.
Responsibilities
- Writing reusable, testable, and efficient code
- Design and implementation of low-latency, high-availability, and performant applications
- Integration of user-facing elements developed by front-end developers with server side logic
- Implementation of security and data protection
- Integration of data storage solutions (may include databases, key-value stores, blob stores, etc.)
Skills And Qualifications
- Expert in Python, with knowledge of Django and DjangoRestFramework
- Familiarity with some ORM (Object Relational Mapper) libraries
- Able to integrate multiple data sources and databases into one system
- Understanding of the threading limitations of Python, and multi-process architecture
- Basic understanding of front-end technologies, such as JavaScript, HTML5, and CSS3
- Understanding of accessibility and security compliance for video streaming applications
- Knowledge of user authentication and authorization between multiple systems, servers, and environments
- Familiarity with event-driven programming in Python
- Able to create database schemas that represent and support business processes
- Strong unit test and debugging skills
- Proficient understanding of code versioning tools (such as Git, Mercurial or SVN)
- Familiarity with RESTful APIs
- Knowledge of modern authorization mechanisms, such as JSON Web Token
- Ability to understand business requirements and translate them into technical requirements
Benefits
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.
About Tessact:
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 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.