Database Engineer

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