LexingtonRecruiter Since 2001
the smart solution for Lexington jobs

ERP Database Administrator

Company: Premier Staffing Solution LLC
Location: Georgetown
Posted on: June 25, 2022

Job Description:

Job purpose
The ERP Database Administrator is responsible to develop, test and implement solutions that efficiently and effectivelyintegrate with ERP and production systems to fulfill business objectives. Design and update software database.Implement data models and database designs, data access and table maintenance codes; resolve databaseperformance issues, database capacity issues, replication, and other distributed data issues. This role will be responsiblefor system audits, conduct testing for business processes, and provide training for all users. The role will also beresponsible for evaluating, responding, and troubleshooting ERP application issues within a timely and professionalmanner.
Duties and responsibilities

  • Identify and resolve system issues using ERP solutions.
  • Identify ideas to improve system performance and impact availability.
  • Experience with SQL, and an understanding of PowerShell, HTML5, CSS3, JavaScript, Java, Python, C++, or other programming language(s).
  • Initiate and lead ERP related projects and provide day to day support.
  • Support integration of changes in test, preproduction, and production environments, evaluating problems and determining required course of action.
  • Clearly and regularly communicate with management and technical support colleagues.
  • Translate logical data models into physical database designs and develops physical databases and assists in establishment of database system flows.
  • Develop and maintain enterprise data documentation, metadata models and database requirements that are provided to system administrators.
  • Develop and improve reports, dashboards, and supporting process flows to provide reliable, accurate, and timely visibility into our business.
  • Test, maintain and recommend software improvements to ensure strong functionality and optimization.
  • Monitor, analyze, troubleshoot, and resolve application and database performance and calibrate Database
  • Management Systems (DBMS) parameters ensuring optimal database performance and availability.
  • Maintain development, production, and testing environments.
  • Independently install, customize, and integrate commercial software packages.
  • Plan and manage the migration of databases.
  • Install, configure, and maintain the database management systems software.
  • Build scripts automating the daily operations of database management.
  • Monitor transactions between application systems and the database for the purpose of identifying and improving inefficiencies.
  • Implement database backup and recovery procedures.
  • Control privileges and permissions to database users and assure appropriate information security is applied in all tasks.
  • Provide production support/database access 24 hrs. X 7 days a week. Conducts level 2 support.
  • Research and evaluate emerging database technologies.
  • Interacts with Managers and other departments on daily operations and ERP problems.
  • Provides training of ERP system to users.
  • Assist users in resolving problems and answer questions with minimal supervision.
  • Perform related duties based on departmental need. This job description can be changed at any time.
  • Other duties as assigned.
    Qualifications
    • Bachelor's Degree in related field.
    • Six (6) years of relevant work experience and/or other specialized training can be used in lieu of education requirement.
    • Excellent communication skills, verbal and written.
    • Highly responsive to calls and emails.
    • 3+ years' experience in a hands-on role supporting one or more systems (preferably manufacturing).
      Working conditionsRequires working in open office with occasional visits to shop floor.

Keywords: Premier Staffing Solution LLC, Lexington , ERP Database Administrator, IT / Software / Systems , Georgetown, Kentucky

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest Kentucky jobs by following @recnetKY on Twitter!

Lexington RSS job feeds