PostGreSQL Database Administrator /Dynamo DB Database Administrator

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