Share this Job

Go Back

ERP Systems Administrator Location: Saint Paul, MN

,
2016-01-26 15:48:37
Job Type: Contract to Hire

Role: ERP Systems Administrator
Location: Saint Paul, MN
Responsibilities
  • Responsible for on-going growth and maintenance of Syteline.
  • Perform database maintenance and recovery, upgrades to support business functions and configure system to maximize performance. Personalize system forms, objects and functions to support business processes.
  • Write reports, install patches, query data, and design new applications.
  • Logical and physical database design to support new and existing applications, reports, data analysis tasks and systems development.
  • Working with other technology teams to monitor, plan, and implement the release of data across reporting, development, testing and production environments.
  • Evaluate and plan system upgrades and enhancements. Develop database specs, data dictionaries; design/coding standards, and appropriate documentation.
  • Run/build diagnostic tools to identify performance bottlenecks and take actions to improve performance. Provide regular updates on database health to stakeholders, provide backup and recovery solutions
  • Work with reporting and development teams to tune SQL queries.
  • Performs problem resolution and root cause analysis along with recommending and implementing preventive techniques.
  • Design and develop integration among multiple systems.
  • Help create and review system and software requirements.
  • Prepare test cases to perform verification and validation of software and data.
  • Follow relevant company procedures and help create and maintain relevant documentation.
  • Involvement in all aspects of the Information systems process.
  • Analyze user requirements and propose systems.
  • Analyze user requests for data and generate reporting.
Skills
  • 3+ years of Syteline or EPICOR Development and Support is required
  • Minimum 4 years of Database management and development experience usingSQL Stored Procedures, triggers, highly complex Queries and Reports.
  • MS SQL, Crystal Reports, SSRS, Business IntelligencePrefer Working Knowledge Developing And Maintaining Software Applications UsingC#, ASP.NET, JQuery/CSS/HTML, JSON
  • Experience in high availability database clustering a plus.
  • Experience working with Syteline ERP system in a manufacturing environment is a big plus.
  • Thorough understanding of advanced relational database concepts, including physical and logical database design.
  • Solid experience using MS SQL Server relational database.
  • Experience in data analysis, data warehousing/business intelligence, data base maintenance and performance tuning.
  • Experience in database disaster recovery and replication.

Key Skills:
N/A



Posted Date 2018-02-16 10:36:16
Posted Date 2020-10-19 11:39:01
Posted Date 2017-08-14 10:13:58
Posted Date 2022-03-17 10:51:07
Posted Date 2017-11-09 19:35:26
Posted Date 0000-00-00 00:00:00