Objective Area Solutions, LLC

Role Description We are seeking an experienced Senior Systems Documentation & Analysis Specialist to lead the comprehensive documentation of a complex, database-driven application used across federal stakeholders. This system is built on SQL-based data architecture and supported by legacy and modern technologies including .NET, ASP, jQuery, and jQuery UI. - Focus on producing a complete, accurate, and industry standards–compliant documentation package that reflects the current state of the system. - Analyze database structures, system workflows, and application behavior. - Reconcile and incorporate existing documentation. - Clearly identify current functionality versus outdated or deprecated components. - The documentation produced will serve as the authoritative foundation for system modernization, security posture assessment, and regulatory compliance efforts. - Work closely with a designated System Subject Matter Expert (SME) to validate findings and ensure completeness and accuracy. - This position has the option of remote, hybrid, or in-person work with an initial intensive documentation phase requiring delivery of a full documentation package within 6 months, followed by a reduced level of ongoing support for documentation maintenance and updates. Qualifications - Bachelor's degree - Minimum of 8 years of relevant professional experience - Eligibility to obtain a Public Trust clearance - Valid Real ID, or the ability to obtain one prior to employment - US citizen and reside in the United States without sponsorship - Demonstrated experience documenting complex, database-driven systems - Strong proficiency with SQL and relational database concepts (schemas, data models, data relationships, normalization) - Experience analyzing systems utilizing more than 1 framework - Proven ability to reverse-engineer systems and produce accurate documentation from incomplete, outdated, or inconsistent sources - Experience consolidating and reconciling multiple documentation sources into a single authoritative set - Strong understanding of industry documentation standards, and security and compliance documentation practices (e.g., IEEE, ISO/IEC/IEEE 42010, NIST, FISMA, or similar frameworks) - Ability to clearly distinguish and document current-state vs. legacy or deprecated functionality - Excellent written communication skills with a high level of precision and attention to detail - Experience collaborating with technical SMEs, developers, DBAs, and stakeholders to validate system understanding - Ability to independently manage work, meet deadlines, and deliver a comprehensive documentation package within a defined timeframe Requirements - Experience working with federal government systems or regulated environments - Prior involvement in system modernization, migration, or re-engineering initiatives - Experience documenting credentialing, identity management, or access control systems - Familiarity with compliance frameworks such as NIST 800-53, FedRAMP, or FISMA - Experience supporting security audits or accreditation processes - Strong background in data governance, data lineage, and data dictionary development - Proficiency with documentation and modeling tools (e.g., Visio, Lucidchart, ER modeling tools, Confluence, SharePoint) - Experience documenting APIs, integrations, and system interfaces - Ability to structure documentation for both technical and non-technical audiences - A highly methodical, detail-oriented approach with a focus on accuracy, traceability, and usability Work Requirements - Remote within the United States EEO Statement Objective Area Solutions LLC is an Equal Opportunity / Affirmative Action Employer. We are committed to attracting, engaging, and building a workplace where everyone feels empowered to bring their full, authentic selves to work. OAS does not discriminate on the basis of actual or perceived race, color, creed, religion, national origin, ancestry, age, sex, gender identity or expression, sexual orientation, marital status, disability, or any other characteristics protected by law. Objective Area Solutions LLC is committed to complying with applicable federal, state, and local laws governing reasonable accommodations of individuals, including not limited to, the Americans with Disabilities Act (ADA). Applicants who wish to request accommodations for disabilities we will adhere to such accommodations. If you are a disabled individual or disabled Veteran and require a reasonable accommodation in applying for any posted position, please speak with your recruiter.

Company Overview At OAS, we're not just growing; we're soaring! As a dynamic management consulting firm, we specialize in powering the aviation industry forward. Our expertise lies in crafting tailored strategies that blend cutting‑edge technical solutions with deep organizational insights-elevating our civilian and military aviation partners. Job Summary Join us in shaping the future of aviation! Objective Area Solutions (OAS) is seeking an experienced Senior Database Engineer to enhance our team. Our ideal candidate will be proficient in database design, optimization, and modernization, with deep expertise in SQL‑based legacy system transformation and sustainment. This role supports the Federal Aviation Administration, which is responsible for ensuring the safety of 45,000 flights and 3 million passengers traversing over 28 million miles of U.S.‑controlled airspace every day. In addition to providing air traffic control and safety oversight for civilian aviation, the FAA also works in lockstep with the Department of Defense and other government agencies to ensure the security of our nation. A key component of that coordination involves the collaborative use of aviation tools and data. Key Responsibilities A successful candidate must have a minimum of 10 years of relevant experience and be proficient in: - Conducting database assessments to identify schema inconsistencies, redundant structures, and performance issues - Designing, refactoring, and optimizing relational database schemas to support modernization - Executing hands‑on database optimization, tuning, and legacy system stabilization - Supporting configuration management, patching, release management, and CI/CD integration - Collaborating with developers, architects, and security analysts to align database structures with modern frameworks - Troubleshooting and resolving database‑related defects across development, testing, and operations - Supporting security authorization documentation, risk assessments, and vulnerability remediation - Validating database changes through unit, integration, system, and user acceptance testing - Creating and maintaining technical documentation including schemas, data models, change logs, and sustainment procedures - Participating in Agile ceremonies and supporting traceable, well‑documented release processes Required Qualifications - Bachelor's degree in Computer Science, Information Technology, Information Systems, Engineering, or related discipline - 10+ years of relevant database development experience - Demonstrated experience with: - Database modeling and schema design - Database optimization and performance tuning - Legacy database assessment and modernization - Enterprise or mission‑critical system support - Strong understanding of: - Relational database design principles - Data normalization and integrity - Configuration and change management - Ability to obtain and maintain a Public Trust clearance Desired Qualifications - Experience supporting the FAA, federal government systems, or aviation safety systems - Experience working within federal architecture constraints and modernization initiatives - Familiarity with Agile methodologies - Experience supporting systems undergoing technology refresh or framework upgrades Work Requirements - Work Environment: Remote within the United States Objective Area Solutions LLC is an Equal Opportunity / Affirmative Action Employer. We are committed to attracting, engaging, and building a workplace where everyone feels empowered to bring their full, authentic selves to work. OAS does not discriminate on the basis of actual or perceived race, color, creed, religion, national origin, ancestry, age, sex, gender identity or expression, sexual orientation, marital status, disability, or any other characteristics protected by law. Objective Area Solutions LLC is committed to complying with applicable federal, state, and local laws governing reasonable accommodations of individuals, including but not limited to the Americans with Disabilities Act (ADA). Applicants who wish to request accommodations for disabilities will be supported in accordance with these requirements. If you are a disabled individual or disabled Veteran and require a reasonable accommodation in applying for any posted position, please speak with your recruiter.

