Database Architect I (Public Trust Clearance)

Aalis Management Consulting

Washington, DC, USA

Published: 6/14/2022

Technology

Full Time

Job Description

Aalis Management Consulting is an 8(a) certified Service-Disabled Veteran-Owned Small Business (SDVOSB) and Economically Disadvantaged Woman-Owned Small Business (EDWOSB) driven by the same principles that guide our armed forces. Founded by a US Army veteran, we take pride in our core values: excellence in reputation, commitment, candor, teamwork, and dependability. Our team delivers stakeholder-focused support in the areas of Acquisition & Procurement Support, (IT) Financial Management, Program Management, and Logistics & Supply Chain Support. Visit us at www.aalismc.com

Title: Database Architect I
Client: Federal Agency
Location: Washington, D.C.
Clearance: Public Trust
Security Clearance Statement: This position requires a government security clearance; the applicant must be a U.S. citizen for consideration.
Number of Position(s): 1
Work Schedule: 8 am – 5 pm
Work Day: Monday – Friday

Job Summary:

The Database Architect I will support Aalis Management Consulting’s government client and be responsible for designing, modeling, and optimizing database systems to meet federal government requirements. This position involves conceptualizing data structures, defining relationships, and ensuring efficient data flow across systems. The ideal candidate will have expertise in multiple database technologies, strong analytical skills, and the ability to design scalable, high-performance architectures.

Key Responsibilities:

Develop logical and physical database models to support business processes and user requirements.
Create entity-relationship diagrams (ERDs) and other documentation to define data structures.
Ensure proper database normalization for optimal performance and integrity.
Design and implement data pipelines from back-end to front-end systems.
Recommend and implement performance-oriented architectures for large-scale data processing.
Support ETL (Extract, Transform, Load) processes and data migration efforts.
Analyze and improve query performance, indexing strategies, and storage efficiency.
Ensure compliance with federal data security, governance, and accessibility standards.
Collaborate with developers, analysts, and stakeholders to align database solutions with mission needs.
Define informational needs, data relationships, and attributes for system documentation.
Generate reports on database performance, usage trends, and optimization opportunities.

Required Qualifications:

Must have a Bachelor of Science (B.S.) in Computer Science, Information Technology, Engineering, or a related field.
Should have at least five (5) years of hands-on database architecture experience.
Experience working with at least two different database technologies (e.g., Microsoft SQL Server, MySQL, Oracle, PostgreSQL, NoSQL).
Strong knowledge of data modeling, ERDs, and normalization techniques.
Familiarity with cloud-based databases (AWS RDS, Azure SQL) is a plus.

Skills & Certifications (Preferred):

Certified Data Management Professional (CDMP), Microsoft Certified:
Azure Data Engineer, or AWS Certified Database Specialty, is desirable.
Experience with federal IT security standards (NIST, FISMA, FedRAMP) is a plus.

Aalis Management Consulting is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

WjVfUhfiqR