Senior Data Engineer – PostgreSQL AWS
Share
Job Location:
Monthly Salary:
Posted on:
9 hours ago
Vacancies:
1 Vacancy
Job Summary
Job Title: Senior Data Engineer - PostgreSQL / AWS
Location: Plano TX - Onsite
Experience Required: 10-12 Years
Education: Bachelors 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.
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
