Senior Database Developer - AWS/PostgreSQL

Position: Senior Database Developer – AWS/PostgreSQLLocation: Washington, DC Metro Area – Hybrid 3 days’Clearance: Ability to obtain a Public TrustAbout the RoleThis position will support the database layer of a large-scale federal enterprise data platform. The role is focused on designing, developing, optimizing, and maintaining databases that can reliably support high volumes of data and users.You’ll have significant ownership of database design and performance and will work closely with engineering and data teams to build scalable and well-governed data solutions.Key ResponsibilitiesDesign and develop scalable database structures and data models.Work extensively with Amazon Aurora (PostgreSQL-compatible), DynamoDB, and Amazon S3/Apache Iceberg.Perform database performance tuning, including query optimization, indexing, partitioning, and EXPLAIN-plan analysis.Develop and maintain PL/pgSQL stored procedures.Support schema changes, database migrations, and data-loading processes.Develop reliable data-loading patterns between S3 and relational/Iceberg data stores.Help establish appropriate database access controls and governance.Troubleshoot database and data-platform performance issues.Ensure data solutions meet the accuracy, security, and auditability expectations of a regulated federal environment.Required Qualifications7+ years of database development and/or administration experience.Bachelor's degree.Strong hands-on experience with PostgreSQL/Amazon Aurora.Experience with DynamoDB and Amazon S3.Experience with Apache Iceberg or similar large-scale data table technologies.Strong understanding of physical database design, including indexing, partitioning, and storage optimization.Experience tuning SQL queries and analyzing EXPLAIN plans.Strong logical and physical data modeling experience.Experience developing PL/pgSQL stored procedures.Ability to communicate effectively and work collaboratively with technical teams.Basic proficiency with Microsoft Word, PowerPoint, and Excel.Preferred QualificationsExperience with AWS Schema Conversion Tool (SCT) or other schema migration tools.Experience with Apache Ranger and data-access controls.Experience with graph databases such as Amazon Neptune or Neo4j.Federal IT or high-volume transaction environment experience.Familiarity with AI-assisted developer tools.What Makes This Opportunity InterestingThis is more than a traditional database development position. You’ll have the opportunity to take ownership of the database layer, work on large-scale data challenges, and contribute to the architecture and performance of a mission-focused federal data platform.