Senior Data Engineer PostgreSQL / AWS

Job Title: Senior Data Engineer - PostgreSQL / AWS

Location: Plano, TX - Onsite

Experience Required: 10-12 Years

Education: Bachelor s degree in Computer Science, Engineering, or a related field

Job Overview

We are seeking an experienced Senior Data Engineer with strong expertise in PostgreSQL, AWS data services, and microservices-based architectures. The ideal candidate will design and maintain scalable data platforms supporting modern microservice-based applications while building efficient ETL/ELT pipelines and optimizing database performance.

This role will work closely with Java microservices teams, cloud engineers, and analytics teams to ensure robust data integration, high availability, and secure data management across enterprise systems.

Key Responsibilities

Data Engineering & Database Development

• Design, develop, and maintain PostgreSQL databases and data pipelines on AWS to support microservice-based applications.

• Develop scalable data models aligned with System of Record (SOR) architecture.

• Build and optimize ETL/ELT pipelines for data ingestion, transformation, and storage.

• Develop and maintain database schemas, stored procedures, and complex SQL queries.

Cloud & Microservices Integration

• Collaborate with Java microservice developers to integrate database solutions efficiently with application services.

• Implement scalable solutions using AWS services such as RDS (PostgreSQL), Aurora PostgreSQL, S3, Lambda, Glue, and Redshift.

• Support Salesforce to PostgreSQL (Aurora PostgreSQL) data migration projects ensuring data accuracy and integrity.

Performance Optimization & Reliability

• Perform PostgreSQL performance tuning and query optimization.

• Ensure database scalability, reliability, and high availability in a microservices environment.

• Design and implement backup, disaster recovery, and monitoring strategies.

Automation & DevOps

• Automate database provisioning, schema migrations, and monitoring using Infrastructure as Code tools (CloudFormation, Terraform).

• Develop automation scripts using Python or Bash for data processing and system operations.

Security & Data Governance

• Ensure data security, integrity, and compliance with cloud security standards.

• Implement data modeling best practices supporting analytics, reporting, and application functionality.

Required Skills

• Strong expertise in PostgreSQL database design, performance tuning, and optimization.

• Hands-on experience with AWS data services (RDS PostgreSQL, Aurora PostgreSQL, S3, Lambda, Glue, Redshift).

• Experience building ETL/ELT pipelines using Python, Airflow, AWS Glue, or similar tools.

• Strong SQL skills with experience writing complex queries, stored procedures, and functions.

• Experience working with Java microservices frameworks such as Spring Boot.

• Experience with Infrastructure as Code tools (CloudFormation, Terraform).

• Strong scripting skills using Python or Bash.

• Understanding of cloud security best practices and data governance.

• Experience working in Agile and cross-functional teams.