Position: Senior Database Engineer Start Date: April 3, 2025 Clearance: Unclassified, eligible for DoD SECRET Hours: 8:00 AM – 5:00 PM, Monday – Friday (excluding Government Holidays) Place of Performance: Remote Years of Experience: 8+ Education/Certification Requirements: Bachelor's Degree in Computer Science, Engineering, Management Information Systems, or an equivalent field Overview The candidate will support Oracle data transformation and migration services to transfer historical order, customer, and reference data from a production clone of the environment. Responsibilities include exporting data from the cloned environment and importing it into the new environment. Specific Duties - Perform data transformation to align with DMP requirements, including but not limited to: - Editing queries to meet size limits and specific formatting requirements. - Creating Materialized Views (MVs) to support the migration effort. - Editing and executing external scripts (e.g., PowerShell) to process, parse, and transform loader (.ldr) exports into XML (Base64-encoded attachments) before transferring data from Out-of-Band (OOB) sources. - Developing queries to meet import requirements. - Optimizing queries to ensure efficient data retrieval and processing. - Leveraging manual or automated processes to export data from the cloned environment and import it into production. - Validate import formats for various data types, including but not limited to: - JSON and XML formats. - Ensure data transformation and export meet required formats, including but not limited to: - Transforming columns into XML rows within SQL execution. - Using external PowerShell scripts to convert loader exports into XML. Our Company Overview: Business Computers Management Consulting Group, LLC (BCMC) is a small business specializing in Information Technology (IT), Cybersecurity, Information Assurance (IA), SOA, Big Data Management, Program Management, and more for Federal, State, and Local agencies. We possess highly skilled engineers, providing innovative solutions backed by strong past performances. We are ISO 9001:2015, ISO 27001:2013, 20000:2018, and CMMI L3 certified and registered promising highest quality and services to all of our clients. Benefits Extremely competitive salary 95% employer paid for employee medical, dental, & vision coverages 100% employer paid for employee life, STD & LTD disability coverages 401k with company match and profit sharing Flexible Spending Account (FSA) for dependent & health care 11 standard holidays & 3 weeks of annual leave