Please share profiles to *vinee...@1pointsys.com <vinee...@1pointsys.com>*
*Looking for Senior SQL Developer/Designer (.Net, SQL and Azure)* *NOTE: * We would hire someone who is very strong in *T SQL*, database design, performance tuning, batch packages and reports. However, our future needs require us to build more interfaces to enterprise products. Therefore, knowing .net related technologies as well is definite plus and will make a candidate stand out over the rest. *Looking for Senior SQL Developer/Designer (.Net, SQL and Azure)* *VISA : No H1b* *Location: Des Moines, IA* *7 months contract (possible extension)* *F2F interview only* *C2C, 1099 or W2* *Web interview for highly qualified candidates that meet and exceed skills. F2F is preferred* This position is for a SQL Database Designer / back-end developer with Transnational system development, ETL, and Analytical Reporting experience - please read the skills section and entire description for more detail. The successful candidate will spend a good portion of their time working with the Systems that support Child Care, Child Welfare, Medicaid, TANF, and SNAP Systems and expected to work in concert with Front End developer(s) troubleshooting system problem reports and processing enhancement requests. While working on system enhancements the successful candidate is expected to propose, design, and develop solutions in concert with the front end developer(s) to fulfill the business requirements. The successful candidate will be required to follow standard practices for migrating changes to the test and production environments and provide post production support. When not working on enhancement requests or problem reports, the candidate would concentrate on performance tuning. Preference will be given to those with Child Welfare, Medicaid, TANF or SNAP Individual should work well in a team and independently as needed. *Responsibilities:* • Assist in designing, developing, and enhancing large transaction and reporting databases. • Assist in converting existing Legacy applications to newer technologies • Assist in integrating in-house applications with enterprise third party solutions. • Design, create, and implement database systems based on the end user's requirements. • Develop database schemas, tables and dictionaries using SQL server 2008 R2, 2012, and 2016. • Translate business requirements into software applications and models. • Develop and maintain efficient, well documented custom SQL scripts, stored procedures, triggers using Microsoft T-SQL in accordance with defined business rules and requirements to support application development • Create and troubleshoot stored procedures and queries performances using SQL Server Profiler, Performance Monitor, DBCC Commands, Database Engine Tuning Advisor and Execution plans. Recommend query and index improvements in application to increase performance. • Thoroughly test all approved application and database code additions and changes prior to implementing to staging. Request approval from users prior to implementing any additions or changes to the production environment. • Research, understand and apply best practices, cost-effective solution, policies and procedures towards all assigned tasks, roles and responsibilities. • Use Microsoft Team Foundation Server (TFS) to manage changes to code. • Participate in requirement analysis discussions and come up with efficient technical solution • Develop new and maintain existing reports using SQL Server Reporting Services (SSRS) • Build and Deploy ETL processes using SQL Server Integration Services (SSIS). *Required Experience/Skills:* • Bachelor’s degree in Computer Science or related field or relevant work experience • Demonstrated experience with relational database design and implementation using MS SQL Server • Experience optimizing SQL queries for improving performance and maintaining data integrity • Experience in creating database migration scripts by using schema and data compare tools • Experience in creating batch packages using SSIS • Experience in creating reports using SSRS • Write efficient, consistent and testable code • Proficiency with using Visual Studio 2012,2015 & 2017 • Ability to understand and analyze the business requirements and come up with efficient technical solution • Experience in using LINQ • Being able work with minimal requirements and improve the functionality as requirements are refined • Technical understanding of infrastructure components, their dependencies, and interactions between servers, virtual systems, networks, databases, web applications, etc. • Demonstrated experience with Microsoft Azure cloud services is nice to have *NOTE: * We would hire someone who is very strong in T SQL, database design, performance tuning, batch packages and reports. However, our future needs require us to build more interfaces to enterprise products. Therefore, knowing .net related technologies as well is definite plus and will make a candidate stand out over the rest. *Skill matrix (Required):* • Experience with working with different versions of SQL server(2008 R2, 2012 and 2016) - 5 years • Expert knowledge of TSQL - 5 years • Database modeling & Design - 5 years • Experience in creating batch packages using SSIS - 3 years • Experience in creating reports using SSRS - 3 years • Experience optimizing SQL queries for improving performance and maintaining data integrity - 5 years *Skill matrix (Desired):* • Experience with C#, .NET framework, and object oriented design/development. - 5 years • Experience in the architecture, writing and maintenance of RESTful APIs/Services - 5 years • Experience in using LINQ - 5 years • Experience with Microsoft Azure cloud services - 1 year • Experience in using Power BI – 3 years • Proficiency with different versions of Visual Studio (2012,2015 & 2017) - 5 years *Skills Matrix:* *Required/Desired* *Actual* *last used* Experience with working with different versions of SQL server(2008 R2, 2012 and 2016) Required 5 Years Expert knowledge of TSQL Required 5 Years Database modeling & Design Required 5 Years Experience in creating batch packages using SSIS Required 3 Years Experience in creating reports using SSRS Required 3 Years Experience optimizing SQL queries for improving performance and maintaining data integrity Required 5 Years Experience with C#, .NET framework, and object oriented design/development Desired 5 Years Experience in architecting, writing and maintaining RESTful APIs/Services Desired 5 Years Experience in using LINQ Desired 5 Years Experience with Microsoft Azure cloud services Desired 1 Years Experience in using Power BI Desired 3 Years Proficiency with different versions of Visual Studio (2012,2015 & 2017) Desired 5 Years *Question* *Answers* Question 6 Interviews will be held on [November 14th and November 15th]*** IN-PERSON INTERVIEWS ARE STRONGLY PREFERRED and will take president; however, WEB interviews will be considered for candidates that exceed the REQUIRED & DESIRED. Work references are greatly appreciated. Question 7 Please provide candidates CURRENT LOCATION here: Question 9 The candidate's LEGAL NAME - FIRST and LAST should be accurately entered into the DETAILS tab before submitting the profile. Please verify that accurate information got entered in the appropriate fields. Personal Info: · Legal First name: · Legal Middle name: · Legal Last name: · Contact info (phone): · Contact info (email): · Visa status: · Current location: · Relocation: · Availability: · Direct employer info if C2C: · Rate (C2C or W2): · Latest Resume for the job (in word format): · Candidate willing to comply with the interview method and dates specified? · Have you applied to this client before? When? *VINEET SHARMA || **Recruiter* *Email : **vinee...@1pointsys.com* <vinee...@1pointsys.com> *Cell:* *(315) 987-0024* *Desk:** (**803**) **818-3474* *Ext: 112* *1 Point System LLC* 115 Stone Village Drive, Suite C, Fort Mill, SC (29708). Fax : 803-832-7973 | W : www.1pointsys.com Gtalk/Skype: vicky1point...@gmail.com LinkedIn: linkedin.com/in/vineet-sharma-11043aa4 <https://www.linkedin.com/in/vineet-sharma-11043aa4> -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to android-developers+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/android-developers/CAGJ1jhjQxqpOoBCkszL63%3DvCwf-DQ_b8J%2B43udmeNAc9k7Tuag%40mail.gmail.com.