Description Job Overview
We are seeking an experienced
SQL Database Administrator / Data Engineer to support a major
data platform modernization and cloud migration initiative. This role will focus on migrating
on-premises SQL Server databases to AWS, building data pipelines, and supporting modern cloud-based database environments.
The ideal candidate will have strong hands-on experience with
AWS database services, Python-based data processing, and data pipeline development. This individual will play a key role in ensuring
data reliability, performance monitoring, and scalable data architecture supporting enterprise applications.
This position requires a
hybrid work schedule, with
2-3 days onsite in Richmond, VA and additional onsite presence as requested by the manager.
WKey Responsibilities
- Support the migration of on-premises SQL Server databases to AWS and Snowflake environments
- Build and maintain AWS-based data pipelines
- Develop Python scripts for data generation, transformation, and bulk data loading
- Design and maintain logical and physical data models
- Support application teams using Amazon RDS and DynamoDB
- Assist with data validation, migration testing, and performance tuning
- Develop operational dashboards and monitoring metrics for database performance
- Ensure data quality, system efficiency, and reporting reliability
- Support BAU operations for SQL Server and cloud database environments
Requirements eRequired Qualifications
- 5+ years of experience in Database Administration, Data Engineering, or a related role
- 5+ years of experience migrating or archiving databases from on-prem environments to AWS
- Experience with AWS Database Migration Service (DMS) or similar migration tools
- Strong experience with AWS database technologies including:
- Amazon RDS
- DynamoDB
- S3
- Experience developing Python scripts for data processing, transformation, and loading
- Experience building AWS data pipelines using services such as:
- AWS Glue
- AWS Lambda
- Amazon S3
- Experience designing logical and physical data models
- Experience supporting application data environments
- Experience with PostgreSQL, SQL Server, DynamoDB, and Snowflake
- Hands-on experience configuring AWS data management services including:
- AWS Glue Data Catalog
- AWS DataZone
- API Gateway
- Familiarity with version control and CI/CD tools such as GitHub and AWS CodePipeline
Preferred Qualifications
- Experience using AWS Schema Conversion Tool (SCT)
- Experience working with large datasets and ETL pipelines
- Knowledge of data lake architecture
- Experience supporting enterprise-scale cloud migrations
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use and Privacy Notice.
Never miss an opportunity! Create an alert based on the job you applied for.