Database Administrator

Motive

Chennai,Tamil Nadu

Job Description

About the job

About the job

Who We Are

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.

Motive is proud to be a Forbes Cloud 100 company and a 2020 Career-Launching Company by Wealthfront.

About The Role

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.

Responsibilities

• 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
  

Qualifications

• 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
  

Creating a diverse and inclusive workplace is one of Motives core values. We are an equal opportunity employer and welcome people of different backgrounds, experiences, abilities and perspectives.

Please do not let an arrest or conviction record prevent you from applying for employment at Motive. Motive considers qualified applicants with arrest and conviction records.

Please review our Candidate Privacy Notice here.

Creating a diverse and inclusive workplace is one of Motives 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 Motives policy to require that employees be authorized to receive access to Motive products and technology.