PostGreSQL Database administrator /Dynamo DB Database administrator

Job description

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 </div

Qualifications

BACHELOR OF ENGINEERING