More jobs:
Aurora PostgreSQL Database Administrator; DBA)
Job in
Seven Hills, Cuyahoga County, Ohio, USA
Listed on 2026-09-01
Listing for:
TALENT Software Services
Full Time
position Listed on 2026-09-01
Job specializations:
-
IT/Tech
Database Administrator, AWS, Disaster Recovery IT
Job Description & How to Apply Below
- Experience Level: Senior-level
- Experience
Required:
5-10+ years
- Job Title:
Aurora PostgreSQL Database Administrator (DBA) - Experience Level: Senior-level
- Experience
Required:
5-10+ years - Primary Database:
PostgreSQL / Amazon Aurora PostgreSQL
- Experienced Aurora PostgreSQL DBA responsible for designing, administering, optimizing, and supporting highly available PostgreSQL databases on Amazon Aurora PostgreSQL.
- Responsible for:
- Database reliability
- Performance
- Security
- Backup and recovery
- Monitoring
- Production support
- Support database environments across:
- Development
- Test
- Production
- Strong hands-on PostgreSQL and AWS/Amazon Aurora experience required.
- Strong understanding of:
- Database performance
- High availability
- Automation
- Troubleshooting
- Administer and support Amazon Aurora PostgreSQL database environments.
- Install, configure, upgrade, patch, and maintain PostgreSQL/Aurora systems.
- Manage:
- Aurora clusters
- Read replicas
- Failover
- Parameter groups
- Subnet groups
- Endpoints
- Perform database performance tuning, including:
- Query optimization
- Execution plan analysis
- Index optimization
- Connection and memory tuning
- Lock and wait-event analysis
- Vacuum/autovacuum optimization
- Monitor database:
- Health
- Capacity
- Performance
- Availability
- Use AWS and PostgreSQL monitoring tools.
- Implement and maintain:
- Backup and restore strategies
- Disaster recovery (DR)
- Business continuity strategies
- Perform Point-in-Time Recovery (PITR).
- Support database recovery exercises.
- Troubleshoot production issues, including:
- Database incidents
- Performance problems
- Connectivity issues
- Replication issues
- Database failures
- Manage database security:
- Users
- Roles
- Permissions
- Encryption
- Auditing
- Access controls
- Work with application and development teams on:
- SQL queries
- Schema design
- Indexes
- Database-related application issues
- Support migrations to Aurora PostgreSQL from:
- On-premises DB2
- Other database platforms
- Develop automation and operational scripts using:
- Python
- AWS Lambda
- AWS CLI
- Establish and maintain:
- Database standards
- Operational procedures
- Documentation
- Runbooks
- Participate in on-call rotations.
- Provide production support for critical database environments.
- Assist with:
- Capacity planning
- Cloud cost optimization
- Database modernization initiatives
- 5+ years of database administration experience with PostgreSQL.
- 2+ years of hands-on experience with Amazon Aurora PostgreSQL.
- Strong understanding of:
- PostgreSQL architecture
- PostgreSQL administration
- PostgreSQL internals
- Strong experience with:
- SQL
- PL/pgSQL
- Indexes
- Transactions
- Locking
- Query execution plans
- Experience with:
- PostgreSQL backup and recovery
- Replication
- High-availability strategies
- Strong AWS knowledge, particularly:
- Amazon Aurora
- Amazon RDS
- EC2
- IAM
- Cloud Watch
- S3
- Airflow
- Lambda
- Experience troubleshooting database performance using:
- EXPLAIN
- EXPLAIN ANALYZE
- PostgreSQL statistics views
- AWS Performance Insights
- Cloud Watch
- Experience with database monitoring and alerting.
- Strong scripting and automation skills using Python or similar languages.
- Experience working with:
- Production-critical databases
- Incident management processes
- AWS Certified Database - Specialty or comparable AWS certification.
- PostgreSQL certification or equivalent professional experience.
- Experience migrating databases to Aurora PostgreSQL using AWS Database Migration Service (DMS).
- Experience with CI/CD pipelines.
- Experience with database observability tools such as:
- Datadog
- Grafana
- Similar platforms
- Experience with:
- PostgreSQL version upgrades
- Aurora major-version upgrades
- Databases:
- PostgreSQL
- Amazon Aurora PostgreSQL
- Amazon RDS
- AWS:
- Aurora
- RDS
- EC2
- VPC
- IAM
- Cloud Watch
- S3
- KMS
- DMS
- Lambda
- Airflow
- Performance Tuning:
- EXPLAIN / EXPLAIN ANALYZE
- Query tuning
- Indexing
- Wait-event analysis
- Lock analysis
- Vacuum/autovacuum
- Connection management
- High Availability & Disaster Recovery:
- Aurora replication
- Read replicas
- Failover
- Backup/restore
- Point-in-Time Recovery
- Disaster recovery
- Automation:
- Python
- AWS CLI
- Lambda
- Airflow
- Monitoring & Observability:
- AWS Performance Insights
- Cloud Watch
- PostgreSQL monitoring
- Grafana
- Prometheus
- Datadog
- Strong analytical and problem-solving skills.
- Excellent troubleshooting skills.
- Strong incident-management capabilities.
- Ability to work effectively…
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×