Database Administrator

Job Family : Database Administration Travel Required : None Clearance Required : Active Top Secret (TS) What You Will Do : Supporting a premier law enforcement agency, the Database Administrator will lead the migration and on-going support of the MREF database architecture, the Oracle to Microsoft SQL or DB2 migration, data migration execution, and the backup and recovery posture. Support and execute the migration of the Oracle database to MSSQL or DB2 Develop the Data Migration Plan covering data inventory, mapping, transfer rules, data cleansing strategy, staging validation, rollback procedures, and government acceptance criteria. Execute at least three mock data migration runs prior to Go-Live and validate migration accuracy in staging with government-approved reconciliation reports before any production migration event.

Coordinate production migration timing with project leads to minimize operational impact and execute the data movement from the government data center to the cloud environment at cutover. Archive and store original system data in the data warehouse in hot storage per the client's data retention policy, with potential migration to cold storage, and preserve legacy TRIRIGA data for reporting needs during decommissioning. Design and implement data replication supporting the 4-hour RTO and 4-hour RPO and create required materialized and business views and replication to the data warehouse and reporting systems.

Perform and validate regular backups per the clie