Senior Database Architect
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+18 more
Job description
This position supports a mission-critical federal program focused on enterprise IT portfolio rationalization, modernization, and governance within a federal agency’s Office of the Chief Information Officer (OCIO). Our team discovers, documents, and rationalizes a large and complex enterprise IT estate - spanning networks, infrastructure, applications, data, and identity - to establish an authoritative baseline and chart a clear path toward a consolidated, well-governed target state. We seek professionals who are not only technically proficient but also adaptable, analytical, and dedicated to excellence, ensuring that we continue to provide our clients with the best expertise available., The Senior Database Architect serves as the authoritative technical lead for understanding, documenting, and rationalizing the enterprise data estate. This is a design- and discovery-focused architecture role, not a database administration role. The Senior Database Architect discovers where data lives, maps how it moves between systems, identifies fragmented and duplicated data, and develops the data models and system-of-record definitions that consolidation and modernization decisions depend on. The role partners closely with the broader architecture team to align the data picture with the program’s rationalization, master-data, and modernization objectives., This is a full-time, onsite role based in Washington, D.C., requiring availability during normal business hours, with occasional night and weekend work as needed based on program demands. The Senior Database Architect works closely with executive leadership and cross-functional engineering teams across applications, cloud, identity, service management, and enterprise architecture, and supports governance processes and milestone reviews throughout the program., * Discover and document the enterprise database estate and data stores across the environment
- Map data flows, integration points, and authoritative systems of record
- Identify fragmented and duplicated data that should share a single source of truth
- Develop conceptual, logical, and physical data models that support rationalization and the target state
- Frame data-consolidation and integration paths toward a consolidated, well-governed target state
- Define how each data store aligns to the enterprise unique-identifier and master-data framework, in partnership with the CMDB and service management team
- Partner with application, cloud, identity, and enterprise architecture teams to align data architecture with modernization objectives
- Produce professional-grade data architecture artifacts, models, and documentation
- Support governance processes, technical reviews, and milestone gates, and brief findings to leadership and federal stakeholders
- Identify opportunities for optimization and continuous improvement in partnership with the broader team
Requirements
Do you have experience in Systems integration?, Do you have a Bachelor’s degree?, Education & Certification
- Bachelor’s degree in Computer Science, Information Systems, Data Management, or a related field preferred (or equivalent experience)
- Professional database or data-management certification required, such as DAMA Certified Data Management Professional (CDMP), Oracle Certified Professional (OCP), or Microsoft Certified: Azure Database Administrator Associate
- One or more of the following strongly preferred: a Federal Enterprise Architecture Framework (FEAF)-based enterprise architecture credential (e.g., FEAC Institute ACEA or CEA); AWS Certified Database - Specialty or Microsoft Certified: Azure Data Engineer Associate; CompTIA Security+; ITIL 4 Foundation, * At least 10 years of progressive experience in database and data architecture, data modeling, and data integration
- Deep, hands-on expertise across enterprise database platforms, with a design- and discovery-oriented (rather than administration-oriented) focus
- Experience discovering, mapping, and rationalizing data estates in large, complex enterprise environments; federal experience preferred
- Proven track record defining systems of record and reducing data fragmentation and duplication
Technical Expertise
- Enterprise relational database platforms (e.g., Microsoft SQL Server, Oracle, PostgreSQL) and familiarity with NoSQL stores (e.g., MongoDB)
- Data modeling at conceptual, logical, and physical levels, including normalization and schema design
- Data integration patterns (ETL/ELT, APIs, messaging) and end-to-end data flow mapping
- Systems-of-record identification and master data management (MDM) concepts
- Data discovery, cataloging, and metadata management tools
- Data quality, deduplication, and consolidation approaches
- Cloud data platforms and migration (e.g., Azure, AWS)
- Working knowledge of federal data governance and security frameworks (e.g., NIST SP 800-53) and data management best practices (e.g., DAMA-DMBOK)
Additional Skills
- Excellent written and verbal communication, including briefing senior leadership and federal stakeholders
- Strong documentation discipline and attention to detail
- Strong analytical, problem-solving, and risk-identification skills
- Effective at collaborating with cross-functional teams to align technical work with program outcomes
- Adaptability in a fast-paced, evolving environment with shifting priorities
Clearance
- Must be a U.S. citizen and be able to obtain a federal background investigation
Benefits & conditions
Pulled from the full job description
- Health insurance
- Paid time off
- Vision insurance
- Dental insurance
- Opportunities for advancement, * Contribute to a mission-critical federal modernization program with high visibility and impact
- Own the authoritative data picture and system-of-record model that makes enterprise consolidation decisions possible
- Be part of a growing company that values innovation, technical excellence, and problem-solving
- Work alongside a senior, multidisciplinary team of architects and engineers
- Opportunities for professional growth and advancement
Pay: $120,000.00 - $130,000.00 per year
Benefits:
- Dental insurance
- Health insurance
- Paid time off
- Vision insurance
About the company
The C.A.S.E. Engineering Group is an Information Technology (IT) engineering firm that specializes in providing cybersecurity advisory services, modernizing IT architectures, developing and implementing IT strategic plans, and designing and engineering innovative systems, software, and applications. C.A.S.E. stands for Cybersecurity, Architecture, Strategy, and Engineering, which reflects both our core expertise and our belief that developing innovative solutions in unique environments requires a balanced approach. While C.A.S.E. tailors its solutions on a case-by-case basis to address the specific challenges organizations face, it also leverages industry best practices to ensure efficiency, security, and long-term success.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on indeed.comGood distractions
Talks and stories from around this role — technically off-topic, practically not.
Moments
Explore playlistsVideos
See allRelated articles
See all
Is Software Engineering Over-Saturated?
Making Data Warehouses Fast: A Developer’s Story
Best Paying Jobs in Technology
The 12 Best Jobs for Software Engineers