Journeyman Database Architect Jobs

Spyros Information And Technology Consulting - Columbia, MD

Full-time

Columbia, MD

Professional, Scientific, and Technical Services

About the position

The position involves designing strategies for enterprise database systems while establishing standards for operations, programming, and security. The successful candidate will be responsible for constructing large relational databases and integrating new systems with the existing warehouse structure to enhance system performance and functionality. A key aspect of the role is to demonstrate applicable knowledge or experience in a technical field, particularly in cybersecurity, SIGINT, systems engineering, telecommunications, data management, data processing, and data engineering. The role also requires implementing registry updates and configuring Niagara Files (NiFi) processor/processor groups. Additionally, the candidate will be tasked with routing, transforming, and enriching ad-hoc dataflows, managing NiFi clusters, and reverse engineering customer dataflows to troubleshoot issues effectively. Responding to customer inquiries and advising them on strategies to transport, store, and manage data is also a critical part of the job. Compliance with data governance, data security, and compliance policies is essential to ensure efficient operations within the organization.

Responsibilities

• Design strategies for enterprise database systems and set standards for operations, programming, and security.
• Design and construct large relational databases.
• Integrate new systems with existing warehouse structure and refine system performance and functionality.
• Implement registry updates.
• Configure Niagara Files (NiFi) processor/processor groups.
• Route, transform and enrich ad-hoc dataflows; Manage NiFi clusters.
• Reverse Engineer customer dataflows and troubleshoot.
• Respond to customer inquiries.
• Advise customers on strategies to transport, store and manage data.
• Comply with data governance, data security and compliance policies more efficiently.

Requirements

• Must possess current Counterintelligence Polygraph and Top Secret clearance with SCI eligibility.
• Must possess minimum five (5) years of experience with data flow/management plus minimum 5 years in IT systems engineering and/or administration.
• Must possess at least bachelor's degree in a technical discipline.
• Must possess any of the following qualifying DoD 8570 IAT Level II certifications: CCNA Security, CySA+, GICSP, GSEC, Security+ CE, CND, or SSCP.

Nice-to-haves

• Experience with Kibana and Elasticsearch (ELK stack).
• Writing Bash/Python scripts to automate routine tasks.
• Proficiency in modern programming languages such as Python or Java.
• Understanding of the analytical and data point challenges across the J-Codes.
• Using Ubuntu Linux or CentOS to ssh, navigate, move files, find/filter file contents, and troubleshoot application logs.
• Understanding of Nifi flow file attributes, dataflow processes, and system-to-system connections.
• Familiarity with FileZilla and Pressurewave.
• Knowledge of data formats such as XML, JSON, CSV, XLSX, PCAP, etc.
• Ability to decompose technical problems and troubleshoot system and dataflow issues.
• Strong experience using the Niagara Files canvas to develop, configure, monitor data provenance and processor status, and troubleshoot complex dataflows.
• Experience with the Atlassian Tool Suite (JIRA, Confluence).
• Experience with corporate data security and compliance procedures and policies.
• Understanding of System Engineering principles.