Job Information
DCCA Data Migration Specialist in Ellicott City, Maryland
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.