Application Database Admin

Job highlights

Identified by Google from the original job post

Qualifications

Knowledge and experience with DB2, Microsoft SQL Server and HANA

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

SAP DB2

Responsibilities

Provide primary database architectural and administrative support (Data Modelling, 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, Flash copy, etc.; reorganize databases;

Conduct performance monitoring and tuning

Job description

Dice is the leading career destination for tech experts at every stage of their careers. Our client, JARM Property Management, is seeking the following. Apply via Dice today!

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 Modelling, 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, Flash copy, 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:

• SAP DB2

Application Database Admin