Database Engineer II

DUTIES As a successful candidate for the Database Engineer II role, you will support the Secure the Enterprise initiative by helping transition manual system security evaluation and authorization processes to a model focused on automation, streamlined approvals, continuous monitoring, and lifecycle-wide data collection. You will provide expertise in database design, development, implementation, data storage and retrieval, and analysis, developing relational and Object-Oriented databases, parser software, and data loading solutions. Responsibilities include designing database architectures that balance performance, security, scalability, and data management requirements; supporting activities from requirements development through system acceptance testing and IOC; translating business and technical requirements into database solutions; and developing queries, scripts, macros, and cloud-based data management capabilities to support system optimization, reporting, and enterprise automation efforts., * Provide technical expertise for database design, development, implementation, information storage and retrieval, data flow, and analysis activities

• Develop, maintain, and optimize database structures that align with overall system architecture while balancing data volumes, user access, performance, retention requirements, security controls, and logical and physical distribution considerations
• Lead the development of databases, database parser software, database loading software, and supporting workflows to automate existing processes and improve operational efficiency
• Support the analysis, evaluation, optimization, enhancement, and maintenance of database systems and associated applications
• Develop long- and short-term requirements and technical recommendations for database administration, design, and implementation throughout the project lifecycle
• Translate business and technical requirements into database solutions by creating and maintaining database schemas, ad hoc queries, scripts, macros, and master data files
• Create new workflows, enhancements, and break/fix solutions to support evolving mission and operational requirements
• Support the development, testing, and maintenance of Python-based ReST endpoints, microservices, and data model management capabilities utilizing Django and Flask frameworks
• Design and develop integrations with MariaDB, MongoDB, and PostgreSQL databases, delivering data in JSON format to user interface front-end applications
• Develop requirements and technical solutions from project inception through deployment, supporting both simple and complex business and information technology systems

QUALIFICATIONS Five (5) years of experience as a DBE in programs and contracts of similar scope, type, and complexity are required. A 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.

Additionally, the candidate must have 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