Senior Database Administrator - PostgreSQL India - Remote

Motive; Aurora (CO); Remote; USD 80,000 - 120,000; Full time

Job summary

An innovative company is seeking a skilled Database Engineer to enhance their database performance and reliability. This role involves overseeing a large number of PostgreSQL databases and collaborating with product teams to optimize queries and manage AWS services. You will be instrumental in ensuring high availability and zero-downtime upgrades while contributing to the company's commitment to operational excellence. Join a diverse team dedicated to creating a safe and productive work environment, where your expertise will directly impact the success of a leading platform in the industry.

Qualifications

• 5+ years of experience with PostgreSQL, focusing on performance and reliability.
• Experience with AWS managed services and high-availability solutions.

Responsibilities

• Design and implement high availability database architecture in AWS.
• Monitor and improve database performance via query and index tuning.

Skills

PostgreSQL

AWS managed services

Database Administration

Query tuning

Terraform

Monitoring tools

Education

B.S. or M.S. in Computer Science

Tools

Terraform

Datadog

New Relic

Sumo Logic

DynamoDB

Redshift

Elasticsearch

Snowflake

Job description

India - Remote

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.

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 Noticehere .

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.

Apply for this job

*

indicates a required field

First Name *

Last Name *

Email *

Phone *

Location (City)

Resume/CV *

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

LinkedIn Profile

Github URL

Other Website

What tangible factors are most important to you when considering a job opportunity? *

Work-life Balance

Remote Work

Leadership

Compensation

PTO

Culture

Company Outlook

Select your top 3.

What about Motive makes it an appealing place to work? *

Pronouns Select...

Let Motive know what pronouns you use so we can address you correctly.

How did you hear about this opportunity? * Select...

How many years of working experience do you have in PostgresSQL? * Select...

Which monitoring tools have you used recently? *

What version of PostgreSQL are you currently using? *

Global Diversity Survey

We invite applicants to share their demographic background. If you choose to complete this survey, your responses may be used to identify areas of improvement in our hiring process.

How would you describe your gender identity? (mark all that apply) Select...

Do you have a disability or chronic condition (physical, visual, auditory, cognitive, mental, emotional, or other) that substantially limits one or more of your major life activities, including mobility, communication and learning? Select...