Database Administrator

Tavant; New Jersey; On-site; USD 120,000 - 180,000; Full time

Job summary

Tavant is seeking a database administrator in New Jersey who can install, configure, and maintain MySQL, PostgreSQL, Redis and MongoDB across on-premise and AWS environments.

You will implement high-availability replication, manage AWS managed services, and automate tasks with Ansible and CloudFormation while monitoring performance with CloudWatch, Datadog and PMM.

Qualifications

• Must be an expert in MySQL and PostgreSQL.
• Must be located in New Jersey or willing to relocate.
• Experience installing, configuring, upgrading, and maintaining MySQL, Redis, PostgreSQL and MongoDB databases in on-premise and AWS environments.

Responsibilities

• Install, configure, upgrade, and maintain MySQL, Redis, PostgreSQL and MongoDB databases in both on-premise and AWS environments.
• Manage replication solutions for each database based on application requirements for proper High Availability.
• Administer and optimize AWS managed database services (RDS, Aurora, ElastiCache, DynamoDB, S3, EC2).
• Automate routine tasks and infrastructure setup using Ansible and AWS CloudFormation.
• Design and implement comprehensive monitoring and alerting systems (CloudWatch, PMM, Datadog, MonYog) to proactively identify performance bottlenecks and apply optimizations.
• Perform daily maintenance, health checks, and capacity planning to ensure database reliability across all environments.
• Collaborate with application developers to design efficient schemas, optimize complex queries, and enhance database performance.
• Work closely with DevSecOps to ensure timely security patches and upgrades.
• Develop and manage robust backup and disaster recovery strategies ensuring minimal data loss and downtime.
• Generate ad-hoc reports and provide insights as requested by internal teams or stakeholders.
• Good with Shell Scripting or Python. Good with linux administration

Skills

MySQL

PostgreSQL

Linux administration

Shell scripting

Python

High availability

Tools

Ansible

AWS CloudFormation

CloudWatch

Datadog

MonYog

PMM

RDS/Aurora

DynamoDB

Job description

Must be located in New Jersey or willing to relocate

Must be an expert in MySQL and PostgreSQL

• Install, configure, upgrade, and maintain MySQL, Redis, PostgreSQL and MongoDB databases in both on-premise and AWS environments.
• Manage Replication solutions for each Database based on application requirement for proper HighAvailability.
• Administer and Optimize AWS Managed database services (RDS, AURORA, ElastiCache, DynamoDB, S3, EC2).
• Automate routine tasks and infrastructure setup using tools like Ansible and AWS CloudFormation.
• Design and implement comprehensive monitoring and alerting systems (CloudWatch , PMM, Datadog, MonYog) to proactively identify performance bottlenecks and apply necessary optimizations or fixes.
• Perform daily maintenance, health checks, and capacity planning to ensure database reliability across all environments.
• Collaborate with application developers to design efficient schemas, optimize complex queries, and enhance database performance.
• Work closely with DevSecOps to ensure timely application of security patches and upgrades.
• Develop and manage robust backup and disaster recovery strategies ensuring minimal data loss and downtime.
• Generate ad-hoc reports and provide insights as requested by internal teams or stakeholders. Good with Shell Scripting or Python. Good with linux administration