Database Engineer 1

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.

Required Skills

• Three (3) years experience as a database engineer (DBE) in programs and contracts of similar scope, type, and complexity.
• 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 degree.
• Support the database design, development, implementation, information storage and retrieval, data flow, and analysis activities.
• 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 Skills

• 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.