Role : Application Database Administrator
Location : Remote
Client : State of Louisiana Division of Administration/ Incom
Deadline for submission : 10/08/2024
The Office of Technology Services (OTS) was established as a means of recognizing cost savings through the consolidation of State IT assets and resources. The creation of OTS consolidated a wide variety of
existing hardware platforms operating systems database management systems networks third party software and custom applications. OTS leads the States technology procurement process in order to standardize technology over the entire organization seek efficiencies of operations maintenance and scalability of new products introduced to the OTS suite of services which can eventually be offered to all inscope agencies. The State seeks resources to provide maintenance and operational support for its SAP Enterprise Resource Planning (ERP) system.
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
Mandatory Experience
Ten (10) plus years of expertise and/or relevant experience in the following areas:
o SAP DB2
Desirable Experience
SAP HANA