MS SQL Server DBA (Hybrid)

Company: RemX Specialty Staffing
Location: San Diego
Posted on: January 25, 2023

Job Description:

RemX is partnered with our Sales & Distribution client to hire an MS SQL Server Database Administrator with experience managing EDI. The DBA will be responsible for data integration via EDI and MS SQL Server database. Will create, install and manage databases, ensure optimal DB performance by analyzing database issues and monitoring database performance. The position is a hybrid work schedule.

• 
  
• Configure, tune, monitor, and maintain MS SQL Server 2008 R2 to 2016+.
  
• Act as data expert to support employees and customer data analysis/report requests.
  
• Develop and maintain ETL processes and procedures for applications using SSIS.
  
• Maintain data warehouses.
  
• Develop ad-hoc queries and datasets for various management audits/requests.
  
• Work with users to automate manual workflows.
  
• Develop and maintain stored procedures, views, and functions.
  
• Create reports and data models using SSRS and Power BI.
  
• Create and maintain technical documentation.
  
• Provide high-level MS SQL Server technical support for IT department.
  
• Diagnose and resolve database access and performance issues.
  
• Analyze customer EDI/data specifications, business requirements, and integration needs to develop automated solutions to transfer customer data into MS SQL for transmission into MRP system.
  
• Point of Contact for EDI vendor, Customers, Staff and Overseas offices for EDI and general data transmission automation requests.
  
• Monitor daily EDI data transmission over IBM VAN/B2Bi Mapping Engine.
  
• Monitor customer direct data connections (AS2/SFTP/HTTPs/etc.).
  
• Utilize IBM B2Bi PaaS solution to translate customer EDI documents into formats compatible with MS SQL.
  
• Develop EDI reports for operations and management.
  

Keywords: RemX Specialty Staffing, San Diego , MS SQL Server DBA (Hybrid), IT / Software / Systems , San Diego, California