Postgresql Dba

About Birlasoft:

Birlasoft, a powerhouse where domain expertise, enterprise solutions, and digital technologies converge to redefine business processes. We take pride in our consultative and design thinking approach, driving societal progress by enabling our customers to run businesses with unmatched efficiency and innovation. As part of the CK Birla Group, a multibillion-dollar enterprise, we boast a 12,500+ professional team committed to upholding the Group's 162-year legacy. Our core values prioritize Diversity, Equity, and Inclusion (DEI) initiatives, along with Corporate Sustainable Responsibility (CSR) activities, demonstrating our dedication to building inclusive and sustainable communities. Join us in shaping a future where technology seamlessly aligns with purpose.

• About the Job Looking for Postgresql DBA Candidate with experience in AWS. We are seeking an experienced PostgreSQL DBA with a strong focus on AWS RDS (Relational Database Service) to manage and maintain high availability, performance, and security of databases.The ideal candidate will have extensive hands-on experience with Postgres database administration, along with a good understanding of cloud-native database environments in AWS.You will be responsible for database design, optimization, troubleshooting, and ensuring database scalability, reliability, and performance.
• Job Title Postgresql DBA with AWS
• Experince- 8+years
• Location:All BSL
• Notice- Immediate or 15 days onlY

Roles and Responsibilities:

1. Database Management:

• Manage and maintain AWS RDS for PostgreSQL databases.
• Ensure database security, backup, recovery, and disaster recovery strategies.
• Automate routine database administration tasks using scripts (e.g., Bash, Python).
• Perform database upgrades, patches, and migrations between environments (e.g., on-prem to cloud).

1. Performance Tuning & Optimization:

• Monitor and optimize PostgreSQL performance, including query tuning, index optimization, and memory management.
• Troubleshoot performance issues using monitoring tools like CloudWatch, Performance Insights, and pg-stat-statements.
• Implement caching strategies and optimize database configurations for maximum throughput.

1. Database Design & Development Support:

• Collaborate with development teams to design highly efficient, scalable databases.
• Assist in writing complex SQL queries, stored procedures, and performance tuning of database operations.
• Ensure database schema designs follow best practices for normalization, indexing, and partitioning.

1. Backup & Recovery:

• Set up and maintain backup policies, automated recovery procedures, and periodic data integrity checks.
• Implement Point-in-Time Recovery (PITR) using AWS features and tools.
• Plan and execute DR (Disaster Recovery) testing and ensure RPO (Recovery Point Objective) and RTO (Recovery Time Objective) are met.

1. Security & Compliance:

• Implement Postgres security best practices like role-based access control (RBAC), SSL encryption, and auditing.
• Ensure data encryption at rest and in transit using AWS KMS (Key Management Service) or other encryption technologies.
• Ensure compliance with relevant regulations (e.g., GDPR, HIPAA) and enforce data privacy measures.

1. Monitoring & Alerting:

• Set up monitoring and alerting using AWS native services (e.g., CloudWatch, RDS Events) or third-party tools (e.g., Datadog, New Relic).
• Perform capacity planning and proactively monitor database health to avoid downtime.
• Address potential resource bottlenecks and plan for future growth.

1. Automation & Infrastructure as Code (IaC):

• Use tools like CloudFormation, Terraform, or AWS CDK to manage database infrastructure as code.
• Automate database provisioning, backups, scaling, and maintenance using AWS Lambda, CloudFormation, or similar tools.

1. Collaboration & Documentation:

• Collaborate with cross-functional teams (cloud engineers, DevOps, developers) for successful integration of database solutions.
• Maintain detailed documentation of database configurations, performance tuning actions, and database procedures.

1. Incident Management:

• Respond to database incidents, outages, and performance degradation events.
• Investigate and resolve PostgreSQL errors, log issues, and failures within SLA timelines.

Skills Required:

• 8+ years of experience in PostgreSQL DBA roles, with at least 3 years on AWS RDS Postgres.
• Strong knowledge of AWS services like RDS, EC2, VPC, and S3.
• Hands-on experience with performance tuning, database troubleshooting, and backup/recovery strategies.
• Expertise in database scripting and automation using Bash, Python, or similar.
• Knowledge of security best practices (SSL, encryption, role management).
• Familiarity with CI/CD pipelines and IaC tools (Terraform, CloudFormation).

Preferred Certifications:

• AWS Certified Database Specialty
• AWS Certified Solutions Architect
• Certified PostgreSQL DBA