SQL Database Administrator (State exp must)

Role: SQL Database Administrator / AWS Migration

Location: 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

Required/Desired Skills

Skill	Required/Desired	Amount	of Experience
On-Prem SQL server to AWS and snowflake source Data Migration experience	Required	5.0	Years
Experience migration/archiving databases from on-premises environments to AWS	Required	5.0	Years
Experience with Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS) or similar tools preferred	Required	5.0	Years
Experience developing Python scripts for data creation transformation and data loads	Required	5.0	Years
Experience building AWS-based data pipelines using s3 Glue Lambda	Required	5.0	Years
Experience supporting application data environments Experience with PostgreSQL SQL Server Dynamo Db	Required	5.0	Years
Hands on experience in using AWS db services including S3 RDS postgres DynamoDB and Snowflake.	Required	5.0	Years
Core experience of configure data management practices on AWS using native services such as AWS Glue AWS Data Zone AWS Glue Data CatalogAPI Gateway	Required	5.0	Years
Familiarity with version control using tools like Github and AWS Code Pipeline	Required	5.0	Years
5 years in Database Administration Data Engineering or similar role (AWS Snowflake) and Sql server	Required	5.0	Years

Required Skills:

On-Prem SQL server to AWS and snowflake source Data Migration experienceExperience migration/archiving databases from on-premises environments to AWSExperience with Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS) or similar tools preferredExperience developing Python scripts for data creationtransformationand data loadsExperience building AWS-based data pipelines using s3GlueLambdaExperience supporting application data environmentsExperience with PostgreSQLSQL ServerDynamo DbHands on experience in using AWS db services including S3RDSpostgresDynamoDBand experience of configure data management practices on AWS using native services such as AWS GlueAWS Data ZoneAWS Glue Data CatalogAPI GatewayFamiliarity with version control using tools like Githuband AWS Code Pipeline5 years in Database AdministrationData Engineeringor similar role (AWSSnowflake) and Sql server