MySQL DBMS Engineer Englewood Cliffs - NJ - New Jersey
Englewood Cliffs, New Jersey, United States of America
Contract
2 weeks ago
$60 USD
Key skills
PythonShellAWSAnsibleCloudFormationEC2S3DynamoDBRDSCloudWatchPostgreSQLMySQLRedisDatadog
About this role
Mysql DBA Analyst
Skills: Digital: Amazon Web Service (AWS) Cloud ComputingMySQL
Experience Required: 10 & Above
Role Descriptions: 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 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.