VIVA USA Inc Application Database Administrator in Johnston, Iowa

Req Ref No: JNIADA10 Location: Johnston, IA Duration: 9.0 months

Description

Description:

Works closely with the business and other Information Technology (IT) teams focusing on the processes of gathering, analyzing and documenting information requirements using standard data management tools and techniques for the creating, support and administration of database objects. Work is of medium to high complexity and moderate to high in risk. Has expanded contact with responsibility to varied and multiple departments and functional operations, and actively participates in strategic business relationships. Serves as an effective and key team member in various roles including serving as a team lead. Participates in the review and formation of work processes. May plan work and schedules for others on project-related work. Impact of decision-making is medium to high risk and impact. Serves as a consultant or expert and actively shares knowledge across workgroups. Applies information analyses to optimize the integration of major strategic business processes. Designs and implements complex changes impacting several processes with minimal direction. Primarily performs as an individual contributor, but may supervise a small work team (6 or fewer members).

Duties:

Leads the review and formation of processes to create and manage physical data models for applications, data warehouse, and data marts. Creates and manages logical data models for an enterprise and/or project level where projects are of medium to high complexity and moderate to high in risk. Documents and maps interaction between business processes, information, and data to ensure that business has data integration for projects which are of medium to high complexity and moderate to high in risk. Performs gap analysis (including problem resolution and change management) and evaluation between information requirements and the quality of design of database and database administration environment of vendor purchased and/or outsource solutions, actively working to share knowledge. Manages physical design and integration of databases to support information requirements where projects are of medium to high complexity and moderate to high in risk. Develops, implements, and supports methodologies, standards, and tools for data management such as metadata management, data mining, data modeling, data cleansing, transformation and matching, data stewardship, data quality, data integration, data security, and data marts. Provides input to design of application systems and interfaces to ensure data access, integration, integrity, and security for projects which are of medium to high complexity and moderate to high in risk. Leads the effort of performing database/application performance tuning, data transformation and mapping, backup, and recovery of application databases including design and development of disaster recovery procedures which ensure enterprise data consistency.

JDF Application Database Administrator

Specific Position Requirements

JOB DUTIES:

Respond to and address nightly abends or issues

Address end-user questions or concerns regarding databases

Monitor database activity and respond to any issues

Build or modify database structures

Assist with end-users query performance review by making SQL change suggestions or adding / modify indexes

Monitor and respond to database requests from end users and developers

REQUIRED:

Strong Mainframe DB2 DBA experience

SQL tuning experience

Experience using BMC suite of tools, including Catalog Manager, Change Manager, DASD Manager, AppTune, etc.

Experience using Power Designer, or equivalent data modeling tool

PREFERRED:

Experience coding in Cobol and/or Java

VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.