7 days ago
USA (city not specified)Senior
Responsibilities
- Design and maintain PostgreSQL data models on AWS RDS, including schema design, indexing, query optimization, and performance tuning.
- Write and review SQLAlchemy models and queries and develop Alembic migrations across environments.
- Support vector and similarity search capabilities for generative AI features.
- Build and maintain ingestion and embedding pipelines integrating with AWS Bedrock, including verification and validation.
- Support data flows for structured relational data and unstructured document content.
- Contribute to CI/CD pipelines using Jenkins and CloudBees and work in GitHub repositories.
- Evaluate data models and recommend optimizations as usage and data volume grow.
- Work within AWS GovCloud constraints, including IAM security and role-based access control.
- Partner with application engineers and other IT teams to improve the computing environment.
Requirements
- Bachelor's degree and at least 3 years of relevant industry experience.
- US citizenship required to obtain DHS Public Trust.
- Expertise in Python.
- Production experience with SQLAlchemy and Alembic, including live-database migrations.
- Advanced PostgreSQL and SQL knowledge, including query authoring, execution plan analysis, indexing, and performance tuning.
- Experience with AWS serverless services including Lambda, API Gateway, Step Functions, S3, and AWS RDS.
- Hands-on experience with vector search and embeddings using PGVector, OpenSearch Serverless, or a comparable vector store.
- Experience integrating with AWS Bedrock or comparable LLM and embedding APIs.
- Experience building and maintaining CI/CD pipelines, ideally with Jenkins and CloudBees, and using GitHub-hosted repositories.
- Experience with APIs and data formats including REST, JDBC, JSON, XML, and CSV.
- Familiarity with AWS IAM security and role-based access control.
Tech Stack
Categories
Data Engineering
About Amivero
Amivero is a woman-owned, privately held IT services firm delivering AI, automation, DevSecOps, cloud migration, cybersecurity, and data analytics to U.S. federal agencies. It builds and operates modernized government systems through agile software development and consulting engagements, with a focus on national security and public-facing digital services. Founded in 2018 and headquartered in Reston, Virginia, the company serves the federal market through multi-year contracts and task orders.