Database Administrator/Engineer

Role Summary

As a Database Administrator you will ensure that our databases (PostgreSQL, Redshift, Snowflake, DynamoDB) are performant, highly available, and reliable. You will partner with other engineers across the org to build and administer databases using code and automation. You will analyze the performance of databases and systems to provide optimizations and build scalable infrastructure. You will help

Learn more about our work culture and team members on this profile of our team here.

Responsibilities

• Design and implement high availability database architecture in AWS
• Partner with developers and SREs to build new infrastructure
• Continuously monitor and improve database usage via query and index tuning, schema updates, partitioning, etc.
• Collaborate with developers to code optimized database queries
• Plan and execute disaster recovery scenarios
• Build dashboards for database health and alerting
• Perform Terraform deployments of database instances, users, groups, and permissions
• Manage database upgrades and migrations with minimal downtime
• Take on-call duty to respond to production incidents

Requirements

• B.S. or M.S. in Computer Science or a related field, or equivalent work experience
• 3+ years of experience working with at least one of the major relational databases, such as PostgreSQL, Oracle, MySQL, SqlServer
• Experience building and maintaining complex mission-critical production database systems
• Solid understanding of relational database architecture (locking, consistency, transaction logging, etc)
• Experience with high-availability, backup and recovery solutions and strategies
• Advanced knowledge of SQL and query optimization techniques
• Working knowledge of at least one scripting language (korn shell, Python) and PostgreSQL procedural language (PL/pgSQL, PL/SQL, T-SQL, etc.)
• Experience provisioning and configuring databases with tools like Terraform, CloudFormation, Ansible
• Creating a diverse and inclusive workplace is one of KeepTruckin's core values. We are an equal opportunity employer and welcome people of different backgrounds, experiences, abilities and perspectives.
• Please review our Candidate Privacy Notice here.

About the Company

KeepTruckin builds technology using the latest advancements in AI and computer vision to improve the safety and efficiency of businesses with vehicles. Over one million drivers and 100,000 companies across every industry trust KeepTruckin’s integrated platform to power their operations, prevent accidents and reduce costs.

At KeepTruckin, we see our hard work rewarded in tangible ways every day, and we believe that intelligence is most powerful when paired with humility. We’re motivated by the opportunity to save lives on the road while impacting and improving every facet of multiple trillion-dollar industries that keep our physical economy moving. KeepTruckin is proud to be a Forbes Cloud 100 company, Forbes Best Startup Employer 2020, and an Inc Magazine Best Place to Work.

KeepTruckin is on a mission to modernize the trucking industry. With the leading fleet management platform, we are bringing trucks online and fundamentally changing the way freight is moved on our roads.

We are a Forbes Cloud 100 company and we’ve been recognized by Glassdoor as a “Best Place to Work” in 2019. We’re on the hunt to find talented individuals to join our growing team.