At OAS, we're not just growing; we're soaring! As a dynamic professional services firm, we specialize in powering the aviation industry forward. Our expertise? Crafting tailored strategies that blend cutting-edge technical solutions with deep organizational insights, all aimed at elevating our civilian and military aviation partners. About the Role We are seeking a Senior / Principal Software Architect to lead the stabilization and modernization of a mission‑critical legacy application for a federal government agency. This position blends hands-on full stack engineering with enterprise-level architectural leadership, with a strong emphasis on database refactoring, system redesign, and incremental modernization strategies. You will assess a fragmented legacy environment, remediate technical debt, and define a scalable target architecture that balances immediate operational needs with long-term modernization goals. In addition to project delivery, you will serve as a corporate technical subject matter expert, shaping solution approaches for proposals and organizational growth initiatives. Key Responsibilities Legacy System Stabilization & Modernization - Assess and stabilize existing application and database environments; resolve critical risks and technical debt. - Analyze and refactor database structures to improve performance, integrity, and maintainability. - Define and implement data migration strategies with minimal operational disruption. - Establish baseline metrics for system performance, capacity, and data health. - Develop a phased modernization roadmap using approaches such as refactor, replatform, or retire. Architecture Leadership - Define target system and database architecture, including integration patterns and data access strategies. - Establish data models, ownership boundaries, and interface contracts to support scalability. - Document system constraints, risks, and architectural decisions. - Define and enforce non-functional requirements (performance, security, reliability, compliance). - Lead architecture reviews and ensure implementation aligns with target design. - Prioritize immediate fixes versus long-term architectural improvements. Collaboration & Stakeholder Engagement - Work closely with program, development, and security teams to align execution with mission needs. - Communicate technical risks, trade-offs, and recommendations to technical and non-technical stakeholders. - Identify risks and dependencies and drive mitigation strategies. Corporate Technical Leadership - Serve as the company's enterprise technical lead, providing insights and recommendations to support business development and proposal efforts. - Contribute architectural guidance and best practices across internal teams. Required Qualifications - Bachelor's degree in a relevant field - 10+ years of full stack development experience - Strong server-side development experience, including APIs and database integration (MySQL, Oracle, SQL Server) - Experience developing modern web applications using HTML, CSS, JavaScript, and frameworks such as React, Angular, or Vue.js - Demonstrated ability to ensure performance, scalability, and secure application development - Familiarity with system architecture principles, version control, and full application lifecycle support - Ability to pass a Public Trust background investigation Desired Qualifications - Experience modernizing legacy systems within federal government environments - Strong background in database redesign and data migration - Proven ability to operate as both a hands-on engineer and architectural leader - Experience implementing incremental modernization strategies (not just full rewrites) - Comfort working in ambiguous, evolving environments with high ownership - Certifications (desired, not required): - AWS Database Specialty - Microsoft Certified: Azure Database Administrator Associate - Oracle Database Architect Certified Professional - Oracle Certified Professional: Java SE Developer - Master's degree in a related field Ideal Candidate Profile You thrive in complex environments where modernization must be balanced with operational continuity. You can dissect a legacy system, chart a path forward, and lead teams through incremental transformation. You understand the realities of government environments and can communicate clearly with both technical teams and mission stakeholders. You bring architectural vision, hands-on capability, and a mindset that connects project success with broader organizational growth. Location: Fully remote within the United States Clearance: Ability to obtain and maintain a Public Trust Education: Bachelor's degree required; Master's preferred Experience: 10+ years EEO Statement: Objective Area Solutions LLC is an Equal Opportunity / Affirmative Action Employer. We are committed to attracting, engaging, and building a workplace where everyone feels empowered to bring their full, authentic selves to work. OAS does not discriminate on the basis of actual or perceived race, color, creed, religion, national origin, ancestry, age, sex, gender identity or expression, sexual orientation, marital status, disability, or any other characteristics protected by law. Objective Area Solutions LLC is committed to complying with applicable federal, state, and local laws governing reasonable accommodations of individuals, including not limited to, the Americans with Disabilities Act (ADA). Applicants who wish to request accommodations for disabilities we will adhere to such accommodations. If you are a disabled individual or disabled Veteran and require a reasonable accommodation in applying for any posted position, please speak with your recruiter.