SQL Developer-*W2 only*
Location:
Charlotte , North Carolina
Posted:
November 18, 2017
Reference:
6176747
Client Job Title:SQL Developer
Top Skills:

1. SQL Development Experience(5+ years)
2. DBA Experience.
Job Description: Responsible for design, development and management of high quality, efficient and effective solutions in Microsoft SQL Server T-SQL, Integration Services and related tools to support a number of large-scale data migration projects. Provide database performance-tuning expertise for internal and third party systems in SQL Server Environment. Provide technical knowhow on projects and work with third parties to understand how their software APIs support data migration.
Additional Information: * Identify and present solutions that promote the values of the company
* Production support and lead troubleshooting as needed
* Support account services team on escalated technical issues
* Quality assurance of system
* Design, develop and maintain ETL processes
* Develop SQL stored procedures and generate SSIS packages
* Produce and maintain technical documentation (ERDs, flow diagrams, business rules/ descriptions and security)
* System customization for new and existing installations.
* Create and maintain standard and ad hoc reporting for internal and external customers
* Deliver a robust, testable, repeatable framework of jobs and scripts for migrating data and producing reconciliation reports to confirm success or failure
* Work with third party suppliers to understand their software APIs and integrate them with your solutions to load and extract data
* Identify and solve performance bottlenecks in SQL Server and DB2 database platforms
* Manage SQL Server database environments that support data migration and backups and recoveries in test environments
* Only use approved technologies when developing systems and adhere to department, industry and regulatory standards
* Provide support for your solutions, including analysis, issue tracking and resolution. Take pro-active ownership of support tasks and see them through to completion
* Report progress on development at daily stand-ups and escalate issues or slippage in a timely fashion, identifying remedial action to keep the project on track
* Demonstrate a logical and structured approach to time management and task prioritization. Work within project timelines and budgets. Be able to organize own time, schedule tasks for completion and deliver work to that schedule
* Excellent working knowledge of the functionality and capabilities of MS SQL Server 2008 R2, DB2
* Desired Database Administrator and very strong SQL Developer with excellent T-SQL and experience of SQL Server Integration Services and strong knowledge of ETL techniques
* Good experience of large-scale data migration projects with multiple data sources and familiar with Extract-Transform-Load patterns and processes
* Strong background in data modelling, data management and data manipulation, code management and version control
* Any experience of Healthcare industry and in particular HIPPA and PHI rights management is useful.
* Work within a professional, dynamic and creative agile development team to support delivery of a major program of change that will bring significant business benefit
* Responsible for defining technical requirements, working with non-technical members of the Data Migration Team
* Design, develop and maintain appropriately-scaled, effective solutions to support data cleansing, migration and reconciliation activity in Microsoft SQL Server T-SQL, Integration Services and related tools
* Ensure design and development take into account all aspects of requirements - including data quality, customer experience, architecture, security & operations - so that software is fit for purpose
* Ensure all development goes through appropriate approval, test and deployment processes
* Manage source code and version control using TFS.
* Work independently or in conjunction with other developers as the work requires. Participate fully in team planning and work with colleagues to continuously improve the team's performance
* Create and maintain strong working relationships with other members of the delivery team and the wider technology organization. Engage professionally with customers and suppliers as required
* Accurately estimate the time and materials required to complete a piece of development work
* Ensure design and development take into account all aspects of requirements - including data quality, customer experience, architecture, security & operations - so that software is fit for purpose

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please call 888 472-3411 or email accommodation@teksystems.com for other accommodation options.

A little about us:
TEKsystems provides corporations with IT staffing, talent management expertise and IT services, enabling them to meet their business objective.

Know someone who would be interested in this job? Share it with your network.