Overview:
The Database Warehouse Specialist Senior supports the U.S. Coast Guard (USCG) Surface Forces Logistics Center (SFLC) modernization of logistics applications and workflows is essential to ensuring the sustainment of surface fleet operations and aligning with broader DHS digital transformation efforts.

Responsibilities:

• Maintain databases within an application area, ensuring the efficient implementation and modification of database systems.
• Develop and maintain ad-hoc queries, customizable to PI and project teams’ needs.
• Plan, coordinate, and implement security measures to safeguard computer databases.
• Serve as a liaison to various internal units, teams, and committees, and external vendors.
• Develop and implement a database management policy and standards for efficient QC and data administration. Collaborate with end users to identify needs and opportunities for improved data design, create, maintain, and manage Enterprise Data Warehouses (EDW), data lakes, data marts, Operational Data Stores (ODS), Extract Transform Load (ETL) solutions, XML, indexes, T-SQL and data manipulation scripts, stored procedures, views, functions, reports, and forms.

Qualifications:

• Maintain databases within an application area, ensuring the efficient implementation and modification of database systems.
• Develop and maintain ad-hoc queries, customizable to PI and project teams’ needs.
• Plan, coordinate, and implement security measures to safeguard computer databases.
• Serve as a liaison to various internal units, teams, and committees, and external vendors.
• Develop and implement a database management policy and standards for efficient QC and data administration. Collaborate with end users to identify needs and opportunities for improved data design, create, maintain, and manage Enterprise Data Warehouses (EDW), data lakes, data marts, Operational Data Stores (ODS), Extract Transform Load (ETL) solutions, XML, indexes, T-SQL and data manipulation scripts, stored procedures, views, functions, reports, and forms