Database Administrator – PostgreSQL

This is a fully remote position, open to applicants in United States.

📋 Description

• Manage PostgreSQL and MySQL databases on Amazon RDS across Development, Testing, Implementation, and Production environments.

• Conduct daily health assessments, capacity and storage oversight, log evaluations, and troubleshooting for locks and connections.

• Strategize and implement database version upgrades and quarterly AWS operating system patches, incorporating blue/green deployments, validation, rollback planning, and environment decommissioning.

• Take ownership of AWS Backup strategies, including snapshots, point-in-time recovery, and scheduled restore tests with documented evidence.

• Monitor and optimize database performance utilizing pg_stat_statements, Performance Insights, query execution plans, indexing, and management of vacuum and bloat.

• Oversee database access and security protocols, encompassing role-based and time-sensitive access, IAM authentication support, and pgaudit audit trails.

• Assist in application deployments by evaluating and executing Liquibase changes, monitoring database activity during releases, and implementing rollback plans.

• Develop and maintain monitoring systems, alarms, and automation through CloudWatch, SNS, pg_cron, Ansible, and Jenkins.

• Collaborate on ETL development and data modeling with the data architecture team utilizing Talend and Erwin Data Modeler.

• Author and update runbooks and technical documentation.

• Work closely with developers, testers, DevOps engineers, and security personnel; engage in Agile planning, estimation, and on-call triage.

⛳️ Requirements

• Must be eligible to obtain and maintain a Public Trust clearance.

• Bachelor's degree in a relevant technical discipline or equivalent professional experience.

• At least three years of experience managing production relational databases.

• Experience serving as a PostgreSQL DBA, including backup and recovery, replication, performance tuning, vacuum and bloat management, and parameter configurations.

• Practical experience with Amazon RDS for PostgreSQL.

• Proficient in SQL, including PL/pgSQL, with a solid understanding of MySQL.

• Experience participating in on-call/triage rotations.

• Familiarity with change control and production change management processes.

• Excellent problem-solving abilities and communication skills.

🏝️ Benefits

• Opportunity to earn an annual bonus.

• Medical benefits.

• Dental benefits.

• Vision benefits.

• Paid Time Off (PTO).

• Company-covered life insurance.

• Generous 401k matching program.

• Meaningful work contributing to the public good.

• Initiatives promoting diversity, equity, and inclusion.

• A calm workplace environment free from artificial urgency, facetime, or workaholism.