POSTGRESQL DATABASE DEVELOPER JOB DESCRIPTION
Location: Hybrid- Suitland, MD. 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.
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.
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.
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 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.
About Sparibis
Sparibis LLC is a professional solution firm that Clients rely on to access the best talent to drive their business success.
Sparibis is an equal opportunity employer that values diversity at all levels. All individuals, regardless of personal characteristics, are encouraged to apply.
