What are the responsibilities and job description for the Senior Database Engineer position at BCMC?
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
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
