AWS Cloud Database Admin

Allegis Group - Newark, NJ

Full-time - Mid Level

Newark, NJ

10,001+ employees

Administrative and Support Services

About the position

As an AWS Cloud Database Administrator and Infrastructure as Code Developer, you will be responsible for delivering high-quality database administration services to Application/Development Teams. This includes provisioning, configuration, maintenance, and optimization of Amazon Redshift, Aurora PostgreSQL, and DocumentDB databases using CloudFormation templates and Terraform. You will collaborate closely with our IT teams to assess the database infrastructure, identify areas for improvement, and implement effective solutions to ensure optimal performance and reliability. In-depth knowledge of Amazon Redshift database administration, DocumentDB database administration, and Aurora PostgreSQL database administration, including installation, configuration, and maintenance, is necessary for this position. Strong analytical and problem-solving skills are essential, as you will need to diagnose and resolve complex database issues. Excellent communication and interpersonal skills are also required to effectively interact with internal teams. You will develop Infrastructure as Code for provisioning, configurations, and maintenance of Amazon Redshift, DocumentDB, and Aurora PostgreSQL databases according to best practices and requirements. Experience with infrastructure as code (IaC) tools such as AWS CloudFormation or Terraform is a must. Proficiency in scripting with Python, AWS Lambda, and Step Functions is also required. You will develop and implement backup and recovery strategies to safeguard critical data and minimize downtime. A deep understanding of database concepts and experience with Redshift, DocumentDB, and Aurora PostgreSQL is crucial for success in this role.

Responsibilities

• Deliver high-quality database administration services to App/Dev Teams.
• Provision, configure, maintain, and optimize Amazon Redshift, Aurora PostgreSQL, and DocumentDB databases using CloudFormation and Terraform.
• Assess database infrastructure and identify areas for improvement.
• Implement effective solutions to ensure optimal performance and reliability.
• Develop Infrastructure as Code for provisioning and maintenance of databases according to best practices.
• Optimize database performance through query tuning, index optimization, and schema refinement.
• 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 for knowledge sharing.

Requirements

• In-depth knowledge of Amazon Redshift, DocumentDB, and Aurora PostgreSQL administration.
• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal skills.
• Experience with infrastructure as code tools such as AWS CloudFormation or Terraform.
• Proficiency in scripting with Python, AWS Lambda, and Step Functions.
• Experience with monitoring and logging tools, particularly AWS CloudWatch.
• Experience in administration, managing, and optimizing databases.

Nice-to-haves

• Experience with CI/CD pipelines and tools like Jenkins for database provisioning.
• Familiarity with backup and recovery strategies for databases.