Database Administrator (RSD and PostgresSQL)

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. - Strong communication skills and ability to work within a distributed remote team. - Experience with AWS Aurora PostgreSQL. - Familiarity with Terraform or CloudFormation for infrastructure provisioning. - Experience with database monitoring tools (e.g., pgBadger, Datadog, CloudWatch Insights). - Knowledge of pglogical, logical replication, or blue-green deployment strategies. - AWS certifications (e.g., AWS Certified Database – Specialty). Why Aspire In addition to a competitive long-term total compensation package with salary and performance-based bonus, we have a reward philosophy that goes beyond compensation. - Be part of a remote-first organization where flexibility is embraced. - Work and learn alongside talented engineers and technology leaders. - Explore opportunities to learn and grow through technical and non-technical training programs. - Gain global exposure by working on products with international teams and clients. - Attend virtual and in-person international technology conferences to expand your knowledge and network.