PostgreSQL DBA with AWS RDS experience
Job Description: Must have 5+ years of PostgreSQL DBA experience with AWS RDS DB. Database Administrator Key Responsibilities - Design, Implementation & Configuration: Architect and configure AWS RDS instances tailored for PostgreSQL workloads. Oversee migrations from on-premises or alternative cloud databases to AWS RDS/PostgreSQL. Performance Management: Monitor performance metrics, diagnose bottlenecks, and optimize query execution plans. Implement indexing, partitioning, and caching strategies for high availability and throughput. Security & Compliance: Apply best practices for database security, encryption, backups, and disaster recovery in AWS. Ensure regulatory compliance and data privacy standards (e.g., GDPR, HIPAA). Maintenance & Troubleshooting: Perform upgrades, patching, and maintenance of database environments. Respond to incidents, troubleshoot failures, and provide root cause analyses. Automation & Monitoring: Develop and maintain automated scripts for provisioning, backup, and monitoring. Integrate AWS CloudWatch, SNS, and other tools for real-time alerting and analytics. Collaboration & Documentation: Work closely with DevOps, application developers, and project managers to support database needs. Document operational procedures, topologies, configurations, and lessons learned. Required Skills & Qualifications Technical Expertise: Deep experience with AWS RDS management, performance tuning, and scalability. Advanced knowledge of PostgreSQL architecture, administration, and optimization. Hands-on with backup, restore, high-availability setups (read replicas, Multi-AZ), and failover strategies in AWS. Proficient in SQL and procedural languages (PL/pgSQL); familiar with data migration tools (DMS, pg_dump, etc.). Cloud & DevOps Knowledge: Experience with infrastructure-as-code tools (CloudFormation, Terraform) for database provisioning. Understanding of VPC, IAM roles, encryption options, and integration with other AWS services. Soft Skills: Strong analytical, troubleshooting, and communication abilities. Commitment to continual learning and adapting in cloud-first environments Administration of RDS and Postgres DBs Apply tot his job