Systems and Database Design SME

Systems and Database Design (SME) Location: One Denver Federal Center, Bldg 48, Denver, Colorado, 80225: Hybrid EnvironmentClearance: Has or has ability to obtain Public Trust ClearancePosition Type: Full-TimeSalary: $160,000.00 - $170,000.00 Job SummaryWorld Services is seeking a Systems and Database Design Subject Matter Expert (Software Developer SME) for a federal client to lead the design, development, and optimization of enterprise databases and system architectures supporting large-scale HR applications. This role focuses on designing new interfaces, maintaining data integrity, and ensuring efficient, high-performing system and database operations. The SME works collaboratively with developers, system architects, and data teams to modernize legacy systems, improve interoperability, and ensure scalability and reliability across environments. Key Responsibilities Core Functional Duties Design, write, test, and maintain code to ensure reliable and efficient system and database operations. Develop new and maintain existing user interfaces that enhance usability and performance. Identify and document major system components and their interfaces to ensure integration integrity. Map and maintain traceability between requirements, design specifications, and implementation. Conduct design reviews to clarify system design drivers and architectural trade-offs. Analyze system portability, scalability, and performance implications to guide modernization efforts. Create logical and physical database models using data modeling and normalization techniques. Identify and recommend opportunities to reuse existing systems and services where feasible. Identify integration challenges with legacy systems and document solutions or mitigations. Systems Development and Database Architecture Lead the design and documentation of database structures and schemas for enterprise HR applications. Oversee database and data-dictionary creation, ensuring compliance with federal lifecycle standards. Collaborate with system architects to align database structures with application-layer design. Develop APIs and integration frameworks to support data interoperability between internal and external systems. Support migration of legacy Oracle and MySQL databases into modern, optimized architectures. Performance, Integration, and Modernization Evaluate existing system architectures and recommend improvements to enhance performance and reliability. Design and maintain data access strategies, ensuring optimal query performance and scalability. Support system conversion activities including data modeling, ETL scripting, and schema refactoring. Provide technical leadership for modernization initiatives involving legacy and cloud-based systems. Document architecture designs, data models, and technical specifications for long-term system maintenance. Required Qualifications Minimum 10 years of experience in systems and database design, development, or administration for enterprise applications. Proven experience creating and managing logical and physical database models using normalization and data-modeling techniques. Expertise with relational database systems such as Oracle and MySQL, including performance tuning, optimization, and backup/recovery. Strong understanding of system integration principles, API management, and legacy system interoperability. Proficiency in SQL and at least one modern programming or scripting language (e.g., Java, PHP, or Python). Demonstrated ability to conduct architecture reviews, lead technical design sessions, and document complex systems. Familiarity with Agile or SAFe development frameworks and configuration-management best practices. Job Types: Full-time, Contract Pay: $160,000.00 - $170,000.00 per year Benefits: 401(k) Dental insurance Health insurance Paid time off Vision insurance Location: Denver, CO 80225 (Preferred) Security clearance: Confidential (Preferred) Work Location: Hybrid remote in Denver, CO 80225