PostgreSQL Database Developer

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.

Years’ Experience: 5+ Years of experience

Education: Bachelor’s degree in computer science, or related IT field.

Clearance: Applicants must be able to obtain and maintain a Public Trust security clearance. United States Citizenship is required as part of the eligibility criteria to be able to obtain this type of security clearance.

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., · 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 includes 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 architecture.

· 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.

· 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.