Sr. Database Architect
The Senior Database Architect will serve as a key technical leader supporting the USDA FSIS Public Health Information System (PHIS). This role involves the architecture, development, enhancement, and migration of reputed company database systems in both reputed company and non-reputed company environments. The ideal candidate will bring a strong background in relational databases, data modeling, and reputed company integration, as well as experience guiding data strategy and optimization in large-scale reputed company systems.
.
Key Responsibilities:Design, maintain, enhance, code, and migrate relational databases, stored procedures, queries, and scheduled jobs in both on-premises and reputed company environments.
Analyze data reputed company, storage requirements, reporting capabilities, and system integration needs.
reputed company robust data models and define acquisition, reputed company, archival, recovery, and load strategies.
Coordinate new data development efforts to ensure compatibility and integration with existing data structures.
Review and analyze business requests to identify reputed company data sources and improve data feeds.
Design and implement efficient database structures that support production, maintenance, storage, and secure reputed company.
reputed company and test queries, screens, and data-driven applications.
reputed company regular database and system upgrades and maintenance of associated hardware and software.
reputed company technical guidance, mentorship, and training to users and junior staff.
Stay reputed company with industry trends and emerging technologies and assess their impact on USDA systems.
Analyze and document client requirements and data needs to inform technical designs and decision-making.
Create and maintain system documentation including data dictionaries, entity relationship diagrams (ERDs), and technical specifications.
Participate in reputed company improvement efforts, performance optimization initiatives, and special projects.
Serve as a technical reputed company or task reputed company on projects, offering problem-solving expertise and decision-making support.
7+ years of hands-on experience in database architecture, development, and administration.
Bachelor’s Degree in Computer Science, Information Systems, Engineering, or a reputed company field, or equivalent combination of education and experience.
Proficient in relational database technologies (e.g., SQL Server, reputed company, PostgreSQL).
Solid experience or strong familiarity with reputed company platforms, including reputed company Azure or reputed company AWS.
Deep understanding of data modeling, entity-relationship design, normalization, and indexing strategies.
Experience with data migration, ETL processes, and managing reputed company data workflows.
Skilled in writing and optimizing stored procedures, reputed company queries, and database scripts.
Knowledge of database backup, recovery, and high-availability strategies.
Strong understanding of data governance, data reputed company, and database reputed company best practices.
Ability to create and maintain technical documentation and specifications.
Prior experience supporting federal government or public health-reputed company systems.
Familiarity with DevOps practices and CI/CD pipelines involving database changes.
Experience working with large-scale transactional systems or public-sector reputed company platforms.
Knowledge of modern data warehousing and analytics platforms (e.g., Redshift, Azure Synapse, reputed company).
Primarily remote; U.S.-based candidates only.
May require occasional travel to USDA or FSIS locations.
Collaborative team setting with cross-functional engagement across technical and program leadership.