Senior DBA / Data Modeler / Data Engineer

Location: Remote Required Clearance: Public Trust Required Education: Bachelors Required Experience: 10 years Position Description The DBA / Data Modeler / Data Engineer is responsible for designing, managing, and optimizing all data activities supporting the FSA IAM systems. This role ensures secure, accurate, and efficient data handling during the transition from the legacy AIMS and PAS systems to the new modern IAM solution and throughout ongoing operations. Responsibilities The DBA / Data Modeler / Data Engineer develops a comprehensive data transition plan to move existing AIMS and PAS data and legacy functionality into the new cloud-centric architecture. They create and maintain detailed file layouts, source-to-target mappings, conceptual, logical, and physical data models, and data dictionaries for all intersystem connections, loads, and extracts. The role includes designing and enhancing automated internal data sharing processes to support analytics for user accounts and potential fraud detection. Additional responsibilities involve supporting network management tasks related to data flows, capturing true user IP addresses for each action, implementing network edge protection, enabling analytic tagging and dynamic error messaging, maintaining application-specific information (ASI) documentation, and supporting AIMS token management data processes. They also contribute to environment support through database configurations, performance tuning, monitoring, backups, and