Database Administration

Database Administration

Location:

Englewood Cliff, NJ

Hybrid:
Yes, 3 days a week

Type:
Contract

Mandatory

Skills:

MySQL, Redis, Postgre

SQL and MongoDB

• 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