Database Administrator - Englewood Cliffs, NJ

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

Job summary

STI is seeking a database expert with solid experience in MySQL and PostgreSQL. The role involves maintaining and optimizing databases in both on-premise and AWS environments. Candidates should be proficient in automated routines and monitoring tools, and familiar with security practices during interactions with application developers and DevSecOps.

Key responsibilities include database installation, replication management, and performance optimization. Flexibility regarding additional technical skills is encouraged.

Qualifications

• Expertise in MySQL and PostgreSQL is a mandatory requirement.
• Good with shell scripting or Python and Linux administration.

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 for proper high availability.
• Administer and optimize AWS managed database services.
• Automate routine tasks using tools like Ansible.
• Design comprehensive monitoring and alerting systems.
• Perform daily maintenance and health checks.
• Collaborate with application developers for schema design.
• Work closely with DevSecOps on security patches.

Skills

MySQL

PostgreSQL

Redis

MongoDB

AWS

Ansible

Python

Linux administration

Tools

CloudWatch

PMM

Datadog

MonYog

AWS RDS

AWS Aurora

AWS ElastiCache

AWS DynamoDB

AWS S3

AWS EC2

Job description

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

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 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 tools such as 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 to ensure 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 and Linux administration.