Astek
Website:
astekgroup.fr
Job details:
About the Role
As a Database Administrator (DBA), 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).
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.
Click on Apply to know more.