Mid-Level Database Developer

This is a fully remote position, open to applicants in United States.

📋 Description

• Ensure the maintenance and optimization of PostgreSQL databases hosted on AWS.

• Create, maintain, and manage version control for DDL scripts related to schema creation, modification, and migration.

• Transfer existing data and schemas from Oracle to PostgreSQL while safeguarding data integrity and enhancing performance.

• Maintain comprehensive technical documentation for database design, configuration, schema alterations, and operational processes.

• Oversee and fine-tune database performance to ensure reliability, scalability, and efficiency.

• Design and implement effective backup and disaster recovery strategies.

• Manage processes related to database backups, restorations, and updates.

• Synchronize database objects and address discrepancies involving tables, indexes, packages, views, constraints, LOBs, grants, and invalid objects.

• Administer database security, access controls, permissions, grants, roles, and privileges.

• Reconcile and optimize indexes, and create scripts for deploying missing indexes.

• Work collaboratively with engineering and DevOps teams to enhance database security, scalability, and compliance.

• Manage the conversion of Oracle schemas to PostgreSQL, including object validation and post-migration reconciliation.

• Configure, monitor, troubleshoot, and optimize AWS DMS migrations, covering CDC, LOB handling, endpoint verification, and task validation.

• Perform migration validation, including checks for row counts, object counts, CDC testing, referential integrity, and application smoke testing.

• Create SQL and shell automation scripts utilizing SQL*Plus, Bash, PostgreSQL utilities, and Oracle metadata utilities.

• Develop automated workflows to detect missing database objects and produce remediation DDL scripts.

• Coordinate migration cutovers with cloud engineers, developers, database administrators, and program stakeholders.

• Write migration procedures, validation checklists, turnover materials, and operational documentation.

• Validate database definitions in accordance with Java object models, OpenAPI specifications, and microservice data contracts.

• Collaborate with Java microservice teams to ensure PostgreSQL schemas align with domain objects, persistence models, DTOs, and service requirements.

• Integrate Liquibase changes into CI/CD pipelines and resolve deployment failures, rollback issues, checksum conflicts, and environment drift.

• Partner with backend developers to support microservice functionality, API contracts, data integrity, and performance.

⛳️ Requirements

• Approximately four years of professional experience, including 4+ years in software engineering, DevOps, or database administration.

• Strong proficiency in SQL and database development.

• Practical experience with PostgreSQL, ideally in an AWS RDS environment.

• Familiarity with Oracle databases.

• Knowledge of AWS Database Migration Service.

• Understanding of CI/CD pipelines, Git, Bash, and other DevSecOps tools.

• Experience with Agile software development methodologies and team practices.

• Familiarity with Liquibase or similar database change management tools.

• Proficiency in Git-based version control and collaborative development workflows.

• Understanding of AWS infrastructure, cloud-hosted database environments, security groups, networking, and application connectivity.

• Strong troubleshooting abilities for schema, data, migration, and deployment challenges across various environments.

• Excellent written and verbal communication skills, including the ability to produce technical documentation and collaborate with developers, cloud engineers, and stakeholders.

• Security+ certification (or a willingness to obtain one).

• Bachelor’s degree in Computer Science, Engineering, or a related field.

• Government security clearance is required.

• U.S. citizenship with eligibility to work without visa sponsorship is mandatory.

🏝️ Benefits

• Paid Time Off.

• Comprehensive medical benefits including 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.