Database Administrator / Data Engineer – AWS Migration

Mbi Llc; Richmond (VA); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology consulting firm in Richmond, Virginia, is seeking a Database Administrator / Data Engineer. The ideal candidate will have over 5 years of experience in database administration and data engineering, with a strong focus on migrating databases to AWS. Responsibilities include building AWS data pipelines and developing Python scripts for data processing. This role involves ensuring production stability and building dashboards for performance monitoring.

Qualifications

• 5+ years in Database Administration, Data Engineering, or a similar role.
• 3+ years of AWS and Snowflake experience.
• Experience with large datasets and ETL pipelines.

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.

Skills

On-Prem SQL Server to AWS and Snowflake source Data Migration experience

Experience migrating/archiving databases from on-premises environments to AWS

Experience with AWS Database Migration Service (DMS)

Python for Data Processing

Building AWS-based data pipelines

Data Modeling

Tools

AWS

Snowflake

Amazon RDS

DynamoDB

Python

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

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

Experience & Requirements

Experience Required

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

Must Have Skills (Screening Required)

• On-Prem SQL Server to AWS and Snowflake source Data Migration experience
• Experience migrating/archiving databases from on-premises environments to AWS
• Experience with AWS Database Migration Service (DMS) or similar tools
• AWS Database Technologies
• Amazon RDS
• DynamoDB
• Python for Data Processing
• Experience developing Python scripts for data creation, transformation, and data loads
• Experience building AWS-based data pipelines
• Familiarity with S3, Glue, Lambda
• Data Modeling – experience designing logical and physical data models
• Ability to support application teams with schema design

Preferred Skills

• Experience with AWS Schema Conversion Tool (SCT) and AWS DMS
• Experience working with large datasets and ETL pipelines
• Knowledge of data lake architecture
• Experience with PostgreSQL, SQL Server, DynamoDB
• Hands-on experience using AWS db services including S3, RDS, PostgreSQL, DynamoDB, and Snowflake
• Core experience in configuring data management practices on AWS using native services such as AWS Glue, AWS Data Catalog, API Gateway
• Familiarity with version control using tools like GitHub and AWS CodePipeline

Fields with * are required.

What is your full name?

How can we contact you?

Where are you located?

What is your preferred method of communication?

File Upload: (only PDF, DOC, DOCX are accepted)