Senior Data Engineer

Vertage is building a next-generation application platform and needs a Senior Data Engineer to lead core data infrastructure and migration work. This role focuses on moving from legacy systems to a modern cloud-based architecture, designing PostgreSQL foundations, and delivering real-time data products with streaming and data lakehouse technologies. The position is based in the United States (onsite), with an hourly rate of USD 70 to 75.

What you’ll work on

• Design and implement PostgreSQL databases and schemas from scratch, with a focus on performance, scalability, and maintainability
• Lead migration of large-scale Oracle databases to AWS RDS PostgreSQL clusters, managing integrity and minimizing downtime during cutover
• Build and optimize real-time data products using Apache Kafka, Apache Flink, and Apache Hudi to serve downstream consumers with reliable streams
• Evaluate and improve existing schemas: identify optimization opportunities, recommend structural changes, and maintain database integrity
• Implement change auditing to track data modifications, provide audit trails, and support compliance needs
• Develop and maintain a data catalog and schema documentation to support integration with application development teams

Skills and experience needed

• Strong PostgreSQL expertise across database design, administration, and optimization, plus solid relational database and SQL knowledge
• Proven database migration experience at enterprise scale (Oracle to PostgreSQL preferred) with demonstrated change management practices
• AWS hands-on experience, especially RDS and EC2, including networking and security configurations
• Practical experience with Kafka and Flink, along with data lakehouse technologies such as Hudi and/or Delta Lake
• Ability to model for both OLTP and analytical workloads, including normalized and denormalized schema trade-offs
• Experience implementing CDC and audit logging for lineage and change tracking
• Communication and documentation skills to explain complex data concepts for technical and non-technical stakeholders, including architecture and schema documentation
• Professional working proficiency in English

Tools and technologies you may use

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, 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 such as Terraform and CloudFormation
• Experience in application modernization or legacy system replacements
• Understanding of data security, encryption, and compliance requirements (including GDPR and HIPAA)