MySQL DBA

Purple Drive Technologies LLC

Englewood Cliffs, NJ, United States

6 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Amazon Web Services Amazon Elastic Compute Cloud Amazon S3 Databases Data Integrity Data Loss Database Schema Disaster Recovery Amazon DynamoDB Python (Programming Language) PostgreSQL Linux System Administration

+20 more

MongoDB MySQL Performance Tuning Redis Cloud Services Ansible Shell Script Backup and Restore Amazon ElastiCache Grafana Database Optimization Database Performance Indexer Cloudformation Gitlab-ci Kubernetes Database Replication Cloudwatch Docker Jenkins

Job description

Install, configure, upgrade, and maintain MySQL, Redis, and PostgreSQL databases in on-premises and AWS environments.
Manage database schemas, indexing, and performance optimization.
Manage database replication and high-availability solutions.
Administer AWS managed database services:
RDS
Aurora
ElastiCache
DynamoDB
S3
EC2
Perform backup, recovery, and disaster recovery operations.
Ensure data integrity, reliability, and minimal data loss/downtime.
Automate routine tasks and infrastructure setup using Ansible and AWS CloudFormation.
Design and implement monitoring and alerting using:
CloudWatch
PMM
Datadog
MonYog
Perform daily maintenance, health checks, and capacity planning.
Troubleshoot database and server issues.
Optimize complex queries and database performance.
Collaborate with application developers on efficient schema design and database optimization.

Requirements

Strong hands-on experience with MySQL installation, configuration, and maintenance.
Strong knowledge of MySQL internals and storage engines.
Strong Linux administration skills.
Experience with MySQL performance tuning.
Experience with backup and recovery processes.
Experience with AWS cloud services preferred.
Experience with Grafana or CloudWatch beneficial.
Experience with Jenkins or GitLab CI beneficial.
Knowledge of MongoDB or Redis is a plus.
Knowledge of Docker or Kubernetes is advantageous.
Good Shell scripting or Python skills.
Participate in on-call rotation for production incidents.
Comfortable working onsite in New Jersey.
Generate ad-hoc reports and provide insights as requested by internal teams or stakeholders.