XX
Senior Data Engineer - PostgreSQL / AWSPurple DriveUnited States
XX

Senior Data Engineer - PostgreSQL / AWS

Purple Drive
  • US
    United States
  • US
    United States

Über

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 .
  • United States

Sprachkenntnisse

  • English
Hinweis für Nutzer

Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klicken Sie auf „Jetzt Bewerben“, um Ihre Bewerbung direkt auf deren Website einzureichen.