Senior Database Architect

Job Description

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 Skills

• 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

,

About Pinnacle Government Solutions, LLC

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.