PostgreSQL Developer

At Imagine Believe Realize, LLC (IBR) we are driven by innovation, transformation and a relentless pursuit of excellence. As an industry leader delivering impactful results, we thrive on solving complex technical challenges and developing cutting-edge solutions that empower our customers and advance critical missions.

IBR is a fast-growing company fueled by passion, curiosity, and innovative thinking – where every team member has the opportunity to continuously learn, unlock their full potential, and redefine what is possible in engineering and technology. If you are inspired by innovation, eager to make a difference, and ready to bring your creativity and expertise to a mission-focused team, we invite you to join us and together, we will shape the future. Let’s Make It Real!

The PostgreSQL Developer must be able to meet the key criteria below:
Location: Candidates must be able to support a hybrid remote work schedule with the willingness to come onsite as needed in Suitland, MD. The onsite support is anticipated to be minimal at once or twice per month.
Education: Bachelor’s Degree in Computer Science, Software Engineering or related IT field.
Security Clearance: IBR is a federal contractor. Applicants must be able to obtain and maintain a Public Trust security clearance issued by the United States Census Bureau. This agency handles and adjudicates the security clearance process.
NOTE: United States Citizenship is required as part of the eligibility criteria to be able to obtain this type of security clearance.
Employment Type: Full Time
Work Schedules: IBR promotes work-life balance by offering flexible scheduling options. Standard business hours are aligned to the Eastern Time Zone.
Key Skills:

• Advanced PostgreSQL database development, optimization, and performance tuning
• Database-centric application development
• Database modernization and migration initiatives (Oracle – PostgreSQL)
• Working knowledge of Oracle databases and Oracle SQL.
• Java and Spring Boot application integration
• AWS cloud technologies and containerized environments
• GitHub-based source control and CI/CD pipelines

Position Overview
IBR is seeking a PostgreSQL Developer to support the continued modernization and development of an enterprise platform. This role requires a background in software development and database engineering experience where there has been demonstrated experience in building database-driven applications and designing scalable data solutions within modern cloud environments.

This position is focused on application development, database engineering, and modernization efforts. The PostgreSQL Developer will help drive PostgreSQL adoption and database modernization initiatives while supporting existing Oracle-based applications during the transition. The role serves as the primary liaison between application development teams and infrastructure DBA teams, ensuring that database changes, maintenance activities, security requirements, permissions, backup schedules, and operational needs are effectively coordinated and successfully implemented. This position operates primarily with application-schema or database owner (DBO) permissions and focuses on engineering, development, and modernization. Infrastructure DBAs maintain responsibility for database administration activities including backups, patching, database upgrades, disaster recovery, maintenance jobs, monitoring, and platform operations.

The enterprise platform includes Java/Spring Boot backend services, Angular front-end applications, PostgreSQL and Oracle databases, Cognos-based analytics, GitHub CI/CD pipelines, and AWS-hosted containerized infrastructure operating within a federal security and compliance environment.

Responsibilities
Database Application Development

• Develop PostgreSQL schemas, SQL, PL/pgSQL procedures, functions, views, indexes, and database objects supporting enterprise application requirements.
• Create and maintain application data models, data access patterns, APIs, migration scripts, and integration components.
• Partner with Java/Spring Boot developers and Angular developers to implement scalable and high-performing application solutions.
• Develop secure, maintainable, and well-documented code following enterprise development standards.
• Participate in code reviews and promote software engineering best practices across development teams.

PostgreSQL Engineering & Data Architecture

• Serve as a PostgreSQL subject matter expert supporting application development and modernization initiatives.
• Design logical and physical data models that support scalability, performance, and long-term maintainability.
• Analyze query execution plans and optimize SQL performance through indexing, schema refinement, and workload analysis.
• Develop standards and best practices for PostgreSQL development, deployment, and performance management.
• Troubleshoot and resolve complex application and database performance issues.

Application Modernization & Cloud Migration

• Support strategic modernization initiatives focused on expanding PostgreSQL-based solutions.
• Analyze application dependencies, database structures, and integration patterns to support modernization efforts.
• Develop migration, validation, reconciliation, and testing approaches for database enhancement initiatives.
• Identify opportunities to reduce technical debt and improve long-term maintainability.
• Support cloud-native development strategies within AWS-hosted environments.

DBA Coordination & Operational Readiness

• Serve as the primary application-side point of contact for infrastructure DBA activities.
• Define application backup, recovery, retention, and testing requirements.
• Coordinate database maintenance schedules, permissions requests, deployment activities, and operational changes.
• Develop implementation plans, deployment procedures, rollback strategies, and validation processes for database releases.
• Validate application functionality following maintenance windows and infrastructure changes.
• Support production issue investigations and root-cause analysis activities in collaboration with DBA, infrastructure, and application teams.
• Ensure database-related activities align with security, audit, and operational requirements.

