GovCIO

Data Migration Specialist

GovCIO

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

Salary

💰 $105,000 - $115,000 per year

Tech Stack

ETLJavaScriptOraclePostgresSQL

About the role

  • Conduct a comprehensive assessment of existing databases and systems, including schema, data, stored procedures, and applications.
  • Support the data migration effort, utilizing tools, custom scripts, or ETL processes to transfer data.
  • Provide technical experience regarding data models (logical and physical) database design development, data mining and segmentation techniques
  • Perform mass data imports/exports using the API or various import tools
  • Apply strong analytical skills to collect, organize, analyze, and distribute substantial amounts of information with meticulous attention to detail and accuracy
  • Ensure data integrity and accuracy during the migration process.
  • Implement effective indexing and caching strategies.
  • Document the entire migration process, including best practices, procedures, and configurations.
  • Assist with training and knowledge transfer to internal teams for ongoing support and maintenance.

Requirements

  • Ability to obtain a DHS Public Trust security clearance (US Citizenship Required)
  • Bachelor’s degree in information technology or related field, or the equivalent combination of education, professional training, or commensurate work experience
  • 5+ years of work experience
  • 3+ years of experience in data migration or related roles
  • Experience with ETL development tools and data warehouse architecture techniques
  • Working knowledge of databases (Microsoft SQL, Oracle, DB2), programming (XML, JavaScript, or ETL frameworks)
  • Knowledge of and experience using analytical reporting tools
  • Familiar with effective approaches and practical experience in data migration, data quality, master data management, and data security, including the use of relevant tools
  • Strong proficiency in scripting and automation for data migration tasks
  • Experience with performance tuning and optimization of PostgreSQL databases
  • Excellent problem-solving and troubleshooting skills.
Benefits
  • Employee Assistance Program (EAP)
  • Corporate Discounts
  • Learning & Development platform, to include certification preparation content
  • Training, Education and Certification Assistance*
  • Referral Bonus Program
  • Internal Mobility Program
  • Pet Insurance
  • Flexible Work Environment
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
data migrationETL processesdatabase designdata miningdata segmentationAPIindexing strategiescaching strategiesscriptingperformance tuning
Soft Skills
analytical skillsattention to detailproblem-solvingtroubleshootingdocumentationtrainingknowledge transfer
Certifications
DHS Public Trust security clearance