Crimson Phoenix - Dayton, OH

posted about 2 months ago

Full-time - Senior
Dayton, OH

About the position

As a Senior Database Architect at Crimson Phoenix LLC, you will play a pivotal role in leading the design and development of databases, database parser software, and database loading software. Your expertise will be crucial in developing database structures that seamlessly integrate into the overall architecture of the systems under development. You will be responsible for developing requirement recommendations from the inception of projects to their conclusion, focusing on both Business and IT subject matter areas, which can range from simple to complex systems. In this role, you will direct the overall database structure, ensuring it aligns with the system architecture while making critical trade-offs among data volumes, user numbers, logical and physical distribution, response times, retention rules, security, and domain controls. You will provide technical expertise in database design, development, implementation, information storage and retrieval, and data flow analysis, utilizing various Database Management Systems (DBMS) such as Oracle and PostgreSQL. Your responsibilities will also include developing relational and/or Object-Oriented databases, projecting long-range requirements for database administration and design, and working primarily at the front end of the lifecycle—from requirements gathering through system acceptance testing and Initial Operational Capability (IOC). You will assist in analyzing and evaluating systems improvements, optimization, development, and maintenance efforts, while actively participating in DevSecOps processes and principles throughout all design phases. Additionally, you will be involved in developing and delivering training as requested by the government to support applications, translating requirements and data into usable documents, and updating existing queries while creating new ones to manipulate data effectively.

Responsibilities

  • Lead design and development of databases, database parser software, and database loading software.
  • Develop 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.
  • Direct the overall database structure that fits into the overall architecture of the system under development.
  • Make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security, and domain controls.
  • 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.
  • Work primarily at the front end of the lifecycle from requirements through system acceptance testing and Initial Operational Capability (IOC).
  • Assist with recommendations for and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts.
  • Participate in DevSecOps processes and practice principles during all design phases.
  • Develop and deliver training as requested by the government to support applications.
  • Translate a set of requirements and data into a usable document by creating or recreating ad hoc queries, scripts, and macros.
  • Update existing queries and create new ones to manipulate data into a master file.
  • Build complex systems using queries, tables, Open Database Connectivity, and database storage and retrieval using Cloud methodologies.

Requirements

  • Extensive experience in database design and development.
  • Proficiency in Oracle, PostgreSQL, and other DBMS Database and Applications.
  • Strong understanding of relational and Object-Oriented databases.
  • Experience with database parser software and database loading software.
  • Ability to project long-range requirements for database administration and design.
  • Experience in DevSecOps processes and principles.
  • Strong analytical and problem-solving skills.

Nice-to-haves

  • Experience with Cloud methodologies for database storage and retrieval.
  • Familiarity with creating ad hoc queries, scripts, and macros.
  • Experience in training and mentoring team members.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service