Database Engineer

T-Rex Solutions is seeking a Database Engineer to support database design development and maintenance for large-scale data processing systems in support of our US Census Bureau customer as we begin development on the 2030 Decennial Census. This role will work with cloud-native applications processing high-volume datasets and support database operations for statistical and administrative data systems.

This role offers excellent growth opportunities in a challenging technical environment supporting critical government statistical operations. The position provides exposure to modern cloud-native data architectures and large-scale data processing systems. Work will be performed on-site at least 2 days per weekat the Census Bureau facilities in Suitland MD with the remainder being remote.

Responsibilities:

• 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

Technical Environment

• Databases: PostgreSQL Amazon Redshift Vector DB NoSQL
• Cloud Platforms: AWS (S3 Glue Athena Kinesis QuickSight)
• Programming: Python SQL
• Tools: Git/GitLab Jenkins Maven Docker Terraform
• Data Formats: Iceberg various data storage formats

Requirements:

• Bachelors degree in Computer Science Information Systems or related field
• 1-3 years of experience with relational databases (PostgreSQL preferred)
• Basic knowledge of SQL query development and optimization
• Familiarity with cloud platforms (AWS preferred)
• Understanding of data modeling concepts and database design principles
• Experience with version control systems (Git)
• Strong analytical and problem-solving skills
• Excellent written and verbal communication skills
• Must be a U.S. citizen eligible for government background investigation

Desired Skills:

• Experience with Amazon Redshift Vector databases or NoSQL systems
• Knowledge of data warehousing and ETL concepts
• Familiarity with Python or other programming languages for data processing
• Experience with Amazon Web Services (S3 Glue Athena Kinesis QuickSight)
• Understanding of data quality frameworks and testing methodologies
• Knowledge of DevSecOps practices and CI/CD pipelines
• Experience with containerization (Docker) and infrastructure as code (Terraform)

T-Rex Overview

Established in 1999 T-Rex Solutions LLC is a proven mid-tier business providing data-centric mission services to the Federal government as it increasingly tries to secure and leverage the power of data. We design integrate secure and deploy advanced technical solutions for our customers so they can efficiently fulfill their critical objectives. T-Rex offers both IT and professional services to numerous Federal agencies and is a leader in providing high quality and innovative solutions in the areas of Cloud and Infrastructure Services Cyber Security and Big Data Engineering.

T-Rex is constantly seeking qualified people to join our growing team. We have built a broad client base through our devotion to delivering quality products and customer service and to do that we need quality individuals. But more than that we at T-Rex are committed to creating a culture that supports the development of every employees personal and professional lives. T-Rex has made a commitment to maintain the status of an industry leader in compensation packages and benefits which includes competitive salaries performance bonuses training and educational reimbursement Transamerica 401(k) and Cigna healthcare benefits.

T-Rex is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race religion color sex (including pregnancy and sexual orientation) parental status national origin age disability family medical history or genetic information political affiliation military service or other non-merit based factors.

In compliance with pay transparency guidelines the annual base salary range for this position is $70000 - $92000. Please note that the salary information is a general guideline only. T-Rex considers factors such as (but not limited to) scope and responsibilities of the position candidates work experience education/training key skills internal peer equity as well as market and business considerations when extending an offer.

T-Rex offers a diverse and collaborative work environment exciting opportunities for professional growth and generous benefits including: PTO available to use immediately upon joining (prorated based on start date) paid parental leave individual and family health vision and dental benefits annual budget for training professional development and tuition reimbursement and a 401(k) plan with company match fully vested after 60 days of employment among other benefits.