Database Engineer

We are seeking an experienced PostgreSQL Developer / Database Engineer to design, develop, optimize, and support enterprise-scale PostgreSQL database solutions. The ideal candidate will have strong expertise in SQL development, PL/pgSQL programming, database architecture, performance tuning, high availability, replication, disaster recovery, and data integration.

The candidate will be responsible for building scalable database solutions, troubleshooting complex performance issues, implementing database security controls, and supporting cloud-based PostgreSQL environments.

Key Responsibilities

• Design, develop, and maintain scalable PostgreSQL database solutions.
• Create and optimize logical and physical data models, including normalization, denormalization, and partitioning.
• Develop complex SQL queries, PL/pgSQL functions, stored procedures, views, and materialized views.
• Analyze execution plans and optimize database performance through indexing, query tuning, and statistics management.
• Implement and manage B-Tree, Hash, GIN, GiST, and BRIN indexing strategies.
• Optimize VACUUM operations, memory utilization, and database maintenance processes.
• Design and support streaming replication, logical replication, read replicas, failover, backup, recovery, and disaster recovery.
• Administer PostgreSQL environments using pgAdmin, psql, pg_dump, and pg_restore.
• Manage Write-Ahead Logging (WAL), database monitoring, and operational troubleshooting.
• Support ETL/ELT processes, Change Data Capture (CDC), and event-driven data pipelines.
• Integrate PostgreSQL databases with applications, APIs, and microservices.
• Support cloud-hosted PostgreSQL environments and infrastructure automation.
• Maintain data quality, profiling, validation, reconciliation, metadata management, and data lineage.
• Implement database security, auditing, encryption, and compliance controls.

Required Skills and Qualifications

• 8-10 years of relevant database development or database engineering experience.
• Strong hands-on experience with PostgreSQL database development and administration.
• Advanced SQL programming skills.
• Experience with CTEs, window functions, stored procedures, views, and materialized views.
• Expertise in execution plan analysis, query optimization, indexing, and performance tuning.
• Knowledge of PostgreSQL internals, VACUUM optimization, statistics management, and memory tuning.
• Experience with streaming replication, logical replication, high availability, failover, and disaster recovery.
• Hands-on experience with PostgreSQL backup and recovery tools, WAL management, pgAdmin, and psql.
• Understanding of data modeling, partitioning, ETL/ELT, CDC, and data validation.
• Knowledge of database security, auditing, encryption, and compliance best practices.
• Strong analytical, troubleshooting, communication, and problem-solving skills.

Preferred Qualifications

• Experience supporting PostgreSQL on cloud database platforms.
• Exposure to infrastructure automation and event-driven data pipelines.
• Experience working with enterprise applications, APIs, and microservices.

Work Arrangement: Hybrid - Hartford, CT.