Database Administrator - Englewood Cliffs, NJ

Job Description

Expertise in MySQL and Postgre

SQL is a mandatory requirement. The client is open to flexibility regarding other technical skills.

• Install, configure, upgrade, and maintain MySQL, Redis, Postgre
  
  SQL and Mongo
  
  DB 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, Elasti Cache, Dynamo
  
  DB, S3, EC2).
• Automate routine tasks and infrastructure setup using tools like Ansible and AWS Cloud Formation.
• Design and implement comprehensive monitoring and alerting systems (Cloud Watch, PMM, Datadog, Mon Yog) 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 Dev Sec Ops  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.