PostgreSQL Engineer

Sr. PostgreSQL DeveloperLocation Requirements: candidates must currently reside in one of the following states:Ohio, Michigan, Indiana, Illinois, Tennessee, Texas, Colorado, Montana, Rhode Island, Florida, Massachusetts, or NevadaWork Authorization Required: U.S. Citizen or Green Card HolderDirect Hire (Exempt)We're seeking a Senior Database Developer with deep PostgreSQL expertise and strong AWS experience to help shape the future of our enterprise data architecture.Please Note: This is a database development role, not a Database Administrator (DBA) position. Candidates whose experience is primarily DBA-focused will not be considered.As a Senior PostgreSQL Developer, you'll be responsible for designing, developing, optimizing, and modernizing enterprise database solutions that support mission-critical products, analytics, and operational systems.Database Development & PerformanceArchitect and develop scalable, high-performance PostgreSQL database solutionsWrite and optimize complex SQL and PL/pgSQL stored procedures, functions, and triggersAnalyze query execution plans and implement performance tuning strategiesImprove database reliability, scalability, and availabilityLead PostgreSQL, Aurora, and Redshift version upgrades and modernization effortsCloud & Data EngineeringManage and optimize AWS database environments, including Aurora PostgreSQL and RedshiftDesign and maintain data pipelines supporting operational and analytical workloadsBuild Infrastructure as Code (IaC) solutions using TerraformContribute to data lake, data mesh, and cloud-native architecture initiativesSupport event-driven data solutions leveraging AWS servicesRequired Experience10+ years of PostgreSQL development experienceAdvanced expertise in SQL, PL/pgSQL, query tuning, and database optimizationExperience with Amazon Aurora (PostgreSQL-compatible)Experience with Amazon Redshift and analytical data platformsStrong understanding of database architecture and performance engineeringExperience building and maintaining data pipelinesInfrastructure as Code experience using TerraformPreferred Technical SkillsAWS Lambda, Step Functions, and event-driven architecturesNoSQL technologies such as DynamoDB or MongoDBMicroservices and distributed systems designGit-based development and database change management.NET, Java/JDBC, or Node.js integration experienceAgile/Scrum methodologies, JIRA, and ConfluenceData governance, cataloging, and security best practicesAI-assisted development tools such as ClaudeBachelor's or Master's degree in Computer Science, Software Engineering, or a related technical discipline preferred.