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: Bachelors 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 (Base64encoded attachments) before transferring data from OutofBand (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:
- Ensure data transformation and export meet required formats including but not limited to:
- Transforming columns into XML rows within SQL .
- 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::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
11standard holidays & 3 weeks of annual leave
Required Experience:
Senior IC