PostgreSQL Database Engineer

Valiant Technologies LLC; Hartford (CT); On-site; USD 95,000 - 150,000; Full time

Job summary

Valiant Technologies LLC in Hartford, CT is seeking a PostgreSQL Developer / Database Engineer to design, develop, optimize, and support enterprise-scale PostgreSQL solutions. You will work on data modeling, performance tuning, HA, and data integration to ensure scalable, secure databases.

The role requires strong SQL/PLpgSQL, experience with cloud-hosted PostgreSQL, and the ability to implement ETL pipelines, replication, and disaster recovery.

Qualifications

• 5+ years of experience with PostgreSQL database development and optimization.
• Experience with high availability, replication, backup, and disaster recovery.
• Experience with ETL/ELT, data integration, and CDC.
• Strong SQL and PL/pgSQL coding skills.

Responsibilities

• Design and maintain scalable PostgreSQL database solutions.
• Develop data models, 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.

Skills

PostgreSQL

SQL

PL/pgSQL

Data modeling

Education

Bachelor's degree in Computer Science or related field

Tools

pgAdmin

Cloud platforms (AWS/GCP/Azure)

Job description

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

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

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.

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.