logo

View all jobs

Database Engineer 1 w/ Oracle, ElasticSearch, and Hadoop

Annapolis Junction, MD · Information Technology
Required:

TO BE CONSIDERED FOR THIS POSITION YOU MUST HAVE AN ACTIVE TS/SCI W/ POLYGRAPH SECURITY CLEARANCE (U.S. CITIZENSHIP REQUIRED) 

Job Description: 
  • The Database Engineer / Developer will support the migration of an application suite from a traditional Oracle transactional database + data warehouse/business intelligence environment to a modern multi-tier web architecture with microservices, data pipeline, big data, enterprise messaging, and advanced reporting and business intelligence.
  • Data technologies include Elasticsearch, Spark streaming, and the Hadoop ecosystem.
  • This position involves the migration of data from legacy business systems, the integration of data across interfacing systems, and the design of advanced real-time and batch data solutions for a new target system.
Required:
  • Three (3) years experience as a DBE in programs and contracts of similar scope, type, and complexity is required.
  • Bachelor’s degree in a technical discipline from an accredited college or university is required. Five (5) years of DBE experience may be substituted for a bachelor’s degree.
  • Support the database design, development, implementation, information storage and retrieval, data flow and analysis activities
  • Support the analysis and evaluation of system improvements, optimization, development and/or maintenance efforts
  • Support the development of long and short term requirements for database administration and design
  • Assist in developing databases, database parser software, and database loading software
  • Translate a set of requirements and data into a usable database schema by creating or recreating ad hoc queries, scripts and macros, updates existing queries, creates new ones to manipulate data into a master file
  • Assist in developing database structures that fit into the overall architecture of the system under development
Desired:
  • Experience developing and deploying solutions with either ElasticSearch, Spark, or Hadoop
  • Experience automating tasks through programming and scripting (e.g., Python, Java, Bash, Powershell)
  • Experience extracting data from diverse databases and file structures (e.g., JSON, XML, CSV, TXT, unstructured) to leverage in a different target system
  • Proficient with identifying data migration requirements, developing repeatable data conversion scripts and mappings, identifying and implementing data cleanup routines, and validating data accuracy and usability
  • Experience with data architecture and associated tools (SQLDeveloper, Kibana) and databases/datasources (Oracle, ElasticSearch, Hadoop)
  • Requires full comprehension of SQL, cardinality, levels of granularity, normalization vs. de-normalization, and database and tool optimization techniques
  • Experience with writing technical specifications and other technical documents
Powered by