Senior Database Architect

The C.A.S.E. Engineering Group
Washington, DC, United States
2 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
1 year minimum
Compensation
$120,000.0 - $130,000.0
Working hours
Shift work
Job source

Tech stack

Application Programming Interfaces (APIs) Amazon Web Services Microsoft Azure Configuration Management Databases CompTIA Security+ Information Systems Databases Data Architecture Data Deduplication Data Discovery Data Governance Data Integration
+18 more
Extract Transform Load (ETL) Data Stores Relational Databases Federal Enterprise Architecture PostgreSQL Meta-Data Management Microsoft SQL Server SQL Azure MongoDB NoSQL Oracle (Applications) Cloud Services Data Streaming Systems Integration Azure Data Factory Information Technology Data Management Physical Data Models

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.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

2:37 min

Comparing traditional SQL tables versus NoSQL non-tabular databases

Stanimira Vlaeva · JS Congress

2:01 min

Migrating existing applications from MongoDB to Postgres

Nikita Shamgunov Nikita Shamgunov · WWC 2024

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

3:16 min

Terminology differences between relational and NoSQL databases

Tim Faulkes · LIVE

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

Videos

See all

Related articles

See all