Database Developer (PostgreSQL)

Job Summary:

We are seeking a dynamic and highly skilled Full Stack Developer with 3-5 years of experience to join our client's team. The ideal candidate will be working with a leading MNC client in the health insurance domain. This role is based in Gurugram and requires candidates to work from the office, Monday to Friday. You will play an integral role in developing and enhancing applications using Node.js, TypeScript, PostgreSQL, and MongoDB.

Responsibilities:

• Design, develop, and maintain scalable applications using Node.js and TypeScript.
• Build and optimize RESTful APIs and backend services.
• Collaborate with cross-functional teams to deliver high-quality products and services.
• Work with PostgreSQL and MongoDB databases for efficient data management and retrieval.
• Ensure the performance, quality, and responsiveness of applications.
• Troubleshoot, debug, and upgrade existing systems and platforms.
• Implement best practices for security, code quality, and performance optimization.
• Participate in code reviews and provide mentorship to junior developers.

Requirements:

• Experience: 3-5 years of hands-on development experience with Node.js, TypeScript, PostgreSQL, and MongoDB.
• Technical Skills:
• Proficiency in Node.js and TypeScript for building scalable web applications.
• Strong experience working with PostgreSQL and MongoDB databases.
• Hands-on experience in building RESTful APIs and microservices architecture.
• Knowledge of best practices in application development, security, and performance tuning.
• Familiarity with version control tools like Git.
• Preferred:
• Experience in the health insurance or fintech domain.
• Ability to work in an agile environment with fast-paced deliverables.
• Excellent communication and collaboration skills.

Soft Skills:

• Strong problem-solving skills and ability to troubleshoot complex issues.
• Ability to work in a team and independently when required.
• Adaptability and willingness to learn new technologies.

We're looking for a Backend Lead Engineer to join our Engineering Team. The Engineering Team forms the backbone of our core business. We build and iterate over our core platform that handles orders, payments, delivery promises, order tracking, logistics integrations to name a few. Our products are actively used by Fynd users, Operations, Delights, and Finance teams. Our team consists of generalist engineers who work on building REST APIs, Internal tools, and Infrastructure for all these users.

What will you do at Fynd?

• Determining project requirements and developing work schedules for the team.
• Managing and mentoring a team of 2-5 engineers, Delegating tasks, and achieving daily, weekly, and monthly goals.
• Build scalable and loosely coupled services to extend our platform
• Build bulletproof API integrations with third-party APIs for various use cases with the team.
• Evolve our Infrastructure and add a few more nines to our overall availability
• Have full autonomy and own your code, and decide on the technologies and tools to deliver as well operate large-scale applications on AWS
• Give back to the open-source community through contributions on code and blog posts
• This is a startup so everything can change as we experiment with more product improvements
• Write technical documentation

Some Specific Requirements

• Atleast 2+ years of Tech Lead Experience, 5+ years of Development Experience
• You have prior experience developing and working on consumer-facing web/app products
• Good understanding of Data Structures, Algorithms, and Operating Systems
• Hands-on experience in JavaScript / Python / Node.Js. Exceptions can be made if you’re really good at any other language with experience in building web-app based tech products
• Good knowledge of async programming using Callbacks, Promises, and Async/Await
• Experience in at least one of the following frameworks - Flask, Sanic, Fastapi would be plus
• Experience in at least one of the following frameworks - Express.js, Koa.js, Socket.io
• Hands-on experience with Frontend codebases using HTML, CSS, and AJAX. Plus knowledge of Frontend Frameworks and Experience in at least one of the following frameworks - React.Js, Angular, Vue.js.
• Deep knowledge of MongoDB, Redis, or MySQL
• Basic knowledge of event-based systems using Kafka or RabbitMQ
• You should have experience with deploying and scaling Microservices.
• You've worked with AWS services in the past and have experience with EC2, ELB, AutoScaling, CloudFront, S3
• Deep Knowledge of Cloud-Native Application Architecture: Docker, Kubernetes, Microservices

Job Summary: We are looking for a skilled SQL Developer to join our team. The ideal candidate will have a strong understanding of database management systems, experience in writing complex SQL queries, and a solid understanding of data structures and algorithms. The SQL Developer will be responsible for designing, developing, and maintaining SQL databases, ensuring their performance, availability, and security.

Key Responsibilities:

• Design, develop, and optimize SQL databases, tables, views, stored procedures, and triggers.
• Develop efficient and complex SQL queries for data extraction, transformation, and loading (ETL).
• Create and maintain database schema designs, data models, and ER diagrams.
• Analyze and optimize complex SQL queries for better performance.
• Implement indexing strategies, query optimization techniques, and other performance tuning practices.
• Ensure data integrity and security by designing and implementing database constraints, data validation rules, and security policies.
• Work with software developers, data analysts, and system administrators to integrate SQL databases with other applications and systems.
• Collaborate with business stakeholders to understand data requirements and provide solutions.
• Document database designs, stored procedures, and other database-related activities.
• Maintain accurate records of database changes, optimizations, and configurations.

Eligibility Criteria:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 3 to 5 years of experience as an SQL Developer or in a similar role.
• Proven experience in database design, development, and management.
• Experience with SQL Server, MySQL, PostgreSQL, or other relational database management systems.
• Proficiency in writing complex SQL queries, stored procedures, functions, and triggers.
• Strong understanding of indexing, query optimization, and performance tuning.
• Familiarity with database security best practices.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Attention to detail and commitment to quality.
• Ability to work independently and in a team environment.
• Experience with cloud-based databases (e.g., AWS RDS, Azure SQL Database).
• Experience with NoSQL databases.

What We Offer:

·        Competitive salary and performance based incentives.

·        Comprehensive benefits package, including health

·        Opportunities for professional growth and career advancement.

·        A collaborative and innovative work environment.

• Responsible for providing technical leadership, design and development of complex pieces of the service oriented architecture based platform.
• Modelling Database Design for large scale applications.
• Develop for performance engineering.
• Design for the right use of micro services, containerization and observability.

• Drive technology and product innovation through rapid prototyping and iterative development.
• Create reference implementation for our integrations and for backward compatibility.
• Not interested in managerial responsibilities

Requirements, Desired Skills and Experience

• Tech Stack based on Ruby-on-Rails, Python-Django or Node.js frameworks.

• Engineering degree 

   Opportunities for the right candidate

• Build and develop SaaS and PaaS products from scratch
• Build the best-in-class UX based products
• State of Art technologies (Latest trends in the industry)
• Work with a well-knit team, almost like one’s family
• Startup culture and advantages of working in a co-working space
• Performance based career progress and high visibility with management and founders

Responsibilities :

- Knowledge of Node.js and frameworks available for it {such as NestJS, Express, StrongLoop, etc.}

- Experience in Database, Postgres Preferred.
- 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
- Integration of data storage solutions 
- Strong proficiency with JavaScript

Here a video that explains our product journey:

https://www.loom.com/share/ccd0ed9e7bc349d7bba851d762253c21">https://www.loom.com/share/ccd0ed9e7bc349d7bba851d762253c21

This is fully a remote role, but the employer needs to fly down to the office in Kolkata for 5–6 days every month. Plane tickets and accommodation will be reimbursed by the company.

Ideal candidate must have :

- 2+ years of experience in writing code

- Ability to meet tight deadlines

- Can work independently and be a team contributor

- Must have good knowledge of Node, Python and Scripting languages

- Experience in one or more of RDBMS - PostgreSQL, MySQL or Oracle

- Experience with NoSQL and real-time DB - Firebase/Firestore or MongoDB

- Must be able to write concise and high-quality API

- Must be a quick learner, curious and ambitious