Database Administrator

J5 Consulting; Tysons (VA); On-site; USD 75,000 - 110,000; Full time

Benefits offered by this job

100% employer‑paid health coverage

6% 401(k) match

PTO

tuition reimbursement

bonuses

professional development

Job summary

J5 Consulting in Tysons, Virginia is seeking a qualified candidate for operations and maintenance of travel data applications. The role requires strong skills in Python, data pipeline management, and AWS cloud computing. Applicants must have US Citizenship and an active Top Secret Security Clearance. The position offers comprehensive benefits including 100% employer-paid health coverage, a 6% 401(k) match, and tuition reimbursement.

Qualifications

• Demonstrated experience in building and managing data pipelines.
• Demonstrated experience with cloud computing using AWS services.
• Demonstrated experience analyzing data in different formats (CSV, XML, JSON, etc.).

Responsibilities

• Provide operations and maintenance for existing applications.
• Support travel data applications and their backend environment.
• Develop travel data ETL pipelines.

Skills

Data pipeline management

Python

AWS cloud computing

Apache Spark

SQL querying

Linux and shell scripting

Data analysis (CSV, XML, JSON, Avro, Parquet)

Unit testing

Tools

NiFi

Apache Airflow

Java

Scala

Job description

Introduction

The Sponsor requires a team to provide operations and maintenance as well as new development work for existing applications. The Sponsor's office is a central data processor and applications developer for applications that utilize travel data. The Sponsor aims to establish support to travel data applications and the associated backend environment while that travel data undergoes a transition period and is ingested into new environments and user applications. As these travel applications analytic capabilities continue to be absorbed, this team will need to provide ongoing support and development to travel data models and travel data ETL pipelines.

Required Skills and Demonstrated Experience

• Demonstrated experience building and managing data pipelines.
• Demonstrated experience with Python.
• Demonstrated experience with cloud computing using AWS services.
• Demonstrated experience processing data using Apache Spark.
• Demonstrated experience with an RDBMS (Relational Database Management System) such as Postgres, Oracle, or MySQL and writing SQL queries.
• Demonstrated experience with Linux and shell scripting.
• Demonstrated experience analyzing data in different file formats such as CSV, XML, JSON, Avro, and Parquet.
• Demonstrated experience writing and validating unit tests.

Highly Desired Skills and Demonstrated Experience

• Demonstrated experience in NiFi, Apache Airflow, or equivalent orchestration tools for data pipelines.
• Demonstrated experience with Java or Scala.
• Demonstrated experience administering an EMR/Spark cluster.
• Demonstrated experience conducting performance tuning of Spark jobs.
• Demonstrated experience supporting Hive, Iceberg, or similar SQL access technologies.
• Demonstrated experience developing cloud-based security solutions.
• Demonstrated experience following configuration management processes to review and deploy code as part of releases.

US Citizenship

• This position requires US Citizenship. Verification of US Citizenship to meet federal government security requirements will be confirmed.

Security Clearance

• The successful candidate must have an active U.S. Government Top Secret Security Clearance with a Full Scope Polygraph.
• Clearance Verification: This position requires successful verification of the stated security clearance to meet federal government customer requirements. You will be asked to provide clearance verification information prior to an offer of employment.

Travel

• This position is expected to be onsite. The position will be located within the Washington Metropolitan Area (WMA). Local travel/POV will be on an as needed basis, within the local place of performance.

Benefits

Enjoy comprehensive benefits, including:

• 100% employer‑paid health coverage
• a 6% 401(k) match
• PTO
• tuition reimbursement
• bonuses
• professional development, and more.