Get AI-powered advice on this job and more exclusive features. Job Overview: We are seeking a skilled SQL Server Developer with data migration experience to join our team. The ideal candidate will be responsible for designing, developing, and optimizing SQL databases and leading data migration efforts across different systems. The role requires expertise in SQL Server, ETL processes, and database performance tuning, ensuring data integrity and seamless transitions during migration projects. Key Responsibilities: Database Development & Optimization: Design, develop, and optimize SQL Server databases. Write complex queries, stored procedures, triggers, and functions for data processing. Ensure high availability and performance of databases. Data Migration & Integration: Plan, design, and execute data migration strategies. Perform data mapping, transformation, and validation for system migrations. Develop ETL processes using Datamart and Power BI embedded. Troubleshoot and resolve data migration-related issues. Data Quality & Integrity: Ensure data accuracy, consistency, and compliance with business rules. Identify and resolve data anomalies and inconsistencies. Implement data validation and reconciliation mechanisms. Deploy Configuration and Data: Manage the deployment of configuration and data from the Sandbox environment to Production, ensuring accuracy and readiness for go-live. Database Restructuring and Documentation: Restructure and rename database tables, columns, and other elements as needed whilst documenting our database for clarity and usability via our API for 3rd party clients. API Integration Support: Collaborate with the development team to ensure the database is optimized for client access through the API, providing support and documentation as required. Web Frontend Development: Help design a user-friendly web frontend to enable clients to perform data migrations independently, ensuring seamless functionality and intuitive navigation. Client Training and Support: Provide training and ongoing support to clients on using the web frontend and API for data migrations, addressing any issues or questions that arise. Process Improvement: Continuously evaluate and improve the data migration and deployment processes to enhance efficiency, reliability, and client satisfaction. Required Qualifications: Education: Bachelor's degree in computer science, Information Technology, or a related field. Experience: 5+ years of experience as an SQL Server Developer. 3+ years of hands-on experience in data migration projects. Technical Skills: Proficiency in MS SQL Server (2016 or later) . Strong expertise in stored procedures, views, triggers, and functions . Experience with Power BI, Datamart, or other ETL tools . Hands-on experience in data mapping, transformation, and validation . Knowledge of performance tuning, indexing, and database optimization techniques. Familiarity with Azure cloud-based multi-tenant database solutions . Soft Skills: Strong analytical and problem-solving abilities. Excellent communication and collaboration skills. Ability to manage multiple projects and meet deadlines. Detail-oriented with a focus on data accuracy. Seniority level Mid-Senior level Employment type Full-time Job function Information Technology Industries Software Development #J-18808-Ljbffr
Job Type
Fulltime role
Skills required
Azure
Location
Lexington, Kentucky
Salary
No salary information was found.
Date Posted
May 21, 2025
PlanStreet is seeking a skilled SQL Server Developer with expertise in data migration to design, develop, and optimize SQL databases. The role involves leading data migration efforts and ensuring data integrity across systems.