The DBA administers, maintains, develops, and implements policies and procedures for ensuring the security and integrity of the database.  Implements data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, replication, and other distributed data issues.

The DBA works under general supervision of the Technical Team Leader System Operations and works with the Technical Team Leader Software Engineers in a team environment.

The DBA recommends the creation and implementation of relational database standards, policies, and procedures, designed to improve the quality and security of the UI database (UIDB) and related information.  Contributes to and enforces programming standards as relates to the database.

The DBA maintains and enhances the Data Dictionary and communicates changes to the user community.  Reviews and approves the addition of databases, and/or tables and fields, based on data models and normalization techniques and following all OUI naming conventions and standards.

The DBA provides assistance to State system administrators and National Office users as requested.  Develops and disseminates correspondence in response to technical questions.

The DBA oversees or performs installation of database upgrades or new database products.  Develops acceptance test plans for all new/updated products.  Creates and maintains a problem log to record reported problems, and interacts with appropriate vendors to develop solutions to problems. The DBA also acts as point of contact for database vendor support.

The DBA controls data access and develops and establishes procedures to ensure data security.  The DBA also develops comprehensive failure contingency of operations plans and disaster recovery plans – as well as performs sizing and capacity planning for the UIDB.

The DBA performs backups and restorations of data files as well as data archiving.

The DBA also is responsible for overall design of the database to ensure the schema meets the goals and objectives for data usage within the UI program.

The DBA serves on workgroups dealing with the database.