PostgreSQL Developer / Database Engineer

Position: PostgreSQL Developer / Database Engineer

Location: Hartford, CT / Hybrid

Duration: 6 Month Contract

Rate: $70/hr

Role Description

The PostgreSQL Developer / Database Engineer will be responsible for designing, developing, Eligible to workimizing, 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 Eligible to workimize 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.

Required Skills

• PostgreSQL
• Data Modeling
• SQL
• PL/pgSQL
• Common Table Expressions (CTEs)
• Window Functions
• Stored Procedures
• Views
• Materialized Views
• Execution Plan Analysis
• Performance Tuning
• B-Tree Indexes
• Hash Indexes
• GIN Indexes
• GiST Indexes
• BRIN Indexes
• VACUUM Eligible to workimization
• Statistics Management
• Memory Tuning
• Streaming Replication
• Logical Replication
• Failover
• Disaster Recovery
• Read Replicas
• Backup and Recovery
• pgAdmin
• psql
• pg_dump
• pg_restore
• WAL Management
• Metadata Management
• Data Lineage
• Data Profiling
• Data Validation
• Data Reconciliation

Disclaimer: Diverse Lynx LLC is an Equal Opportunity Employer. All applicants and employees are evaluated without discrimination, based solely on their qualifications, ability, competence and performance. This email and its attachments may contain confidential or proprietary information and is intended only for the recipient(s). If you received this message in error, please disregard it and notify the sender. If you no longer wish to receive our communications, you may unsubscribe at any time.

Security Notice: Our official website is www.diverselynx.com We do not operate or authorize any other websites representing Diverse Lynx LLC.