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
Never miss an opportunity! Create an alert based on the job you applied for.
