AWS Administrator

MUST BE LOCAL TO NEWARK, NJ - HYBRID SCHEDULE 2-3 days a week

Long term contract to hire position

About the role :

As a AWS Cloud Database Administrator and Infrastructure 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 DocumentDB Databases using Cloud Formation Templates and Terraform.

You 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.

In-depth knowledge of Amazon Redshift database administration, DocumentDB 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.

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, 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.

Responsibilities :

• Delivering high-quality database administration services to App / Dev Teams
• Provisioning, configuration, maintenance, and optimization of Amazon Redshift, Aurora PostgreSQL and DocumentDB Databases
• Assessing database infrastructure and identifying areas for improvement
• Implementing effective solutions for optimal performance and reliability
• Developing Infrastructure as Code for provisioning, configurations, and maintenance of databases
• Optimizing database performance through query tuning, index optimization, and database schema refinement
• Providing technical support and troubleshooting assistance for Database related issues and incidents
• Developing and implementing high availability and disaster recovery solutions
• Documenting database configurations, procedures, and troubleshooting steps for knowledge sharing and future reference
3 days ago