SQL Database Administrator

Role Overview
The client is seeking a Database Administrator / Data Engineer to support modernization of the data platform through migration of on-premises databases to AWS. The role involves database migration, Python-based data processing, and development of AWS data pipelines supporting applications using Amazon RDS and DynamoDB. The position also supports database performance monitoring, operational stability, and data quality reporting.

Key Responsibilities
Support migration of on-premises databases to AWS environments
Develop Python scripts for data generation, transformation, and bulk data loads
Build and maintain AWS-based data pipelines
Design and support logical and physical data models for application teams
Support applications using Amazon RDS and DynamoDB
Monitor database performance and develop operational metrics and dashboards
Perform data validation, migration testing, and performance tuning
Support database operations and production stability

Required Skills
Database Administration / Data Engineering 5+ years
AWS Cloud Technologies 3+ years
Snowflake 3+ years
SQL Server database administration and migration
On-premises to AWS database migration
Amazon RDS
DynamoDB
Python for data processing and automation
AWS data pipeline development
AWS services (S3, Glue, Lambda)
Data modeling (logical and physical schema design)

Preferred Skills
Experience with AWS Schema Conversion Tool (SCT)
Experience with AWS Database Migration Service (DMS)
Experience working with large datasets and ETL pipelines
Knowledge of data lake architecture
Experience with PostgreSQL, SQL Server, and DynamoDB
Experience supporting application data environments