Please mention DailyRemote when applying
AI Summary
This is a remote position.
About the Role
As a Senior DBA - PostgreSQL & RDS 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 p glogical, logical replication, or blue-green deployment strategies.
AWS certifications (e.g., AWS Certified Database – Specialty).
Awareness or knowledge of IT security best practices as defined by ISO / SOC or similar.
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.
Exposure to work in an IT environment that adheres to rigorous security and compliance standards defined by ISO / SOC.
Automatically Apply to the Best Remote Jobs
Stop the endless job search. Our AI finds and applies to the best jobs for you.
