PostgreSQL Database Engineer

MACHINE LEARNING TECHNOLOGIES LLC; Hartford (CT); In loco; USD 98.000 - 138.000; Tempo pieno

Descrizione del lavoro

MACHINE LEARNING TECHNOLOGIES LLC in Hartford, CT is seeking a PostgreSQL Database Engineer to design, develop, optimize, and support enterprise-scale PostgreSQL solutions. The role emphasizes robust database architecture, performance tuning, high availability, and secure data management.

Responsibilities include data modeling, complex SQL/PL/pgSQL optimization, HA/DR design, ETL/ELT pipelines, and cloud integration.

Competenze

• Design and develop enterprise-scale PostgreSQL database solutions.
• Expertise in database architecture, performance tuning, and security.
• Experience with high availability, data integration, and cloud platforms.

Mansioni

• Design and maintain scalable PostgreSQL database solutions.
• Develop data models, including normalization and partitioning.
• Develop and optimize SQL and PL/pgSQL code.
• Analyze execution plans and troubleshoot performance issues.
• Implement indexing strategies and performance tuning.
• Design and support high availability, replication, backup, recovery, and DR.
• Administer and monitor PostgreSQL environments with standard tools.
• Support data quality, governance, metadata management, and lineage.
• Develop ETL/ELT processes, CDC, and event-driven pipelines.
• Integrate PostgreSQL with apps, APIs, and microservices.
• Support cloud-hosted PostgreSQL environments and automation.
• Implement security, auditing, encryption, and compliance controls.

Conoscenze

PostgreSQL

SQL

PL/pgSQL

Performance tuning

High availability

Data integration

Cloud databases

Security

Descrizione del lavoro

Job Overview

Job ID: J54622

Job Title: PostgreSQL Database Engineer

Location: Hartford, CT

Duration: 12 Months + Extension

Domain Exposure: Manufacturing

Client: To Be Discussed Later

Employment Type: W-2, 1099, C2C

Work Authorization: US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Bill Rate

\$71/hour (C2C)

Job Description

The PostgreSQL Developer / Database Engineer will be responsible for designing, developing, optimizing, and supporting enterprise-scale PostgreSQL database solutions. The role requires expertise in database architecture, performance tuning, high availability, data integration, cloud database platforms, and database security.

Responsibilities

• Design and maintain scalable PostgreSQL database solutions.


• Develop logical and physical data models, including normalization, denormalization, and partitioning strategies.


• Develop and optimize complex SQL and PL/pgSQL code.


• Analyze execution plans and troubleshoot database performance issues.


• Implement indexing strategies and database performance tuning.


• Design and support high availability, replication, backup, recovery, and disaster recovery solutions.


• Administer and monitor PostgreSQL environments using standard PostgreSQL tools.


• Support data quality, governance, metadata management, and data lineage initiatives.


• Develop and support ETL/ELT processes, CDC solutions, and event-driven data pipelines.


• Integrate PostgreSQL with applications, APIs, and microservices.


• Support cloud-hosted PostgreSQL environments and infrastructure automation.


• Implement database security, auditing, encryption, and compliance controls.

Equal Opportunity Employer

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.