SQL Database

About Prêtture

We are India’s coolest SaaS ERP for Fashion, Lifestyle and Home Decor brands. Currently working across 100 brands like House of Masaba, Rahul Mishra, Raw Mango, Anamika Khanna and many others across India, helping them organise their end to end business workflow through our application.

 

We are currently working on new development and enhancement in the application and are hence looking forward to senior software developers.

 

The ideal candidate is a creative problem solver who understands the requirement and comes up with the solution keeping in mind the impact of the solution on existing code

 

Responsibilities

• Understand the problem statement and get the code done for the server side programming of our software including the database and other internal/external micro services communication
• Maintain the quality of code
• Impact analysis before actually writing any code
• Use the optimised SQL queries only

 

Qualifications

• At least 2-3 years' of experience using NodeJS and MySql/PostgreSQL (This is mandatory. Please do not apply in case of lesser experience in either NodeJS or MySQL/PostgreSQL)
• Bachelor's degree or equivalent experience in Computer Science

 

Office Location

 Navi Mumbai

Come and Join the future.

This is an opportunity to work directly with Industry experts having 20+ years of experience in Technology and product development.

Roles and Responsibilities 

• Developing front end website architecture.
• Designing user interactions on web pages.
• Developing back end website applications.
• Creating servers and databases for functionality.
• Ensuring cross-platform optimization for mobile phones.
• Ensuring responsiveness of applications.
• Working alongside graphic designers for web design features.
• Seeing through a project from conception to finished product.
• Designing and developing APIs.
• Meeting both technical and consumer needs.
• Staying abreast of developments in web applications

Desired Candidate Profile

• Strong organizational and project management skills.
• Proficiency with fundamental front end languages such as HTML, CSS and JavaScript.
• Familiarity with JavaScript frameworks such as Angular JS, and React JS.
• Proficiency with server-side languages like Nodejs, and Expressjs.
• Familiarity with database technology such as MySQL, Postgresql or MongoDB.
• Excellent verbal communication skills.
• Good problem-solving skills.
• Attention to detail.

We are looking for a Node.js 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, definition, and maintenance of the central database, and 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.

• 2+ years of experience with Node.js/Express.js or similar framework
• 1+ years of experience with MongoDB
• 1+ years of experience creating REST APIs and backend systems
• Experience with Docker is a plus
• Integration of user-facing elements developed by front-end developers with server-side logic
• Writing reusable, testable, and efficient code
• Design and implementation of low-latency, high-availability, and performant applications
• Implementation of security and data protection
• Server Setup/AWS/GCP experience is a plus
• Creating APIs and backend systems
• Scraping sites and creating backend dashboards for data management
• Backend infrastructure management and deployment

Responsibilities:

• Developing and maintaining all server-side network components.
• Ensuring optimal performance of the central database and responsiveness to front-end requests.
• Collaborating with front-end developers on the integration of elements.
• Designing customer-facing UI and back-end services for various business processes.
• Developing high-performance applications by writing testable, reusable, and efficient code.
• Implementing effective security protocols, data protection measures, and storage solutions.
• Running diagnostic tests, repairing defects, and providing technical support.
• Documenting Node.js processes, including database schemas, as well as preparing reports.
• Recommending and implementing improvements to processes and technologies.
• Keeping informed of advancements in the field of Node.js development.

Requirements:

• Bachelor's degree in computer science, information science, or similar.
• At least two years of experience as a Node.js developer.
• Extensive knowledge of JavaScript, web stacks, libraries, and frameworks.
• Superb interpersonal, communication, and collaboration skills.
• Exceptional analytical and problem-solving aptitude.
• Great organizational and time management skills.
• Availability to resolve urgent web application issues outside of business hours.

Fulfil’s software engineers develop the next-generation technologies that change how millions of customer orders are fulfilled by merchants. Our products need to handle information at massive scale. We're looking for engineers who bring fresh ideas from all areas into our technology.

As a senior software engineer, you will work on our python based ORM and applications that scales to handle millions of transactions every hour. This is mission critical software and your primary focus will be building robust and scalable solutions that are easy to maintain.

