Lead Database Engineer

Hireology's technology empowers businesses to build great teams. Over the last 15 years, we've grown from a startup to a market-leading organization with over 150 team members, and we've created an award-winning culture that makes this company an amazing place to work.
We are in search of an experienced Lead Database Engineer to spearhead our database management initiatives. This role demands a deep understanding of PostgreSQL databases, proficiency in Linux and shell scripting, and expertise in managing data flow across multiple enterprise systems. A significant project involves transitioning our PostgreSQL database from AWS to an Azure Service, requiring adeptness in both platforms.
This role is a superb opportunity for a Lead Database Engineer passionate about pioneering in high-performance database management, data process optimization, and leading vital migration and integration projects. If your expertise aligns with our needs, we are eager to explore your potential as part of our team.
Responsibilities:

• Advanced PostgreSQL Database Management: Lead the management of PostgreSQL databases, focusing on backups, security, and performance tuning to ensure optimal operation and reliability.
• Database Performance Mastery: Identify and resolve complex database performance issues, implementing advanced techniques for efficiency and speed optimization.
• ETL Process Leadership: Oversee the development and optimization of shell scripts for ETL processes, ensuring robust integration with third-party systems and maintaining data integrity.
• Cross-Organizational Data Integration: Collaborate with various departments to design and implement strategies for integrating and managing data flow from a range of internally deployed enterprise data and reporting systems.
• Linux and Shell Scripting Expertise: Leverage expert-level knowledge in Linux environments and shell scripting to automate sophisticated database operations.
• Snowflake Proficiency: Utilize expertise in Snowflake for enhanced data warehousing and analytical capabilities.
• Strategic Database Migration: Lead the strategic migration of the PostgreSQL database from AWS to an Azure Service, ensuring a seamless and efficient transition.

Educational Requirements:

• Bachelor's Degree in Computer Science, Information Technology, or related field. A Master's Degree is highly preferred.
• Professional Certifications: Advanced certifications in database management (e.g., PostgreSQL), Linux, or cloud services (AWS, Azure) are highly desirable.

Qualifications:

• Extensive PostgreSQL Experience: Demonstrated experience in managing and optimizing PostgreSQL databases, with a focus on advanced performance tuning and security. Conversely, we will consider candidates with exceptional skills in other DBMS, such as Microsoft SQL Server, with a strong desire to learn PostgreSQL.
• Linux and Shell Scripting Proficiency: Advanced skills in Linux environments and scripting for complex database operation automation.
• Snowflake Knowledge: Deep understanding of Snowflake and its integration within database systems.
• Expertise in ETL Management: Proven experience in leading ETL processes, particularly involving shell scripts and intricate third-party integrations.
• Cloud Services Expertise: In-depth knowledge and experience with cloud services, specifically AWS and Azure, for effective database migration projects.
• Leadership and Collaboration: Strong leadership skills with the ability to work effectively in a team environment, driving major projects and organizational initiatives.
• Knowledge of Ansible is preferred

A few benefits of working at Hireology:

• Unlimited paid time off & mental health days
• Health, Dental, Vision insurance coverage from day one
• Work from anywhere!
• 401(k) with company match
• Hybrid office in the heart of Chicago
• Award-winning culture
• External learning budget
• Amazing growth opportunities.. and more!

Compensation : $150,000- $190,000 plus bonus
Hireology is committed to equal employment opportunities regardless of race, color, genetic information, creed, religion, sex, sexual orientation, gender identity, national origin, age, marital status, disability status or protected veteran status, or any other category protected under the law. All employment decisions are solely based on business needs, job requirements, and individual qualifications. We support an inclusive workplace where Hireologists excel based on personal merit, qualifications, experience, ability, and job performance.
Agency and/or third party Inquires will not be accepted. Must be authorized to work in the United States. We are not able to provide or transfer visa sponsorship.