SAP Hana DB2 Administrator Part time Remote - Paramount Software Solutions

Title: SAP Hana DB2 Administrator

Location: Part time Remote - Louisiana

Duration: 12 Months

Description:

The scope of the proposed services will include the following:

· Knowledge and experience with DB2, Microsoft SQL Server and HANA

· Provide primary database architectural and administrative support (Data Modeling, Attribution, Referential Integrity and Database Security);

· Evaluate, and recommend changes to the database environment based on analysis of the monitoring effort;

· Oversee the physical database design including physical file characteristics, backup and recovery requirements, security requirements and physical space requirements dictated by the database design;

· Recommend additional software based on the analysis of available software and Database Management System (DBMS) requirements;

· Supervise the installation and testing of DBMS software; create and manage database objects schemas, views, tables, stored procedures, triggers, partitioning, cluster and indexing strategies;

· Provide the audit ability of the database to insure data integrity, detection of missing data, late transaction reporting and untimely error correction;

· Evaluate and complete a conversion from one database to another database (structure and data);

· Conduct backup and recovery via Image Copy, Flashcopy, etc.; reorganize databases;

· Conduct performance monitoring and tuning.

Expertise and/or relevant experience in the following areas are mandatory:

· Ten (10) plus years of expertise and/or relevant experience in the following areas:

o SAP DB2

Expertise and/or relevant experience in the following areas are desirable but not mandatory:

o SAP HANA