The influencer marketing platform empowering ecommerce brands to build and cultivate influential communities
Senior DBA - PostgreSQL & RDS
Location
EST (UTC-5)
Posted
3 days ago
Salary
0
Seniority
Senior
Job Description
Senior DBA - PostgreSQL & RDS
Aspire
Role Description This is a remote position. We are seeking two experienced Database Administrators (DBAs) to support a major database upgrade project. The successful candidates will play a critical role in planning, executing, and validating the migration of our PostgreSQL and AWS RDS environments, ensuring high availability, minimal downtime, and data integrity throughout the process. Work will primarily follow Eastern Standard Time business hours, with flexibility required to perform critical upgrade activities during low-traffic windows such as late evenings or weekends. Focused on database architecture, upgrade strategy, performance tuning, and RDS service management throughout the upgrade lifecycle. Key Responsibilities - Lead and execute major PostgreSQL and AWS RDS database version upgrades - Develop and maintain detailed upgrade plans, rollback procedures, and runbooks - Perform pre- and post-upgrade database health checks, validation, and performance benchmarking - Monitor, tune, and optimize database performance during and after the 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 and 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, runbooks, and configs using GitHub Primary working hours align with Eastern Standard Time (EST). Candidates must be available for scheduled maintenance windows — including evenings and weekends — during critical phases of the upgrade project. Advance notice will be provided for all off-hours activities. Qualifications - 5+ years of hands-on DBA experience with PostgreSQL in production environments - Strong experience with AWS RDS (PostgreSQL engine) and related services (e.g., 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 Nice to Have - 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)
Related Guides
Related Job Pages
More Full-stack Engineer Jobs
Claims Technical Lead
AflacAflac gives you cash to help with expenses health insurance doesn't cover like deductibles and co-payments.
• acts as a main point of contact for claims specific questions for the case managers • serves as a mentor for new hires as well as supports new hiring training • takes an active role in refresher training and development of existing staff • ensures case managers are utilizing appropriate risk management skills to secure the appropriate claim outcome • conducts manager reviews/audits of claims as necessary to ensure overall quality • provides the appropriate coaching and feedback to case managers as needed • monitors KPIs and reports to ensure service levels and commitments are met, working with case managers as needed • monitors and adjusts workload balancing for case managers • provides support to management in facilitating team meetings/ huddles • may periodically manage complex cases and customer escalations • elevates any trends and/or coaching opportunities to the leadership team • completes special projects and/or ad hoc assignments as requested by leadership • performs other related duties as required
• Develop and maintain our SaaS platform using modern web technologies. • Collaborate with product and design teams to build user-friendly and scalable solutions. • Write clean, maintainable, and efficient code. • Troubleshoot and debug applications. • Stay up-to-date with emerging trends and technologies in web development.
• Start-up, commissioning and preventative maintenance along with repairs at customer sites. • Understanding customer requirements and working closely with them on existing systems • Informing the customer about obsolete equipment and stimulating replacement of old equipment that cannot be repaired anymore • Create accurate reports on all executed activities as well as the findings reported by the customer • Use and maintain all measuring equipment and tools optimally and timely calibrate these according to the procedures
Technical Lead
Müller's SolutionsTech Solutions company where we believe in empowering businesses to leap forward, by providing top-tier tech resourcs.
• Lead the design, development, and implementation of solutions on the Skadina platform. • Provide technical leadership and mentorship to development teams. • Translate business requirements into technical solutions. • Review code and ensure adherence to development standards and best practices. • Coordinate with architects, business analysts, and QA teams to ensure successful delivery. • Support system integration, testing, deployment, and post-production activities. • Troubleshoot and resolve complex technical issues. • Ensure application performance, security, and scalability. • Prepare technical documentation and knowledge transfer materials.
