Job Description
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 compl
