*Senior ETL/ELT & Cloud Database Engineer* (Local to Boston, MA Area) (Boston) Job at Jobs via Dice, Boston, MA

dmQyNDkrSUtVb0JuUjhFTXk1MEdBS2ht
  • Jobs via Dice
  • Boston, MA

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

#J-18808-Ljbffr

Job Tags

Full time, Contract work, Local area, Remote work,

Similar Jobs

SPECTRUM

Data Analyst Job at SPECTRUM

 ...Data Analyst at SPECTRUM summary: The Data Analyst role involves managing and analyzing data to support business decision-making by creating reports, forecasts, dashboards, and ad hoc analyses. The position requires integrating data from multiple sources, ensuring... 

Eliassen Group

Senior Oracle Pl/SQL Developer with ETl and Python (Hybrid/W2 Only) Job at Eliassen Group

 ...onsite at your own expense. We are looking for a Senior Pl/SQL Developer to support our client's capital markets area. Data is coming...  ...views using advanced features of Oracle 11g and 12c. Manage ETL processing with Python, Oracle, and Unix, including both batch... 

Merck & Co.

Principal Scientist - Biologics Potency, Cell Based Sciences, Analytical R&D Job at Merck & Co.

 ...Description The Analytical Research & Development, Cell Based Sciences in Rahway, NJ is seeking a motivated senior level scientist...  ...on cross-functional product development teams and effectively communicate with stakeholders in partner organization and to management and... 

badam

Arab Operations Job at badam

 ...sorting of Middle Eastern products, understanding player needs through user feedback and solving player problems;2. Responsible for Arabic translation and proofreading;3. Responsible for community operation and management of Middle Eastern products, including planning... 

VETERANS HEALTH ADMINISTRATION

Purchasing Agent Job at VETERANS HEALTH ADMINISTRATION

Summary The incumbent must work directly with the Veteran, his/her family, surgeon or clinical provider, and the community care service. Initiates procurement of all outpatients' medical requirements to include but not limited to direct individual purchases to the...