Jsr Tech Consulting - Newark, NJ

posted 3 months ago

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

About the position

As an AWS Cloud Database Administrator and Infrastructure as Code Developer, you will play a crucial role in delivering high-quality database administration services to Application and Development Teams within a major financial firm. This long-term contract-to-hire position requires you to work in a hybrid model, spending 2-3 days per week in Newark. Your primary responsibilities will include the provisioning, configuration, maintenance, and optimization of various databases such as Amazon Redshift, Aurora PostgreSQL, and DocumentDB. You will utilize CloudFormation Templates and Terraform to ensure that these databases are set up and maintained according to best practices and organizational requirements. In this role, you will collaborate closely with IT teams to assess the existing database infrastructure, identify areas for improvement, and implement effective solutions that enhance performance and reliability. A deep understanding of database concepts, particularly in Amazon Redshift, DocumentDB, and Aurora PostgreSQL, is essential. You will be expected to develop and implement backup and recovery strategies to safeguard critical data and minimize downtime, as well as optimize database performance through query tuning, index optimization, and schema refinement. Your technical expertise will also extend to providing support and troubleshooting assistance for database-related issues and incidents. You will be responsible for developing high availability and disaster recovery solutions, ensuring that the databases are resilient and can recover quickly from failures. Additionally, you will document database configurations, procedures, and troubleshooting steps to facilitate knowledge sharing and future reference. The use of CI/CD pipelines and tools like Jenkins will be integral to your role, enabling you to provision databases and develop solutions that empower developers with self-service capabilities.

Responsibilities

  • Provision, configure, maintain, and optimize Amazon Redshift, Aurora PostgreSQL, and DocumentDB databases using CloudFormation Templates and Terraform.
  • Assess database infrastructure and identify areas for improvement in collaboration with IT teams.
  • Develop Infrastructure as Code for provisioning, configurations, and maintenance of databases 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 database schema refinement.
  • Provide technical support and troubleshooting assistance for database-related issues and incidents.
  • Develop and implement high availability and disaster recovery solutions for databases.
  • Document database configurations, procedures, and troubleshooting steps for knowledge sharing.

Requirements

  • In-depth knowledge of Amazon Redshift, DocumentDB, 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 to effectively interact with internal teams.
  • Experience with Infrastructure as Code (IaC) 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.
  • Familiarity with CI/CD pipelines and tools like Jenkins.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service