Database Administrator

CloudThat; Ahmedabad District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A technology consulting firm in Gujarat is seeking an experienced Database Administrator to manage PostgreSQL databases and develop data layer solutions. The ideal candidate will have 3+ years of PostgreSQL experience, strong skills in data streaming and message queuing, as well as familiarity with Amazon AWS services. This full-time role offers a chance to work on cutting-edge technologies in a collaborative environment.

Qualifications

• 3+ years of production experience in PostgreSQL installation and troubleshooting.
• Understanding of master-slave setups and troubleshooting connectivity issues.
• Experience with EC2 instance management.

Responsibilities

• Manage PostgreSQL databases running on EC2 instances.
• Implement data streaming and event processing with Apache Kafka.
• Monitor database health and implement alerting solutions.

Skills

PostgreSQL management

Data streaming

Connection pooling

Linux administration

AWS Basics

Message queuing

Tools

PGBouncer

RabbitMQ

Apache Kafka

Redis

Git

Job description

Database Administrator

Join to apply for the Database Administrator role at CloudThat. We are seeking a Database & Data Infrastructure Engineer to manage and maintain our data layer technologies running on EC2 instances. This role focuses on PostgreSQL database management, data streaming, message queuing, and connection pooling solutions. The ideal candidate should be prepared to transition these services to AWS managed offerings (RDS, MSK, SQS, etc.) as our infrastructure evolves.

Key Responsibilities

• Manage PostgreSQL databases running on EC2 instances
• Handle database backups, recovery, and performance optimization
• Troubleshoot replication issues and cluster connectivity problems
• Monitor database health and implement alerting solutions
• Plan and execute database migrations and upgrades
• Configure and maintain connection pooling for PostgreSQL using PGBouncer
• Setup and manage message queuing systems with RabbitMQ
• Implement data streaming and event processing with Apache Kafka
• Manage caching layers and session storage with Redis
• Handle time‑series data and extensions using TimescaleDB
• Design migration strategies with minimal downtime for moving to AWS managed services
• Evaluate and recommend appropriate AWS services for current workloads
• Ensure compatibility and performance during service transitions
• Document migration processes and best practices
• Set up monitoring for all data layer components and create alerts for system health and performance issues
• Perform regular maintenance and updates
• Troubleshoot connectivity and performance problems
• Maintain documentation and runbooks

Required Technical Skills

• Database Technologies
  • PostgreSQL: 3+ years production experience with installation, configuration, and troubleshooting
  • Replication: Understanding of master‑slave setups and troubleshooting connectivity issues
• Data Layer Technologies
  • PGBouncer: Connection pooling setup and configuration
  • RabbitMQ: Message queue installation and basic clustering
  • Apache Kafka: Topic management and basic stream processing
  • Redis: Caching implementation and configuration
• Linux Administration: EC2 instance management and system administration
• AWS Services (Migration Ready)
  • Basic AWS Understanding: EC2, VPC, Security Groups, IAM
  • Managed Services Awareness: RDS, Amazon MSK, SQS, ElastiCache
  • Migration Mindset: Willingness to learn and transition to managed services
• Tools & Scripting
  • Monitoring: Basic monitoring setup (CloudWatch, system metrics)
  • Version Control: Git for configuration management

Required Experience

• 3+ years of PostgreSQL database administration
• 2+ years of Linux system administration
• 1+ year of experience with data layer technologies (PGBouncer, Redis, message queues)
• Experience with EC2 instance management and troubleshooting
• Basic understanding of AWS services and cloud concepts
• Troubleshooting database connectivity replication issues
• Setting up and configuring data layer services on Linux
• Performance monitoring and basic optimization
• Documentation and knowledge sharing
• Adaptability to learn new AWS managed services

Additional Information

• Seniority level: Mid‑Senior level
• Employment type: Full‑time
• Job function: Training, Consulting, and Information Technology
• Industries: IT Services and IT Consulting