Who We Are
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.
Want more jobs like this?
Get Data and Analytics jobs in United States delivered to your inbox every week.
About the Job:
As a PostgreSQL DBA you will ensure that our databases 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 developers write efficient queries and review code that interacts with our databases. You will plan and execute major upgrades and maintenance tasks with minimal downtime.
Qualifications:
- B.S. or M.S. in Computer Science or a related field, or equivalent work experience
- 3+ years of experience working with PostgreSQL 9.6+
- Experience building and maintaining mission-critical production PostgreSQL databases
- Solid understanding of PostgreSQL database architecture (locking, consistency, transaction logging, etc)
- Experience with high-availability, backup and recovery solutions and strategies
- Advanced knowledge of query tuning and optimization techniques
- Experience provisioning PostgreSQL databases in AWS with tools like Terraform, CloudFormation, Ansible
- Experience with monitoring and log tools like Datadog, New Relic, Sumo Logic
- Experience with other databases like DynamoDB, Redshift, Snowflake is a plus
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 tune and optimize 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