CloudThat - Database Administrator - PostgreSQL

Description :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. (ref:hirist.tech)