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