Senior Data Engineer

Vertage is building a next-generation application platform and needs a Senior Data Engineer to lead critical data infrastructure and migration work. This role focuses on transitioning from legacy systems to a modern, cloud-based architecture, while delivering reliable real-time data products powered by streaming technologies.

This position is onsite in the United States with an hourly salary range of USD 70 to 75.

Responsibilities

• Design and implement PostgreSQL databases and schemas from the ground up, with a focus on performance, scalability, and maintainability
• Lead the migration of large-scale Oracle databases from on-premises infrastructure to AWS RDS PostgreSQL clusters, managing data integrity and minimizing downtime
• Build and optimize data products using Apache Kafka, Apache Flink, and Apache Hudi to deliver dependable data streams to downstream consumers
• Assess existing database schemas, identify optimization opportunities, recommend structural improvements, and maintain database integrity through changes
• Design and implement comprehensive change auditing to track data modifications, provide audit trails, and support compliance requirements
• Develop and maintain a data catalog and comprehensive schema documentation to support integration with application development teams

Requirements

• Deep proficiency in PostgreSQL database design, administration, and optimization, including relational database principles and strong SQL skills
• Proven experience migrating large enterprise databases, with Oracle to PostgreSQL preferred, plus strong change management practices
• Hands-on experience with AWS services, particularly RDS and EC2, including networking and security configurations
• Solid experience with Apache Kafka, Apache Flink, and data lakehouse technologies such as Hudi (and/or Delta Lake or similar)
• Ability to design both normalized and denormalized schemas, understand trade-offs, and optimize for OLTP and analytical workloads
• Experience implementing CDC patterns and audit logging systems to support data lineage and change tracking
• Strong communication skills to translate complex data concepts for technical and non-technical stakeholders, along with clear documentation of architectures and schemas
• English with professional working proficiency

Technologies

PostgreSQL, Oracle Database, AWS RDS, EC2, Apache Kafka, Apache Flink, Apache Hudi, Terraform, CloudFormation, AWS Data Pipeline tools (Glue, Lambda, or Step Functions), Delta Lake, GDPR, HIPAA, and Cryptography.

Preferred

• Experience with AWS Data Pipeline tools (Glue, Lambda, or Step Functions)
• Knowledge of data quality and validation frameworks
• Familiarity with infrastructure-as-code tools (Terraform, CloudFormation)
• Prior experience in application modernization or legacy system replacements
• Understanding of data security, encryption, and compliance requirements such as GDPR and HIPAA