PostgreSQL Database Administrator (DBA) 5+ years Pune Full Time

ROLE- PostgreSQL Database Administrator (DBA)

LOCATION- Pune

EXPERIENCE- 5-10 Years

We are seeking a skilled PostgreSQL Database Administrator (DBA) with 36 years of experience to manage maintain and optimize our database systems. The ideal candidate will have hands-on expertise in PostgreSQL administration database performance tuning and backup strategies along with working knowledge of AWS database services (such as RDS EC2 S3 and CloudWatch). You will be responsible for ensuring database availability security and performance in both on-premise and cloud environments.

Key Responsibilities

Database Administration

• Install configure and upgrade PostgreSQL database servers and related tools.
• Manage database schemas tables indexes constraints and relationships.
• Perform routine database maintenance including vacuuming reindexing and statistics updates.
• Manage database replication (streaming or logical) clustering and failover setups.
• Implement and manage database backup and recovery procedures using tools like pgdump pgbasebackup and WAL archiving.
• Monitor database health query performance and storage utilization.
• Troubleshoot database errors crashes and performance bottlenecks.

Performance Tuning and Optimization

• Analyze slow queries and optimize SQL statements and indexes.
• Perform regular health checks query plan analysis and database tuning.
• Configure PostgreSQL parameters (e.g. shared buffers workmem autovacuum) for optimal performance.

Security and Compliance

• Implement and maintain user access control and role-based permissions.
• Ensure database security through encryption SSL and audit trails.
• Perform regular database patching and version upgrades to maintain compliance.
• AWS Cloud Database Operations
• Deploy and manage PostgreSQL databases on AWS services such as Amazon RDS Aurora PostgreSQL or EC2.
• Configure automated backups snapshots and monitoring via CloudWatch.
• Manage parameter groups security groups and IAM roles for database access.
• Support DR (Disaster Recovery) planning and cross-region replication.

Maintenance and Automation

• Automate repetitive DBA tasks using scripts (Python Bash or SQL).
• Schedule and monitor maintenance tasks such as backups reindexing and vacuuming.
• Support CI/CD pipelines for database schema deployment.
• Collaborate with development teams for schema design and data model optimization.

Monitoring and Reporting

• Set up and maintain monitoring tools (e.g. pgAdmin Prometheus Grafana AWS CloudWatch or Datadog).
• Generate performance reports and provide insights to improve database efficiency.

Required Skills and Qualifications

• Bachelors degree in computer science Information Technology or related field.
• 34 years of experience as a PostgreSQL DBA in production environments.
• Strong understanding of PostgreSQL internals performance tuning and SQL optimization.
• Experience with AWS cloud services related to database hosting and management.
• Proficiency with Linux/Unix environments and shell scripting.
• Hands-on experience with backup and recovery strategies replication and clustering.
• Familiarity with monitoring tools (e.g. CloudWatch pgstatstatements or similar).
• Strong troubleshooting and analytical skills.

Preferred Qualifications

• Certification in AWS (e.g. AWS Certified Database Specialty or AWS Solutions Architect Associate).
• Experience with automation tools (Terraform Ansible) for database provisioning.
• Exposure to other database platforms (MySQL MongoDB) is a plus.
• Understanding of DevOps pipelines and CI/CD integration with databases.

Soft Skills

• Excellent communication and documentation skills.
• Strong problem-solving and analytical mindset.
• Ability to work independently and collaborate in a cross-functional team environment.
• Commitment to continuous learning and staying updated with PostgreSQL and AWS trends.

Interested candidates can please revert with updated resume to .