Senior Backend Engineer – Database Design & Cloud Infrastructure

SWITS DIGITAL Private Limited; Chennai District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

SWITS DIGITAL Private Limited is seeking a highly experienced Senior Backend Engineer specializing in database design and cloud infrastructure. This role involves managing the core data layer for enterprise applications, focusing on schema design and AWS RDS configurations.

The ideal candidate should have over 6 years of experience with SQL, backend development using Node.js, and strong AWS RDS knowledge. Responsibilities include optimizing queries, database migrations, and supporting backend services with modern technologies.

Qualifications

• 6+ years of experience in SQL and relational database design.
• Experience managing AWS RDS including backups and scaling.
• Hands-on experience developing backend services using Node.js and TypeScript.

Responsibilities

• Design relational database schemas from scratch.
• Write and optimize complex SQL queries and stored procedures.
• Configure and manage Amazon RDS, including backups and scaling.

Skills

SQL and relational database design

PostgreSQL and/or MySQL

AWS RDS administration

Node.js

TypeScript

GraphQL (AWS AppSync or Apollo Server)

AWS CDK

Tools

DBeaver

Job description

Job Title: Senior Backend Engineer Database Design & Cloud Infrastructure

Location: Chennai, India

Experience Required: 6+ Years

We are looking for a highly experienced Senior Backend Engineer with strong expertise in relational database design, SQL, and AWS RDS to build and manage the core data layer of our enterprise applications. This role will primarily focus on database architecture, schema design, query optimization, migrations, and AWS RDS infrastructure, while also supporting backend development using Node.js, TypeScript, GraphQL, AWS Lambda, and AWS CDK.

Key Responsibilities

• Design relational database schemas from scratch, including tables, relationships, constraints, indexes, and normalization.
• Write and optimize complex SQL queries, stored procedures, and views.
• Manage database migrations, schema versioning, and rollback strategies.
• Configure and manage Amazon RDS (PostgreSQL/MySQL), including backups, scaling, and Multi-AZ deployments.
• Implement RDS Proxy for connection management in serverless environments.
• Develop backend services using Node.js and TypeScript on AWS Lambda.
• Build and optimize GraphQL APIs using AWS AppSync.
• Define and maintain infrastructure using AWS CDK in TypeScript.
• Apply AWS security best practices, including IAM, VPC, and Secrets Manager.

Required Skills

• 6+ years of experience in SQL and relational database design.
• Strong hands‑on experience with PostgreSQL and/or MySQL.
• Proven experience with AWS RDS administration and optimization.
• 6+ years of backend development experience using Node.js and TypeScript.
• Experience with GraphQL (AWS AppSync or Apollo Server).
• Experience with AWS CDK.
• Familiarity with DBeaver or similar database management tools.

Preferred Skills

• Experience with migration tools such as Flyway, Liquibase, Prisma Migrate, or TypeORM.
• Familiarity with RDS Proxy.
• Knowledge of data modeling patterns, audit trails, and multi‑tenancy architectures.
• Experience with read replicas and database query scaling.
• Exposure to Postman or similar API testing tools.