In this role, you will be collaborating closely with the rest of the team working on different layers of infrastructure in an international environment. Therefore, a commitment to collaborative problem solving, sophisticated design, and quality product are important.

What You’ll Do:

• Own definition and implementation of API interfaces (REST and GraphQL). We take pride in our 100% open API with over 600 endpoints.
• Implement simple solutions to complex business logic that enables our merchants to manage financials, orders and shipments across millions of transactions.
• Build reusable components and packages for future use.
• Translate specs and user stories into reviewable, test covered patches.
• Peer review code and refactor existing code.
• Integrate with our eCommerce partners (Shopify, BigCommerce, Amazon), shipping partners (UPS, USPS, FedEx, DHL) and EDI.
• Manage Kubernetes and Docker based global deployment of our infrastructure.

Requirements
We’re Looking for Someone With:

• Experience working with ORMs like SQLAlchemy or Django (2-3 years)
• Experience with SQL and databases (Postgres preferred)
• Experience in developing large server side applications and microservices
• Ability to create high quality code
• Experience with python testing tools (pytest) and test automation
• Familiarity with code versioning tools like GIT
• Strong sense of ownership and leadership quality
• Experienced in the tools of our web stack- Python, Celery, Postgres, Redis, RabbitMQ

Nice to Haves:

• Prior experience at a growth stage Internet/Software company
• Experience with ReactJS, Google Cloud, Heroku
• Cloud deployment and scaling experience

Roles & Responsibilities:

• Work as a Web Developer to create front end & backend of websites
• Play a key role in the design lifecycle, from brief through to design and release/implementation
• Should have good knowledge of HTML, CSS, REACT JS, NODE JS, POSTGRES, GIT, REST API.
• A good understanding of servers, hosting, domains, DNS
• Ensure all designs work across all browsers and on all devices
• Help to design elements of mobile apps
• Ensure all designs are produced to deliver a great user experience

 

Key Skills/Experience:

• A minimum of one year of experience in designing and developing websites and web apps
• Good working experience in React JS, Redux, JavaScript ES6, NodeJS, AJAX, HTML, CSS, etc
• Knowledge about REST API
• Who has worked on libraries such as Bootstrap, Material is.
• Experience with Unit testing, Git, GitHub, and other DevOps and CI/CD tool
• A strong portfolio that demonstrates a range of work and techniques
• A passion for strong web design that delivers a great user experience
• A good understanding of the latest web design trends

• Set up, manage, automate and deploy AI models in development and production infrastructure.
• Orchestrate life cycle management of AI Models
• Create APIs and help business customers put results of the AI models into operations
• Develop MVP ML learning models and prototype applications applying known AI models and verify the problem/solution fit
• Validate the AI Models
• Make model performant (time and space) based on the business needs
• Perform statistical analysis and fine-tuning using test results
• Train and retrain systems when necessary
• Extend existing ML libraries and frameworks
• Processing, cleansing, and verifying the integrity of data used for analysis 
• Ensuring that algorithms generate accurate user recommendations/insights/outputs
• Keep abreast with the latest AI tools relevant to our business domain

Job Qualifications

• Bachelor’s or master's degree in Computer Science, Statistics or related field 
• A Master’s degree in data analytics, or similar will be advantageous.
• 3 - 5 years of relevant experience in deploying AI models to production
• Understanding of data structures, data modeling, and software architecture
• Good knowledge of math, probability, statistics, and algorithms
• Ability to write robust code in Python/ R
• Proficiency in using query languages, such as SQL
• Familiarity with machine learning frameworks such as PyTorch, Tensorflow and libraries such as scikit-learn
• Worked with well know machine learning models ( SVM, clustering techniques, forecasting models, Random Forest, etc.)
• Having knowledge in CI/CD for the building and hosting the solutions
• We don’t expect you to be an expert or an AI researcher, but you must be able to take existing models and best practices and adapt them to our environment.
• Adherence to compliance procedures in accordance with regulatory standards, requirements, and policies. 
• Ability to work effectively and independently in a fast-paced agile environment with tight deadlines 
• A flexible, pragmatic, and collaborative team player with an innate ability to engage with data architects, analysts, and scientists.

