MSYS - Newark, NJ

posted 3 months ago

Full-time - Entry Level
Hybrid - Newark, NJ
Professional, Scientific, and Technical Services

About the position

As an AWS Cloud Database Administrator Specialist, you will play a crucial role in delivering high-quality database administration services to Application and Development Teams. This position is hybrid, requiring local candidates from New Jersey, and involves responsibilities such as provisioning, configuration, maintenance, and optimization of various Amazon databases including Redshift, Aurora PostgreSQL, and Document DB. You will utilize Infrastructure as Code (IaC) tools like CloudFormation and Terraform to ensure that the database infrastructure is robust and efficient. Your work will involve close collaboration with IT teams to assess the current database infrastructure, identify areas for improvement, and implement effective solutions that enhance performance and reliability. You will be expected to develop Infrastructure as Code for provisioning and maintaining databases according to best practices and specific requirements. This role demands a deep understanding of database concepts and hands-on experience with the mentioned Amazon databases, ensuring that you can optimize performance through query tuning, index optimization, and schema refinement. In addition to technical skills, strong analytical and problem-solving abilities are essential, as you will need to diagnose and resolve complex database issues. Excellent communication and interpersonal skills are also necessary to effectively interact with internal teams. You will be responsible for developing and implementing backup and recovery strategies to safeguard critical data, as well as high availability and disaster recovery solutions. Furthermore, you will document database configurations, procedures, and troubleshooting steps to facilitate knowledge sharing within the team.

Responsibilities

  • Deliver high-quality database administration services to App/Dev Teams.
  • Provision, configure, maintain, and optimize Amazon Redshift, Aurora PostgreSQL, and Document DB databases.
  • Develop Infrastructure as Code for provisioning and maintenance of databases using CloudFormation and Terraform.
  • Assess database infrastructure and identify areas for improvement.
  • Implement effective solutions to ensure optimal performance and reliability.
  • Optimize database performance through query tuning, index optimization, and schema refinement.
  • Develop and implement backup and recovery strategies to safeguard critical data.
  • Provide technical support and troubleshooting assistance for database-related issues.
  • Develop and implement high availability and disaster recovery solutions.
  • Document database configurations, procedures, and troubleshooting steps.

Requirements

  • In-depth knowledge of Amazon Redshift, Document DB, and Aurora PostgreSQL database administration including installation, configuration, and maintenance.
  • Strong analytical and problem-solving skills to diagnose and resolve complex database issues.
  • Excellent communication and interpersonal skills for effective interaction with internal teams.
  • Experience with Infrastructure as Code (IaC) tools such as AWS CloudFormation or Terraform.
  • Proficiency in scripting with Python, Lambda, and Step Functions.
  • Experience with monitoring and logging tools, particularly AWS CloudWatch.
  • Experience in administration, managing, and optimizing databases like Redshift, Document DB, and Aurora PostgreSQL.

Nice-to-haves

  • Experience with CI/CD pipelines and tools like Jenkins for database provisioning and development solutions.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service