What are the responsibilities and job description for the Database Administrator - Englewood Cliffs, NJ position at Software Technology Inc?
Job Description :
Expertise in MySQL and PostgreSQL is a mandatory requirement. The client is open to flexibility regarding other technical skills.
Expertise in MySQL and PostgreSQL is a mandatory requirement. The client is open to flexibility regarding other technical skills.
- 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.
- 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.
- 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.