JOB TITLE: DBA DB2 (Ref code: 121712-MELTAY-IOM-E-CHI)

LOCATION:  St. Paul, MN

DURATION:  Long Term

VISA TYPE: GC/Citizen/EAD

JOB DESCRIPTION:

This person will be responsible for supporting DB2, IMS, and Global SAP DB2 systems at 3 and maintain the systems at optimal performance, availability and efficiency.

Roles and Responsibilities:

- 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.

- Monitoring errors.

- Stay current with new database technology developments and techniques, research new software and tools, proactively recommend improvements

- Participate in on-call rotation to ensure 24/7 operations of these critical systems

Basic/Minimum Qualifications:

- Minimum three (3) years IT experience

- Minimum three (3) years experience mainframe DB2 and IMS

Preferred Qualifications:

- 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 environment (i.e. backup and recovery, reorgs, runstats, table partitioning, database cloning).

- 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

Please mention the job code in the subject line : DBA DB2 (Ref code: 121712-MELTAY-IOM-E-CHI).

For immediate response:

Contact: Ching, Ph: 703 859 8531, email: chingm@iormyx.com