Netrist Solutions

Mid-Level Database Developer

Posted 2 Days Ago

Hiring Remotely in Charleston, South Carolina, USA

In-Office or Remote

Mid level

Information Technology • Mobile • Software

The Role

Develops and maintains PostgreSQL databases in AWS, including schema design, performance tuning, backups, access controls, and disaster recovery. Supports Oracle-to-PostgreSQL migrations using AWS DMS, validates data and database objects, and creates SQL and Bash automation scripts. Integrates Liquibase schema changes into CI/CD pipelines and collaborates with Java microservice, cloud engineering, DevOps, and database teams to align schemas with application models and API contracts.

Summary Generated by Built In

This is a remote position.

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

The position requires a government security clearance. Candidates must be U.S. citizens and eligible for work without a visa sponsorship.

Benefits

Paid Time Off
Medical benefits: Health Care, Vision, Dental, Long- and Short-Term Disability, and Life Insurance
Dependent Care and Healthcare Flexible Spending Accounts
Annual Health Reimbursement Arrangement
Education Assistance Program
401(k) Plan

Skills Required

4+ years of professional experience in software engineering, DevOps, or database administration
Security+ certification or willingness to obtain it
Bachelor’s degree in Computer Science, Engineering, or a related field
U.S. citizenship
Eligibility for a government security clearance
Ability to work without visa sponsorship
Strong SQL, relational database design, schema development, and database object management experience
Hands-on PostgreSQL experience, preferably with AWS RDS
Familiarity with Oracle and Oracle-to-PostgreSQL migrations
Familiarity with AWS Database Migration Service
Experience with Liquibase or a similar database change-management tool
Experience with Bash, Git, CI/CD pipelines, and DevSecOps practices
Strong troubleshooting, documentation, communication, and cross-functional collaboration skills