Postgres SQL Data Engineer

Viva Tech Solutions LTD - Las Vegas, NV

Full-time

Las Vegas, NV

About the position

The Postgres SQL Data Engineer role is focused on managing and optimizing AWS RDS databases, particularly in PostgreSQL environments. The position requires extensive experience in database administration, performance assessment, and configuration of complex RDS databases to ensure high availability and resiliency. The engineer will also be responsible for monitoring database performance and utilizing various tools to enhance database operations.

Responsibilities

• Manage and optimize AWS RDS databases, particularly PostgreSQL.
• Conduct capacity planning and performance assessments of AWS RDS.
• Administer complex RDS databases in AWS, ensuring high availability and resiliency.
• Monitor multiple RDS instances and manage different database versions on large systems.
• Utilize reporting and query tools to enhance database performance.
• Implement Performance Insights and manage RDS KPIs.

Requirements

• 8-10 years of experience in database administration, specifically with PostgreSQL and SQL Server.
• Hands-on experience with AWS RDS and its configuration.
• Strong technical knowledge in PostgreSQL administration and associated tools like PeBouncer and PePool.
• Experience in managing high availability and resiliency solutions using Aurora Read replicas and Global Database.
• Practical experience in monitoring database performance and using performance insights.

Nice-to-haves

• Working knowledge of AWS Lambda and Python.
• Experience with reporting and query tools.