Database Administrator

Guidehouse•Dc, DC

9d•$113,000 - $188,000

About The Position

The Database Administrator will support a premier law enforcement agency by leading the migration and ongoing support of the MREF database architecture. The role includes migrating Oracle databases to Microsoft SQL Server or DB2, executing data migration, and supporting backup and recovery operations. The administrator will develop and execute a data migration plan, perform mock migrations and staging validation, coordinate production cutover, and preserve original and legacy data in accordance with retention requirements. The role also includes designing replication to meet recovery objectives, creating views and data warehouse replication, performing backups, testing disaster recovery and business continuity procedures, and supporting databases in sustainment. The position contributes database flow and backup documentation to the as-built architecture and helps create and maintain the MREF data dictionary for business intelligence and data warehouse efforts. An active and maintained Top Secret clearance and U.S. citizenship are required.

Requirements

Eight years of experience as a Database Administrator, including database design.
Microsoft SQL Server or DB2 and Oracle administration experience.
Bachelor's degree; four additional years of relevant experience may substitute for formal education or an advanced degree.
U.S. citizenship.
Active and maintained Top Secret Federal or DoD security clearance.

Nice To Haves

Eight years of database administration experience, including three years supporting IBM Maximo, MREF, or TRIRIGA databases and two years in a Federal accredited environment.
Enterprise-scale Microsoft SQL Server, DB2, and Oracle administration, including cross-platform migration from Oracle to Microsoft SQL Server or DB2.
Knowledge of TRIRIGA and MREF schema structures, performance tuning, and execution plan analysis.
Experience with ETL and bulk data migration tooling, staging design, rollback procedures, and reconciliation reporting.
Replication design supporting defined RTO and RPO objectives and materialized and business view design.
Knowledge of encryption, database auditing, and privileged access separation of duties under FBI IT security policy.
Knowledge of data retention, archival, hot and cold storage tiering, and legacy data preservation for decommissioning.
Microsoft SQL or DB2 Database Administrator-related certification or Oracle Certified Professional certification.

Responsibilities

Support and execute migration of Oracle databases to Microsoft SQL Server or DB2.
Develop a data migration plan covering data inventory, mapping, transfer rules, data cleansing, staging validation, rollback procedures, and government acceptance criteria.
Execute at least three mock data migration runs before go-live and validate migration accuracy in staging using government-approved reconciliation reports.
Coordinate production migration timing with project leads and execute 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 according to client retention policy, with potential migration to cold storage.
Preserve legacy TRIRIGA data for reporting during decommissioning.
Design and implement data replication supporting a four-hour RTO and four-hour RPO.
Create required materialized and business views and replication to the data warehouse and reporting systems.
Perform and validate regular backups according to client retention and recovery policy.
Maintain and annually test disaster recovery and business continuity procedures.
Provide ongoing database support during sustainment.
Contribute database internal data flow and backup descriptions and diagrams to the as-built architecture.
Contribute to creation and maintenance of the MREF data dictionary supporting business intelligence and data warehouse efforts.

Benefits

Medical, prescription, dental, and vision insurance
Personal and family sick time
Company-paid holidays
Parental leave
401(k) retirement plan
Group term life and travel assistance
Voluntary life and AD&D insurance
Health savings account
Health care and dependent care flexible spending accounts
Transit and parking commuter benefits
Short-term and long-term disability
Tuition reimbursement
Personal development, certifications, and learning opportunities
Employee referral program
Corporate-sponsored events and community outreach
Care.com annual membership
Employee assistance program
Supplemental benefits, including critical care, hospital indemnity, accident insurance, legal assistance, and identity theft protection
Position may be eligible for a discretionary variable incentive bonus