Important W-2 Information Click here to read more.

close

Questions? 1-888-481-3375

MS SQL Server DBA (Hybrid)

San Diego, CA

Apply Now

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.

Job Requirements

  • Bachelor's Degree or equivalent experience in Computer Science, Technology, or a related field
  • 3+ years experience with DBA of MS SQL Server 2008R2+ (Users, Permissions, Schema Changes, Queries, Functions)
  • 2+ years experience with SSRS, SSIS
  • 2+ years experience with ETL processes using SSIS and other 3rd party tools
  • Knowledge of EDI Management (Trading Partners, Maps, Direct Connections, AnsiX12, EDIFACT)
  • Ability to collect, analyze and translate business and user requirements into functional specs 
  • Ability to produce documentation for all aspects of job function 
  • Ability to work with minimal supervision 
  • Stay abreast on new technologies 
Apply Now