Remote Senior PostgreSQL Data Engineer - Real-Time Finance

ITDS Business Consultants; United States; Teletrabalho; USD 78 000 - 123 000; Tempo integral

Resumo da oferta

ITDS Business Consultants is seeking a Senior PostgreSQL / Data Engineer to design and operate high-performance PostgreSQL solutions for a major financial sector client. This role is 100% remote with a focus on real-time data processing and scalable analytics.

You will optimize queries, implement data models, and collaborate with cross-functional teams using RabbitMQ and ETL pipelines. Strong PL/pgSQL and Linux experience are required, with 5+ years in PostgreSQL and data engineering.

Qualificações

• Minimum 5 years of experience with PostgreSQL, including advanced SQL and data modeling.
• Proven expertise in PostgreSQL architecture, partitioning, indexing, and performance monitoring.
• Strong knowledge of PL/pgSQL, stored procedures, functions, and triggers.
• Practical experience with large data volumes, performance tuning, and Big Data environments.
• Hands-on experience with Linux environment setup and maintenance.

Responsabilidades

• Design, develop, and maintain high-performance PostgreSQL database solutions for large-scale financial data processing.
• Optimize database performance through advanced tuning, indexing, and data modeling.
• Build and implement data models to support near real-time analytics.
• Collaborate with cross-functional teams to ensure seamless data integration using RabbitMQ and ETL processes.
• Monitor system performance and troubleshoot issues to ensure high availability and scalability.
• Automate deployment and maintenance tasks using CI/CD pipelines.
• Participate in planning and executing database migration, archiving, and data retention strategies.

Conhecimentos

PostgreSQL

SQL

Data modeling

Performance tuning

Partitioning

Indexing

PL/pgSQL

Linux

Big Data

Python scripting

Ferramentas

RabbitMQ

Kafka

Apache Airflow

CI/CD

ETL processes

Descrição da oferta de emprego

ITDS Business Consultants is seeking a Senior PostgreSQL / Data Engineer to design and operate high-performance PostgreSQL solutions for a major financial sector client. This role is 100% remote with a focus on real-time data processing and scalable analytics.

You will optimize queries, implement data models, and collaborate with cross-functional teams using RabbitMQ and ETL pipelines. Strong PL/pgSQL and Linux experience are required, with 5+ years in PostgreSQL and data engineering.