Job Title: SQL Database Administrator / Data Engineer
Location: Richmond, Virginia
Duration: 6 Months Contract
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