AWS Data Engineer/ Administrator

Position Description:
DBHDS - DBA

Duration: Currently, until July 31 but with possibility of extension if needed
ON SITE: 2-3 days a week ON SITE and then as requested by Mgr.

*Deadline to submit: by 4 pm est on Wed., 3/18

Duration: Currently, until July 31 but with possibility of extension if needed
ON SITE: 2-3 days a week ON SITE and then as requested by Mgr.
Parking not provided for contractors

*Deadline to submit: by 4 pm est on Wed., 3/18

Role: Database Administrator / Data Engineer – AWS Migration

US- Richmond/VA

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)

      1.    On-Prem SQL server to AWS and snowflake source Data Migration experience

      •     Experience migration/archiving databases from on-premises environments to AWS

      •     Experience with AWS Database Migration Service(DMS) or similar tools preferred

      2.    AWS Database Technologies

      •     Strong experience with:

      •     Amazon RDS

      •     DynamoDB

      3.    Python for Data Processing

      •     Experience developing Python scripts for data creation, transformation, and data loads

      4.    Data Pipeline Development

      •     Experience building AWS-based data pipelines

      •     Familiarity with services such as:

      •     S3, Glue, Lambda

      5.    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 data migration service (DMS)

      •     Experience working with large datasets and ETL pipelines

      •     Knowledge of data lake architecture

      •     Experience with PostgreSQL, SQL Server, Dynamo Db

      •     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

Skills Table:
Skill
Required / Desired
Amount
of Experience
On-Prem SQL server to AWS and snowflake source Data Migration experience
Required
5
Years

Experience migration/archiving databases from on-premises environments to AWS
Required
5
Years

Experience with Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS) or similar tools preferred
Required
5
Years

Experience developing Python scripts for data creation, transformation, and data loads
Required
5
Years

Experience building AWS-based data pipelines using s3, Glue, Lambda
Required
5
Years

Experience supporting application data environments, Experience with PostgreSQL, SQL Server, Dynamo Db
Required
5
Years

Hands on experience in using AWS db services including S3, RDS, postgres, DynamoDB, and Snowflake.
Required
5
Years

Core experience of configure data management practices on AWS using native services such as AWS Glue, AWS Data Zone, AWS Glue Data Catalog,API Gateway
Required
5
Years

Familiarity with version control using tools like Github, and AWS Code Pipeline
Required
5
Years

5+ years in Database Administration, Data Engineering, or similar role (AWS, Snowflake) and Sql server
Required
5
Years

Question 
In what city and state does your candidate permanently reside? Local Richmond candidates preferred bc of on site requirements. If your candidate is local to Richmond, have you (vendor) taken the necessary steps to verify this residency? No need to upload DL, just confirm by answering the quesiton.

Question 
Pls note: Mgr will conduct initial Web based IVs but reserves the right to bring in selected candidates for a follow up IN PERSON interview if they deem necessary. Does your candidate agree to this arrangement?

Question 
If selected, role requires 2-3 days ON SITE each week. Add''l days maybe requested as needed. If selected, does your candidate agree to this arrangement?