16 Aug
|
Aspire, Jordan
|
India
16 Aug
Aspire, Jordan
India
About the Role
As a Database Administrator (DBA) at Aspire, you will be responsible for supporting a major database upgrade project—planning, executing, and validating the migration of our PostgreSQL and AWS RDS environments. You will ensure high availability, minimal downtime, and data integrity throughout the process, with a focus on database architecture, upgrade strategy, performance tuning, and RDS service management throughout the upgrade lifecycle.
What You'll Do
- Lead and execute major PostgreSQL and AWS RDS database version upgrades.
- Develop and maintain detailed upgrade plans, rollback procedures, and operational runbook.
- Perform pre- and post-upgrade database health checks, validation, and performance benchmark.
- Monitor, tune, and optimize database performance during and after migration.
- Collaborate with application, infrastructure, and DevOps teams to coordinate upgrade activities.
- Schedule and execute critical tasks during designated low-traffic maintenance windows.
- Document all procedures, configurations, and changes in a clear, auditable manner.
- *(Role B only)*
Write and maintain Bash scripts to automate routine DBA tasks and upgrade steps.
- *(Role B only)*
Manage version-controlled scripts, runbook, and configs using GitHub.
What You'll Need
- 5+ years of hands-on DBA experience with PostgreSQL in production environments.
- Strong experience with AWS RDS (PostgreSQL engine) and related services (RDS Proxy, Parameter Groups, CloudWatch, Snapshots, Multi-AZ).
- Proven track record of managing major database version upgrades with minimal disruption.
- Proficiency in query optimization, indexing strategies, vacuum/analyze tuning, and connection management.
- Experience with database backup, recovery, and point-in-time restore procedures.
- Solid understanding of high availability and disaster recovery configurations.
- Solid communication skills and ability to work within a distributed remote team.
- Experience with AWS Aurora Postgre
📌 Database Administrator (India)
🏢 Aspire, Jordan
📍 India