We are seeking talented, motivated engineers who will be part of a dynamic global team delivering and supporting technology infrastructure to meet the growth needs of the business. 

 

As a Product Support Engineer, you will collaborate with the Engineering, Product and Support teams to ensure the designed product and service is fully operational with streamlined processes and procedures for addressing reported bugs and anomalies. Production Support Engineers will take ownership of resolving product issues through its life cycle and communication to multiple stakeholders. 

This is a programming role which requires a good understanding of Java along with solid debugging skills so complex workflows can be debugged and solved. You will own the code you push to production

 

To be successful, you must be an excellent team player and self motivated person who can carry out duties with minimal supervision.

 

Skills you need to have:

• A good understanding of SQL

• An understanding of Java and Java design patterns

• L4 support

• Good debugging and problem solving skills

• Excellent communication

Bonus Skills:

• An understanding of SpringBoot and ORM's
  
  

Job Title: Odoo Developer
Job Type: Full Time
Job Location: India- Bangalore/Pune
Reporting To: Manager ERP Solutions/Director Cloud Engineering
Work Hours: 9 hours (Indian Shift)

 

Main Duties and Responsibilities:

The candidate will be responsible for interacting with internal and external customers, gather requirements, map it to the system design solution if required, discuss it with Functional consultant and deploy/implement it and post implementation support.

Qualifications:

BSc Computer Science, Electronics, MSc/MCA, PGDCA or any equivalent degree

Experience – 1- 3 Years

Skills:

Functional Skills:

• Good understanding of ERP Process and system
• Candidates should have hands-on experience in implementing Odoo Sh preferably, Odoo Online, Enterprise, Odoo Community Edition or experience in implementing any other ERP Software.
• Good Knowledge on the following: Purchase Process (Procure 2 Pay), Sales Process(Order 2 Cash), CRM , Accounting, Manufacturing

Technical Skills:

• Must knowledge on core Python programming concepts, Django framework, JavaScripts
• Good knowledge on SQL, PostgreSQL
• Good knowledge on ORM methods, Xml, Jquery/JS
• Good to have knowledge on Odoo Framework, Installing Odoo, Customize modules, create modules.

Personal Qualities and Behavior traits:

 

1- Be a good team worker demonstrating loyalty and commitment to the organization and team members.

  
2- Good organizational skills and excellent attention to details Interact with individuals to provide needed information

• Good written and verbal communication skills.
• Aptitude for learning new concepts, technologies and understanding them to utilize in a customer facing/service environment.
• Should be able to work in a team environment and independently.
  
  Performance Goals
  1- Able to handle multiple assignments simultaneously.
  2- Ensures timely response to client and internal peers.

 

Who :BlueOptima is the is the only company providing objective software development productivity metrics.The technology has been implemented by some of the world's largest organisations including insurance companies, asset managers, telecoms and seven of the world's top ten Universal Banks.This successful product uptake has led to rapid expansion of the company.What :The role involves:- Contributing to overall technical architecture- Understanding, prioritizing and paying off technical debt- Measuring, diagnosing and improving product performance- Conceiving, developing, releasing and maintaining features. For us, a feature isn't delivered until it's in production and each team member is responsible for the features that they releaseRequirements :- Familiarity with Windows and Linux development environments- Core Java, Advanced Java PostgreSQL, Hibernate, Spring, Angular.JS, REST APIs- 2-5 years- experienceWhy :In addition to testing and proving your Java skills, this is an exciting career opportunity with BlueOptima.We have 12 full-time Software Developer positions to fill - and many reasons to work for us:- 10 year-old company, now growing rapidly, offers both stability and rapid career progression- Distributed developer team means you can work from home: Save travel time / cost- International business travel- Work alongside other leading engineers, using a cutting-edge technology stack- Above market-rate salary- Potential stock options for outstanding performersThe most eligible candidates may progress to further stages:Technical Interview, Work Sample and Work Sample Discussion, and Final Interview with our COO.

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.