Application Database Administrator - Louisiana Technology Group Inc
Baton Rouge, LA
About the Job
Application Database Administrator: Part Time
Description/ 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.
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
Expertise and/or relevant experience in the following areas are desirable but not mandatory:
-SAP HANA