Data Developer

  • Windsor
  • Kamispro
We are seeking a high-performing Database Developer with scripting experience to migrate the data from sources to targets. This position will be client-facing and highly visible, with extensive opportunity for growth.<br><br>Candidates must be able to be onsite in Windsor, CT 1-3 days per week. <br><br><strong>Job Duties</strong><br><ul><li>Leads in defining, documenting and developing the plans and scripts, as well as contributing to data model design discussions, in collaboration with the project team.</li><li>Responsible for data migration, testing, support, maintaining and troubleshooting/debugging the data that support business units or support functions.</li><li>Perform data extraction, aggregation, and quality checking from the source's tables in support of trend identification, root cause analysis, and validation of the performance measures.</li><li>Prepare summary reports from the analysis findings that include illustrative tables and figures.</li><li>Performance tuning our SQL database installations at either the server level, database level, or analyzing Query Execution Plans</li><li>Creates thorough, professional-quality project documentation and technical specifications.</li><li>Evaluates software change requests, determines business need or conducts root cause analysis, and implements technically efficient solutions.</li><li>Assesses the impact of the changes and conducts tests to mitigate risks.</li><li>Participates in and promotes a knowledge-sharing environment.</li><li>Proactively recommends, schedules, and performs the improvements, hotfixes and upgrades.</li><li>Recommends best practices and policies for data migration, as well as the usage of database applications in hosted environments.</li><li>Troubleshooting problems with builds and tools</li></ul><br><strong>Requirements</strong><br><ul><li>9 or more years of related experience; or equivalent combination of education and experience with full software development life cycle (Waterfall and Agile), including design, testing, deployment, and documentation activities.</li><li>5+ years of experience designing and developing objects and components of relational database creating database schemas that represent and support business processes.</li><li>Must have excellent written/verbal communication, presentation, and listening skills.</li><li>Excellent collaboration/teamwork skills. Should be able to coach other developers and team members and review their deliverables.</li><li><strong>The following technical skills and experience are required: SQL Server, ORACLE, SSIS packages.</strong></li><li>Loading of the data from the flat files to SQL</li><li>Knowledge on the linked server setup</li></ul><br>Our client offers excellent benefits - Including health, dental, and retirement!