Senior Cloud DBA-ETL-ELT Data Pipeline Engineer

RESPONSIBILITIES:
Kforce has a client in Boston, MA that is in need of a Senior Cloud DBA-ETL-ELT Data Pipeline Engineer.

Responsibilities:
* Manage cloud-native databases and services (RDS Oracle, Aurora, Postgres, Snowflake)
* Optimize query execution, compute scaling, and storage performance
* Define snapshot, PITR, and cross-region replication policies
* Implement encryption, access controls, masking, and auditing for FERPA/PII compliance
* Oversee schema migrations, data pipelines, and versioned deployments
* Migrate legacy SSIS ETL to a SQL-based solution using Apache Airflow for scheduling and dependencies
* Re-engineer solution approach, develop code packages, fix bugs, test, and manage GitHub repository
* Design and implement Apache Airflow scheduling and dependency framework
* Tune performance and benchmark against on-prem solution
* Use Jira for task tracking and GitHub for code management, reviews, and pull requests

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
* Advanced SQL coding skills and ability to translate Oracle PL SQL and Stored Procedure code to alternative SQL platforms such as Snowflake
* Familiarity with data warehouse and data mart concepts such as normalization, facts, dimensions, slowly changing dimensions
* Familiarity with Change Data Capture (CDC) concepts and implementations
* Understanding of common file formats such as JSON, XML, CSV
* Basic experience using scripting tools to automate tasks (e.g.: Python, Windows PowerShell, bash)
* Ability to write unit test scripts and be able to validate migrated ELT/ETL code

The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.

We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.

Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.

This job is not eligible for bonuses, incentives or commissions.

Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.