Database Administrator

Job Role: - DBA

Years of experience: - 6-8

Location: - Bangalore

Hybrid Mode (Work from office)

Shift: - Rotational (sometimes)

Position Overview

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

Database Management

• 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

Data Layer Technologies (EC2-based)

• PGBouncer:
Configure and maintain connection pooling for PostgreSQL

• RabbitMQ:
Setup and manage message queuing systems

• Apache Kafka:
Implement data streaming and event processing

• Redis:
Manage caching layers and session storage

• TimescaleDB:
Handle time-series data and extensions

AWS Managed Services Transition

• Plan migration from self-managed to AWS managed services (RDS, MSK, SQS)

• Evaluate and recommend appropriate AWS services for current workloads

• Design migration strategies with minimal downtime

• Ensure compatibility and performance during service transitions

• Document migration processes and best practices

Monitoring & Maintenance

• Set up monitoring for all data layer components

• 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

• Database Administration:
Backup/recovery, performance tuning, user management

• 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

• Scripting:
Bash, Python (basic automation)

• 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+ years
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

Key Competencies

• Troubleshooting database connectivity and 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