PostGreSQL Developer

Location: Remote but candidate must be from Ohio, Michigan, Indiana, Illinois, Tennessee, Texas, Colorado, Montana, Rhode Island, Florida, Massachusetts, Nevada.

Duration: Full Time

Independent Consultants Only

**.

Job Summar**

y:The Senior Database Developer is responsible for the design, development, optimization, and modernization of enterprise database solutions that support critical product, analytics, and operational systems. This role ensures database environments are scalable, secure, and high performing, with a strong focus on PostgreSQL and AWS technologies, including Aurora, Redshift, and RD

S.

The position works closely with software developers, infrastructure teams, business intelligence, and other stakeholders to deliver reliable data architecture, improve system performance, and support data-driven decision-making. Responsibilities include advancing cloud-based data infrastructure, improving automation, establishing engineering best practices, and maintaining the long-term health, integrity, and governance of database syste

ms.

This role also translates business and technical requirements into sustainable database solutions, supports performance tuning and continuous improvement efforts, and contributes to data governance, security, documentation, and cross-functional technical execut

ion.

The ideal candidate brings deep PostgreSQL expertise, strong AWS experience (Aurora, Redshift, RDS), a systems-thinking mindset, and the communication skills to collaborate effectively across engineering and business t

**eams.

Primary Duties and Responsibi**

litiesDatabase Design & Devel

opmentArchitect and implement scalable, high-performance relational database solutions in Postg

reSQL.Write complex, optimized SQL and PL/pgSQL stored procedures, functions, and tri

ggers.Continuously monitor, tune, and improve database performance, availability, and reliab

ility.Lead scheduled version upgrades and evaluate emerging PostgreSQL, Aurora, and Redshift features for ado

**ption.

Cloud & Data Infrast**

ructureManage and monitor cloud-based database hosts using AWS RDS, Aurora, and Re

dshift.Design and maintain data pipelines supporting analytics, reporting, and operational wor

kloads.Build and maintain Infrastructure as Code (IaC) using Terraform for database provisioning and configu

ration.Contribute to data mesh and data lake architecture initi

**atives.

Collaboration & Go**

vernancePartner with developers to improve application data access patterns and enforce best pr

actices.Gather and translate user and stakeholder requirements into reliable database

designs.Implement and uphold data governance, access controls, auditing, and security st

andards.Provide data management support and technical guidance to end users and applicatio

**n teams.

Documentation &**

• ; ProcessDevelop and maintain comprehensive technical documentation, runbooks, and training m
• aterials.Research and recommend new database products, services, and architectural
• patterns.Participate in Agile/Scrum ceremonies and contribute to sprint planning and

delive

• ry.

  SkillsCore Database

• & SQLExpert-level SQL authoring including writing complex queries, query plan analysis, index optimization, and performan
• ce tuning.Solid understanding of data management fundamentals including permissions, backup/recovery, security, and m
• onitoring.Experience with NoSQL databases (e.g., DynamoDB,

**MongoDB).

AWS & Clou**

• d PlatformsProven experience with Amazon Aurora (PostgreSQL-compatible)
• and AWS RDSHands-on experience with Amazon Redshift for analytics and data
• warehousingFamiliarity with AWS Lambda, Step Functions, and event-driven dat
• a workflowsInfrastructure as Code usin

**g Terraform

Architecture & Engineeri**

• ng PracticesSystems architecture thinking with experience designing microservices and data-layer i
• ntegrations.Knowledge of data mesh, domain-driven design, and/or data lake a
• rchitecture.Experience building and maintaining dat
• a pipelines.Proficient with Git and version-controlled database change
• management.Familiarity with .NET Framework, Java/JDBC, and/or Node.js for application
• integration.Experience working in Agile/Scrum teams using JIRA and
• Confluence.Exposure to data governance, cataloging, and security bes
• t practices.Proficiency with AI-powered development tools (e.

g., Claude).