Senior data engineer (aws / postgresql / migration)

job summary: We are seeking a highly skilled Senior Data Engineer for an onsite role in Columbus, OH. In this role, you will lead complex data engineering and migration efforts, modernizing database infrastructures from legacy SQL Server environments to AWS Aurora PostgreSQL while engineering robust, enterprise-grade data pipelines. location: Columbus, Ohio job type: Contract salary: $40 - 45 per hour work hours: 8am to 5pm education: Bachelors responsibilities: Analyze legacy SQL Server schemas, T-SQL code, views, and stored procedures to design comprehensive PostgreSQL migration strategies. Convert and optimize T-SQL database objects for Amazon Aurora PostgreSQL, resolving compatibility gaps and tuning performance. Design, build, and maintain production ETL/ELT pipelines using AWS Glue, Python (Boto3), and Apache Airflow. Execute schema conversion, data migration, data validation, testing, and production cutovers. Provide troubleshooting and performance stabilization support post-cutover. qualifications:

REQUIRED QUALIFICATIONS

Bachelor's or Master's degree in Computer Science or a related field. 10+ years of hands-on data engineering experience. Deep technical expertise in Amazon Aurora PostgreSQL and PostgreSQL database architecture (indexing, execution plan analysis, partitioning, tuning). Extensive experience converting and optimizing Microsoft SQL Server (T-SQL) workloads to PostgreSQL. Proven track record building enterprise data pipelines using AWS Glue, Python, and Apache Airflow in cloud environments. Ability to work 100% onsite in Columbus, OH.

PREFERRED QUALIFICATIONS

Experience with AWS Schema Conversion Tool (SCT) and Amazon MWAA. Hands-on knowledge of PySpark, AWS Lambda, CI/CD pipelines, and Infrastructure as Code (Terraform or CloudFormation). Familiarity with enterprise AI coding tools such as GitHub Copilot. skills: AWS Aurora,AWS Glue,AWS Lambda,Apache Airflow,S3,AWS cloud environments,AWS,AWS cloud,Boto3,CloudFormation,CloudWatch,CI/CD pipelines,data architecture,data migration,data pipelines,ELT pipelines,data processing,SQL development,database migration,database migrations,database monitoring,database performance,database,DAGs,ETL,GitHub Copilot,observability tools,IAM,indexing,Infrastructure as Code (IaC) tools,Data Catalogs,Microsoft SQL Server,SQL Server,PostgreSQL,PySpark,Python,Python development,query optimization,query performance,stored procedures,production deployments,Terraform,T-SQL,strong analytical capabilities,Troubleshoot,pipeline design,architecture,AI coding,automation,data reconciliation,statistics,testing,data workflows,Workflows Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact View email address on click.appcast.io. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility). This posting is open for thirty (30) days. Randstad