PostgreSQL Database Administrator

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

Senior Software Engineer

Responsibilities:

• Lead by the principle of "customer first" to analyse, debug, develop, and maintain customer-centric software.

• Collaborate closely with multidisciplinary teams to analyse, debug and fix issues with high quality code, zero regressions, scalable, innovative technical solutions.

• Optimizing components for maximum performance and scalability

• Participates in R&D, Proof of Concepts, Prototyping, Code review, Root Causing, etc.

• At least 2-3 yrs of experience in taking full ownership of software development lifecycle including planning, design, architecture, development, test & deployment. And 2+ years of experience in supporting production or customer issues and escalations.

• Review and analyze support tickets that are complex in nature and require more technical knowledge to analyze. Investigate issues to identify root causes and document findings clearly.

• Influences the development practices so that they follow best practices, policies, and procedures.

• Ensure software products meet all non-functional requirements including operational and security needs.

• Excellent verbal and written communication skills, problem solving skills.

• Address complex technical challenges within software systems, ensuring robustness, compliance, and customer satisfaction.

• Contribute to knowledge base

• Support the Lead and Mentor the team of software engineers and own the technical health of the service the team is working on.

Requirements:

• Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.

• Minimum of 5 years of professional experience in Java development with expertise in core Java, JDK, data structures, and multithreading.

• Strong analytical skills with experience in root cause analysis and fixes • Strong experience with Spring and Spring Boot frameworks.

• Strong understanding of software design principles, architecture, and best practices

• Familiarity with server technologies, including Tomcat and WebLogic.

• Proficiency in working with relational databases such as Oracle and PostgreSQL

• Experience with messaging queues, particularly JMS MQ or Artemis MQ.

• Possess exceptional debugging and troubleshooting skills to resolve complex issues across the entire, cross-functional technology stack

• Awareness / exposure to debugging Frontend applications (ReactJS / .Net) is a good to have.

• Exposure to Kubernetes, containerization and cloud (AWS) technologies in building scalable, resilient, and distributed environments.

• Excellent problem-solving skills and the ability to work in a fast-paced and in production customer sensitive environments.

• Strong communication and collaboration skills. Quick learner.

• Experience and knowledge in working in the HRP application – specifically the Claims functionality. Added experience in other areas including Enrollment, Billing, Financials is a plus. Candidate must have worked previously in HRP

• Familiarity with ticketing systems (Jira, SalesForce) and production support workflows.

At Upswing, we are a passionate and self-driven team of thinkers who aspire to build the rails to connect the legacy financial sector with financial innovators through a simple and powerful banking-as-a-service (BaaS) platform.

We’re building our platform putting the focus on pragmatism, reliability, and maintainability. We believe that keeping the engineering complexity under control is key to preserving the development productivity and long-term evolution of a platform.

To bring this vision to life, we are building the infrastructure using Microservices architecture using the latest set of technologies that are also fun to work with such as Java, Scala, Postgres, Akka, Kafka with a completely automated DevOps pipeline from the get-go using tools like Chef, Jenkins, Grafana, Graylog.

We are looking for motivated engineers who will be working in a highly creative and cutting edge technology environment to build a world-class financial services suite.

Why you should join us:

• You will redefine the financial services landscape for India in the coming years.
• Be part of a core Engineering team that will create innovative and scalable Fintech solutions.
• Work with passionate and experienced engineering, product & business workforce that believes in teamwork, and that helps fast-track your learning on solving complex technical challenges.
• We are funded by the leading fintech VC `QED Investors` and other established Founders and Executives of awesome Indian companies.

What you will do if you join us:

• Propose solutions to solve complex system architecture challenges and actively lead the end-to-end development of the system.
• Create robust, flexible, consistent, and easy-to-use APIs
• Continuously strive for performance improvements, code reusability, and readability

You should have:

• Tech or a higher degree in computer science or a related field.
• 1+ years of experience working on the back-end development for complex distributed systems who are willing to adopt any Programming language as per the requirement.
• Familiarity with any of the following – Java, C++, Scala, Kotlin, and frameworks like Spring, Play, Hibernate, Django, etc.
• Good understanding of Algorithms, Data Structure, OOP, Design patterns, Parallel programming, Multithreading concepts & Event-Driven Systems.
• Experience with Relational databases such as MySQL, PostgreSQL, Oracle, or any NoSQL database.

It’s a plus if you have:

• Familiarity with cloud platforms like AWS, Azure, or Google Cloud
• Worked on Micro-services architecture

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

Key Skills Required :

1. Proficiency in Python 3.x based web and backend development
2. Solid understanding of Python concepts
3. Strong experience in building web applications using Django
4. Experience building REST APIs using DRF or Flask
5. Experience with some form of Machine Learning (ML)
6. Experience in using libraries such as Numpy and Pandas
7. Hands on experience with RDBMS such as Postgres or MySQL including querying
8. Comfort with Git repositories, branching and deployment using Git
9. Working experience with Docker
10. Basic working knowledge of ReactJs
11. Experience in deploying Django applications to AWS,Digital Ocean or Heroku

Responsibilities :

1. Understanding requirement and congributing to engineering solutions at a conceptual stage to provide the best possible solution to the task/challenge
2. Building high quality code using coding standards based on the SRS/Documentation
3. Building component based, maintainable, scalable and reusable backend libraries/modules.
4. Building & documenting scalable APIs on the Open Spec standard
5. Unit testing development modules and APIs
6. Conducting code reviews to ensure that the highest quality standard are maintained
7. Securing backend applications and APIs using industry best practices
8. Troubleshooting issues and fixing bugs raised by the QA team efficiently.
9. Optimizing code
10. Building and deploying the applications

Programming Languages: Perl, java. Perl programming with strong OOPs knowledge.

UI: HTML, JS
System: Linux must have – good knowledge and shell scripting experience.
Prior experience in infrastructure automation, monitoring will definitely help.


Description:

The person in this role:


- Will be involved in developing new monitoring scripts, enhancement & defect fixes on existing monitors

- Have to be on-call to support any incoming production/P1 internal issues which need urgent attention (team members are on call for a week and we have a weekly rotation policy within the team)
Preferred skills:

- Perl
- Shell scripting

- Unix

- Jenkins

Why join the navy when you can be the pirate?

Get onboard this ship & let's make KYC and onboarding easier than ever!

We want to ensure that our tech is successfully consumed by end users easily.

We are looking forward to work with you.

We would love to have you for the following reasons :

• Strong hold in python based backends such as Flask & Django
• Knowledge of backend principles, patterns, and best practices
• Aware of the open-source ecosystem and the libraries available.
• Proficient understanding of Git
• Must have written Unit, Integration and UI Test Cases
• Understanding of Cloud hosting (AWS,Azure) principles and interface guidelines
• Experience in working with distrubuted data using REST APIs, JSON and other technologies
• Potential interns with experience in containers will hold an advantage.
• Experience in Kafka & ELK will be an advantage.
• Experience of 1-2 years.