
Amazon Aurora PostgreSQL Database Administrator
Q1 Technologies · Aurora, IL
Strong hiring record · median 12 days open
- First seen
- 14 November 2026
- Reposted
- Not since September 2026
- Last checked
- Today · still on the employer's board
All reasons
In its favour
- Posted 2 days ago
- Still listed on the employer's own board
Must Have Technical/Functional Skills
Technical Skills
- Strong expertise in PostgreSQL architecture, replication, backup and recovery.
Deep knowledge of AWS database services, including
o Amazon Aurora PostgreSQL
o Amazon RDS
o AWS DMS
o AWS SCT
o CloudWatch
o IAM
o KMS
- Experience with database performance tuning and troubleshooting.
- Proficiency in scripting languages such as Python, Bash, or PowerShell.
- Experience with Infrastructure-as-Code tools including Terraform, Ansible or CloudFormation.
- Familiarity with CI/CD tools and DevOps practices.
Experience
- Minimum 5+ years of hands-on database administration experience.
- Strong experience administering PostgreSQL databases in AWS environments.
- Proven experience with Amazon Aurora PostgreSQL and Amazon RDS services.
Roles & Responsibilities
Database Administration
- Provision, configure, monitor and maintain Amazon Aurora PostgreSQL and Amazon RDS databases.
- Perform database installation, upgrades, patching and lifecycle management.
- Monitor database health, capacity and performance metrics.
Performance Optimization
- Analyze and optimize SQL queries and database workloads.
- Implement indexing strategies and query tuning best practices.
- Manage connection pooling and resolve infrastructure bottlenecks.
- Troubleshoot and resolve database performance issues.
High Availability & Disaster Recovery
- Design and implement Multi-AZ deployments and cross-region replication.
- Develop, test, and maintain backup and disaster recovery processes.
- Ensure database availability and business continuity objectives are met.
Cloud Migration & Modernization
- Lead or support database migration initiatives to Aurora PostgreSQL.
- Utilize AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT) for migration projects.
- Perform migration assessments, validations and post-migration optimization.
Automation & Infrastructure as Code (IaC)
- Develop automation scripts for routine database administration activities.
- Manage infrastructure using Terraform, Ansible or AWS CloudFormation.
- Support CI/CD pipeline integration for database deployments and schema changes.
Security & Compliance
- Implement security controls, database encryption and access management.
- Apply database patches and vulnerability remediation activities.
- Ensure compliance with organizational and regulatory security standards.
- Perform periodic security reviews and audit support activities.
Skills
- Aurora
- PostgreSQL
- AWS
- RDS
- AWS CloudWatch
- IAM
- KMS
- Python
- Bash
- PowerShell
- Terraform
- Ansible
- AWS CloudFormation
- SQL
More jobs at Q1 Technologies
All 359- Azure Data CloudQ1 Technologies · Aurora, IL2d ago
- Java Senior Engineer (26-07554) -Q1 Technologies · Location not stated2d ago
- Senior Test Automation Engineer - API TestingQ1 Technologies · Aurora, IL2d ago
- Mainframe DeveloperQ1 Technologies · Aurora, IL2d ago
- QA Automation EngineerQ1 Technologies · Aurora, IL2d ago
Similar roles
- Senior Database Administrator - Production SupportJobgether · US · USD 116,450–157,550/yrtoday
- Power BI Developer / Data Visualization AnalystJobgether · UStoday
- Data Engineering Solution LeadJobgether · UStoday
- Staff Data Platform Engineer, Knowledge PlatformAirwallex · US - Seattletoday
- Data Platform Principal Architect, Seattle/San FranciscoAirwallex · US - Seattletoday
- Senior Battery Data EngineerRedwood Materials · San Francisco, California, United Statestoday