Administrative Skills, Amazon Elastic Compute Cloud (EC2), Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Analysis Skills, Ansible, Applications Security, Automation, Capacity Management, Cloud Computing, Data Recovery, Database Administration, Database Design, Database Optimization, Database Replication, Disaster Recovery, Financial Reporting, Health Maintenance, High Availability, Linux Administration, Linux Operating System, MySQL, Performance Tuning/Optimization, PostgreSQL, Python Programming/Scripting Language, Query Optimization, Redis, Replication and Remote Mirroring, Security Patches, Software Development, Time Management, Unix Shell Programming
Job Title: MySQL DBA Analyst
Location: Englewood Cliffs, NJ
Duration: 6 Months
Employment Type: W2 only
Salary Range: $40.00 $45.45/hr
Work Model: 100% Onsite
> Job Description
Install, configure, upgrade, and maintain MySQL, Redis, PostgreSQL databases in both on-premises and AWS environments.
Manage replication solutions for each database based on application requirements for proper High Availability.
Administer and optimize AWS managed database services including:
- RDS
- Aurora
- ElastiCache
- DynamoDB
- S3
- EC2
Automate routine tasks and infrastructure setup using tools like:
- Ansible
- AWS CloudFormation
Design and implement comprehensive monitoring and alerting systems including:
- CloudWatch
- PMM
- Datadog
- MonYog
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
- 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
- Linux administration
< Required Skills & Experience
- 10+ years of experience
- Strong expertise in:
- MySQL
- PostgreSQL
- Redis
- AWS Cloud
- Experience with:
- RDS
- Aurora
- ElastiCache
- DynamoDB
- EC2
- S3
- Strong knowledge of:
- Database replication
- High availability
- Backup & recovery
- Performance tuning
- Experience with:
- CloudWatch
- Datadog
- PMM
- MonYog
- Automation experience using:
- Ansible
- AWS CloudFormation
- Good scripting skills in:
- Good Linux administration experience
=' Technical Skills
- MySQL
- PostgreSQL
- Redis
- AWS Cloud
- RDS
- Aurora
- DynamoDB
- EC2
- S3
- Ansible
- CloudFormation
- Linux
- Python
- Shell Scripting
< Company Benefits & Culture
- Inclusive and diverse work environment
- Opportunities for professional growth and development
- Comprehensive health and wellness benefits
= Application
Email your resume to: Vibhor.babbar@artech.com