Job Title: PostgreSQL DBA / DynamoDB Database Administrator
Experience: 6-8 Years
Location: Kolkata
Employment Type: Full-Time
Mode of interview: F2F/ Walk-in on 8th Aug
Job Summary
We are looking for an experienced PostgreSQL DBA / DynamoDB Database Administrator with 6-10 years of experience in database administration, performance tuning, high availability, backup and recovery, and cloud database management. The ideal candidate will be responsible for managing mission-critical PostgreSQL and DynamoDB environments, ensuring optimal database performance, security, scalability, and reliability.
Key Responsibilities
PostgreSQL Database Administration
- Install, configure, upgrade, and maintain PostgreSQL database environments.
- Manage database performance tuning, query optimization, and troubleshooting.
- Implement and maintain database backup, recovery, and disaster recovery strategies.
- Configure and support PostgreSQL replication, clustering, and high-availability solutions.
- Monitor database health, storage utilization, and performance metrics.
- Perform database migrations, patches, and version upgrades.
- Manage database security, user roles, and access controls.
- Conduct capacity planning and database growth forecasting.
DynamoDB Database Administration
- Design, implement, and maintain DynamoDB database solutions.
- Create and optimize DynamoDB tables, indexes, and partition keys.
- Monitor and optimize read/write capacity and throughput performance.
- Implement backup, restore, and data retention policies.
- Ensure high availability, scalability, and fault tolerance of DynamoDB workloads.
- Analyze database access patterns and optimize cost and performance.
- Manage DynamoDB security, encryption, and access policies.
- Support application teams in database design and best practices.
Operations & Support
- Monitor database environments and resolve production incidents.
- Perform root cause analysis for database-related issues.
- Create and maintain operational documentation and runbooks.
- Collaborate with Infrastructure, Cloud, DevOps, and Application teams.
- Participate in on-call support and critical incident management.
Required Skills
Database Technologies
- PostgreSQL Database Administration
- AWS DynamoDB
- Database Performance Tuning
- Query Optimization
- Backup & Recovery
- Replication and High Availability
- Disaster Recovery Planning
Cloud & Infrastructure
- AWS Cloud Services
- Database Security and Compliance
- Linux Administration
- Cloud Monitoring & Logging
Scripting & Automation
- Shell Scripting
- Python
- SQL and PL/pgSQL
- Automation of Database Tasks
Preferred Skills
- Terraform
- AWS RDS PostgreSQL
- Aurora PostgreSQL
- DevOps Practices
- Kubernetes and Docker
- Monitoring Tools (CloudWatch, Grafana, Prometheus, CA-UIM)
Qualifications
- Bachelor's Degree in Computer Science, Information Technology, or related discipline.
- 6-10 years of experience in Database Administration.
- Strong experience supporting enterprise-scale PostgreSQL and DynamoDB environments.
Preferred Certifications
- AWS Certified Database Specialty
- AWS Certified Solutions Architect Associate
- PostgreSQL Professional Certification
- AWS SysOps Administrator