Job Description
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
