PostgreSQL Database Administrator
4 days ago
New York City, NY, United States
Nexiva Inc
Full-time
Free with email or Google
Save this job and keep your search organized
Create a free account to save jobs, create alerts and return to this listing from your dashboard.
Free with email or Google
By continuing, you agree to our Terms & Privacy Policy.
Title: PostgreSQL Database Administrator (DBA)
Location: REMOTE
Duration: 12 Months Contract
Interview Mode: Video
Job Description:
Notes
- 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.