Database Administrator

The Database Administrator at the Informatics Research Institute at the University of Louisiana at Lafayette is responsible for the administration, maintenance, security, and performance of database systems. This position provides technical expertise in database architecture, data integrity, backup and recovery, performance optimization, and database security to ensure the availability, reliability, and efficient operation of critical business data. The Database Administrator reports to the Chief Technology Officer of the Informatics Research Institute. This is an on-site position in Baton Rouge, Louisiana. Duties and Responsibilities: 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. 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 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. Perform additional duties as assigned.