• Thorough understanding of the software development lifecycle
• Determines and documents database requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems to create or improve database solutions.
• Based on requirements, develops and implements data models for new projects, and maintains and/or enhances existing data models and data architectures.
• Creates graphics and other flow diagrams (including ERD) to show complex database design and database modeling more simply.
• Develop data structures for transactional systems; and
• Provides guidance for business intelligence systems, as required.
• Implements new database solutions and/or corresponding database changes to support new and modified applications and ensure that new designs conform to data standards and guidelines; are consistent, normalized, and perform as required; and are secure from unauthorized access or update.
• Creation of technical documentation for process and interface documentation
• Follow guidelines on creating data models and various standards relating to governed data. This includes the ability to appropriately classify personally identifiable information.
• Collects, queries, and analyzes data using standard database tools , applications, methods, and techniques for the purposes of creating normalized database solutions.
• Knowledgeable of Change Data Capture (CDC) for bulk data movement
• Ability to promote code from development environments to production
• Familiarity with GitHub or equivalent version control systems
• Experience with:
  • Oracle databases
  • Snowflake databases
  • SQLServer databases
  • Database Modeling tools, like DBSchema
  • Mainframe IMS hierarchical databases
• Knowledge of
  • Informatica
  • Microsoft SSIS

• Ability to provide status reports and project progress reports to stakeholders and project managers
• Performs related work as assigned

II.CANDIDATE SKILLS AND QUALIFICATIONS