Data Migration Specialist Location Ellicott City, MD Job Code 2224 # of Openings 1 Apply Now (https://phg.tbe.taleo.net/phg02/ats/careers/v2/applyRequisition?org=DCCAMD&cws=39&rid=2224) DCCA is a veteran-owned IT business specializing in providing innovative solutions to a variety of government agencies and commercial enterprises since 1982. DCCA is proud to offer career growth opportunities and a competitive compensation and benefits package. Visit our website at: www.dcca.com Data Migration Specialist Candidate must have or be willing to obtain a Public Trust Clearance DCCA is looking for an experienced Data Migration Specialist to lead the migration of the customer’s legacy data in Microsoft SQL Server to a defined modernized Postgres RDS data model. · Utilize data conversion and migration skills and oversee conversion script development, including tuning queries · Support data loading, monitoring progress, resolving data transition issues and reporting errors · Identify and analyze issues, make recommendations, and escalate issues as needed for resolution in a timely manner · Develop data migration process flows and prepare documentation describing the data migration approach · Perform data mapping of source-to-target data sets · Develop data migration execution plans · Lead efforts during test data migration exercises and refine conversion scripts · Facilitate cross-team collaboration to resolve any dependencies Required Skills: Proven experience: · 5-8 years of proven experience: o SQL database, preferably Amazon RDS for PostgreSQL and Microsoft SQL Server 2019 o NiFi ETL for data migration · Technical experience developing/supporting lutions using Amazon Web Services (AWS) · Supporting databases in the AWS Cloud · Exceptionally strong communication skills, verbal and written. · Applicants shall have lived in the United States at least three (3) out of the last five (5) years. · Excellent Communication skills Desired Skills : · Proven experience with: o Working in an Agile SCRUM environment o Collaborating in a multiple contractor environment o Previous experience working with financial data is preferred o Proficient in MS Word, and MS Excel Education/Certifications: · Computer Science degree or Bachelor’s degree in a related major. Candidate must have or be willing to obtain a Public Trust Clearance. COVID Safety Requirements DCCA is committed to the safety of our workforce and customers, adhering to COVID-19 Safety Protocols as required by the company, our customers and the Safer Federal Workforce Task Force. Some customer facilities require all employees to provide proof of vaccination status as a condition of employment, subject to approved medical or religious accommodations. Mask wearing and frequent COVID testing/attestation may also be required. DCCA is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, or disability status.