T-Rex Solutions, LLC

Backend Engineer

• Design, develop, and maintain database schemas and data structures for PostgreSQL, Redshift, and Vector databases
• Support data pipeline development and ETL processes for high-volume data ingestion
• Implement and maintain data quality checks and validation processes
• Assist with database performance optimization and query tuning
• Support data storage solutions using Amazon S3, Iceberg, and other cloud storage technologies
• Collaborate with development teams on database integration for applications
• Participate in database monitoring, backup, and recovery procedures
• Document database designs, procedures, and data lineage
• Work on cloud-native applications processing high-volume datasets in support of the US Census Bureau 2030 Decennial Census

Database Engineer

Engineer

• Design, implement, and manage IAM policies, roles, and users within the AWS environment.
• Create and evaluate IAM policies, trust policies, and SCP policies to ensure secure access to AWS resources.
• Analyze policy statements service by service to identify excessive permissions or potential impacts to guardrails.
• Scope IAM policies to specific resources or conditions to maintain the principle of least privilege.
• Conduct regular audits and reviews of IAM policies to ensure compliance with security best practices and organizational policies.
• Collaborate with cross-functional teams to integrate IAM best practices into development and operational workflows.
• Develop and maintain documentation for IAM policies, procedures, and configurations.
• Respond to security incidents and perform root cause analysis to prevent future occurrences.
• Stay updated on AWS IAM services and industry best practices to ensure our environment is secure and compliant.
• Use AWS services like CloudTrail, CloudWatch, and Access Analyzer to audit existing policies and recommend changes based on actual usage.
• Help us review IAM changes that are needed when adding new services to the approved service catalog.

Database Engineer

Senior IAM Engineer