Senior Database Engineer (DBA)

3 Months ago • 5 Years + • Programming

Job Summary

Job Description

As a Database Engineer at Motive, you will ensure the performance, reliability, scalability, and automation of our databases. You will oversee over 100 databases, primarily PostgreSQL, and contribute to the successful use of AWS managed data layer services like DynamoDB, Elasticsearch, and Redshift. Collaborating with product team engineers, you'll analyze database performance, optimize queries, and ensure zero-downtime upgrades. Responsibilities include designing high-availability database architecture, monitoring and improving database performance, collaborating on query optimization, and managing database upgrades and migrations.
Must have:
  • 5+ years of experience, 3+ with PostgreSQL 9.6+
  • Experience building and maintaining PostgreSQL databases
  • Understanding of PostgreSQL database architecture
  • Experience with AWS managed services
  • Knowledge of query tuning and optimization
  • Experience provisioning PostgreSQL databases in AWS with tools like Terraform
Good to have:
  • Experience with other databases like DynamoDB, Redshift, Elasticsearch, Snowflake
  • Experience with monitoring and logging tools like Datadog, New Relic, Sumo Logic

Job Details

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.

About the Role:

As a Database Engineer at Motive, you will ensure that our databases are performant, reliable, scalable, and automated. While also acting as a DBA overseeing more than 100 databases, almost all of which are Postgres, you will also have a hand in the success of Motive’s expanded use of AWS managed data layer services (such as DynamoDB, Elasticsearch, and Redshift, etc.). Partnering 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. You will also help run zero-downtime upgrades and maintenance as Motive reaches 99.99% SLAs, helped in large part by the excellence of our Database Engineering team’s focus on reliability.

Responsibilities:

  • Design and implement high availability database architecture in AWSPartner with developers and SREs to build and automate the provisioning of new infrastructure
  • Continuously monitor and improve database performance via query and index tuning, schema updates, partitioning, etc.
  • Collaborate with developers to tune and optimize database queries
  • Work with our Data and ML teams on Kafka and Snowflake integrations and data flows from our main DBs
  • Database Administrator tasks and maintenance ensuring the health of database tables
  • 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 to zero-downtimeTake 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
  • Overall 5+ years of experience and 3+ years 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)AWS managed services experience (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 other databases like 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 .

UK 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

Similar Jobs

Enphase Energy - Engineer, DVT

Enphase Energy

Bengaluru, Karnataka, India (On-Site)
2 Months ago
WebTech Corporation - Senior Hardware Engineer

WebTech Corporation

Suzhou, Jiangsu, China (On-Site)
1 Year ago
Tencent - Agent Development Intern (Marketing and UA Support)

Tencent

London, England, United Kingdom (On-Site)
2 Weeks ago
Gusto - Product Manager – Order to Cash (O2C)

Gusto

San Francisco, California, United States (Hybrid)
2 Weeks ago
PwC - Manager - Content Publishing Lead - Advisory - Application Technology

PwC

Mumbai, Maharashtra, India (On-Site)
3 Weeks ago
Luxoft - Senior Java Developer

Luxoft

Ukrainka, Kyiv Oblast, Ukraine (Remote)
8 Months ago
NVIDIA - GPU C++ Modeling Engineer

NVIDIA

Shanghai, Shanghai, China (On-Site)
4 Months ago
Ubisoft - Team Lead Programming

Ubisoft

Montreal, Quebec, Canada (Hybrid)
1 Month ago
FICO - Senior C++ Engineer (Parallel Processing)

FICO

United States (Remote)
1 Year ago
Ion - Senior Java Developer - Italy

Ion

Rome, Lazio, Italy (On-Site)
10 Months ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Wrike - Account Manager 3 - Klaxoon

Wrike

Paris, Île-de-France, France (Hybrid)
2 Weeks ago
playrix  - Game Designer Playables

playrix

Cyprus (Remote)
4 Months ago
London stock Exchange - Software Development Engineer in Test (SDET)

London stock Exchange

Bengaluru, Karnataka, India (On-Site)
2 Months ago
RTL - Management RTL Deutschland

RTL

Germany (On-Site)
1 Month ago
Valeo - Industrial Testing Engineer

Valeo

Czechowice-Dziedzice, Silesian Voivodeship, Poland (On-Site)
3 Weeks ago
Pivotroots - Business Development Manager

Pivotroots

Gurugram, India (Hybrid)
3 Months ago
Reveal - Account Executive, Enterprise

Reveal

Washington, District Of Columbia, United States (On-Site)
5 Months ago
IMC - Risk Manager

IMC

Amsterdam, North Holland, Netherlands (On-Site)
2 Weeks ago
Thales - ZENITH - S4HANA Archetype Director - Product Series version M/F

Thales

Meudon, Île-de-France, France (On-Site)
2 Weeks ago
Rush street interactive  - Talent Acquisition Partner

Rush street interactive

Estonia (Hybrid)
1 Month ago

Get notifed when new similar jobs are uploaded

Jobs in Worldwide

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Programming Jobs

Capgemini - Record to Analyze Process Expert - C

Capgemini

Bengaluru, Karnataka, India (On-Site)
2 Months ago
Diligent Corporation - Head of Board & C-Suite Engagement

Diligent Corporation

New York, United States (Hybrid)
1 Month ago
Varonis  - Python Team Leader

Varonis

Herzliya, Tel Aviv District, Israel (Hybrid)
3 Months ago
Thumbtack - Senior Software Engineer, Developer Experience

Thumbtack

Ontario, Canada (Remote)
1 Month ago
HCL Tech - Technical Lead - C++, C#

HCL Tech

Massachusetts, United States (On-Site)
2 Months ago
Electronic Arts - Software Developer II

Electronic Arts

Vancouver, British Columbia, Canada (Hybrid)
1 Month ago
Capgemini - Senior Software Engineer - C

Capgemini

Hyderabad, Telangana, India (On-Site)
2 Months ago
Synechron - Big Data Java Developer with PySpark

Synechron

Mississauga, Ontario, Canada (Hybrid)
1 Month ago
5minlab - Client Programmer

5minlab

Seoul, South Korea (On-Site)
7 Months ago
TransUnion - Principal Engineer - Database

TransUnion

Leeds, England, United Kingdom (Hybrid)
3 Weeks ago

Get notifed when new similar jobs are uploaded