Mid-Level Database Developer

We are seeking a Database Developer with approximately four years of professional experience to support database development, modernization, cloud-hosted PostgreSQL environments, and migration initiatives.

The ideal candidate has strong SQL and database development skills and hands-on experience with PostgreSQL and Oracle, familiarity with the AWS Database Migration, and practical experience using Liquibase to manage database changes through DevSecOps pipelines. The candidate should be comfortable developing automation scripts and collaborating with microservice teams to ensure database structures remain aligned with application object models.

What you will do

• Database Development and Schema Management
  • Maintain and optimize a PostgreSQL database hosted in AWS.
  • Develop, maintain, and version-control data definition (DDL) scripts for schema creation, modification, and migration.
  • Work with senior developers to execute the migration of existing data and schema from an Oracle database to PostgreSQL, ensuring data integrity and performance.
  • Maintain technical documentation for database design, configuration, schema changes, and operational procedures.
  • Monitor and tune database performance for reliability, scalability, and efficiency.
  • Design and implement back-up and disaster recovery processes to ensure high availability and business continuity.
  • Manage database backups, restores, and updates in alignment with best practices.
  • Perform database object synchronization by identifying and resolving discrepancies involving tables, indexes, packages, views, constraints, LOBs, grants, and invalid objects.
  • Manage database security and access controls by validating user permissions, schema grants, role assignments, and object-level privileges.
  • Perform index reconciliation and optimization by comparing source and target database structures and generating missing index deployment scripts.
  • Collaborate with engineering and DevOps teams to ensure database security, scalability, and compliance.
• Oracle-to-PosgreSQL Migration and AWS DMS Support
  • Manage schema conversion, object validation, and post-migration reconciliation across multiple Oracle database schemas.
  • Support AWS DMS configuration, monitoring, and troubleshooting, including task validation, CDC synchronization, LOB handling, endpoint verification, and migration performance tuning.
  • Conduct migration validation activities including row count comparisons, object count verification, CDC testing, referential integrity checks, and application smoke testing.
  • Develop and execute SQL and shell automation scripts for schema exports, row count validation, object comparison, and migration verification using SQL*Plus, Bash, PostgreSQL utilities, Oracle metadata utilities, and related tools.
  • Create automated workflows for identifying missing database objects and generating DDL scripts to remediate inconsistencies between source and target environments.
  • Coordinate migration cutover activities and work cross-functionally with cloud engineers, developers, database administrators, and program stakeholders to ensure successful deployment and operational continuity.
  • Author migration procedures, validation checklists, turnover materials, and operational documentation to support sustainment and knowledge transfer.
• Database Management for Microservices using Liquibase
  • Support automated generation or validation of database table definitions based on Java object models and microservice data contracts.
  • Review OpenAPI specifications to understand microservice interfaces, request and response models, and data structures that affect database design.
  • Work with Java microservice teams to ensure database tables and schema changes are consistent with Java domain objects, persistence models, DTOs, and service-layer requirements.
  • Help define repeatable workflows for translating OpenAPI-defined service models and Java application objects into consistent PostgreSQL schema updates.
  • Integrate Liquibase database changes into CI/CD pipelines to support controlled, repeatable, and auditable schema deployments.
  • Validate Liquibase changes across environments and troubleshoot schema deployment failures, rollback issues, checksum conflicts, and environment drift.
  • Collaborate with backend developers to ensure database changes support microservice functionality, API contracts, data integrity, and performance requirements.

You should be familiar with

• SQL, relational database design, schema development, and database object management.
• Developing DDL scripts, migration scripts, validation scripts, and database automation scripts.
• Hands-on experience with PostgreSQL, preferably hosted in AWS RDS.
• Familiarity with Oracle
• Familiarity with AWS Database Migration Service
• Familiarity with CI/CD pipelines, Git, Bash, and other DevSecOps tools
• Agile software development methodology and team practices
• Experience using Liquibase or a similar database change management tool
• Proficiency with Git-based version control and collaborative development workflows.
• Familiarity with AWS infrastructure, cloud-hosted database environments, security groups, networking, and application connectivity.
• Strong troubleshooting skills and the ability to analyze schema, data, migration, and deployment issues across environments.
• Strong written and verbal communication skills, including the ability to document technical procedures and collaborate with developers, cloud engineers, and stakeholders.

What we like to see

• Passionate about database development and coding
• Flexible and adaptable when requirement change or priorities change
• Enthusiastic about adopting DevSecOps practices
• Thrives when collaborating within a small, cross-functional team
• Proactive communicator who knows when to ask for help when blocked

Requirements

• 4+ years of professional experience in software engineering, DevOps, or database administration.
• Security+ certification (or willingness to obtain one)
• Bachelor’s Degree in Computer Science, Engineering, or related field