Job Description

Senior Cloud DBA / ETLELT Data Pipeline Engineer

Location: Boston, MA (Remote)

Duration: 12+ Months (Contract)

The organization is seeking a Cloud DBA/ETL Engineer to support the maintenance, modernization, optimization, and troubleshooting of cloud-based data warehouses, data marts, and enterprise data platforms. The role involves managing cloudnative databases and data services to ensure performance, security, high availability, and compliance with governance standards.

Key Responsibilities

• Manage and optimize cloud databases such as RDS Oracle, Aurora, Postgres, and Snowflake.
• Monitor query performance, compute scaling, storage usage, and system reliability.
• Implement backup policies, PITR, crossregion replication, encryption, access controls, and auditing.
• Lead schema migrations, data pipeline development, and versioned deployments.
• Reengineer and migrate legacy SSIS ETL code to SQLbased solutions orchestrated via Apache Airflow.
• Develop Airflow DAGs, scheduling frameworks, and dependency management structures.
• Conduct performance tuning, benchmarking, troubleshooting, and code unit testing.
• Use GitHub for code management and Jira for task tracking.

Required Skills

• Experience with Oracle RDS and AWS services (S3, MWAA, DMS).
• Strong SQL and PL/SQL translation skills across platforms (e.g., Snowflake).
• Knowledge of data warehousing concepts (facts, dimensions, SCDs) and CDC frameworks.
• Familiarity with file formats (JSON, XML, CSV) and scripting (Python, PowerShell, Bash).

Preferred

• Experience with Airflow configuration and advanced Snowflake features.
• Background in large organizations or government environments.
• Education data domain knowledge.

How to Apply

Interested candidates can apply with their detailed Wordformatted resume along with contact information or availability to raj (dot) sekhar (at) kellton (dot) com. Phone 703592.951.7

Job Tags

Similar Jobs