Database Engineer

Company: SW Complete
Location: Columbia
Posted on: May 27, 2023

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

Keywords: SW Complete, Columbia , Database Engineer, IT / Software / Systems , Columbia, South Carolina