Database Administrator Specialist

Unclassified - Newark, NJ

Full-time

Newark, NJ

About the position

The Database Administrator Specialist role focuses on delivering high-quality database administration services, particularly in AWS environments. The specialist will manage and optimize databases such as Amazon Redshift, Aurora PostgreSQL, and Document DB, utilizing Infrastructure as Code (IaC) tools like Terraform and CloudFormation. This position requires collaboration with IT teams to enhance database infrastructure and ensure optimal performance and reliability.

Responsibilities

• Provision, configure, maintain, and optimize Amazon Redshift, Aurora PostgreSQL, and Document DB databases using CloudFormation and Terraform.
• Assess database infrastructure and identify areas for improvement in collaboration with IT teams.
• Develop Infrastructure as Code for database provisioning and maintenance according to best practices.
• Implement backup and recovery strategies to safeguard critical data and minimize downtime.
• Optimize database performance through query tuning, index optimization, and schema refinement.
• Provide technical support and troubleshooting for database-related issues and incidents.
• 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, 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.

Nice-to-haves

• Experience with CI/CD pipelines and tools like Jenkins for database provisioning and developer self-service.

Benefits

• Relocation assistance available.