Benefits:

Health insurance

Paid time off

Requirements:

Assist the State in database design and administration of Intelligrants database for disaster recovery grants management based on complexity of State use

Expertise and/or relevant experience in the following areas are mandatory:

Experience in Intelligrants grant management software database architecture

The duties of an Application Database Administrator include, but are not limited to:

· Knowledge and experience with DB2, Oracle, ADABAS, Microsoft SQL Server, Microsoft Access, PostgreSQL, and VSAM;

· 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;

· Recommend additional software based on the analysis of available software and Database Management System (DBMS) requirements;

· 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 insure data integrity, detection of missing data, late transaction reporting and untimely error correction;

· Evaluate and complete a 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.

This is a remote position.