Database Administrator

US132 Guidehouse Digital, LLC; Washington (District of Columbia); On-site; USD 113,000 - 188,000; Full time

Benefits offered by this job

Medical

401(k) Retirement Plan

Parental Leave

Group Health Insurance

Job summary

Guidehouse is seeking a senior Database Administrator to lead the migration of the MREF database architecture from Oracle to MSSQL/DB2 and oversee backup, recovery, and data replication. The role requires active TS clearance, US citizenship, and 8+ years in DBA with strong design and cross-platform expertise.

You will coordinate data movement, develop migration plans, validate results against government acceptance criteria, and contribute to the as-built architecture and data dictionary.

Qualifications

• Eight years of experience as a Database Administrator with database design.
• Experience administering SQL Server, DB2 and Oracle environments.
• Bachelor's degree or four additional years of relevant experience; US citizenship.
• Active and maintained Top Secret clearance.

Responsibilities

• Lead migration from Oracle to MSSQL/DB2 and ongoing DB architecture support.
• Develop data migration plan including inventory, mapping, transfer rules and validation.
• Execute mock data migrations and validate staging with government reports.
• Coordinate cutover timing to minimize operational impact and move data to cloud.
• Archive original data and preserve legacy TRIRIGA data for reporting during decommissioning.
• Design data replication to meet 4-hour RTO and 4-hour RPO; create views and data dictionary.
• Perform regular backups and test disaster recovery and business continuity procedures.
• Contribute to as-built architecture and data flow documentation.

Skills

SQL Server administration

DB2 administration

Oracle administration

Database design

Education

Bachelor's degree

Tools

ETL tooling

Job description

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 clients retention and recovery policy.
• Maintain and annually test disaster recovery and business continuity procedures.
• Provide ongoing database support in sustainment and contribute the 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 the business intelligence and data warehouse efforts.

What You Will Need:

• Eight years of experience as a Database Administrator, including database design.
• Microsoft SQL Server or DB2 and Oracle administration
• Bachelor's degree (FOUR (4) additional years of relevant experience may be substituted for formal education or advanced degree).
• US Citizenship is required.
• An ACTIVE and MAINTAINED TOP SECRET Federal or DoD security clearance

What Would Be Nice To Have:

• Eight (8) years of database administration experience, including three (3) years supporting IBM Maximo, MREF, or TRIRIGA databases and two (2) years in a Federal accredited environment.
• Microsoft SQL Server, DB2 and Oracle administration at enterprise scale, including cross-platform migration from Oracle to Microsoft SQL or DB2 TRIRIGA and MREF schema structures; performance tuning and execution plan analysis.
• ETL and bulk data migration tooling, staging design, rollback procedures, and reconciliation reporting.
• Replication design supporting defined RTO and RPO objectives; materialized and business view design.
• Encryption, database auditing, and privileged access separation of duties under FBI IT security policy.
• Data retention, archival, hot and cold storage tiering, and legacy data preservation for decommissioning.
• Microsoft Certified: Microsoft SQL or DB2 Database Administrator related; Oracle Certified Professional.
• The annual salary range for this position is $113,000.00-$188,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.

What We Offer:

• Medical
• Rx
• Dental & 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 & Dependent Care Flexible Spending Accounts
• Transit and Parking Commuter Benefits
• Short-Term & Long-Term Disability
• Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities
• Employee Referral Program
• Corporate Sponsored Events & Community Outreach
• Care.com annual membership
• Employee Assistance Program
• Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.)
• Position may be eligible for a discretionary variable incentive bonus

About Guidehouse

Guidehouse is an Equal Opportunity Employer-Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation.

Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.

Guidehouse is a global AI-led professional services firm delivering advisory, technology, and managed services to the commercial and government sectors.

With an integrated business technology approach, Guidehouse drives efficiency and resilience in the healthcare, financial services, energy, infrastructure, and national security markets.

Built to help clients across industries outwit complexity, the firm brings together approximately 18,000 professionals to achieve lasting impact and shape a meaningful future.

guidehouse.com