Position: SQL Database Administrator
Location: Richmond, VA (Hybrid) weekly 2/3 days at client location
Duration: 3+ Months contract
Client: State Of VA
Note: Need only local s to Virginia (who can provide D/L copy of VA)
Interview: Both Web Cam and In Person Interview
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
o Experience migration/archiving databases from on-premises environments to AWS
o Experience with AWS Database Migration Service(DMS) or similar tools preferred
AWS Database Technologies
o Strong experience with:
o Amazon RDS
o DynamoDB
Python for Data Processing
o Experience developing Python scripts for data creation, transformation, and data loads
Data Pipeline Development
o Experience building AWS-based data pipelines
o Familiarity with services such as:
o S3, Glue, Lambda
Data Modeling
o Experience designing logical and physical data models
o 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
Never miss an opportunity! Create an alert based on the job you applied for.
