PostgreSQL Database Administrator – Developer

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

📋 Description

• Oversee and sustain PostgreSQL databases within AWS, which includes tasks such as monitoring, backups, upgrades, routine maintenance, and planning/testing for disaster recovery.

• Assist in the transition from SQL Server to PostgreSQL by converting and verifying database objects and processes.

• Collaborate with developers to create, review, and enhance database code while ensuring database efficiency.

• Strategize, manage, and execute database deployments and releases in coordination with development and operations teams across various environments.

• Assess database performance and troubleshoot issues alongside DBA, development, operations, help desk, and reporting teams.

• Adhere to and enhance security protocols, access controls, and data quality assessments.

• Automate routine tasks, refine team processes, and maintain comprehensive documentation and procedures.

• Collaborate closely with the Senior DBA, developers, and operations personnel to facilitate daily database operations and transition towards cloud-native methodologies.

⛳️ Requirements

• A Bachelor’s degree with 5 years of relevant experience, or 9 years of experience with a high school diploma/equivalent.

• Practical experience in PostgreSQL administration and database development.

• Experience managing PostgreSQL within AWS, including Amazon RDS for PostgreSQL and self-managed databases on EC2.

• Proficient in SQL and PL/pgSQL, particularly in query optimization and troubleshooting.

• Familiarity with backup and recovery processes, replication, and database security procedures.

• Scripting experience in Python, PowerShell, or similar languages.

• Background in Microsoft SQL Server.

• Excellent communication skills with a proven ability to collaborate effectively with developers, operations, and business users.

• Must be a U.S. citizen.

• Required to obtain and maintain the necessary agency clearance.

• Preferred: Hands-on experience with migrating from SQL Server to PostgreSQL, as well as understanding the differences between T-SQL and PL/pgSQL.

• Preferred: Familiarity with Git, CI/CD pipelines, and automated deployment processes for infrastructure and database modifications.

• Preferred: Experience with PostgreSQL administration tools such as psql, pgAdmin, pgBouncer, pgBackRest, Patroni, and pgBadger.

• Preferred: Experience with database IDEs and schema/data comparison tools like DBeaver, DataGrip, Visual Studio Code, and dbForge Schema Compare and Data Compare for PostgreSQL.

• Preferred: Knowledge of pgaudit, IAM database authentication, and KMS encryption.

• Preferred: AWS certifications, such as AWS Certified Solutions Architect – Associate or AWS Certified Database – Specialty.

🏝️ Benefits

• Medical insurance

• Dental insurance

• Vision insurance

• Life insurance

• Health savings account

• Short-term disability

• Long-term disability

• Employee assistance program (EAP)

• Parental leave

• 401(k)

• Paid time off (PTO) for vacation

• Company-paid holidays

• Potential eligibility for overtime

• Potential eligibility for shift differential

• Potential eligibility for a discretionary bonus