Senior SQL Server DBA & Data Architecture Lead

Talentify; Lafayette (LA); On-site; USD 80,000 - 110,000; Full time

Job summary

The Informatics Research Institute at the University of Louisiana at Lafayette is seeking a Database Administrator to oversee the administration, security, and performance of critical database systems. This on-site role is based in Baton Rouge, Louisiana, reporting to the CTO.

Responsibilities include data modeling, backups, performance tuning, security, and ensuring data integrity across multiple DBMS environments. Collaboration with IT teams and development staff is essential.

Qualifications

• Three (3) plus years advanced DBA experience focused on MS SQL Server including maintenance, permissions, backups, complex SQL, and migrations.
• Five (5) plus years' experience with T-SQL, SSMS, and database maintenance plans.
• Five (5) plus years' experience with Microsoft SQL Server.
• Bachelor's degree in Information Technology, Computer Science, MIS, or related.

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 monitoring analysis.
• Oversee physical database design including backup/recovery, security, and space requirements.
• Supervise installation and testing of DBMS software; create/manage schemas, views, tables, stored procedures, triggers, partitions, clustering, and indexing strategies.
• Provide auditability of the database to ensure data integrity, explain missing data, late transactions, and error correction.
• Evaluate/complete conversion from one database to another (structure and data).
• Conduct backup and recovery via Image Copy, Flashcopy, etc.; reorganize databases.
• Conduct performance monitoring and tuning.
• Perform additional duties as assigned.

Skills

MS SQL Server

T-SQL

SSMS

Database maintenance plans

Education

Bachelor's degree in Information Technology/Computer Science/MIS

Tools

DB2

Oracle

ADABAS

Microsoft Access

PostgreSQL

VSAM

Job description

The Informatics Research Institute at the University of Louisiana at Lafayette is seeking a Database Administrator to oversee the administration, security, and performance of critical database systems. This on-site role is based in Baton Rouge, Louisiana, reporting to the CTO.

Responsibilities include data modeling, backups, performance tuning, security, and ensuring data integrity across multiple DBMS environments. Collaboration with IT teams and development staff is essential.