
Database Engineer
Prolim Global · Hartford, CT, United States · Hybrid
Weak hiring record · median 125 days open
- First seen
- 10 November 2026
- Reposted
- Not since September 2026
- Last checked
- Today · still on the employer's board
All reasons
- 71% of this employer's openings are over 60 days old
In its favour
- Still listed on the employer's own board
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.
Skills
More jobs at Prolim Global
All 484- Embedded Software Engineer 3Prolim Global · Irvine, CA, United States2d ago
- End User Services L3 - Desktop SupportProlim Global · Washington, DC, United States2d ago
- Labview Test Engineer (USC/ GC)Prolim Global · Beaverton, OR, United States2d ago
- Desktop support EngineerProlim Global · Charlotte, NC, United States2d ago
- Network Engineer - Intermediate LevelProlim Global · Draper, UT, United States2d ago
Similar roles
- SQL Database Administrator / Database Performance Engineer – ServiceNow PlatformCACI · Chantilly, VA, US · USD 103,800–218,100/yr3d ago
- Senior Software Engineer - Database Engine InternalsDatabricks · Mountain View, California · USD 166,000–225,000/yr2d ago
- Staff Software Engineer - Database Engine InternalsDatabricks · Mountain View, California · USD 192,000–260,000/yr2d ago
- Database EngineerEmployer not named · Farmers Branch, TX, United States · USD 90,000–105,000/yr4d ago
- AWS Databricks Database EngineerKmrg · Washington, DC · USD 140,000–175,000/yr3d ago