Cloud Database Administrator (DBA) / ETL Engineer

Cloud Data Engineer

100% Remote

Contract : Goes until 6 / 30 anticipated to renew each fiscal year

Hours : 37.5hrs a week (7.5hrs daily)

In alignment with state-level technology modernization initiatives, the Education Technology Office has undertaken a multi-year application and platform modernization project. The IT team is seeking a Cloud Database Administrator (DBA) / ETL Engineer to assist in maintaining, optimizing, modernizing, and troubleshooting the organization’s data warehouse, data mart, and overall data portfolio. Under the direction of senior leadership and data engineering team leads, the DBA / ETL / ELT Engineer will manage databases and data services hosted on cloud platforms, ensuring they are secure, performant, highly available, and compliant with governance policies.

The Engineer will be hands-on working with a team of cloud Engineers, ETL developers, technical leads, DBAs, project managers and analysts to design and implement the Education portfolio data, data pipelines, and transformations in a more stream-lined, scalable and cost-effective set of solutions.

Mandatory requirements

• Experience working with Oracle RDS
• Experience working with one or more AWS Cloud services such as S3 storage, Managed Airflow (MWAA),      Data Migration Service (DMS) in support of building data pipelines
• Experience working with a variety of backend data sources (e.g. SQL Server, Oracle, Postgres, DynamoDB,

Snowflake)

changing dimensions

replication tools is a plus

Preferred

for managing dependent graphs and complex steps

Regular responsibilities include :

ETL code to a SQL based solution with Apache Airflow for scheduling and dependency management.

fixing, unit testing code and using GitHub code repository

solution to ensure that it performs comparably or better

This is a remote position.