The US Census Bureau (USCB) is undergoing a digital transformation in preparation for the 2030 Decennial Census and seeks to integrate advanced technologies and techniques to enhance and scale up the Decennial System of Systems (SoS). The 2030 Decennial Census program will grow to become one of the largest, most innovative Federal Civilian production environments within AWS GovCloud. T-Rex Solutions LLC seeks a Senior Database Architect to lead the design and development of key data structures and models, including the Bureau's Person Characteristic File. This pivotal role directs the structuring and management of demographic data, enhancing USCB's capacity to deliver essential population insights. In this role, you will ensure that the data architecture effectively supports USCB's broad mission of providing accurate data to inform government decision making and provide the public with actionable population insights.

Responsibilities:

• Database Architecture: Lead the design and development of innovative database architectures tailored to enhance the functionality of the USCB systems. Drive the creation of robust, scalable databases that fully integrate across the USCB SoS ecosystem.
• Standards Development: Develop and enforce rigorous standards for database operations, including programming, querying, and security protocols, to ensure reliable and secure data handling within a multidimensional network environment.
• Large-Scale Design: Design and prototype the deployment of large-scale, multi-Terabyte database systems in support of USCB data handling needs and objectives.
• Technical Collaboration and Leadership: Work collaboratively with application engineering, DevOps teams, and data scientists to ensure full data and database integration and optimization. Provide technical leadership in data architecture and database design.

Requirements:

• Education and Experience: Bachelor's degree in Computer Science, Information Systems, or related field, with at least 14 years of professional experience in database architecture and design.
• Technical Expertise: Extensive experience with both relational and non-relational databases, preferably within the AWS ecosystem, including use of Python, Postgres, Redshift, Neptune/Graph DBs, and Vector DBs.
• System Integrity and Data Modeling: Demonstrated ability to manage complex information flows and develop data models that ensure the stability and security of production environments.
• Lifecycle Management: Proven record of overseeing the full development lifecycle of database solutions, from analysis and design through development and deployment.
• Security and Citizenship: US Citizenship is required with the ability to pass a Department of Commerce Public Trust investigation.

Desired Skills:

• Industry Experience: Experience with USCB and AWS technologies highly desirable.
• Advanced Data Handling: Proven capability in data engineering or data science, with practical experience using AWS SageMaker and other industry-standard data analytics tools.
• Professional Strengths: Strong analytical and problem-solving skills, excellent communication abilities, and a proven record of leading complex database projects that drive organizational success.

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 employee's 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, gender identity, 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.

As part of our overall strategy and commitment to maintaining a safe and healthy workplace, and in accordance with applicable regulations, employees of T-Rex must be fully vaccinated against COVID-19 if required by customer or client policies or federal mandates as a condition of employment, subject to reasonable accommodation and other requirements under applicable federal, state, and local law. If required by the customer, the selected individual will have to submit documentation of proof of vaccination before starting employment with T-Rex or have an approved exemption prior to the start of employment.

In compliance with pay transparency guidelines, the annual base salary range for this position is $145,000 - $210,000. 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, candidate's work experience, education/training, key skills, internal peer equity, as well as market and business considerations when extending an offer.