Senior Database Developer, PostgreSQL

About the role

This role is hybrid after a 60-day orientation period for local candidates within 45 miles of Holland, OH headquarters. For candidates outside the local area, it is primarily remote. Onsite visits are required for the first week for onboarding and for conferences/meetings as needed.

Responsibilities

• Design, develop, optimize, and modernize enterprise database solutions in PostgreSQL.
• Write complex, optimized SQL and PL/pgSQL stored procedures, functions, and triggers.
• Monitor, tune, and improve database performance, availability, and reliability.
• Lead scheduled version upgrades and evaluate emerging PostgreSQL, Aurora, and Redshift features for adoption.
• Manage 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.
• Partner 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.
• Develop 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.

Requirements

• Deep PostgreSQL expertise.
• Strong AWS experience (Aurora, Redshift, RDS).
• A systems-thinking mindset.
• Effective communication skills to collaborate with engineering and business teams.

Skills

• Core Database & SQL Expert-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 Platforms Proven experience with Amazon Aurora (PostgreSQL-compatible) and AWS RDS.
• Hands-on experience with Amazon Redshift for analytics and data warehousing.
• Familiarity with AWS Lambda, Step Functions, and event-driven data workflows.
• Infrastructure as Code using Terraform.
• Architecture & Engineering Practices Systems 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).

Soft Skills

• Strong problem-solving and troubleshooting ability under tight deadlines.
• Excellent verbal and written communication and interpersonal skills.
• Highly organized with strong attention to detail.

Education Requirements

• B.S., M.S., in software engineering, computer science, or related area or equivalent experience.

Preferred Experience

• 10+ years of database development experience.
• 5+ years of hands-on PostgreSQL development, including PL/pgSQL.