PostgreSQL Database Administrator

4 days ago

New York City, NY, United States Nexiva Inc Full-time

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.