Database Administrator DBA

Compunnel, Inc.; Englewood Cliffs (NJ); On-site; USD 100,000 - 130,000; Full time

Job summary

Compunnel, Inc. is looking for an experienced Database Administrator to manage enterprise database environments on-premises and in AWS. The successful candidate will have strong expertise in MySQL, PostgreSQL, Redis, and MongoDB, and will perform tasks like database installation, optimization, and support.

The ideal applicant should possess at least 10 years of experience in database administration, with a focus on high-availability production setups, database migrations, and automation using tools like Ansible and AWS CloudFormation.

Qualifications

• 10+ years of experience as a Database Administrator in production environments.
• Strong expertise in MySQL, PostgreSQL, Redis, and MongoDB.
• Experience with AWS database services and automation tools.

Responsibilities

• Install and configure databases across on-prem and AWS platforms.
• Manage database replication for high availability.
• Administer AWS managed database services like RDS and Aurora.
• Automate database tasks using Ansible and AWS CloudFormation.
• Perform database migrations and optimize performance.

Skills

MySQL

PostgreSQL

Redis

MongoDB

Shell scripting

Python

AWS EC2

Database replication

Performance tuning

Tools

AWS RDS

HAProxy

Ansible

AWS CloudFormation

Job description

We are seeking an experienced Database Administrator to install, configure, administer, optimize, and support enterprise database environments across on-premises and AWS platforms. The ideal candidate will possess strong expertise in MySQL, PostgreSQL, Redis, and MongoDB while supporting high-availability production environments, database migrations, automation, performance tuning, backup and recovery, and cloud database services.

Key Responsibilities

• Install, configure, upgrade, maintain, and administer MySQL, PostgreSQL, Redis, and MongoDB databases across on-premises and AWS environments.
• Manage database replication solutions to support application-specific high-availability requirements.
• Administer and optimize AWS managed database services including RDS, Aurora, ElastiCache, DynamoDB, EC2, and S3.
• Perform database migrations, upgrades, blue-green deployments, and refresh activities with minimal downtime.
• Automate infrastructure provisioning and routine administrative tasks using Ansible and AWS CloudFormation.
• Design, implement, and maintain database monitoring, alerting, and performance management solutions.
• Perform database health checks, capacity planning, maintenance, and performance optimization.
• Troubleshoot production database issues and resolve performance bottlenecks.
• Collaborate with application development teams to optimize database schemas, SQL queries, and overall database performance.
• Support DevSecOps initiatives by implementing security patches, upgrades, and database hardening activities.
• Develop, implement, and maintain backup, recovery, and disaster recovery strategies.
• Generate reports and provide database insights to internal stakeholders.
• Support database administration across Linux-based environments.
• Develop and maintain Shell or Python scripts to automate database administration activities.
• Create, tune, and optimize stored procedures as required.

Required Qualifications

• Overall 10+ years of professional experience as a Database Administrator supporting enterprise production environments.
• Strong hands-on experience with MySQL, PostgreSQL, Redis, and MongoDB.
• Extensive experience administering enterprise databases in production environments.
• Experience deploying, migrating, upgrading, and supporting databases on AWS EC2, Aurora, RDS MySQL, and PostgreSQL.
• Strong knowledge of database replication, high availability, ACID principles, normalization, and transaction management.
• Experience with HAProxy and Keepalived configuration and administration.
• Strong experience with Shell scripting or Python.
• Experience using Ansible and AWS CloudFormation for infrastructure automation.
• Strong knowledge of Linux administration.
• Experience with database performance tuning, query optimization, and stored procedures.
• Experience implementing backup, recovery, monitoring, and disaster recovery solutions.
• Strong troubleshooting, analytical, problem‑solving, and communication skills.

Preferred Qualifications

• Experience with MongoDB administration.
• Experience with monitoring tools such as CloudWatch, PMM, Datadog, or MonYog.
• Experience working with DevSecOps teams and cloud-native infrastructure.
• Experience supporting enterprise-scale AWS database environments.