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 transparent, 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.
Strong communication skills and ability to work within a distributed remote team.
Experience with AWS Aurora PostgreSQL.
Familiarity with Terraform or CloudF
📌 Database Administrator (India)
🏢 Aspire, Jordan
📍 India