DB2 Database Analyst
Lorven Technologies - Kansas City, MO

This job posting is no longer available on Lorven Technologies. Find similar jobs: DB2 Database Analyst jobs - Lorven Technologies jobs

Our Direct Integration Client is looking for a DB2 Database Analyst For a Long Term Project in Kansas City, MO below is the Detail requirement

Job Title: DB2 Database Analyst

Location: Kansas City, MO

Duration: Long Term

Job Description:
Technical/Functional Skills:
Demonstrable experience with:
o Linux DB2 administration

o Logical and physical DB modeling. Must be capable of converting a logical model into a physical model

o Writing and maintaining DB2 Stored Procedures

o Creating and maintaining indexes

o Creating and maintaining triggers

o DB performance analysis and tuning, including memory footprint, I/O, processor

o Linux administrator tools

o Database modeling tools, ER Studio preferred

o Java programming and JDBC s

Excellent written and verbal communication skills across multiple disciplines: architecture, development, operations, product, project management.

Self-starting

Ability to independently research problems and come up with solutions

Travel Industry experience a plus

Roles & Responsibilities:
Creation of physical DB definition

Initial DB set up for environment

Initial and ongoing sizing of database

Tuning of database and queries

Review of all database changes

Creation and maintenance of Stored Procedures

Monitor test environment for problems

Analyze and group database changes for implementation impact

Creation of implementation scripts

Hand off of DB changes to Production DBAs

Act as the Database administrator for test systems: Backup / recovery / reorgs / runstats etc / run scripts / troubleshoot