Job Details
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.
Job Duties
- 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.
- Responsible for data migration, testing, support, maintaining and troubleshooting/debugging the data that support business units or support functions.
- 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.
- Prepare summary reports from the analysis findings that include illustrative tables and figures.
- Performance tuning our SQL database installations at either the server level, database level, or analyzing Query Execution Plans
- Creates thorough, professional-quality project documentation and technical specifications.
- Evaluates software change requests, determines business need or conducts root cause analysis, and implements technically efficient solutions.
- Assesses the impact of the changes and conducts tests to mitigate risks.
- Participates in and promotes a knowledge-sharing environment.
- Proactively recommends, schedules, and performs the improvements, hotfixes and upgrades.
- Recommends best practices and policies for data migration, as well as the usage of database applications in hosted environments.
- Troubleshooting problems with builds and tools
Requirements
- 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.
- 5+ years of experience designing and developing objects and components of relational database creating database schemas that represent and support business processes.
- Must have excellent written/verbal communication, presentation, and listening skills.
- Excellent collaboration/teamwork skills. Should be able to coach other developers and team members and review their deliverables.
- The following technical skills and experience are required: SQL Server, ORACLE, SSIS packages.
- Loading of the data from the flat files to SQL
- Knowledge on the linked server setup
Our client offers excellent benefits Including health, dental, and retirement!