Database Engineer II

Job Description

SALARY RANGE $143,000 - $200,000/year

DUTIES As a successful candidate for the Database Engineer II role, you will 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. Responsible for developing a database structure that fits into the overall architecture of the system under development and making trade-offs 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, ranging from simple to complex systems. Assist with recommendations for, and the analysis and evaluation of, system 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; create new ones to manipulate data into a master file; and build complex systems using queries, tables, Open Database Connectivity, and database storage and retrieval using Cloud methodologies.

Required Skills

SKILLS

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; update existing queries; create 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 the 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 make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security, and domain controls

QUALIFICATIONS Bachelor's degree plus ten (10) years of professional experience is acceptable. Fifteen (15) years of relevant experience is acceptable if the candidate does not possess a degree.

Additional Requirements:

Database experience using MongoDB or MariaDB, including:

Deployment and management of the database itself

Debugging of optimization issues

Scaling

Desired Skills

Python, Django, or Flask

ReST Endpoint Development

Micro-Service Model

Swagger

AWS, C2S, or other cloud experience

Docker

Visual Studio Code or similar IDEs, JSON, and/or XML serialization

Jira, Confluence

Git version control

Experience working in an Agile environment