Senior Database Developer, PostgreSQL

Midwest Tape•Holland, OH

5d•Hybrid

About The Position

Midwest Tape is currently seeking a Senior Database Developer with AWS and PostgreSQL experience. We are looking for a highly qualified, senior database developer to design stable and reliable database solutions according to our company’s needs. The candidate will be responsible for developing, testing, improving and maintaining new and existing database solutions to help applications and users retrieve data effectively. As part of our IT Product Development team, you will work closely with developers to ensure system consistency. You will also collaborate with administrators and clients to provide technical support and identify new requirements. Communication and organization skills are keys for this position, along with a problem-solution attitude. Ultimately, you should be able to ensure our database systems run effectively and securely on a daily basis.

Requirements

Proven work experience as a senior PostgreSQL Database Developer, including pgplsql.
Demonstrated expertise in diagnosing and resolving operational database challenges.
Proven experience in implementing continuous improvement initiatives to drive optimization.
Writing complex SQL statements and performance tuning.
In-depth understanding of data management (e.g. permissions, recovery, security and monitoring).
Experience using AWS RDS to manage and monitor cloud-based database hosts.
System architecture thinking.
Proficient with git.
Experience with data mesh, domain-driven design, and/or data lake architecture.
Strong problem solving and troubleshooting ability under tight deadlines.
Excellent communication skills.
Knowledge of software development and user interface web applications.
Familiarity working with .Net Framework, Java/JDBC, and Node.js.
Excellent analytical and organizational skills..
Attention to detail.
An ability to understand front-end user requirements and a problem-solving attitude.
Excellent verbal and written communication skills, interpersonal skills.
Experience working in Agile/Scrum Methodology.
Experience with JIRA, Confluence, Visio, and Microsoft Office applications.
Proficiency using AI-powered tools (e.g., GitHub Copilot, ChatGPT).

Nice To Haves

Knowledge of AWS Redshift, Lambda, step functions, and Infrastructure as Code using Terraform, is highly desirable.
Knowledge of Amazon Aurora and no-SQL databases is a plus.
Experience working with data pipelines.

Responsibilities

Design and implement scalable, high-performance databases
Continuously improve database performance
Modernize Data Infrastructure (AWS Cloud native, Microservices, event-driven architecture)
Drive analytics and reporting capabilities, working along with Business Intelligence teams
Accelerate development with AI & automation
Enable data microservices architecture
Ensure data integrity and security (Data Governance)
Gather user requirements and identify new features
Liaise with developers to improve applications and implement best practices
Develop technical and training manuals
Provide data management support to users
Research and suggest new database products, services and protocols