What are the responsibilities and job description for the Database Engineer position at Jobs via Dice?
Job Description:
- Install, configure, upgrade, and maintain MySQL, Redis, PostgreSQL databases in both on-premise and AWS environments.
- Manage Replication solutions for each Database based on application requirement for proper HighAvailability.
- Administer and Optimize AWS Managed databaseservices (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.