Database Engineer 1

Synergy ECP; Fort Meade (MD); On-site; USD 110,000 - 140,000; Full time

Job summary

Synergy ECP in Maryland is seeking a Database Engineer/Developer to support migrating an application suite from an Oracle environment to a modern multi-tier web architecture with microservices, data pipelines, and big data capabilities using Elasticsearch, Spark, and Hadoop. The role involves migrating data from legacy systems, integrating data across interfaces, and designing advanced real-time and batch data solutions for the new target system.

U.S.

Qualifications

• Three years of DBE experience in programs/contracts of similar scope, type and complexity.
• Bachelor's degree in a technical discipline is required; five years of DBE experience may substitute for a degree.
• Support 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 requirements into a usable database schema by creating or recreating ad hoc queries, scripts and macros.

Responsibilities

• Migrate an application suite to a modern multi-tier web architecture with microservices and data pipeline.
• Work with data technologies including Elasticsearch, Spark streaming, and the Hadoop ecosystem.
• Design advanced real-time and batch data solutions for the new target system.
• Assist in integrating data across interfacing systems.

Skills

DBE experience

Database design

SQL proficiency

Data migration

Big data concepts

Scripting (Python/Java)

Education

Bachelor's degree in a technical discipline

Tools

Elasticsearch

Spark

Hadoop

JSON

XML

CSV

Job description

Synergy ECP is a Service-Disabled Veteran-Owned Small Business SD(VOSB) that was formed in July 2007 with Headquarters in Columbia, MD and is made up of talented, dedicated staff to provide a broad range of services to the defense, intelligence and health care industries.

In an ultra-competitive environment, Synergy ECP has thrived by adhering to our name, making sure excellence is displayed by our Employees, to our Customers and by Improving Performance (ECP).

It's what sets us apart, enabling us to be an autonomous yet agile business that delivers huge results - showing we're ready to meet our customers' evolving demands.

Synergy ECP has earned a client list that includes numerous Fortune 100 companies, in addition to multiple branches of the US government and military services.

Synergy ECP is an equal opportunity employer and considers qualified applicants for employment without regard to race, color, creed, religion, national origin, sex, sexual orientation, gender identity and expression, age, disability, veteran status, or any other protected class. Clearance Requirement: TS/SCI with Full Scope Polygraph. US 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 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