Job Description:
AWS Glue
AWS Database Migration Service (DMS)
AWS Lake Formation / Data Lakes
Redshift RBAC / security
Advanced Postgres tuning examples (parameter strategy, workload isolation)
This person will oversee daily operations of production, non-production and redundant database environments on the cloud and on-premises implementations
• Database Certification (Postgres or Oracle) preferred
• Should be skilled in AWS Glue and AWS Database Migration Service
• Skill in Amazon RDS and Amazon Aurora for PostgreSQL administration tasks
• General understanding of Amazon Redshift architecture and service model, including role-based access control, user/group management, and security permissions
• 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/analyze tuning, and parameter configuration
• Experience monitoring and troubleshooting PostgreSQL database performance, resource utilization, and availability
• Skill in AWS Lake Formation, data lake deployments and administration
• Strong SQL development skills across OLTP and analytical data platforms