What are the responsibilities and job description for the Database Architect position at A P Ventures, LLC?
Title: Database Architect
Location: Remote
Company Background
A P Ventures, LLC (APV) is an innovative Woman-Owned Small Business (WOSB) providing services to Government customers at the federal and state levels in three key focus areas: High-End IT Consulting, Emerging Technology and Training Solutions, and Human Capital Services. Established in 2007, APV has completed 70 prime contracts and currently oversees 25 task orders, consistently achieving high client satisfaction, CPARS, and customer accolades. Our success is fueled by our skilled and motivated workforce, reflected in our impressive employee retention rate exceeding 90%.
APV has a wide portfolio of contracts and “Best-in-Class” contract vehicles, including GSA MAS, OASIS , CIO-SP3 SB & 8(a) across all functional areas, HCaTS, and several other industry-specific BPA and IDIQs.
APV is a mature company dedicated to quality and exceptional delivery to meet its clients’ missions. We understand personnel are an essential part of this. We hire the best and take care of the people who come to work for us. We continue to maintain employee satisfaction and have a high retention rate, well above the industry average for our small business peers. We do this through our corporate practice that emphasizes employee satisfaction through the three “C’s” – Culture, Compensation, and Career Development.
Position Overview
The Database Architect is responsible for designing, implementing, and optimizing database solutions that support a high-volume federal data reporting system. Work may involve connecting mainframe DB2 data with modern relational or cloud-based databases.
Duties and Responsibilities
• Architect, implement, and maintain databases across DB2 (mainframe), Oracle, or other RDBMS platforms.
• Optimize schemas, indexes, and queries for high throughput and minimal latency.
• Develop data models that support reporting/analytics needs, ensuring accuracy and consistency.
• Ensure compliance with federal security standards, including encryption and role-based access.
• Collaborate with development teams to design efficient ETL/ELT workflows.
Required experience and skills
• 5 years of hands-on database design/administration experience.
• Expert-level SQL skills, performance tuning, and knowledge of mainframe-based data ingestion.
• Experience working with MicroStrategy for data consumption or report generation.
• Strong capacity-planning, backup/recovery, and disaster recovery planning abilities.
Preferred experience and skills
• Bachelor’s or master’s degree in computer science, Data Management, or related field.
• Certifications in Oracle, IBM DB2, or cloud database services.
• Federal contracting experience supporting data analytics/reporting solutions.
About A P Ventures
A P Ventures, LLC is a full-service IT consulting company headquartered in Columbia, MD. We are one of the fastest-growing IT companies in the Washington DC–metro area, and are a prime vendor with various federal, State, and Local agencies. Learn more at www.apvit.com.
A P Ventures is an Equal Employment Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, national origin, gender, age, religion, disability, sexual orientation, veteran status, or marital status.
