Job Description :
SQL Developer and Performance Tuning expert
Location : North Bergen, NJ
Interview : Phone and F2F
Duration : 3+ Months
Visa : USC or GC
JOB DESCRIPTION :
Must have Skill set
SQL Server Database Development/Management
Performance Tuning/Automation
Communication (verbal and written)
Skill-Set Summary:
Must have 5 to7 years of experience in IT industry with specializedskillsin MS SQLServer, SQL Reporting Services, SQL Integration Services and SQL Analysis Services, MS Excel and Access Databases, C# . NET Programming Language.
Strong MS SQL Server 2005/2008/2008R2/2012 DeveloperSkills including writing StoredProcedures, User-DefinedFunctions, Triggers, ViewsandIndexes etc.
Experiencedinidentifyingdatabaseperformanceissue s, TroubleShootingthemandapplyingQueryOptimizationt echniques.
Highly skilled in SQL Server 2005/2008/2008R2/2012 Administrationincluding user authorizations, databasecreation, Backup and restoration.
Highexpertise increatingReports ofalltypes inSSRS, likeAd-hocReports, Drill-DownReports, Drillthroughreports, PivotandTabularreports.
Excellent ability to create complex SSRS templates and should be able to understand the report level and database level data manipulation to improve reports generation process.
Strong knowledge of ETL architectures for data transfers between two or more than two homogeneous or heterogeneous environments.
Experiencedincreatingpackages using varioustools(DTS/SSISImportExportData, DTS/SSISPackages, BulkInsertand BCP, SSIS) with using C#scripting languagefortransferreddatamodifications.
Excellent skills with Excel having ability to write expressions and Macros using VBA Editor.
Highly Skilled in creating various objects like Macros and Forms in Access database and able to connect it to various sources like MS SQL, MS Excel etc.
High Expertise in developing MS Windows Application Environment using C# . Net programming language, capable of supporting and handling complex business requirements.
Proficient in developing windows application using C# . Net programming language and connecting it to different data sources such as MS SQL, MS Access, and MS Excel etc.
Highly expert in developing optimized programming algorithms to satisfy business requirements in the most efficient way.
Good understanding of OLTP and OLAP information systems with ability to extract, transform and load data from OLTP to EDW.
WorkedonAgilescrumMethodologyanddesignedhighleve lETLarchitectureforoveralldata transferamong multiple environments usingSSIS.
As a partoftheteam, extensivelyinvolvedthrough theSoftware DevelopmentLifeCycle(SDLC) frominitial Planningthroughimplementationoftheproject. Capableofhandlingresponsibilities independentlyaswellasaproactiveteammember.
Fast learning capability, can adapt to the n-tier development environment, excellent communication, learning, problemsolvingandconceptualskills, abilitytoworkeffectivelyina teamenvironmentaswellasindividually.
Highly capable of understanding business requirements and able to fulfill them efficiently. A retail industry experience is a plus.
Degree Requirement:
Applicant should have at least Bachelor’s degree in Computer Science/Engineering or related field.