Database Engineer - (GC-2/3)

Legato, LLC•Annapolis Junction, MD

1d•Onsite

About The Position

The Database Engineer will provide both engineering and administration support. There will be a focus on data optimization, dealing with large data sets, and seeking Oracle efficiencies. There will be an opportunity to optimize an Oracle system to operate at peak performance and efficiency. The ideal candidate will shape how massive and usual data types are processed, stored, and leveraged. They will provide technical expertise for database design, development, implementation, information storage and retrieval, data flow and analysis. Develops relational and/or Object-Oriented databases, database parser software, and database loading software. Projects long-range requirements for database administration and design. Responsible for developing a database structure that fits into the overall architecture of the system under development and has to make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls. The DBE works primarily at the front end of the lifecycle requirements through system acceptance testing and Initial Operational Capability (IOC). Develops requirements from a project’s inception to its conclusion for a particular business and Information Technology (IT) subject matter area (i.e., simple to complex systems). Assist with recommendations for, and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts. Translates a set of requirements and data into a usable document by creating or recreating ad hoc queries, scripts, and macros; updates existing queries, creates new ones to manipulate data into a master file; and builds complex systems using queries, tables, Open Database Connectivity and database storage and retrieval using Cloud methodologies.

Requirements

Experience with Oracle or PostgresSQL
Experience in both database engineering and database administration
Experience with data optimization, large data sets and organization of data.
IAT Level 2 Certification required at start date
At least five (5) years experience as a Database Engineer
A bachelor’s degree in a related discipline is required. Five (5) years of equivalent experience may be substituted for the bachelor's degree for a total of ten (10) years of experience

Responsibilities

Provide engineering and administration support for databases.
Focus on data optimization, dealing with large data sets, and seeking Oracle efficiencies.
Optimize an Oracle system to operate at peak performance and efficiency.
Shape how massive and usual data types are processed, stored, and leveraged.
Provide technical expertise for database design, development, implementation, information storage and retrieval, data flow and analysis.
Develop relational and/or Object-Oriented databases, database parser software, and database loading software.
Project long-range requirements for database administration and design.
Develop a database structure that fits into the overall architecture of the system under development.
Make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls.
Work primarily at the front end of the lifecycle requirements through system acceptance testing and Initial Operational Capability (IOC).
Develop requirements from a project’s inception to its conclusion for a particular business and Information Technology (IT) subject matter area.
Assist with recommendations for, and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts.
Translate a set of requirements and data into a usable document by creating or recreating ad hoc queries, scripts, and macros.
Update existing queries and create new ones to manipulate data into a master file.
Build complex systems using queries, tables, Open Database Connectivity and database storage and retrieval using Cloud methodologies.