Job Title: Database Administrator Specialist/AWS Cloud Database Administrator

Job Duration: Right to Hire

Job Location: Newark, NJ

Try to send 6 years' experience or Sr. candidates acceptable

Relocation acceptable

Check the yellow highlight.

What You'll Do:

• As an AWS Cloud Database Adminsitrator and Infrasturcture as Code Developer, you will be responsible for delivering high-quality database administration services to App/Dev Teams, including provisioning, configuration, maintenance, and optimization of Amazon Redshift, Aurora PostgreSQL and Document DB Databases using Cloud Formation Templates and Terraform.
• Will work closely with our IT teams to assess database infrastructure, identify areas for improvement, and implement effective solutions to ensure optimal performance and reliability.
• Develop Infrastructire as Code for provsioning, configurations, and maintenance of Amazon Redshift, Document DB and Aurora PostgreSQL Databases according to best practices and requirements.

What You Bring:

• In-depth knowledge of Amazon Redshift database administration, Document DB database administration and Aurora PostgreSQL database administration including installation, configuration, and maintenance is necessary for the position.
• Strong analytical and problem-solving skills, with the ability to diagnose and resolve complex database issues.
• Excellent communication and interpersonal skills, with the ability to effectively interact with internal teams are necessary.
• Experience with infrastructure as code (IaC) tools such as AWS CloudFormation or Terraform is a must.
• Proficiency in scripting with Python, lambda and Step Functions.
• Develop and implement backup and recovery strategies to safeguard critical data and minimize downtime.
• Deep understanding of database concepts and experience with Redshift, DocumentDB, Aurora PostgreSQL is a must.
• Optimize database performance through query tuning, index optimization, and database schema refinement.
• Experience with monitoring and logging tools, particularly AWS CloudWatch is a must.
• Provide technical support and troubleshooting assistance for Database related issues and incidents.
• Develop and implement high availability and disaster recovery solutions.
• Experience in administration, managing and optimizing databases like Redshift, DocumentDB and Aurora PostgreSQL.
• Use of CI/CD pipelines and tools like Jenkins to provision databases and develop solutions for developer Self Service.
• Document database configurations, procedures, and troubleshooting steps for knowledge sharing and future reference.