MSSQL Database AdministratorRohm Semiconductor has an immediate career opportunity for an MSSQL Database Administrator with experience managing EDI (EDIFACT/ANSIX12). This position will be responsible for the data integration via EDI and in-house MSSQL database. This opening can be filled in any one of the following locales: California - San Diego County, Orange/Los Angeles County, Santa Clara County, or Novi, Michigan.
Ideally, hybrid work schedule preferred; fully remote may be considered. The ideal candidate will be responsible for creating, installing and managing our databases. You will ensure optimal database performance by analyzing database issues and monitoring database performance.Essential MS SQL SERVER RDMBS Duties and Responsibilities (80%)Configure, tune, monitor, and maintain MS SQL Server 2008 R2 to 2016+.Become in-house data expert to support employees and customer data analysis/report requests.Develop and maintain ETL processes and procedures for applications using SQL Server Integration Services (SSIS)Maintain data warehouses (OLAP, SSAS)Provide end-user training/support for accessing OLAP/SSAS via Pivot Tables & Power QueryDevelop ad-hoc queries and datasets for various management audits/requestsWork with users to explore ways we can use our existing technology stack (MS SQL Server, B2Bi,.NET) to automate their manual workflowsDevelop and maintain stored procedures, views, and functionsCreate reports and data models using SSRS and Power BI that meet business requirementsCreate and maintain technical documentationPro-actively work with department to resolve problems and to cross-train other team membersProvide high-level MS SQL Server technical support for IT department.Diagnose and resolve database access and performance issuesWork with IT department to test/update MS SQL Server disaster recovery plansEssential EDI Duties and Responsibilities (20%)Analysis of customer EDI/data specifications, business requirements, and integration needs to develop automated solutions to transfer customer data into MS SQL for transmission into our in-house MRP system.Provide a point of contact for EDI vendor, Customers, In-house 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.Create EDI translation maps based on ANSI X12 and EDIFACT, to be run on IBM B2Bi PaaS.Experience mapping Order and Financial EDI documents (ANSI X12: 820, 830, 862, 850, 856, 810, 820); (EDIFACT: ORDRSP, DELFOR, ORDERS, ORDRSP, DELJIT, DESADV, INVOIC)Development of EDI reports for operations and managementQualificationsEducation/Training:Bachelor's Degree or equivalent experience in Computer Science, Technology, or a related field of study3+ years developing ad-hoc and automated reports using Excel, Pivot Tables, and T-SQL queries2+ years of MS SQL Server 2008R2+Management (Users, Permissions, Schema Changes, Queries, Functions)2+ years of MS SQL Service 2008R2+Solutions using (SQL Server Integration Services, Analysis Services, Reporting Services)2+ years developing extraction, transformation, and loading("ETL") processes using SSIS and other 3rd party tools2+ years of EDI Management (Trading Partners, Maps, Direct Connections, AnsiX12, EDIFACT)Desired: 2+ years of experience in a similar technical role with applicable Microsoft SQL Server and IBM B2Bi certificationsBackground/Knowledge:Ability to read/translate EDI ANSI X12/EDIFACT documents for development of ETL processingAbility to build data algorithms for EDI forecast models (Cumulative Order Processing) or Consignment Inventory ManagementAbility to manage an IBM B2Bi PaaS installations (System Admin, Trading Partner Setup, Direct Connection Setup, EDI Document Mapping, etc.)Ability to manage a Microsoft SQL Server 2008R2 to 2016 installation (Users, Permissions, Schema Design, Auditing Logs, Backups/Restores)Ability to develop new solutions using MS SQL Server tools (SSMS, SSIS, SSAS, SSRS)Ad-hoc development of reports using various tools (Access, Excel, SQL Reporting Services, T-SQL)MS Office Suite (expert in Excel) requiredSterling Gentran v3-5.x experience is a plusAbilities/Attitude:Ability to collect, analyze and translate business and user requirements into functional specificationsAbility to produce documentation for all aspects of job functionAbility to envision optimal system development and migration approachesFlexibility and adaptability to changing prioritiesAbility to work alone with minimal supervisionMust have the ability to work independently and as part of a teamExceptional customer service, problem solving, and communication skillsPositive customer service attitude while interacting with usersStrong written, verbal, listening communication skills; communicate effectively with internal and external customersStay abreast on new technologies