Senior Database Engineer (DBA)

Posted 2 Days Ago
Easy Apply
Hiring Remotely in India
Remote
Senior level
Artificial Intelligence • Fintech • Hardware • Information Technology • Sales • Software • Transportation
Unlock the potential of the physical economy.
The Role
Database Engineer at Motive responsible for designing and implementing high availability database architecture in AWS, monitoring and optimizing database performance, collaborating with developers on query optimization, automating routine database tasks, managing database security, and more. Requires 5+ years of PostgreSQL experience and expertise in AWS database services.
Summary Generated by Built In

Who we are:

Motive empowers the people who run physical operations with tools to make their work safer, more productive, and more profitable. For the first time ever, safety, operations and finance teams can manage their drivers, vehicles, equipment, and fleet related spend in a single system. Combined with industry leading AI, the Motive platform gives you complete visibility and control, and significantly reduces manual workloads by automating and simplifying tasks.

Motive serves more than 120,000 customers – from Fortune 500 enterprises to small businesses – across a wide range of industries, including transportation and logistics, construction, energy, field service, manufacturing, agriculture, food and beverage, retail, and the public sector.

Visit gomotive.com to learn more.

As a Database Engineer at Motive, you will ensure that our databases are performant, reliable, scalable, and automated. While overseeing more than 100 databases, almost all of which are PostgreSQL, you will also have a hand in the success of Motive’s expanded use of AWS managed data layer services (such as MySQL, DynamoDB, Elasticsearch, and Redshift, etc.). Working with product team engineers across a great variety of use cases, you will analyze the performance of databases and systems to provide optimizations and partner with product engineers on query tuning to help us keep scaling safely. As a member of Database Engineering team, you will execute zero-downtime upgrades and maintenance helping Motive to achieve 99.99% SLAs.

Responsibilities:

  • Design and implement high availability database architecture in AWS
  • Partner with developers and SREs to build and automate the provisioning of new infrastructure
  • Continuously monitor and improve database performance via proactive database maintenance, schema updates, table partitioning, etc.
  • Collaborate with developers to optimize database queries 
  • Automate routine database administration and maintenance tasks ensuring the health of databases
  • Plan and execute disaster recovery scenarios
  • Build dashboards for database health and alerting
  • Perform Terraform deployments of database instances and clusters
  • Manage database upgrades and migrations with minimal to zero-downtime
  • Work with our Data and ML teams on Kafka and Snowflake integrations and data flows from our main DBs
  • Oversee database security policies implementation, including user and group permissions management, data security and retention
  • 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
  • 7+ years of experience working with PostgreSQL
  • Experience building and maintaining mission-critical production PostgreSQL databases 
  • Solid understanding of PostgreSQL database architecture (locking, consistency, transaction logging, etc)
  • AWS database services experience (RDS/Aurora, 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 logging tools like Datadog, New Relic, Sumo Logic
  • Experience with connection pooling tools (such as Pgbouncer, RDS Proxy)
  • Experience with other databases like MySql, DynamoDB, Redshift, Elasticsearch, Snowflake is a plus

Creating a diverse and inclusive workplace is one of Motive'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.

The applicant must be authorized to receive and access those commodities and technologies controlled under U.S. Export Administration Regulations. It is Motive's policy to require that employees be authorized to receive access to Motive products and technology. 

#LI-Remote

Top Skills

Ansible
AWS
CloudFormation
Datadog
DynamoDB
Elasticsearch
MySQL
New Relic
Postgres
Redshift
Snowflake
Terraform
The Company
HQ: San Francisco, CA
4,000 Employees
Remote Workplace
Year Founded: 2013

What We Do

Motive builds technology to improve the safety, productivity, and profitability of businesses that power the physical economy. The Motive Automated Operations Platform combines IoT hardware with AI-powered applications to automate vehicle and equipment tracking, driver safety, compliance, maintenance, spend management, and more. Motive serves more than 120,000 businesses, across a wide range of industries including trucking and logistics, construction, oil and gas, food and beverage, field service, agriculture, passenger transit, and delivery. Visit gomotive.com to learn more.

Why Work With Us

We work hard, with humility and we see our efforts rewarded in tangible ways every day. At Motive, you’ll have the chance to make a difference for the drivers who keep our world moving. We trust each other to do great work because together we can achieve collective goals that reach beyond the physical economy.

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

Motive Offices

Remote Workspace

Employees work remotely.

Typical time on-site: None
Bengaluru, IN

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account