Database Administrator

Position Title: Database Administrator

Department: 9030IRI-Tech Transfer

Responsibilities:

The DatabaseAdministrator at the Informatics Research Institute at the University ofLouisiana at Lafayette is responsible for the administration maintenancesecurity and performance of database systems. This position provides technicalexpertise in database architecture data integrity backup and recoveryperformance optimization and database security to ensure the availabilityreliability and efficient operation of critical business data.
The DatabaseAdministrator reports to the Chief Technology Officer of the InformaticsResearch 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.

Qualifications:

RequiredQualifications:

• Three (3) plus years advanced DBA experience primarily focused on MS SQL Server. Experience should include routine maintenance managing user permissions running backups; writing debugging and optimizing complex SQL queries; and database migrations.
• Five (5) plus years experience with T-SQL SQL Server Management Studio (SSMS) and database maintenance plans.
• Five (5) plus years experience with Microsoft SQL Server.
• A Bachelors degree in Information Technology Computer Science Management Information Systems (MIS) or related.

PreferredQualifications:

• Knowledge and experience with DB2 Oracle ADABAS Microsoft Access PostgreSQL and VSAM.
• A graduate degree in Information Technology Computer Science Management Information Systems (MIS) or related.
• Experience working on a development team.
• Experience with client engagements on design delivery deployment and on-going maintenance.
• Previous experience working in an Agile/Scrum environment.

Job Ad#(req4495)

Required Experience:

Unclear Seniority