Search jobs > Newark, NJ > Database engineer

Database Engineer (Redshift & AWS)

TechTriad
Newark, NJ, United States
Full-time

As a 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 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.

Responsibilities :

Develop Infrastructire as Code for provsioning, configurations, and maingtenance 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

2 hours ago
Related jobs
Promoted
TechTriad
Newark, New Jersey

As a 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 DocumentDB...

Promoted
VirtualVocations
Elizabeth, New Jersey

A company is looking for a Data Integration Engineer to design, develop, and implement enterprise data integration architectures. ...

Promoted
Analytic Recruiting Inc.
Florham Park, New Jersey

Expert level capabilities with: Data Warehouses, Data Lakes, ETL interfaces and Data Analytics solutions. Years of experience providing data solutions, architecture, design and delivery, in a Data Engineering role within a large financial institution. This person will collaborate with data architect...

Promoted
FYI Solutions
Newark, New Jersey

Job Description: 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 PostgreS...

ASB Resources
NJ, United States

The candidate will also support and assist in all aspects of the Treasury database tasks including but not limited to: <ul> <li>Managing clients requirements</li> <li>Writing shell scripts for automation of backup scripts</li> <li>Testing and validating</li>...

ST2 ManTech Advanced Systems Intl
Jersey City, New Jersey

Conduct statistical, mathematical, geospatial modeling or data-mining analysis in partnership with other Data Scientist or Analyst colleagues. Independently compile data to address the most complex intelligence issues or problems for senior internal/external customers. Identify and network with appr...

PSEG
Newark, New Jersey

Comply with policies and procedures for the administration of the databases, maintenance and upgrades of database software, and oversight of backups and standby databases. Comply with policies and procedures for the administration of the databases, maintenance and upgrades of database software, and ...

Winc
Jersey City, New Jersey

Pricing Database Administrator. Pricing Development and Analytics function to support the wider business through managing the commercial team’s database whilst ensuring optimal performance, server continuity and maintenance. Manage all ETL/SSIS packages, database, data cubes and models, and team ser...

Rutgers University
Somerset, NJ

In partnership with the research community and other biomedical and clinical informatics specialists, the successful candidate will manage and analyze data being created in molecular and cellular biology, genomics and biomedicine through the use of existing data science and machine learning tools as...

HAN
Totowa, New Jersey

Collaborate with the team to build out features for the data platform and consolidate data. Experience with relational datastores, NoSQL datastores and cloud object stores. Bonus: Familiar with data observability solutions, data governance frameworks. Build, maintain and optimize data pipelines buil...