Job Description
Job DescriptionWe are looking for an experienced Database Administrator to join our team in Allentown, Pennsylvania. This long-term contract position focuses on supporting a large-scale data migration project and ensuring the integrity of database operations. The ideal candidate will possess strong technical expertise and a proactive approach to problem-solving.
Responsibilities:
• Configure and deploy MySQL databases to support organizational data needs.
• Lead the migration of sensitive student and staff data from the Sapphire system to the PowerSchool platform.
• Perform data mapping and manipulation using specialized file formats to ensure seamless integration.
• Develop and execute scripts, including PowerShell and Excel macros, to automate data transformation processes.
• Conduct thorough data validation to maintain accuracy and compliance with security protocols.
• Collaborate with IT teams and leadership to align database solutions with project goals.
• Optimize database performance and troubleshoot issues to ensure uninterrupted operations.
• Document processes and provide technical support throughout the migration lifecycle.• Extensive experience working with MySQL and Microsoft SQL databases.
• Proven expertise in data migration processes across multiple platforms.
• Proficiency in scripting tools such as PowerShell and Excel macros.
• Strong ability to manipulate and transform large datasets with precision.
• Familiarity with data privacy regulations and handling sensitive information.
• Excellent analytical and problem-solving skills.
• Strong communication skills for effective collaboration with stakeholders.