Data Architect

Novel Applications Dulles, VA
Residency Status: ALL CANDIDATES MUST BE A U.S. CITIZEN

Clearance: Active Top Secret clearance with SSBI in last five years (TS/SCI desired)

ID: NA052018-6 Ray

Time Type: Full-Time

Relocation Fees: No

Company Overview:

Novel Applications of Vital Information Inc. (Novel Applications) is a premier technology services company that provides solutions in the areas of Cyber Security, Information Management, Systems Integration. Novel Applications is a business that combines experience, creativity, flexibility, pragmatism, and cost-effective solutions in order to deliver measurable business value to our clients.

Headquartered in Springfield, Virginia, Novel Applications employs engineers, analysts, IT specialists and other professionals who strive to be the best at everything they do.

Novel Applications is an AA/EEO Employer - Minorities/Women/Veterans/Disabled.

Job Description:

NAOVI is seeking a Data Architect to lead the development and deployment of cybersecurity data models and databases.

* Directs the organization of requirements and data into a usable database schema by designing ad hoc queries, scripts, macros, and updates to existing queries.

* Develops the overall database structures to match the architecture of the system under development and makes trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls.

* Advises on the organization of requirements and data into a usable database schema by directing development of ad hoc queries, scripts, macros, and updates to existing queries.

* Directs the development of complex systems using queries, tables, Open Database Connectivity and database storage and retrieval methodologies.

* Develops the overall database structure that represents the architecture of the system under development and makes trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls.

Required Qualifications:

* Bachelors degree in Systems Engineering, Software Engineering, Computer Science, or a related discipline or equivalent experience.

* Must have 8 years of professional experience or 6 years with a Masters degree or 4 years with PhD in a related discipline.

* DoD 8570.1 IAT Level 2 certification or the ability to obtain certification within three months of employment.

* Must have strong data modeling, schema design, and database engineering experience.

* Experience and/or familiarity with Apache Hadoop, Spark, PostgresSQL, MySQL or Oracle.

* Demonstrated experience with data migration from legacy systems to new repositories.

* Knowledge of industry standard exchange schema implementation experience.

* Experience with development and execution of database security policies, procedures and auditing-experience with database authentication methods, authorization methods, and data encryption techniques.

* Evaluate and install new software releases, patches and system upgrades.

* Knowledge and understanding of all aspects of database tuning: software configuration, memory usage, data access, data manipulation, SQL, and physical storage.

* ALL CANDIDATES MUST BE U.S. CITIZENS AND HAVE A TS CLEARANCE WITH SCI ELIGIBILITY (SSBI WITHIN THE PAST 5 YEARS).

Desired Qualifications:

* Experience database engineering support to DHS, DoD or Intelligence Customers.

* Database-specific certifications.

* Data Science skills and experience.

* Experience working with large unstructured data sets.

* Experience with Map/Reduce technologies.

* Experience with process development and deployment.

* Cloudera Certified Professional (CCP) or Cloudera Certified Associate (CCA).

* Understanding of Certification and Accreditation (NIST 800-53) processes as they apply to database technologies.

* ITIL knowledge and certification.

* Experience with agile development methodologies.