Senior Data Architect

Senior Data Architect

Senior Data Architect

ADS Federa is seeking a Senior Data Architect to join our team in supporting a Federal client in Washington, DC. The candidate will be expected to provide the following:

  • Define a data model and database design that is based on business needs
  • Stand up a relational database
  • Design and develop a data migration strategy and source to target mapping to migrate the data out of the legacy systems into the relational database

In addition, the candidate will be expected to perform the following:

  • Business Requirements Analysis
  • Data Modeling
  • Database Design
  • Educate both the project team and data warehouse team on the proper usage of the data structures
  • Provide application database administration support to development teams

SKILLS/REQUIREMENTS

  • Data Modeling, including reverse and forward engineering
  • Database Design: RDBMS, Data Warehouse, Data Mart and Data Mining
  • Data Modeling Tools: IBM Rational tools (InfoSphere Data Architect and Clear Case). Some experience with a data modeling tool is required; IBM InfoSphere Data Architect is USPTO’s current data modeling tool.
  • SQL and PL/SQL
  • MS Office Suite (Word, Excel, Visio, etc.)
  • Application DBA Skills
  • Java based technology Object Relational Mapping (ORM) tools – Hibernate, iBATIS and Java Persistence API (JPA) (nice to have)
  • PEGA Systems COTS, Case Management and Rules Engine experience (nice to have)
  • TOAD for MySQL and Oracle (nice to have)
  • Excellent Communication Skills (written and verbal)
  • MySQL
  • Oracle
  • Ability to analyze data sources and create import routines