PostgreSQL DBA

Conch Technologies
United States
8 days ago
Apply on www.adzuna.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source

Tech stack

Amazon Web Services Cloud Database Databases Database Security PostgreSQL Online Transaction Processing Performance Tuning Query Optimization Role-Based Access Control SQL Databases Database Optimization Database Performance
+8 more
Indexer Database Migration Amazon Relational Database Service Data Lakes AWS Lake Formation AWS Glue User Administration Amazon Redshift

Job description

We are seeking an experienced PostgreSQL Database Administrator (DBA) with strong hands-on experience in PostgreSQL and Amazon Aurora PostgreSQL. The ideal candidate will be responsible for database administration, performance optimization, monitoring, troubleshooting, and supporting cloud-based database environments., * Install, configure, upgrade, patch, and maintain PostgreSQL databases.

  • Administer and support Amazon RDS and Amazon Aurora PostgreSQL environments.
  • Perform database performance tuning, query optimization, and indexing strategies.
  • Manage vacuum and analyze operations and optimize database parameters.
  • Monitor database performance, resource utilization, availability, and reliability.
  • Troubleshoot database performance issues and resolve production incidents.
  • Develop and optimize SQL queries for OLTP and analytical database platforms.
  • Support AWS Lake Formation and data lake deployment and administration.
  • Work with Amazon Redshift, including user management, roles, groups, and security permissions.
  • Support AWS Glue and AWS Database Migration Service (DMS).
  • Ensure database security, availability, and operational efficiency.

Requirements

  • Strong hands-on experience with PostgreSQL Database Administration.
  • Mandatory: Amazon Aurora PostgreSQL experience.
  • Experience with Amazon RDS for PostgreSQL.
  • Strong knowledge of PostgreSQL performance tuning and query optimization.
  • Expertise in indexing, vacuum, analyze, and database parameter configuration.
  • Strong SQL development and troubleshooting skills.
  • Experience with AWS Lake Formation and data lake administration.
  • Understanding of Amazon Redshift architecture, RBAC, and security permissions.
  • Experience with AWS Glue and AWS Database Migration Service (DMS).
  • Strong communication and problem-solving skills.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.adzuna.com
Prepare application

Good distractions

Loading talks and stories from around this role…