PostGreSQL Developer

Location: Remote but candidate must be from Ohio, Michigan, Indiana, Illinois, Tennessee, Texas, Colorado, Montana, Rhode Island, Florida, Massachusetts, Nevada.Duration: Full TimeIndependent Consultants Only.Job Summary: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 RDS.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 systems.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 execution.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 teams.Primary Duties and ResponsibilitiesDatabase Design & DevelopmentArchitect and implement scalable, high-performance relational database solutions in PostgreSQL.Write complex, optimized SQL and PL/pgSQL stored procedures, functions, and triggers.Continuously monitor, tune, and improve database performance, availability, and reliability.Lead scheduled version upgrades and evaluate emerging PostgreSQL, Aurora, and Redshift features for adoption.Cloud & Data InfrastructureManage and monitor cloud-based database hosts using AWS RDS, Aurora, and Redshift.Design and maintain data pipelines supporting analytics, reporting, and operational workloads.Build and maintain Infrastructure as Code (IaC) using Terraform for database provisioning and configuration.Contribute to data mesh and data lake architecture initiatives.Collaboration & GovernancePartner with developers to improve application data access patterns and enforce best practices.Gather and translate user and stakeholder requirements into reliable database designs.Implement and uphold data governance, access controls, auditing, and security standards.Provide data management support and technical guidance to end users and application teams.Documentation & ProcessDevelop and maintain comprehensive technical documentation, runbooks, and training materials.Research and recommend new database products, services, and architectural patterns.Participate in Agile/Scrum ceremonies and contribute to sprint planning and delivery.SkillsCore Database & SQLExpert-level SQL authoring including writing complex queries, query plan analysis, index optimization, and performance tuning.Solid understanding of data management fundamentals including permissions, backup/recovery, security, and monitoring.Experience with NoSQL databases (e.g., DynamoDB, MongoDB).AWS & Cloud 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 data workflowsInfrastructure as Code using TerraformArchitecture & Engineering PracticesSystems architecture thinking with experience designing microservices and data-layer integrations.Knowledge of data mesh, domain-driven design, and/or data lake architecture.Experience building and maintaining data 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 best practices.Proficiency with AI-powered development tools (e.g., Claude).