Postgres Database Developer with DBA Experience

Full stack Developer (Ref.ID: VRPL-FSD-Chn-0326)

No. of Positions: 2 Nos. Senior 1 No. Junior 1 No.

API Development & Architecture:

Design and develop scalable RESTful APIs using Node.js & TypeScript

Build modular, reusable, and clean backend architecture

Implement authentication & authorization (JWT / OAuth / Role-based access)

Ensure API security best practices

Write well-structured documentation (Swagger / Postman)

Real-Time Communication (Sockets):

Develop real-time features using WebSockets / Socket.io

Implement:

Live tracking

Real-time notifications

Status updates

Chat systems

Optimize socket performance and reconnection handling

Ensure scalability under concurrent user load

Database & Data Layer (PostgreSQL):

Design scalable and optimized database schemas

Write complex SQL queries & joins

Implement indexing & query optimization

Handle transactions and concurrency control

Work with ORMs like Prisma / TypeORM (preferred)

Maintain database security and backup strategies

Ensure data security and backups

Performance & Scalability:

Optimize API response times

Implement caching strategies (Redis preferred)

Design rate limiting and throttling mechanisms

Ensure system reliability & fault tolerance

Handle background jobs & queues

Deployment & DevOps Collaboration:

Deploy applications on AWS / GCP

Work with Docker containers

Implement CI/CD pipelines

Monitor logs & performance metrics

WhatsApp Business Integration:

Integrate WhatsApp Business API (Cloud / On-Premise)

Work with providers like Exotel / Twilio (preferred)

Implement Template messaging

OTP authentication

Notifications & alerts

Two-way communication

Manage webhook events and delivery tracking

Ensure compliance with WhatsApp policies

Required Skills:

Strong proficiency in Node.js

Hands-on experience with TypeScript

Strong experience in PostgreSQL

Experience building RESTful APIs

Experience with WebSockets / Socket.io

Good understanding of system design & architecture

Git version control

Knowledge of API security best practices

Preferred Skills:

Experience in real-time platforms (ride-hailing, delivery, chat systems)

Redis for caching

Message queues (Kafka / RabbitMQ / BullMQ)

Microservices architecture

Payment gateway integration

Cloud infrastructure knowledge

Soft Skills:

Strong analytical, problem-solving skills, and debugging skills

Startup mindset & ownership attitude

Ability to work in fast-paced startup environment and work independently

Good communication skills in all aspects

Job Description: Software Engineer - Backend ( 3-5 Years)

Location: Bangalore

WHO WE ARE:

TIFIN is a fintech platform backed by industry leaders including JP Morgan, Morningstar, Broadridge, Hamilton Lane, Franklin Templeton, Motive Partners and a who’s who of the financial service industry. We are creating engaging wealth experiences to better financial lives

through AI and investment intelligence powered personalization. We are working to change the world of wealth in ways that personalization has changed the world of movies, music and more but with the added responsibility of delivering better wealth outcomes.

We use design and behavioral thinking to enable engaging experiences through software and application programming interfaces (APIs). We use investment science and intelligence to build algorithmic engines inside the software and APIs to enable better investor outcomes.

In a world where every individual is unique, we match them to financial advice and investments with a recognition of their distinct needs and goals across our investment marketplace and our advice and planning divisions.

OUR VALUES: Go with your GUT

●Grow at the Edge: We embrace personal growth by stepping out of our comfort zones to

discover our genius zones, driven by self-awareness and integrity. No excuses.

●Understanding through Listening and Speaking the Truth: Transparency, radical candor,

and authenticity define our communication. We challenge ideas, but once decisions are

made, we commit fully.

●I Win for Teamwin: We operate within our genius zones, taking ownership of our work

and inspiring our team with energy and attitude to win together.

Responsibilities:

• Contribute to the entire implementation process including driving the definition of improvements based on business needs and architectural improvements.

• Review code for quality and implementation of best practices.

• Promote coding, testing, and deployment best practices through hands-on research and demonstration.

• Write testable code that enables extremely high levels of code coverage.

• Ability to review frameworks and design principles toward suitability in the project context.

• Candidates who will demonstrate an ability to identify an opportunity lay out a rational plan for pursuing that opportunity, and see it through to completion.

Requirements:

• Engineering graduate with 3+ years of experience in software product development.

• Proficient in Python, Django, Pandas, GitHub, and AWS.

• Good knowledge of PostgreSQL, and MongoDB.

• Strong Experience in designing REST APIs.

• Experience with working on scalable interactive web applications.

• A clear understanding of software design constructs and their implementation.

• Understanding of the threading limitations of Python and multi-process architecture.

• Familiarity with some ORM (Object Relational Mapper) libraries.

• Good understanding of Test Driven Development.

• Unit and Integration testing.

• Preferred exposure to Finance domain.

• Strong written and oral communication skills.

