Job Title: Database Architects
Location: Hagerstown, MD
Employer: 4Consulting, Inc
Position Type: Full Time
Worksite: Onsite
Position Summary
4Consulting, Inc is seeking a qualified Database Architects to support technology consulting, application development, systems analysis, testing, data management, cybersecurity, infrastructure, or project delivery services for client projects. The selected candidate will perform duties consistent with the client’s project requirements and company delivery standards.
Essential Duties and Responsibilities
The candidate will be responsible for:
- Design, develop, troubleshoot, deploy, and maintain ETL workflows that integrate data across relational and NoSQL database platforms.
- Develop, optimize, and maintain SQL stored procedures and complex queries, including analytical functions, correlated subqueries, transaction management, error handling, input validation, and performance tuning.
- Identify and implement automated data migration validation rules, document data lineage and data usage, and investigate data inconsistencies across systems.
- Perform pre- and post-migration validation, verify data accuracy and integrity, troubleshoot discrepancies, and collaborate with stakeholders to support reliable data processing and system operations.
Minimum Qualifications
The position requires:
|
Education
|
Bachelor’s degree in Computer Science, Information Technology, Engineering, Business, or related field, or equivalent combination of education and experience.
|
|
Experience
|
Experience designing ETL workflows, developing complex SQL procedures, integrating relational and NoSQL databases, documenting data lineage, and validating data migrations.
|
|
Technical Skills
|
Oracle SQL, MongoDB, PostgreSQL, ETL Development, SQL Stored Procedures, Query Optimization, Data Migration, Data Validation, Data Lineage
|
|
Business / Domain Skills
|
- Experience supporting federal government logistics and supply chain systems, including data integration, migration, validation, and operational information flows across enterprise applications.
- Experience supporting Department of Defense medical logistics or comparable supply chain processes, including logistics data management and system interoperability.
- Experience validating business rules, application workflows, interfaces, data, batch processes, and end-to-end transactions through functional, integration, regression, UAT, and end-to-end testing.
- Experience working within federal delivery environments involving data governance, traceability, migration controls, cross-functional stakeholder coordination, and Agile or SAFe project practices.
|
|
Communication
|
Ability to communicate with technical and business stakeholders.
|
|
Documentation
|
Ability to prepare project documentation, status updates, and deliverables.
|
|
Work Authorization
|
Must be legally authorized to work in the United States. Sponsorship may be considered where permitted by company policy and project requirements.
|
Certification Required
None
Travel Required
None
Supervisory Role
No
Preferred Qualifications
- Experience with DoD medical logistics, supply chain systems, LogiCole, or comparable medical logistics applications.
- Experience supporting Agile or SAFe delivery in federal government environments.
- Strong analytical, troubleshooting, data quality, and problem-solving skills.
Equal Employment Opportunity Statement
4Consulting, Inc is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, citizenship status, immigration status where protected by law, or any other legally protected status. All candidates will be evaluated based on job-related qualifications, experience, skills, availability, and ability to perform the essential duties of the position.
