Database Administrator - Englewood Cliffs, NJ

STI; Englewood Cliffs (NJ); On-site; USD 120,000 - 160,000; Full time

Job summary

STI in Englewood Cliffs, NJ is seeking an expert Database Administrator with mandatory MySQL and PostgreSQL expertise to manage on-prem and AWS databases, ensure high availability, and drive performance.

You will configure and maintain MySQL, Redis, PostgreSQL, MongoDB; implement replication, automate tasks with Ansible and CloudFormation, monitor with CloudWatch, Datadog, and PMM, and collaborate with DevSecOps to apply patches and backups.

Qualifications

• Expert in MySQL and PostgreSQL with production experience.
• Experience managing databases in AWS (RDS/Aurora) and cloud services.
• Proficient in Shell scripting or Python and Linux administration.

Responsibilities

• Install, configure, upgrade, and maintain MySQL, Redis, PostgreSQL and MongoDB databases in on-premise and AWS environments.
• Manage replication solutions for each database to ensure 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 monitoring and alerting with CloudWatch, PMM, Datadog, MonYog to identify bottlenecks and apply fixes.
• Perform daily maintenance, health checks, and capacity planning for reliability across environments.
• Collaborate with developers to design efficient schemas and optimize queries.
• Work with DevSecOps to apply security patches and upgrades.
• Develop and manage backup and disaster recovery strategies to minimize downtime.
• Generate ad-hoc reports and provide insights; proficient in Shell/Python and Linux administration.

Skills

MySQL

PostgreSQL

AWS

Shell scripting

Python

Linux administration

Monitoring tools

Tools

Ansible

AWS CloudFormation

CloudWatch

Datadog

MonYog

RDS/Aurora

Redis

MongoDB

DynamoDB

Job description

Job Description

Expertise in MySQL and PostgreSQL is a mandatory requirement. The client is open to flexibility regarding other technical skills.

• 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 High Availability.
• 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.
  

Roles & 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 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.