Role: Application Database Administrator
Location: Remote (PartTime)
Duration: 12 Months Contract
Job Summary:
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 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:
Expertise and/or relevant experience in the following areas are desirable but not mandatory: