PostgreSQL Database Administrator, PostgreSQL DBA
- Steneral Consulting
14 Hours Ago
NA
W2
Remote
8-10 Years
Required Skills: PostgreSQL database administration, PostgreSQL installation, configuration, upgrades, patching, PostgreSQL performance tuning, Query optimization, Index strategy, Vacuum tunning, Analyze tuning, Database parameter configuration, PostgreSQL monitoring and troubleshooting, Resource utilization and availability management, Amazon RDS, Amazon Aurora, AWS Database Migration Service, DMS, AWS Glue, AWS Lake Formation, Data lake deployment and administration
Job Description
- 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.
