Mentor Database Administrator staff in coordination with VP of Product Development and DBA Team Lead, including task assignment and review.
Stay current on PostgreSQL (Aurora) and AWS database technologies; recommend and integrate new solutions into RouteSmart products.
Develop maintenance roadmaps for AWS database services to ensure timely patching and updates.
Design and implement logical and physical database structures based on customer requirements.
Provide guidance on database standards and procedures.
Collaborate with development and architecture teams to ensure smooth PostgreSQL transition to production.
Lead implementation of Multi-AZ and cross-region support, including migration to Aurora Global Database.
Implement automated methods and best practices for PostgreSQL configurations in production and non-production environments.
Manage backup/recovery functions for large PostgreSQL environments.
Monitor system health and performance; set up alerting mechanisms.
Manage user accounts, database security, and performance tuning.
Plan and coordinate system upgrades and capacity planning.
Manage Disaster Recovery environment and resolve incidents promptly.
Generate detailed reports on PostgreSQL processes and resource usage.
Other duties as assigned.

Requirements

Bachelor’s degree in Computer Science, Information Systems, Business Technology, or a related field, or equivalent relevant work experience
5+ years of experience as a Database Administrator, with the majority focused on PostgreSQL environments.
In-depth knowledge of PostgreSQL database architecture.
At least 2 years of experience working in a cloud environment.
AWS RDS certification(s) or other industry-standard DBA certifications strongly preferred.
Ability to perform database patching and maintenance during off-peak hours.

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

PostgreSQLAWSdatabase architecturedatabase maintenancedatabase securityperformance tuningbackup/recoveryMulti-AZcross-region supportautomated methods

Soft Skills

mentoringcollaborationguidancetask assignmentincident resolutionreport generationcapacity planningsystem upgradescommunicationleadership

Certifications

AWS RDS certificationindustry-standard DBA certifications