Senior PostgreSQL Database Engineer - Active TS/SCI required

Posted Yesterday
Be an Early Applicant
Washington, DC, USA
Hybrid
200K-225K Annually
Senior level
Artificial Intelligence • Software • Consulting
The Role
Lead the architecture, engineering, administration, modernization, and migration of PostgreSQL and Oracle database ecosystems supporting high-volume Multi-INT data fusion and tracking. Develop spatial and spatiotemporal data models, ingestion and archiving systems, cloud integrations, web services, algorithms, and UI data services. Support hybrid infrastructure, performance optimization, security, operations, systems assessments, configuration management, documentation, and operator training.
Summary Generated by Built In

Riptide Technology is seeking a Senior Database Design Engineer (Level V) to support cutting-edge Research and Development (R&D), Data Analysis, and Cloud Migration initiatives in a hybrid role at the  Naval Research Laboratory (NRL) in Washington, D.C.

This Subject Matter Expert (SME) will lead the design, implementation, and operations of high-performance database infrastructures—spanning PostgreSQL and Oracle Enterprise RDBMS—to support critical, ongoing programs within the Naval Center for Spacecraft Technology (NCST). This dual-database architecture handles massive volumes of multi-source event data, supports data fusion, and is actively transitioning toward modern Cloud architectures.

We are seeking a seasoned Database Design Engineer and Architect who possesses full-spectrum software development capabilities. While you must understand traditional database administration, your primary focus is engineering future-state data models, designing tracking algorithms, managing data migration strategies, and deploying resilient cloud/on-premise database ecosystems.

Core Responsibilities:

  • Database Architecture, Administration, & Modernization

    • Oracle Enterprise Management: Implement, manage, and tune Oracle Enterprise Edition RDBMS (including Oracle 12c, SQL Developer, and 12c Cloud Console). Expertly install Oracle Enterprise Linux, Oracle software, and manage workloads across bare metal servers, Real Application Clusters (RAC), and Exadata servers.
    • Advanced Oracle Security & Optimization: Configure and utilize advanced native Oracle features including Oracle Label Security, Real Application Clusters (RAC), and Oracle Partitioning options via complex SQL programming.
    • Database Migration & Planning: Research, engineer, and establish transition paths for shifting legacy Oracle RDBMS data stores to the IC and DoD Cloud data layers. Support data engineering by defining and implementing complex object models (e.g., Unified Object Model, Generalized Entity Model) within cloud environments.
    • Infrastructure & OS Management: Support a hybrid suite of virtualized systems and bare metal servers running Red Hat Linux, Oracle Enterprise Linux (OEL), Community Enterprise OS (CentOS), and limited Windows environments.
    • 2. Algorithm Development, Data Fusion, & Tracking

      • Multi-INT & Geolocation Tracking: Develop, modify, and enhance data fusion and geographic tracking algorithms for multiple situational awareness data types (GEOINT, SIGINT, OSINT). Optimize track correlation, tracker algorithm performance, and database-level alerting/alarming capabilities.
      • Algorithm Review & Long-Term Trending: Perform continuous algorithm analysis, performance measurement, and long-term trending while data remains active. Detect, document, and report anomalies to the Government lead.
      • Data Tagging & Characterization: Research and develop automated electronic emission pattern data tagging methodologies.
      • 3. Data Ingestion, Archiving, & Cloud Integration

        • Cloud & Web Architecture: Build and maintain system architectures hosting maritime data feeds, schedule information, and web extractor software across hardware suites, IC/DoD Clouds, or commercial Government clouds such as Amazon Web Services (AWS). Lead systems engineering efforts for transitioning existing capabilities into evolving cloud ecosystems.
        • Data Archiving & Query Web Services: Implement long-term online data archives capable of indexing multi-domain positions (maritime, airborne, land, space) and metadata. Integrate Open Source Schedule data and build queryable web services to retrieve historical archives.
        • Operations & Maintenance: Provide Echelon 2 Operations and Maintenance (O&M) support for existing tactical and strategic data feeds.
        • 4. UI/Widget Integration & Object Production (OBP)

          • Widget Suite Prototyping: Design and engineer user interface prototypes and underlying data access web services to integrate analysis capabilities within the Ozone Widget Framework (OWF) or equivalent presentation frameworks.
          • Object Management as a Service / OMAAS: Implement an Object-Based Production approach that delivers aggregated real-world object profiles (vessels, airplanes, facilities) in a collaborative regional/worldwide service framework. Develop advanced object aggregation algorithms to support R&D.
          • 5. Systems Engineering & Lifecycle Support

            • Systems Assessment: Perform technical and engineering data analyses on system functionality, survivability, and performance to solve critical design deficiencies. Run short-term engineering analyses and quick-reaction studies.
            • Documentation & Training: Prepare training documentation and instruct operators on data analysis products, supporting program deliveries, demonstrations, and high-level customer presentations.
            • Configuration Management: Participate in system capability reviews, modify existing application codebases, and maintain rigorous baseline control by archiving all software modifications in a CM database.
            • Infrastructure Upkeep: Support and enhance network technology implementations, handle routine equipment maintenance, manage system access via account creation scripts, and connect with Local/Wide Area Networks utilizing thin-client architectures.

