Demo

Senior Database Architect

Pinnacle Government Solutions
Washington, DC Full Time
POSTED ON 3/8/2025
AVAILABLE BEFORE 6/8/2025

Pinnacle Government Solutions is a minority-owned small business that provides Software and Cloud Engineering Solutions for our Department of Defense and Federal Civilian agencies. We bring SME-level expertise and over two decades of industry knowledge and experience. We believe in getting it right for our customers and our country.

We are seeking a Database Architect responsible for designing, implementing, and maintaining a cloud and / or container-based database architecture and infrastructure to support the development, sustainment, and operational needs of the applications and capabilities. This role is critical to ensuring system reliability, data integrity, and performance optimization across various intelligence and defense applications.

Responsibilities :

  • Design and implement database solutions that are scalable, performant, and secure, aligning with DIA's mission requirements and IT data architecture standards.
  • Work closely with application developers, solution architects, Information Systems Security Officers (ISSO), and technical leads to build and integrate data polyglot(s) with other applications and ensure secure and seamless data flow and accessibility.
  • Conduct technical research and analysis of alternatives to identify technically and functionally advantageous approaches to identify database solutions that satisfy government validated functional requirements.
  • Integrate database architectures with government-specified technologies including, but not limited to, Oracle, PostgreSQL, Mongo DB, graph database engines, ElasticSearch, and caching technologies like Redis.
  • Build and manage Not Only SQL (NOSQL) database solutions, such as MongoDB, Cassandra, or Amazon DynamoDB with an understanding of the different types of NOSQL databases and when to use them based on the application requirements. This includes knowledge of designing and configuring NoSQL schemas, performing CRUD operations, and managing data replication and distribution in NoSQL databases.
  • Ensure developed capabilities are compatible with the network operating environment and architecture identified by the government.
  • Develop and maintain conceptual, logical, and physical data models to accommodate multiple intelligence domains and understand complexities of data transfer between the domains.
  • Collaborate with the ISSO to manage and update all authority to operate (ATO) documentation and processes in accordance with DIA policies and guidance.
  • Provide Tier 2 and 3 help desk support as defined by the government, potentially requiring multiple shifts to cover operations up to 24 hours per day.
  • Collaborate and communicate effectively with internal and external teams of software developers, data scientists, system administrators, stakeholders, and clients.

Required Qualifications :

  • Bachelor’s Degree and 12 years of relevant Database experience
  • Strong understanding of Structured Query Language (SQL) fundamentals such as creating tables, views, stored procedures, joins, and writing complex queries. This includes knowledge of advanced SQL concepts like indexing, normalization, transactions, query performance optimization, and database schema design.
  • Familiarity with database modeling tools like Cameo, ER / Studio, ERWin, or Toad Data Modeler can be useful for designing databases and generating database schemas.
  • Knowledge and familiarity with NOSQL databases such as MongoDB, Cassandra, or DynamoDB are often required due to their scalability and flexibility with semi-structured and unstructured datasets.
  • Experience with managed cloud database services such as Amazon RDS to perform tasks such as database migration, backup and disaster recovery strategies, and implementing cloud-native high availability and scaling.
  • Understanding of data security and privacy regulations along with knowledge of best practices and regulations like Risk Management Framework (RMF), Defense Information Systems Agency (DISA) Security Technical Implementation Guides (STIGs) guidance, and National Institute of Standards and Technology (NIST) Special Publication 800-53 catalog of database security controls.
  • Experience with database programming languages including SQL, stored procedures, database triggers : SQL, NOSQL
  • Excellent written and verbal communication skills to facilitate collaboration and teamwork among teams, ensure documentation is clear, concise, and comprehensive to serve as both deliverables as well as a guide to users, developers and future team members.
  • Active TS / SCI with CI Poly Required
  • If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Senior Database Architect?

    Sign up to receive alerts about other jobs on the Senior Database Architect career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $147,901 - $186,323
    Income Estimation: 
    $170,841 - $219,163
    Income Estimation: 
    $147,901 - $186,323
    Income Estimation: 
    $170,841 - $219,163
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $147,901 - $186,323
    Income Estimation: 
    $89,551 - $118,439
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $124,724 - $161,246
    Income Estimation: 
    $81,769 - $104,543
    Income Estimation: 
    $89,551 - $118,439
    Income Estimation: 
    $103,228 - $139,671
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Not the job you're looking for? Here are some other Senior Database Architect jobs in the Washington, DC area that may be a better fit.

    Senior Database Architect

    CGI Technologies and Solutions, Inc., Arlington, VA

    Senior Database Architect

    CGI, Arlington, VA

    AI Assistant is available now!

    Feel free to start your new journey!