We are looking for a skilled Backend Developer with strong experience in building, scaling, and optimizing server-side systems. The ideal candidate is proficient in Node.js, FastAPI (Python), and database design, with hands-on experience in cloud infrastructure on AWS or GCP.

Responsibilities:

Design, develop, and maintain scalable backend services and APIs using Node.js and FastAPI

Build robust data models and optimize performance for SQL and NoSQL databases

Architect and deploy backend services on GCP/AWS, leveraging managed cloud services. 

Implement clean, modular, and testable code with proper CI/CD and observability (logs, metrics, alerts)

Ensure system reliability, security, and high availability for production environments

Requirements:

2–5 years of backend development experience

Strong proficiency in Node.js, FastAPI, REST APIs, and microservice architecture

Solid understanding of PostgreSQL/MySQL, MongoDB/Redis or similar NoSQL systems

Hands-on experience with AWS or GCP, Docker, and modern DevOps workflows

Experience with caching, queueing, authentication, and API performance optimization

Good to Have:

Experience with event-driven architecture, WebSockets, or serverless functions

Familiarity with Kubernetes or Terraform

Job Location: Gurugram, Haryana, India

Industry: Artificial Intelligence

Position: Database Administrator (PostgreSQL)

Location: Raipur

Experience: 7 to 9 years

Salary: 15-18 LPA

Qualification: BE / B.Tech / MCA

Job Profile

·      Expertise in PostgreSQL database installation, configuration, and administration.

·      Experience with database security, backup, recovery, and high availability.

·      Strong SQL development, query optimization, and performance-tuning skills.

·      Solid understanding of logical and physical database design and data modeling.

·      Ability to perform impact analysis and handle database migrations.

·      Providing SQL expertise, proposing design recommendations and optimization.

·      Knowledge of system administration and network administration concepts.

·      Experience in enforcing database and coding standards.

·      Ability to generate reports and statistics using database queries.

·      Excellent problem-solving, communication, and documentation skills.

Candidate Profile

·      Candidate should have very good technical skill in PostgreSQL Database Administration

·      Candidate should be able to work in team & manage team members, if required

·      Communication skill should be excellent

·      Candidate should be smart & personality should be very good

We're looking for someone to join a team dedicated to building performant APIs and backend services that deal with large volumes of data for the company's flagship, global consumer product. Small, high-impact teams require conscious planning and decision-making when it comes to design, architecture, and product features. So, it's essential that you enjoy working in such an environment.

We're a team that cares about simplicity and being able to build reliable, deterministic systems and platforms. Hence, our choice of tooling is usually battle-tested reliable software with a robust test suite.

How we work

1. You won't deal with the hustle culture. We're focused on building well-thought-out, stable and reliable software and we try our best to ensure everyone understands the big picture and the immediate goals.
2. We work a solid 6-8 hour days and don't slave away 24/7.
3. We're a remote engineering team. This makes effective communication extremely important. Our teams have benefitted greatly from good written communication. This includes everything from the product specification to the API spec. We spend a lot of time writing READMEs. As a result our engineers work with greater clarity and planning.
4. We deploy several times a day and rely on a good test suite to ensure we're not making life hard for our colleagues.
5. We don't expect anyone to know everything, but we are curious and learn along the way.
6. We learn about the fitness space and what it means to really be fit and not just Instagram fit.

The Python Backend Engineer position may be a good fit for you if:

1. You have 3 (or more) years of experience building and maintaining cloud applications.
2. You have built APIs with Python, Flask, Django or FastAPI before.
3. You have experience working with relational databases like PostgresSQL or MySQL and have spent time writing SQL queries for large datasets.
4. Experience in writing Unit tests with pytest.
5. You have worked with Docker, docker-compose.
6. Familiarity with the AWS ECS stack.

We want you to care about

1. Good object oriented design
2. Performant APIs
3. Analysing why queries are slow and how to go about improving them.
4. Understanding DNS, Load balancing, Caching and Hashing.
5. Customer data and privacy.

Our API Stack services use:

1. Python 3.8+, Typescript
2. FastAPI, Flask, HapiJs
3. PostgresSQL, MySQL
4. Redis
5. Celery
6. Pytest, Jest for unit testing.
7. Gitlab CI/CD
8. Amazon ECS container services

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.

• 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 

We are looking for a highly capable Node.js developer to optimize our web-based application performance. You will be collaborating with our front-end application developers, designing back-end components, and integrating data storage and protection solutions.

To ensure success as a Node.js developer, you should possess extensive knowledge of Node.Js based services and experience in a similar role. An accomplished Node.js developer will be someone whose expertise results in the stable, fast, and secure exchange of data between servers and end-users.

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.

Skills

• At least one year of experience as a Node.js developer.
• Extensive knowledge of JavaScript, web stacks, libraries, and frameworks.
• Knowledge of front-end technologies such as HTML5 and CSS3.
• 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.