Senior Database Developer, PostgreSQL

Midwest Tape•Holland, OH

1d•$120,000 - $150,000•Hybrid

About The Position

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.

Requirements

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).
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
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).
Strong problem-solving and troubleshooting ability under tight deadlines
Excellent verbal and written communication and interpersonal skills
Highly organized with strong attention to detail
Must currently live in the following U.S. states to be considered: Ohio, Michigan, Indiana, Illinois, Tennessee, Texas, Colorado, Montana, Rhode Island, Florida, Massachusetts, Nevada.
Must be able to work business hours of 8:30am-5:00pm EST in addition to off-hours deployments or crisis resolution per the off-hours production support schedule
All candidates must have authorization to work in the U.S. without current or future sponsorship.

Nice To Haves

B.S., M.S., in software engineering, computer science, or related area or equivalent experience.
10+ years of database development experience.
5+ years of hands-on PostgreSQL development, including PL/pgSQL.

Responsibilities

Architect 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.
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.