Job Description

Job Title: Database Engineer

Overview

We are seeking a highly motivated and detail-oriented Database Engineer with 1-2 years of experience in managing, optimizing, and maintaining both single-tenant and multi-tenant database architectures. The ideal candidate will have hands-on experience with relational, distributed, and NoSQL databases, including PostgreSQL, MySQL, Redis, ClickHouse, Kafka, and MongoDB. This role involves designing scalable schemas, optimizing queries, implementing replication strategies, managing high-availability clusters, and ensuring the overall health and performance of database systems across environments.

Key Responsibilities

Design, implement, and maintain database schemas for single-tenant and multi-tenant applications. Manage master-slave, primary-write and multiple-read replica database configurations. Configure and maintain distributed database architectures for scalability and reliability. Develop and manage stored procedures (SPs), triggers, functions, and views. Implement and monitor high-availability (HA) clusters and failover mechanisms. Perform database optimization, query tuning, and index management for performance improvement. Manage data replication, partitioning, and sharding strategies for large-scale systems. Set up backup and recovery processes and ensure disaster recovery (DR) readiness Implement security best practices including role management, DCL permissions, and encryption. Monitor database health using tools like pgAdmin, Percona Toolkit, Prometheus, Grafana, or equivalent. Integrate Kafka for data streaming and event-driven architectures. Manage and optimize Redis for caching and in-memory data operations. Work with ClickHouse for analytical workloads and distributed data queries. Maintain and optimize MongoDB clusters for high-performance NoSQL operations. Write and execute all categories of SQL operations -- DDL, DML, DCL, DQL, and TCL. Collaborate with development and DevOps teams for database CI/CD and schema versioning.

Required Qualifications

Bachelor's degree in Computer Science, Information Technology, BCA, or a related eld. 1-2 years of professional experience in database engineering or administration. Hands-on experience with PostgreSQL and MySQL for transactional and analytical workloads. Strong understanding of SQL fundamentals, query optimization, and execution plans. Practical knowledge of replication, sharding, partitioning, and multi-tenant data models. Familiarity with Redis (caching), ClickHouse (analytical DB), Kafka (data streaming), and MongoDB (NoSQL). Experience in backup, restore, HA, and DR configurations. Proficiency in database monitoring and tuning tools. Knowledge of database security and access control (roles, grants, privileges).

Preferred Skills (Nice to Have)

Experience with cloud-hosted databases (AWS RDS, Aurora, Azure Database, GCP Cloud SQL). Understanding of containerized database environments using Docker or Kubernetes. Knowledge of ETL pipelines and data migration strategies. Exposure to automated schema deployment tools such as Liquibase or Flyway. Familiarity with time-series, real-time analytics, or OLAP systems. Experience writing database design documentation and performance reports.

Experience Level

1-2 years of hands-on experience as a Database Engineer, DBA, or similar role.

Languages

Tamil and English (written and verbal proficiency required).

Employment Type

Full-time

Location

On-Site : Salem, Chennai

Job Type: Full-time

Pay: ₹12,000.00 - ₹25,000.00 per month

Benefits:

Food provided
Work Location: In person