Application Database Administrator

Smart IMS - Baton Rouge, LA

Part-time

Baton Rouge, LA

Professional, Scientific, and Technical Services

About the position

The Application Database Administrator role at Smart IMS involves providing architectural and administrative support for various database systems, including DB2, Microsoft SQL Server, and SAP HANA. The position requires extensive experience in database management, performance tuning, and ensuring data integrity. The role is part-time and focuses on overseeing database design, security, and recovery processes, as well as recommending software solutions based on system analysis.

Responsibilities

• Provide primary database architectural and administrative support including Data Modeling, Attribution, Referential Integrity, and Database Security.
• Evaluate and recommend changes to the database environment based on monitoring efforts.
• Oversee the physical database design including file characteristics, backup and recovery requirements, and security requirements.
• Recommend additional software based on analysis of available software and DBMS requirements.
• Supervise the installation and testing of DBMS software.
• Create and manage database objects such as schemas, views, tables, stored procedures, triggers, and indexing strategies.
• Ensure auditability of the database to maintain data integrity and detect issues.
• Evaluate and complete conversions from one database to another.
• Conduct backup and recovery operations using various methods.
• Reorganize databases and conduct performance monitoring and tuning.

Requirements

• Ten (10) plus years of expertise in DB2, Microsoft SQL Server, and SAP HANA.
• Experience in database architectural support and administration.

Nice-to-haves

• Experience with SAP HANA is desirable but not mandatory.