feedback icon
Summary

Thu Mar 22, 2018 - 4 weeks ago

Login or Register to vew

1 Views, 0 Applications

Senior SQL Server Developer

Kforce has a client that is seeking a Senior SQL Server Developer in New York, New York (NY). Responsibilities:
* Consulting services pertaining to the planning, management and operations of systems, procedures and guidelines for Real-Time Field Force
* Create data mapping between Oracle & SQL Server objects / attributes
* Create SSIS packages to facilitate data: change, conversion / transform, transfer between Oracle and SQL Server
* Create logical, physical data models
* Design and implement ETL logic to hold Oracle and MS SQL Server databases synchronized in near real time
* Performance Tune and Optimize queries
* Assist development teams in the build out of schema and database technologies
* Work in Agile environment
The agency has a need for an Microsoft SQL Server Developer to design, develop and deliver a back-end solution for the Real-Time Field Force project to build the following components:
* Geo-Location of Inspection devices and Inspection assignment
* Line of Travel Inspection (Detours)
* Non-Heat Complaint Inspection
* On-field work assignment
* Reinspection
* Contact Information
* External Property information integration
* Dispatch Center
* Administration Module
* Minimum 5 years of experience in SQL Server 2014, 2016; Oracle 11 (and higher) enterprise databases
* Minimum 5 years of experience in ETL solutions using SQL Server Integration Services (SSIS)
* Minimum 5 years of experience in Data Analysis, Conversion and Migration
* Minimum 5 years of experience creating Stored Procedures, Triggers, Functions, Indexes, Views, Joins and T-SQL code for applications
* Minimum 5 years of experience performance Tuning and Query Optimization techniques
* Minimum 3 years of experience in ETL logic to hold Oracle and MS SQL Server databases synchronized in near real time
* Minimum 3 years of experience in Visual Studio Team Foundation Server
* Experience in the build out of schema and database technologies
* Experience in implementing Data security strategies
* Demonstrate understanding of Agile or other Iterative development process
* Excellent communication skills and values accountability
* Exposure to Oracle DB technologies a plus
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.*Compensation Type:*Hours*Minimum Compensation:*0.00*Maximum Compensation:*0.00

loading...