Lead Data Architect — AWS PostgreSQL & Modernization

Inadev; Reston (VA); Hybrid; USD 190,000 - 230,000; Full time

Benefits offered by this job

Hybrid schedule

Job summary

Inadev seeks a Lead Data Architect to define and drive the EDGAR data architecture, guiding modernization of high-availability, scalable, secure data platforms on AWS and open-source databases. You’ll set architectural standards, mentor teams, and collaborate with security and DevSecOps to meet federal requirements.

The role demands deep PostgreSQL expertise, cloud-native design, and strong leadership in a complex enterprise environment with hybrid work in Reston, VA and client sites in the DC

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related technical discipline.
• 10+ years of experience in database engineering, data architecture, or related disciplines.
• 5+ years in a senior or lead data architecture role supporting complex enterprise systems.
• Deep expertise with PostgreSQL and open-source relational database technologies.
• Strong experience designing database solutions in AWS.
• Experience with Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL.
• Strong knowledge of relational data modeling, normalization, indexing, partitioning, query optimization, and transaction processing.
• Experience architecting highly available, resilient, and scalable database platforms.
• Experience with database modernization and migration.
• Strong understanding of database security, encryption, access control, backup, recovery, and auditing.
• Experience supporting Agile and DevSecOps delivery environments.
• Strong technical leadership, communication, and architecture documentation skills.

Responsibilities

• Define and maintain the EDGAR enterprise data architecture and modernization roadmap.
• Establish architectural standards and patterns for relational, transactional, analytical, and distributed data workloads.
• Lead logical and physical data modeling across EDGAR applications and services.
• Define database design, partitioning, indexing, replication, availability, backup, recovery, and retention strategies.
• Conduct architecture and design reviews and provide technical direction to engineering teams.
• Establish standards for data quality, integrity, lineage, security, and lifecycle management.
• Architect cloud-native database solutions using AWS and PostgreSQL/open-source technologies.
• Design solutions using Amazon Aurora PostgreSQL, Amazon RDS for PostgreSQL, PostgreSQL, Amazon S3, AWS DMS, AWS Glue, and related AWS data services.
• Define patterns for highly available, fault-tolerant, scalable, and recoverable database environments.
• Evaluate database workload requirements and recommend storage, replication, caching, and performance strategies.
• Support infrastructure automation and repeatable deployment of database environments.
• Lead database modernization from legacy platforms to AWS-hosted open-source database technologies.
• Define migration, transformation, reconciliation, and validation approaches.
• Develop strategies to minimize application disruption and migration risk.
• Partner with application teams to identify and remediate database dependencies, incompatible features, stored procedures, schemas, and data-access patterns.
• Establish performance baselines and validate migrated database workloads.
• Establish database performance engineering and optimization practices.
• Lead analysis of complex database performance and scalability issues.
• Define monitoring, observability, capacity, availability, backup, and disaster-recovery requirements.
• Support architecture for mission-critical workloads requiring high levels of reliability and data integrity.
• Define database security architecture including encryption, access controls, secrets management, auditing, and data protection.
• Ensure data architecture aligns with SEC security and federal compliance requirements.
• Collaborate with cybersecurity and DevSecOps teams to incorporate security controls throughout the data lifecycle.
• Provide technical leadership and mentoring to database engineers, developers, and data specialists.
• Collaborate with application, cloud, integration, security, and DevSecOps architects to ensure cohesive end-to-end designs.
• Develop architecture documentation, standards, reference patterns, and technical decision records.
• Communicate complex data architecture decisions to both technical and non-technical stakeholders.

Skills

PostgreSQL

AWS

Data modeling

Performance tuning

Cloud-native architecture

Data architecture

Architecture standards

Education

Bachelor’s degree in Computer Science / related field

Tools

Amazon Aurora PostgreSQL

Amazon RDS for PostgreSQL

AWS DMS

AWS Glue

Amazon S3

Job description

Inadev seeks a Lead Data Architect to define and drive the EDGAR data architecture, guiding modernization of high-availability, scalable, secure data platforms on AWS and open-source databases. You’ll set architectural standards, mentor teams, and collaborate with security and DevSecOps to meet federal requirements.

The role demands deep PostgreSQL expertise, cloud-native design, and strong leadership in a complex enterprise environment with hybrid work in Reston, VA and client sites in the DC