Database Engineer, Level 3

Avalore.ai; Maryland; On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Health care plan

Retirement Plan (401k)

Life Insurance

Paid Time Off

Disability Insurance

Training & Development

Employee Assistance Program

Job summary

Avalore.ai seeks a seasoned Database Engineer to shape scalable data architectures, optimize performance, and ensure secure data flows across enterprise systems.

The role emphasizes leadership in schema design, PostgreSQL-based development, and cloud-enabled storage while aligning with DoD IA controls and secure access requirements.

Qualifications

• Ten (10) years experience as a 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 bachelor's degree.
• Information Assurance: DoD 8570.01-M compliance with Information Assurance Technical (IAT) Level II is required
• Information Technology: 2 Yrs Experience in PostgreSQL
• Clearance: Active TS/SCI with an appropriate current polygraph is required to be considered for this role; Ability to receive privileged access rights

Responsibilities

• Support the database design, development, implementation, information storage and retrieval, data flow and analysis activities
• Support the analysis and evaluation of system improvements, optimization, development and/or maintenance efforts
• 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
• Lead development of database structures that fit into the overall architecture of the system under development
• Lead development of databases, database parser software, and database loading software
• Develop requirement recommendations from a project's inception to its conclusion for a particular Business and IT subject matter area
• 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 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 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 the development of complex systems using queries, tables, Open Database Connectivity and database storage and retrieval using Cloud methodologies

Education

Bachelor's degree in a technical discipline

Tools

PostgreSQL

ODBC

Job description

Provides 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 longrange 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.

• Support the database design, development, implementation, information storage and retrieval, data flow and analysis activities
• Support the analysis and evaluation of system improvements, optimization, development and/or maintenance efforts
• 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
• Lead development of database structures that fit into the overall architecture of the system under development
• Lead development of databases, database parser software, and database loading software
• 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 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 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 the development of complex systems using queries, tables, Open Database Connectivity and database storage and retrieval using Cloud methodologies

Requirements

• Ten (10) years experience as a DBE in programs and contracts of similar scope, type, and complexity is required.
• 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.
• Information Assurance: DoD 8570.01-M compliance with Information Assurance Technical (IAT) Level II is required
• Information Technology: 2 Yrs Experience in PostgreSQL
• Clearance: Active TS/SCI with an appropriate current polygraph is required to be considered for this role; Ability to receive privileged access rights

Benefits

Eligibility requirements apply.

• Employer-Paid Health Care Plan (Medical, Dental & Vision)
• Retirement Plan (401k, IRA) with a generous matching program
• Life Insurance (Basic, Voluntary & AD&D)
• Paid Time Off (Vacation, Sick & Public Holidays)
• Short Term & Long Term Disability
• Training & Development
• Employee Assistance Program