PostgreSQL DBA
Conch Technologies
United States
8 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.adzuna.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
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
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