Apply on
Availability Status
This job is expected to be in high demand and may close soon. We’ll remove this job ad once it's closed.
Duties/Responsibilities
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 ensure 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.
Innosoft is an Equal Opportunity/Affirmative Action employer
Mandatory Experience
Ten (10) plus years of expertise and/or relevant experience in the following areas:
o SAP DB2
Desirable Experience
SAP HANA