DevSecOps & CI/CD

• Manage database code and deployment artifacts within GitHub repositories.
• Develop and maintain automated deployment, testing, and release processes.
• Support CI/CD pipelines for database and application delivery.
• Develop automated testing capabilities for schema changes, stored procedures, and application integrations.
• Work closely with cloud engineers, DevOps teams, and security personnel to support secure and compliant deployments.

Agile Collaboration & Technical Leadership

• Manage database code and deployment artifacts within GitHub repositories.
• Develop and maintain automated deployment, testing, and release processes.
• Support CI/CD pipelines for database and application delivery.
• Develop automated testing capabilities for schema changes, stored procedures, and application integrations.
• Work closely with cloud engineers, DevOps teams, and security personnel to support secure and compliant deployments.

Required Qualifications

• Must be able to obtain and maintain a Public Trust security clearance. U.S. Citizenship required.
• Bachelor’s Degree in an IT-related field required.
• 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, and PL/pgSQL development.
• Strong experience designing and supporting enterprise applications backed by relational databases.
• Experience integrating PostgreSQL with Java/Spring Boot applications and REST-based architectures.
• Expertise in SQL development, query tuning, data modeling, and database performance optimization.
• Experience developing and deploying database changes through automated CI/CD pipelines.
• Experience with GitHub and modern source-control practices.
• Experience troubleshooting performance issues across application and database layers.
• Experience 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.

Preferred Qualifications

• Experience supporting Oracle-based applications and Oracle SQL.
• Experience with Oracle-to-PostgreSQL migration initiatives.
• Experience with Oracle APEX applications.
• Experience with Flyway, Liquibase, or similar database deployment frameworks.
• Experience supporting AWS RDS PostgreSQL, Aurora PostgreSQL, Docker, Kubernetes, or containerized platforms.
• Experience supporting Cognos reporting and analytics environments.
• Experience with Python, Bash, or PowerShell automation.
• Experience supporting federal government systems or regulated environments.
• PostgreSQL, AWS, Java, DevSecOps, or cloud-related certifications.

Application Deadline:  
Applications will be reviewed as received and accepted on a continuous basis until the position is filled. Early application is strongly encouraged.

Physical Demands and Work Environment
This role primarily involves sedentary work, in a workplace and/or home office environment. There are some physical demands associated with the role, including:

• Extended periods of sitting and working at a computer workstation.
• Occasional lifting and carrying of equipment or materials weighing up to 20 pounds.
• Occasional travel to client sites or meetings may be required.
• Work may need to be performed in a fast-paced environment requiring quick decision making.
• Flexible work arrangements may be available based on business needs.
• Will be exposed to a wide variety of clients in differing functions, personalities, and abilities.

Benefits and Compensation Information
At Imagine Believe Realize, LLC (IBR), we recognize that our employees are our greatest asset. We are committed to attracting and retaining exceptional talent by offering competitive compensation, comprehensive benefits, and programs that support employees' health, financial well-being, professional growth, and work-life balance. Eligible employees enjoy a robust total rewards package that includes:

• Nationwide medical, dental, and vision insurance
• 3 weeks of Paid Time Off and 11 Paid Federal Holidays
• 401k matching
• Life Insurance, Short-Term Disability, and Long-Term Disability at no cost to our employees
• Supplemental insurance options
• Flexible spending accounts and Dependent Care spending accounts
• Wellness incentives
• Reimbursement for professional development and certifications
• Access to training assistance opportunities to support career growth and progression
• Hybrid and Remote work opportunities to support work-life balance

Salary Range: $110,000.00 – $130,000.00 USD annually.

This salary range represents the anticipated range for this position at the time of posting. Actual compensation may vary based on qualifications, experience, work location, internal equity, and business needs.

Apply Today
If you are ready to grow your career and make an impact, then we encourage you to apply today by submitting an application. We welcome you to explore additional job opportunities listed on our careers page

Pay Transparency
The anticipated compensation range for this position will be provided in accordance with applicable federal, state, and local pay transparency laws. Actual compensation offered will be determined based on factors such as the candidate's skills, qualifications, experience, education, geographic location, internal equity, and business needs.

In addition to base pay, eligible employees may be offered a comprehensive benefits package, paid time off, retirement benefits, bonus opportunities, and other programs, where applicable. Eligibility for benefits and incentive programs is governed by the terms of the applicable plans and company policies.