Motive
Senior Cloud Database Engineer (PostgreSQL)
Job Description
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 AWS
- Partner 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
- Experience building and maintaining mission-critical production PostgreSQL databases
- Solid understanding of PostgreSQL database architecture (locking, consistency, transaction logging, etc)
- Experience in 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
Motive
Motive provides an integrated platform to help improve the safety, productivity, and profitability of fleet operations for the physical economy.
See more jobsSafe Remote Job Search Tips
Verify Employer Thoroughly
Research the company's identity thoroughly before applying. Check for a professional website with contacts, active social media, and LinkedIn profiles. Verify details across platforms and look for reviews on Glassdoor or Trustpilot to confirm legitimacy.
Never Pay to Get a Job
Legitimate employers never require payment for applications, training, background checks, or equipment. Always reject upfront payment requests or demands for bank details, even if they claim it's for purchasing necessary work gear on your behalf.
Safeguard Your Personal Information
Protect sensitive data like SSN, bank details, or ID copies. Share this only after accepting a formal, written job offer. Ensure it's submitted via a secure company system or portal, never through insecure channels like standard email attachments.
Scrutinize Communication & Interviews
Watch for communication red flags: poor grammar, generic emails (@gmail), vague details, or undue pressure. Be highly suspicious of interviews held only via text or chat apps; legitimate companies typically use video or phone calls.
Beware of Unrealistic Offers
If an offer's salary or benefits seem unrealistically high for the work involved, be cautious. Research standard pay for similar roles. Offers that appear 'too good to be true' are often scams designed to lure you into providing information or payment.
Insist on a Formal Contract
Always secure and review a formal, written job offer or employment contract before starting work or sharing final personal details. Ensure it clearly defines your role, compensation, key terms, and conditions to avoid misunderstandings or scams.