5+ years experience with Oracle, Linux, SQL, and scripting
Bachelor's degree in a technical field or equivalent work experience
Active TS/SCI clearance with Fullscope polygraph
Responsibilities
Support database design and implementation for effective data retrieval
Develop long and short term database administration requirements
Analyze system improvements and optimize maintenance efforts
Translate requirements into a functional database schema
Create and update data models using PowerDesigner
Lead the development of database structures aligned with system architecture
Direct and organize requirements into a usable database schema
Benefits
Health, Dental, Vision, and Flexible Spending Account
Paid Time Off (PTO)
11 paid holidays
Tuition Education Assistance
Professional Development
401(k) retirement plan
Life insurance and short- and long-term disability insurance
Employee Referral Program
Marketing Incentive Plans
Full Job Description
Role description: The Oracle Database Engineer will:
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.
Support the analysis and evaluation of system improvements, optimization, development and/or maintenance efforts.
Translate a set of requirements and data into a usable database schema.
Create and update data models using PowerDesigner
Assist in developing database structures that fit into the overall architecture of the system under development.
Lead development of database structures that fit into the overall architecture of the system under development.
Develop requirement recommendations from a project's inception to its conclusion for a particular Business and IT subject matter area (i.e. simple to complex systems).
Develop 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.
Direct the overall 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.
Direct fulfillment of requirements from a project's inception to it conclusion.
Direct organization of requirements and data into a usable database schema by directing development of ad hoc queries, scripts, macros, updates to existing queries.
Direct the development of complex systems using queries, tables, Open -Database Connectivity and database storage and retrieval
*May require database engineering on-call support for troubleshooting and correcting operational system issues.
Required skills:
Experience with Oracle, Linux, SQL and scripting,
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 bachelor's degree.
Active TS/SCI with Fullscope polygraph
Desired skills:
Oracle Data Guard
Jira
Confluence
relational database design tools such as PowerDesigner
Our Benefits
DigiFlight's competitive benefits package allows employees to manage their personal and professional portfolios through a variety of features and programs. Our benefits include:
Health, Dental, Vision, and Flexible Spending Account
Paid Time Off (PTO)
11 paid holidays
Tuition Education Assistance
Professional Development
401(k) retirement plan
Life insurance and short- and long-term disability insurance
Employee Referral Program
Marketing Incentive Plans
DFI offers a highly competitive, family-oriented benefits package.