Senior Database Engineer

PlanHub

64d

About The Position

As a Database Administrator, you will be responsible for designing, configuring, and managing MySQL databases hosted on AWS RDS and Aurora. Your role will involve troubleshooting, root cause analysis, slow query log analysis, and query tuning. You will work on improving existing database systems and architecture, modernizing the data tier on AWS towards a highly scalable, available, and performant database architecture and data flows with the SaaS platform and external data sources. Additionally, you will perform database code deployment and tooling, define, develop, and optimize queries for product, assist software developers with query optimizations, implement reports as needed to support internal business stakeholders, and collaborate with the application development and BI teams to maintain and modernize our data architecture. You will also review and troubleshoot reported issues.

Requirements

• 7+ years of experience designing, configuring, and managing MySQL databases on AWS RDS and Aurora.
• 5+ years of experience with troubleshooting, root cause analysis, slow query log analysis, and query tuning.
• 5+ years of experience utilizing AWS CLI for infrastructure tasks.
• Experience with modernization of software to support growth in AWS Cloud infrastructure.
• Ability to maintain comprehensive technical documentation.
• Experience in designing and implementing OLTP database solutions.
• Degree in Computer Science or related technical discipline or equivalent experience.
• Hands-on experience with Bash/Python scripting.
• Self-motivated and willing to do what it takes to get the job done.
• Ability to plan, organize, and work on multiple projects with minimal supervision.
• Strong written and verbal communication skills.

Nice To Haves

• Experience with GUI ETL tools: Informatica, SSIS, Apache NiFi, AWS Glue.
• Experience with Snowflake, AWS Redshift, AWS Lake Formation, or similar tools.
• Experience working with NoSQL databases such as MongoDB or ElasticSearch.
• Experience in data warehousing and dimensional modeling concepts.
• Proficiency in Python, Perl, or similar languages.

Responsibilities

• Design, configure, and manage MySQL databases hosted on AWS RDS and Aurora.
• Troubleshoot, perform root cause analysis, and analyze slow query logs.
• Work on improving existing database systems and architecture.
• Modernize the data tier on AWS for scalability and performance.
• Perform database code deployment and tooling.
• Define, develop, and optimize queries for product.
• Assist software developers with query optimizations.
• Implement reports to support internal business stakeholders.
• Collaborate with application development and BI teams.
• Review and troubleshoot reported issues.

Benefits

• Remote friendly work environment.
• Open time-off policy.
• 401(k) plan with company match.
• Opportunity to join a dynamic team recognized in the top list of Inc. 5000 in 2024.

What This Job Offers

• Job Type: Full-time
• Education Level: Bachelor's degree
• Number of Employees: 101-250 employees