- Optimizes PostgreSQL performance through query optimization, index strategy, vacuum and analyze tuning, and database parameter configuration.
- Administers Amazon RDS and Amazon Aurora for PostgreSQL and supports database migration and data integration activities using AWS Database Migration Service and AWS Glue.
- Hands-on experience with PostgreSQL database administration, including installation, configuration, upgrades, and patching.
- Strong expertise in PostgreSQL performance tuning, including query optimization, index strategy, vacuum and analyze tuning, and parameter configuration.
- Experience monitoring and troubleshooting PostgreSQL database performance, resource utilization, and availability.
- Experience administering Amazon RDS and Amazon Aurora for PostgreSQL.
- Experience with AWS Lake Formation and data lake deployment and administration.
- General understanding of Amazon Redshift architecture and service model, including role-based access control, user and group management, and security permissions.
- Experience with AWS Glue and AWS Database Migration Service.
- Database certification in PostgreSQL or Oracle preferred.
Rate:
Not specified
Location:
Remote
IR35 Status:
Outside
Remote Status:
Remote
Industry:
IT
Seniority Level:
Not Specified