Database Engineer 1

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

Job summary

Synergy ECP is seeking a Database Engineer to migrate an Oracle transactional/database environment to a modern multi-tier web architecture with microservices and data pipelines. You will work on real-time and batch data solutions using Elasticsearch, Spark streaming, and Hadoop ecosystems.

The role focuses on migrating data from legacy systems, integrating data across interfaces, and delivering scalable data architectures for a new target system, requiring TS/SCI clearance with FSP and US

Qualifications

• 3 years experience as a database engineer on similar scope
• Bachelor's degree in a technical discipline; 5 years experience may substitute
• Proficient in database design, development, and data flow analysis

Responsibilities

• Support migration from Oracle DB to a modern multi-tier web architecture
• Develop data pipelines and pipelines using ElasticSearch, Spark, and Hadoop
• Design real-time and batch data solutions for a new target system

Skills

Database engineering

SQL querying

Data integration

Data analysis

Education

Bachelor's degree in a technical discipline

5 years experience substituted for degree

Tools

ElasticSearch

Spark

Hadoop

Kibana

SQLDeveloper

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