Required Qualifications:

  • Education: Minimum B.S. Degree in Mathematics, Engineering, or Computer Science.
  • Certifications: required to meet DoD 8570/8140 Information Assurance Technical (IAT) Level II requirements 
  • Software Development Methodologies: 12+ years of experience applying software development methodologies and practices, including traditional structured programming as well as object-oriented programming techniques and broad utilization of current software development tools within numerous environments.
  • Relational Database Engineering: 12+ years of experience with relational database planning, design, development, testing, installation, and maintenance of complex technical software systems (PostgreSQL, Oracle, SQL Server, Sybase).
  • Spatial Database Architecture: 4+ years of strong proficiency in spatial databases, specifically PostGIS, or equivalent relational spatial extensions (e.g., Oracle Spatial, MS SQL Spatial, SpatiaLite).
  • Engineering Breadth: Database engineers must possess the full spectrum of skills required for the development of complex software systems. This includes experience in all aspects of software development supporting complex Multi-INT processing from initial planning and design to final installation and maintenance.
  • Enterprise Computing & Design: Enterprise computing and architecture design capability for ground-based analysis systems, to include system information modeling and database design.
  • System Integration: Ability to incorporate system architecture using enterprise design, business process modeling (BPM), workflow implementation, and web-based/semantics-based development methodologies.
  • Multi-Modal Data Fusion: Proven experience designing and implementing scalable databases to ingest, integrate, and synthesize highly disparate, multi-source data feeds / Multi-INT fusion products (structured data streams, high-volume ingestion, raw telemetry, and imagery) to deliver mission-critical insights to tactical field operators and end-users in low-latency environments.
  • Mission Domain Knowledge: Leverage knowledge of terrestrial and space surveillance methodologies, sensor technologies and capabilities, and the ability to envision new modes of operation via an evolutionary development process.
  • SDLC Consultation: Experience in producing technical and user documentation, training and system orientation, and consulting with related development teams throughout the software development life cycle.
  • Security Clearance:  This position requires US Citizenship and and active DoD Top Secret/SCI clearance

Equivalent Spatial Technologies Reference

  • Candidates who possess 4+ years of experience in any of the following alternative spatial environments are highly encouraged to apply and will be considered equivalent:

    • Cloud Data Warehouses: Google BigQuery GIS, Amazon Redshift Spatial, Snowflake Geospatial
    • Relational Alternatives: Oracle Spatial & Graph, Microsoft SQL Server Spatial, MySQL Spatial
    • NoSQL / Search Spatial: Elasticsearch (Geo-shape/Geo-point), MongoDB Geospatial
    • Big Data Frameworks: Apache Sedona (GeoSpark), GeoMesa, Databricks Mosaic

