Database Engineer 1 w/ Oracle, ElasticSearch, and Hadoop
Annapolis Junction, MD · Information Technology
TO BE CONSIDERED FOR THIS POSITION YOU MUST HAVE AN ACTIVE TS/SCI W/ POLYGRAPH SECURITY CLEARANCE (U.S. CITIZENSHIP REQUIRED)
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.
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
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