Database Administrator

Roles and Responsibilities

Collaboration

• Work closely with ES FWS DDI (Ecological Services – Fish and Wildlife Service - Data division) management in developing and executing a strategic plan for our EDW (Enterprise Datawarehouse) to align with current platform cloud migration objectives and goals
• Work with DDI staff to ensure integration of data for various sources into the EDW, ensuring data quality, and consistency.
• Coordinate with multiple teams, including interfacing with engineering and project teams
• Work with US FWS staff, contractors, and vendors to build, manage, and maintain a solid EDW (Enterprise Datawarehouse), Extract, Transform, and Load (ETL) processes, and automations
• Collaborate with USFWS stakeholders to understand their reporting and analytical needs and to provide solutions that enable them to access and analyze data effectively

Database Management:

• Manage database maintenance and modification activities for the current legacy on-prem platform and support cloud migration efforts
• Work with DDI staff to ensure integration of data for various sources into the ES EDW, ensuring data quality, and consistency
• Manage the ETL processes to extract data from various source systems, transform it into the required format, and load its data into the ES EDW
• Design and enforce database standards, policies, and quality control measures
• Ensure data integrity, reliability, and overall database health