SQL Developer

Eminence IT Solutions Inc. North Carolina, United States
1 year - 3 years
$ 45
Posted: 2 years ago
salesflare
Part-time

Job Summary

Eminence IT Solutions, Inc. seeks SQL Developer for Cary, North Caroline office to participate in all aspects of Software Development Life Cycle (SDLC) including requirements analysis, software specifications and high/low level design, testing, and deployment. Analyze, design, develop, implement and test client/ server applications using Microsoft SQL Server, BI Suite.

Job Description

Eminence IT Solutions, Inc. seeks SQL Developer for Cary, North Caroline office to participate in all aspects of Software Development Life Cycle (SDLC) including requirements analysis, software specifications and high/low level design, testing, and deployment. Analyze, design, develop, implement and test client/ server applications using Microsoft SQL Server, BI Suite. Plan and implement MSSQL server security and database permission. Design, write and code logical/physical database, DTS packages, Microsoft Reporting Services (SSRS), Integration Services (SSIS), analysis service (SSAS), performance tuning and troubleshooting. Recommend optimal database design for database development, data migration, and data modeling. Maintain multi-tier application models, analyze & determine programming requirements, structures & processes & refine technical implementations. Test databases, correct errors and make necessary modifications. Develop Oracle packages, procedures, scripts on large databases. Write Oracle stored procedures, functions, and triggers. Perform database queries tuning and application tuning utilizing latest tuning concepts, including Explain Plan, materialized views and SQL optimizers. Provide upgrade, migration and patch management. Design and create logical/physical data models based on requirements. Plan and architect solutions. Design and code all aspects of solutions using Microsoft SQL Server best practices and industry standards. Design Workflows and assist developers to create new job designs and automate job sequences. Utilize Workflow manager to create Workflow sessions to define mapping sequence. May travel and relocate to various unanticipated sites throughout the United States.


Skills & Requirements: Must have Master’s degree in Computer Science, Information Systems, Engineering or related and 12 months of experience.


Please send the Resumes and cover letter to resumes@eitsinc.com

Keyskills