AWS Data Engineer

Richmond, VA - USA

Monthly Salary: Not Disclosed

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

Job Description

Job description:

Title: Database Administrator / Data Engineer

Duration: 3 months

Location: Richmond VA USA

Mode of work: Hybrid

Mode of Interview: In person

Complete Description:

ABOUT THE ROLE

We are seeking a Database Administrator / Data Engineer with strong experience in migrating on-premises databases to AWS. The candidate will support data platform modernization by assisting with database migration Python-based data processing and building AWS data pipelines supporting applications using Amazon RDS and DynamoDB.

Responsible for supporting SQL Server/Cloud BAU operations. supports production stability and performance monitoring by building operational metrics and dashboards for database performance. Develop data quality and performance dashboards to monitor system efficiency and ensure reliable data for reporting and analytics.

The role requires hands-on experience in database migration data modeling and AWS data services.

Must Have Skills (Screening Required)

On-Prem SQL server to AWS and snowflake source Data Migration experience
1. Experience migration/archiving databases from on-premises environments to AWS
2. Experience with AWS Database Migration Service(DMS) or similar tools preferred
AWS Database Technologies

Strong experience with:

Amazon RDS
DynamoDB

Python for Data Processing
1. Experience developing Python scripts for data creation transformation and data loads
Data Pipeline Development
1. Experience building AWS-based data pipelines
2. Familiarity with services such as:

i. S3 Glue Lambda

Data Modeling
1. Experience designing logical and physical data models
2. Ability to support application teams with schema design

Preferred Skills

1. Experience with AWS Schema Conversion Tool (SCT)and data migration service (DMS)

2. Experience working with large datasets and ETL pipelines

3. Knowledge of data lake architecture

4. Experience with PostgreSQL SQL Server Dynamo Db

5. Experience supporting application data environments

Experience Required

5 years in Database Administration Data Engineering or similar role
3 years of AWS and Snowflake experience

Responsibilities

Support migration of on-prem databases to AWS
Develop Python scripts for data generation and bulk loads
Build and maintain AWS-based data pipelines
Design and support data models
Support application teams using RDS and DynamoDB
Assist with data validation migration testing and performance tuning

Key Skills & Experience

5 years of experience in On-Premise SQL Server to AWS and Snowflake data migration including large-scale source data transfers and validation.
5 years of experience migrating and archiving databases from on-premises environments to AWS cloud platforms.
5 years of experience using AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS) or similar migration tools for database modernization and migration projects.
5 years of experience developing Python scripts for data generation transformation automation and data loading processes.
5 years of experience building and managing AWS-based data pipelines using Amazon S3 AWS Glue and AWS Lambda.
5 years of experience supporting application data environments working with PostgreSQL SQL Server and DynamoDB databases.
5 years of hands-on experience working with AWS database services including Amazon S3 Amazon RDS PostgreSQL DynamoDB and Snowflake.
5 years of experience configuring data management and governance practices on AWS using services such as AWS Glue AWS DataZone AWS Glue Data Catalog and API Gateway.
5 years of experience working with version control and CI/CD tools including GitHub and AWS CodePipeline.
5 years of experience in Database Administration and Data Engineering specializing in AWS Snowflake and SQL Server environments.

About Us

At Radiant Digital we provide IT solutions and consulting services to help government agencies and businesses in the USA Canada the Middle East and Southeast Asia. On the federal side we support agencies like NASA the Department of State (DOS) the IRS ACL ACFUSDA and many others along with numerous state and local government agencies.

We work with industries like telecom healthcare entertainment oil and gas offering solutions designed to meet their specific needs. We focus on improving systems making better use of data and updating applications to keep up with changing markets.

Required Experience:

Job Description Job description: Title: Database Administrator / Data EngineerDuration: 3 months Location: Richmond VA USA Mode of work: Hybrid Mode of Interview: In personComplete Description:ABOUT THE ROLEWe are seeking a Database Administrator / Data Engineer with strong experience i...