PostgreSQL Developer

Location: Hybrid remote schedule with onsite support in Suitland, MD once or twice per month; standard business hours aligned to the Eastern Time Zone. U.S. Citizenship and authorization to work in the United States are required.

Salary: $110,000–$130,000 USD annually.

Company

hirify.global delivers engineering and technology solutions for critical, mission-focused customers, including federal government clients.

What you will do

• Develop PostgreSQL schemas, SQL, PL/pgSQL procedures, functions, views, indexes, data models, APIs, and migration scripts for enterprise applications.
• Design scalable database architectures and optimize query execution, indexing, schemas, and application/database performance.
• Support PostgreSQL adoption, Oracle-to-PostgreSQL modernization, dependency analysis, migration validation, reconciliation, and testing.
• Coordinate application-side database requirements with infrastructure DBAs, including permissions, maintenance schedules, backup and recovery requirements, deployments, rollbacks, and operational readiness.
• Manage database code, automated testing, releases, and CI/CD pipelines in GitHub while collaborating with Java, cloud, DevOps, infrastructure, and security teams.
• Investigate production issues, conduct root-cause analysis, and ensure database activities meet security, audit, and compliance requirements.

Requirements

• Ability to obtain and maintain a Public Trust security clearance issued by the United States Census Bureau; U.S. Citizenship is required.
• Bachelor’s degree in Computer Science, Software Engineering, or a related IT field.
• 5+ years of professional software engineering, database application development, or database engineering experience supporting enterprise systems.
• Advanced PostgreSQL development experience, including schema design, SQL optimization, indexing, data modeling, PL/pgSQL, and database performance tuning.
• Experience designing and supporting enterprise applications backed by relational databases, including PostgreSQL integration with Java/Spring Boot and REST architectures.
• Experience developing and deploying database changes through automated CI/CD pipelines, with GitHub and modern source-control practices.
• Experience troubleshooting performance issues across application and database layers and working in AWS-hosted or cloud-based environments.
• Experience operating within structured SDLC, change-management, security, and compliance frameworks.
• Ability to coordinate with infrastructure DBA teams and communicate effectively across technical disciplines.

Nice to have

• Oracle-based application and Oracle SQL experience, including Oracle-to-PostgreSQL migrations or Oracle APEX.
• Flyway, Liquibase, AWS RDS PostgreSQL, Aurora PostgreSQL, Docker, Kubernetes, or other containerized-platform experience.
• Cognos reporting and analytics experience.
• Python, Bash, or PowerShell automation experience.
• Federal government or regulated-environment experience.
• PostgreSQL, AWS, Java, DevSecOps, or cloud-related certifications.

Culture & Benefits

• Hybrid and remote work opportunities with flexible scheduling and work-life-balance support.
• Nationwide medical, dental, and vision insurance, life insurance, short- and long-term disability coverage, and supplemental insurance options.
• Three weeks of paid time off, 11 paid federal holidays, and 401(k) matching.
• Flexible spending and dependent-care accounts, wellness incentives, and professional-development and certification reimbursement.
• Training assistance and opportunities for career growth; occasional travel to client sites or meetings may be required.

Hiring process

• Applications are reviewed as received on a continuous basis until the position is filled; early application is encouraged.
• Employment is contingent on identity and U.S. employment-eligibility verification, applicable pre-employment requirements, and the required Public Trust clearance process.