Senior Database Engineer
About The Position
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. 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.
Requirements
- 8+ Years of Experience
- Bachelor's Degree in Computer Science, Engineering, Management Information Systems, or an equivalent field
- Clearance: Unclassified, eligible for DoD SECRET
Responsibilities
- 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.
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Number of Employees
11-50 employees
