DB2 - IMS Database Administrator
LCI-Lawinger Consulting - Saint Paul, MN

This job posting is no longer available on LCI-Lawinger Consulting. Find similar jobs: DB2 jobs - LCI-Lawinger Consulting jobs

Job Summary:

This person will be responsible for supporting DB2, IMS, and Global SAP DB2 systems in a global FORTUNE 100 company

Roles and Responsibilities include but are not limited to the following:
  • Implementation of relational databases at an enterprise level
  • Provide expertise related to DB performance, HA, and scalability
  • DR Planning and execution in HA environments
  • Physical database tuning
  • Bulk loading of source data and source data conditioning
  • Database security and diagnostic maintenance
  • Capacity planning of database.
  • Database user security and permissions
  • Database automation through scripting and stored procedures
  • Evaluation and utilization of software products to assist in the management of data
  • Planning, installation, and maintenance of DBMS software
  • Support/recommend reporting, query and analysis tools ensuring efficient database access
  • Diagnosis of problems and resolution for application software
  • Measurement of DBMS performance and tuning; diagnosis of problems
  • Modification of system-level configuration to optimize performance
  • Interface with developers for performance and data access requirements
  • Development of standards and procedures for the DBMS environment
  • Consultation with system administrator regarding O/S - DBMS requirements
  • Maintenance of physical integrity of all production databases
  • Regularly scheduled verification procedures and error correction.
  • Participate in on-call rotation to ensure 24/7 operations of these critical systems


Three (3+years IT experience

  • Production support work experience with JCL, IMS Utilities
  • Experience with tools such as ENDEVOR, CA7, CA DB utilities and various performance and space reports.
  • 3+ years experience providing Database Administration support for the DB2 LUW and/or DB2 z/OS Database
  • Experience supporting the SAP application running on DB2 LUW or DB2 z/OS.
  • Experience with Red Hat Enterprise Linux
  • Experience with Database high availability technologies (i.e. HADR, Data Sharing, TSA). Experience in Shell/Perl scripting
  • Minimum 3 years experience with DBA support of Enterprise Resource Planning, Customer Relationship Management, Manufacturing Systems, Supply Chain Management, Supplier Relationship Management, or other relevant corporate systems
  • 1+ years in a regulated environment (SOX, FDA, etc.) subject to compliance controls
  • Excellent interpersonal, written and team collaboration skills

LCI-Lawinger Consulting - 13 months ago - save job - block