What are the responsibilities and job description for the DBA Consultant (In-Person Interview) position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Dminds Solutions Inc., is seeking the following. Apply via Dice today!
Title : DBA Consultant
Location: Eaglewood NJ (weekly 3 days at office)
Mandatory Skills: MySQL, Redis, PostgreSQL and MongoDB
Job Description:
Title : DBA Consultant
Location: Eaglewood NJ (weekly 3 days at office)
Mandatory Skills: MySQL, Redis, PostgreSQL and MongoDB
Job Description:
- Install, configure, upgrade, and maintain MySQL, Redis, PostgreSQL and MongoDB 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 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