Desired Qualifications:

  • Experience & Certifications: 5+ years of hands-on PostgreSQL administration or development experience. A PostgreSQL Professional Certification (or AWS/Azure Cloud Database Certification) is a strong plus, but equivalent production experience is highly valued.
  • Team Collaboration: Proven track record collaborating within multi-disciplinary engineering environments, interfacing effectively with infrastructure, security, application development, functional leads, and product/operational managers.
  • Distributed Architectures: Experience designing, deploying, and managing multi-node PostgreSQL clusters, high-availability (HA) setups, and cloud-based PostgreSQL configurations (e.g., AWS RDS/Aurora, Azure Cosmos DB for PostgreSQL).
  • High-Scale Data Processing: Expertise handling large-scale, high-velocity datasets, specifically spatiotemporal (geo-spatial) architectures, large time-series datasets, and streaming event logs.
  • Massive Data Ingestion: Mastery of high-volume bulk loading, parallel data ingestion techniques, and ETL/ELT optimization strategies.
  • Advanced Data Security: Deep understanding of enterprise security models, including Role-Based Access Control (RBAC), Row-Level Security (RLS), multi-level secure access controls, and data security labeling/classification schemas.
  • Performance Engineering: Strong skills in database performance tuning, query optimization, and profiling using tools such as pgBench, EXPLAIN ANALYZE, Dynatrace, or native PostgreSQL statistics.

Riptide Technology, Inc. is an equal opportunity employer ensuring no employee or prospective employee will be discriminated against based on race, color, national origin, age, religion, disability status, gender, sexual orientation, gender identity, genetic information or marital status with regards to recruitment, hiring, upgrading, promotion or rehiring.

Skills Required

  • Bachelor of Science degree in Mathematics, Engineering, or Computer Science
  • DoD 8570/8140 Information Assurance Technical Level II certification requirements
  • 12 or more years applying software development methodologies, structured programming, object-oriented programming, and software development tools
  • 12 or more years of relational database planning, design, development, testing, installation, and maintenance
  • Experience with PostgreSQL, Oracle, SQL Server, and Sybase
  • 4 or more years of experience with spatial databases, including PostGIS or equivalent spatial extensions
  • Experience developing complex software systems supporting Multi-INT processing across the full software development lifecycle
  • Enterprise computing, system information modeling, and database architecture design experience
  • Experience with enterprise architecture, business process modeling, workflow implementation, and web- or semantics-based development
  • Experience designing scalable databases for disparate, high-volume, multi-source data feeds and data fusion
  • Knowledge of terrestrial and space surveillance methodologies, sensor technologies, and capabilities
  • Experience producing technical and user documentation, delivering training, and consulting with development teams
  • U.S. citizenship
  • Active DoD Top Secret/SCI security clearance
  • 5 or more years of hands-on PostgreSQL administration or development experience
  • PostgreSQL Professional Certification or AWS/Azure Cloud Database Certification
  • Experience collaborating with infrastructure, security, application development, functional, and operations teams
  • Experience designing and managing multi-node PostgreSQL clusters, high-availability systems, and cloud PostgreSQL configurations
  • Experience with large-scale spatiotemporal, time-series, and streaming event datasets
  • Expertise in bulk loading, parallel ingestion, and ETL/ELT optimization
  • Knowledge of RBAC, row-level security, multi-level secure access controls, and data security labeling
  • Database performance tuning and query optimization using PostgreSQL profiling tools
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Oviedo, FL
13 Employees
Year Founded: 2011

What We Do

Riptide Technology is a professional IT services company specializing in systems architecture, solutions research and software development. Riptide’s primary functional expertise is in Maritime ISR systems. Riptide Technology was incorporated and officially opened for business in May 2011. Riptide has established an office in Old Town Alexandria. Our contact information is: 201 King Street, #304 Alexandria, Virginia 22314 Phone: (703)888-2711 Fax: (703)888-2933

Similar Jobs

Hilton Logo Hilton

Senior Manager, Property Services Sourcing

Events • Food • Travel • Hospitality • Hotels & Resorts
In-Office or Remote
2 Locations
500000 Employees
110K-160K Annually

DraftKings Logo DraftKings

Financial Crimes Compliance Specialist, Predictions

Digital Media • Gaming • Information Technology • Software • Sports • Esports • Big Data Analytics
Remote or Hybrid
United States
6400 Employees
76K-95K Annually
Hybrid
Washington, DC, USA
289097 Employees

Ericsson Logo Ericsson

Data Center Technician II

Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
In-Office
Washington, DC, USA
88000 Employees
58K-76K Annually

Similar Companies Hiring

Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account