Role: DBA

Location: Englewood Cliff, NJ (Hybrid: Yes, 3 days a week)

Interview: In-person technical round at the client location

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 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