Accumulo Database Engineer SME

P3S CORPORATION; San Antonio (TX); On-site; USD 110,000 - 140,000; Full time

Job summary

P3S CORPORATION in San Antonio, Texas is looking for a Senior Accumulo Database Engineer to serve as the technical authority on Apache Accumulo for critical DoD systems. This role requires over 8 years of database administration experience, including expertise in Hadoop ecosystem technologies and classified environments.

The ideal candidate should possess strong skills in performance tuning and data architecture, with a Bachelor's degree in a related field. Join us to ensure the resilience and security of our large-scale data platforms.

Qualifications

• 8+ years of enterprise database administration or engineering experience.
• Experience supporting classified DoD or Intelligence Community environments.
• 3+ years of hands-on Apache Accumulo administration and engineering experience.

Responsibilities

• Administer and troubleshoot Accumulo architecture and operations.
• Design scalable Accumulo schemas and row-key strategies.
• Monitor and tune Accumulo cluster performance.

Skills

Apache Accumulo

Hadoop Ecosystem

HDFS

ZooKeeper

Data Modeling

Java

Linux Administration

PostgreSQL

MongoDB

Performance Tuning

Education

Bachelor's Degree in Computer Science or related field

Tools

Apache Accumulo

PostgreSQL

MongoDB

Job description

Senior Accumulo Database Engineer / Accumulo SME

Position Overview

P3S Corporation is seeking a highly skilled Senior Accumulo Database Engineer / Subject Matter Expert (SME) to support mission‑critical Department of Defense and Intelligence Community systems within a TS/SCI environment. This position serves as the technical authority for Apache Accumulo architecture, administration, optimization, security, and integration across large‑scale enterprise data platforms.

Education

• Bachelor's Degree in one of the following:
  • Computer Science
  • Information Systems
  • Software Engineering
  • Data Engineering
  • Computer Engineering
  • Related Technical Discipline
• Additional experience may substitute for education where permitted.

Experience

• 8+ years of enterprise database administration or engineering experience.
• 5+ years supporting Hadoop ecosystem technologies.
• 5+ years supporting distributed data platforms.
• 3+ years of hands‑on Apache Accumulo administration and engineering experience.
• Experience supporting classified DoD or Intelligence Community environments.

Required Technical Skills

• Apache Accumulo
• Hadoop Ecosystem
• HDFS
• ZooKeeper
• RFiles
• Tablet Architecture
• Major and Minor Compactions
• Write Ahead Logs (WAL)
• Data Modeling
• Java
• Linux Administration
• PostgreSQL
• MongoDB
• Security Hardening
• Backup & Recovery
• Performance Tuning

Desired Qualifications

• Preferred certifications:
  • CISSP
  • CISM
  • CASP+
  • Certified Hadoop Administrator
  • Cloudera Certification
  • MongoDB DBA Certification
  • PostgreSQL Certification
  • AWS Data Analytics Specialty
  • Certified Data Management Professional (CDMP)
• Preferred experience:
  • Intelligence Community data platforms
  • GEOINT, SIGINT, or Cyber Operations environments
  • Spark
  • NiFi
  • Elasticsearch
  • Kubernetes
  • Cloud‑hosted Big Data architectures

Essential Responsibilities

Apache Accumulo Administration & Engineering

Serve as the primary technical expert for Apache Accumulo architecture and operations.

• Design, deploy, configure, maintain, and optimize enterprise Accumulo clusters.
• Administer and troubleshoot:
  • Tablet Servers
  • Master Services
  • ZooKeeper
  • HDFS
  • Write‑Ahead Logs (WAL)
  • Metadata Tables
• Manage tablet assignment, balancing, compactions, and recovery operations.
• Develop operational procedures supporting cluster health and resiliency.

Data Architecture & Modeling

Design scalable Accumulo schemas and row‑key strategies.

• Optimize:
  • Scan performance
  • Load distribution
  • Hotspot avoidance
  • Data locality
• Implement:
  • Locality Groups
  • Bloom Filters
  • Time‑series partitioning strategies
  • High‑ingest architectures

Security & Data Governance

• Implement and manage Accumulo Cell‑Level Security.
• Design and administer:
  • Visibility Labels
  • Authorizations
  • Classification schemas
  • Access control policies
• Support compliance with:
  • RMF
  • NIST 800-53
  • DoD Cybersecurity Policies
  • Intelligence Community security requirements
• Maintain auditability, lineage tracking, and data retention controls.

Performance Optimization & Troubleshooting

• Monitor and tune Accumulo cluster performance.
• Analyze:
  • Tablet distribution
  • Cache utilization
  • Garbage Collection activity
  • Compaction queues
  • WAL performance
  • HDFS health
• Resolve performance bottlenecks impacting ingestion, querying, and storage.
• Develop monitoring dashboards and performance baselines.

Bulk Ingest & Data Pipelines

• Design and support high‑volume data ingestion architectures.
• Implement:
  • Bulk Imports
  • RFiles
  • MapReduce Jobs
  • Hadoop Workflows
  • Spark Pipelines
• Develop validation strategies ensuring data integrity and consistency.
• Optimize ingest throughput while minimizing impact to query performance.

Iterator Development

• Design, implement, and maintain custom Accumulo iterators.
• Develop:
  • Aggregation Iterators
  • Filtering Iterators
  • Age‑Off Iterators
  • Combiners
• Evaluate server‑side versus client‑side processing approaches.
• Optimize iterator stack performance.

Database Administration

• Manage enterprise databases including:
  • Apache Accumulo
  • PostgreSQL
  • MongoDB
• Implement backup and recovery strategies.
• Support disaster recovery planning and execution.
• Maintain high availability and system reliability.

System Integration

• Collaborate with software development teams utilizing:
  • Java
  • Spring Framework
  • REST APIs
  • Big Data Platforms
• Support enterprise application integration and data services.

Operations & Lifecycle Management

• Perform upgrades and migrations for:
  • Accumulo
  • Hadoop
  • ZooKeeper
  • HDFS
• Develop rolling upgrade strategies minimizing operational downtime.
• Create technical documentation, SOPs, architecture diagrams, and operational runbooks.

Our organization provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, marital status, veteran status, sexual orientation, gender identity, or genetics.