What are the responsibilities and job description for the Senior Database Developer, PostgreSQL position at Midwest Tape?
Midwest Tape | Hoopla
About us:
For over 30 years, Midwest Tape has served libraries and their patrons with unparalleled access to the best content available in the media world. Our digital offering, hoopla Digital, combines the media and library expertise of Midwest Tape with the latest in web and mobile technology, delivering an all-in-one experience to the library world. As hoopla continues to grow on a global scale, we are expanding our team.
At Midwest Tape, we know our people are the reason for our success. We value our employees and believe in empowering them to help them thrive. We offer competitive pay and benefits, a healthy work/life balance, and appreciation for a job well done.
- For local candidates within 60 miles of our Holland, OH headquarters, this role is hybrid after 60-day orientation period.
- For candidates outside of local area, this role would be primarily remote, but must be open to travel to HQ as required by the manager.
- Must live in the following 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 occasional off-hours deployments or crisis resolution.
- We are currently unable to sponsor employment visas. All candidates must have authorization to work in the U.S. without current or future sponsorship.
What we are looking for:
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.
Primary Duties and 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
Skills
- 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.
- 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.
- 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).
Preferred Education Requirements
- B.S., M.S., in software engineering, computer science, or related area or equivalent experience.
Preferred Experience
- Minimum 10 years of database development, mostly in Postgres environments, highly preferred.
Physical Requirements / Work Environment
The work environment characteristics and physical demands described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Ability to regularly sit for extended periods of time.
- Physically able to attend meetings, presentations, and training sessions.
- Perform repetitive motion type tasks.
- Ability to work on-site as requested in a team environment.
Company Benefits:
- Medical, dental, & vision insurance
- 401k match
- Profit sharing
- Paid vacation and personal time
- Flex time
- 10 paid holidays
- Company performance bonus
- Holiday bonus
- Training & career development opportunities
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
#LI-Remote #LI-Hybrid
Salary : $120,000 - $150,000
