Back to jobs

MSSQL Database Administrator

Pay
Pay not listed
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Configure, tune, monitor and maintain MS SQL Server databases

  • Build and maintain SSIS ETL processes for applications

  • Create EDI translation maps for ANSI X12 and EDIFACT on IBM B2Bi

  • Monitor daily EDI transmissions and customer direct connections

  • Create SSRS and Power BI reports and data models

From the employer’s posting
Configure, tune, monitor, and maintain MS SQL Server 2008 R2 to 2016+.
Develop and maintain ETL processes and procedures for applications using SQL Server Integration Services (SSIS)
Create EDI translation maps based on ANSI X12 and EDIFACT, to be run on IBM B2Bi PaaS.
Monitor daily EDI data transmission over IBM VAN/B2Bi Mapping Engine.
Create reports and data models using SSRS and Power BI that meet business requirements

What you’ll bring

All qualifications

Core experience

  • Bachelor's Degree or equivalent experience in Computer Science, Technology, or a related field of study
  • Ability to read/translate EDI ANSI X12/EDIFACT documents for development of ETL processing
  • Ability to collect, analyze and translate business and user requirements into functional specifications
  • Ability to work alone with minimal supervision
  • 3+ years developing ad-hoc and automated reports using Excel, Pivot Tables, and T-SQL queries
  • Ability to build data algorithms for EDI forecast models (Cumulative Order Processing) or Consignment Inventory Management
Qualification wording
Bachelor's Degree or equivalent experience in Computer Science, Technology, or a related field of study
Ability to read/translate EDI ANSI X12/EDIFACT documents for development of ETL processing
Ability to collect, analyze and translate business and user requirements into functional specifications
Ability to work alone with minimal supervision
3+ years developing ad-hoc and automated reports using Excel, Pivot Tables, and T-SQL queries
Ability to build data algorithms for EDI forecast models (Cumulative Order Processing) or Consignment Inventory Management
Education & alternatives
Education/Training: - Bachelor's Degree or equivalent experience in Computer Science, Technology, or a related field of study - 3+ years developing ad-hoc and automated reports using Excel, Pivot Tables, and T-SQL queries
Apply at Rohm

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
5
Last seen by us
Nov 22, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 6 and day 56.

From 14,770 similar postings that came down. Coming down is not always a hire.

Rohm is hiring

3 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • T-SQL
  • Excel
  • Power BI
  • Power Query
  • SQL Server
  • SSAS
  • SSIS
  • SSRS
Where the posting names them
ROHM 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+.
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.
- 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)
- Develop ad-hoc queries and datasets for various management audits/requests - Work with users to explore ways we can use our existing technology stack (MS SQL Server, B2Bi, .NET) to automate their manual workflows - Develop and maintain stored procedures, views, and functions
- Pro-actively work with department to resolve problems and to cross-train other team members - Provide high-level MS SQL Server technical support for IT department. - Diagnose and resolve database access and performance issues
- Diagnose and resolve database access and performance issues - Work with IT department to test/update MS SQL Server disaster recovery plans Essential EDI Duties and Responsibilities (20%)
Essential 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 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.
- Bachelor's Degree or equivalent experience in Computer Science, Technology, or a related field of study - 3+ years developing ad-hoc and automated reports using Excel, Pivot Tables, and T-SQL queries - 2+ years of MS SQL Server 2008R2+Management (Users, Permissions, Schema Changes, Queries, Functions)
- 3+ years developing ad-hoc and automated reports using Excel, Pivot Tables, and T-SQL queries - 2+ 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 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 tools
- 2+ 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 certifications Background/Knowledge:
- Ability 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)
- 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)
- 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) required
- Ad-hoc development of reports using various tools (Access, Excel, SQL Reporting Services, T-SQL) - MS Office Suite (expert in Excel) required - Sterling Gentran v3-5.x experience is a plus
- Develop and maintain stored procedures, views, and functions - Create reports and data models using SSRS and Power BI that meet business requirements - Create and maintain technical documentation
- Maintain data warehouses (OLAP, SSAS) - Provide end-user training/support for accessing OLAP/SSAS via Pivot Tables & Power Query - Develop ad-hoc queries and datasets for various management audits/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 Query
- 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 tools - 2+ years of EDI Management (Trading Partners, Maps, Direct Connections, AnsiX12, EDIFACT)

Your next step

Complete your application on phg.tbe.taleo.net. The employer’s form will show what is required.

Already applied? Track this application

Has Rohm posted this job before?

Yes. We’ve followed one other MSSQL Database Administrator job there since November 2026. It is still up.

  1. Place not statedStill up after 3 days, first seen Nov 18
  2. This jobUp 3 days so far, first seen Nov 18

Job description

View original posting ↗

ROHM 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 Query
  • Develop ad-hoc queries and datasets for various management audits/requests
  • Work with users to explore ways we can use our existing technology stack (MS SQL Server, B2Bi, .NET) to automate their manual workflows
  • Develop and maintain stored procedures, views, and functions
  • Create reports and data models using SSRS and Power BI that meet business requirements
  • Create and maintain technical documentation
  • Pro-actively work with department to resolve problems and to cross-train other team members
  • Provide high-level MS SQL Server technical support for IT department.
  • Diagnose and resolve database access and performance issues
  • Work with IT department to test/update MS SQL Server disaster recovery plans

Essential 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 management

QUALIFICATIONS

Education/Training:

  • Bachelor's Degree or equivalent experience in Computer Science, Technology, or a related field of study
  • 3+ years developing ad-hoc and automated reports using Excel, Pivot Tables, and T-SQL queries
  • 2+ 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 tools
  • 2+ 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 certifications

Background/Knowledge:

  • Ability to read/translate EDI ANSI X12/EDIFACT documents for development of ETL processing 
  • Ability to build data algorithms for EDI forecast models (Cumulative Order Processing) or Consignment Inventory Management 
  • Ability 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) required
  • Sterling Gentran v3-5.x experience is a plus

Abilities/Attitude:

  • Ability to collect, analyze and translate business and user requirements into functional specifications 
  • Ability to produce documentation for all aspects of job function 
  • Ability to envision optimal system development and migration approaches 
  • Flexibility and adaptability to changing priorities 
  • Ability to work alone with minimal supervision 
  • Must have the ability to work independently and as part of a team 
  • Exceptional customer service, problem solving, and communication skills 
  • Positive customer service attitude while interacting with users 
  • Strong written, verbal, listening communication skills; communicate effectively with internal and external customers 
  • Stay abreast on new technologies 

    Demand for Data Engineer roles

    New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

    Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
    August 17Last week

    Each bar is one week of new postings. The darkest bars are the last 6 weeks.

    Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

    About the role

    We file this job under Data Engineer, by the work the posting describes.

    Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

    Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

    An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

    US government figures for database architects

    Median yearly pay, May 2025
    $139,500
    Expected change, 2025 to 2035
    9.4% more jobsagainst 3.5% for all jobs

    The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

    Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

    Source details

    View original posting ↗

    Source notes

    Source excerpts

    Selected passages from the saved posting. Check the full description for conditions and exceptions.

    Pay

    No pay amount identified in the saved description.

    Location & working pattern

    Location not supplied.

    ROHM 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%)
    Work authorization

    No clear work-authorization passage found. Eligibility is unconfirmed.

    Find answers in the posting

    AI
    How answers work

    AI selects complete passages from this posting. Check them for conditions and exceptions.

    Uses this posting and your question. No profile needed.