*Position: SQL DeveloperLocation: Wayne, PADuration : 6 Months Responsibilities & duties (Mandatory)*
Microsoft SQL Developer with 7 to 9 years of experience working as part of a team developing .NET and SQL applications with the following responsibilities and skills. Hands on SQL Programming, Reporting on MS SQL server and MS SQL databases. Able to understand existing Reports, Modify the reports, create new reports. Ability to Troubleshoot and resolve issues relating to database integrity, database performance (deadlock, blocking, etc.) Provide solutions, able to write complex procedures. *Project Description (Mandatory)* The SQL developer, who can maintain & support the set of SQL Databases and SQL Programs, based applications for wireless insurance business. Hands on SQL Programming, Reporting on MS SQL server and MS SQL databases. Able to understand existing Reports, Modify the reports, create new reports. *Work experience & skills (Mandatory)* *Essential Skills* (including minimum years of experience required for each skill) Microsoft SQL server 2005, 2008, SQL Programming, SSRS and Crystal Reports · MS SQL Server · Able to Troubleshoot and resolve issues relating to database integrity, database performance (deadlock, blocking, etc.) · Assist in developing and troubleshooting SQL code, indexes, stored procedures, functions, etc. · Experience in Data Modeling, Database design and well versed with SQL Server best practices · Hands-on SQL programming skills. · Adhoc reporting, Parameterized Reports, Custom Reporting Developed interactive reports using Crystal Reports and SQL Server Reporting Services · Good in performance tuning especially tuning complex queries, procedure and indexing strategies · Create database objects such as tables, views, stored procedures, Triggers etc. · Create functions to provide custom functionality as per the requirements · Be aware of potential blocking, deadlocking and write code to avoid those situations · Ability to create/interpret an Entity Relationship Diagram · Understanding primary and foreign key relations · Understanding of how Joining Tables Understanding of normalization · Ability to create stored procedures and views · Ability to construct processes using fundamental programming concepts. · Ability to process multiple records in a loop as individual transactions · Knowledge of sql transaction processing · Knowledge of exception handling · Knowledge of how to use aggregates *Desirable Skills* · Strong analytical ability to analyze requirements or design to create a solution with minimal guidance · Good in SQL Server Integration Services (SSIS) for ETL and SQL Server Reporting Services (SSRS) for report generation · Strong communication skills, able to express code and design decisions to other technical staff and business analysts · Efficient time management skills and used to delivering solutions in a fast pace environment · Ability to create technical documentation to explain the solution that was implemented · Proficiency at creating optimized sql statements that are scalable · Experience in working a member of a team · Onsite-Offshore Coordination Experience -- *Thanks & Regards* *Ishant Bawa* *IT Recruiter* *HMG America LLC* *:**7326451989* *E : **i <[email protected]>[email protected] <[email protected]>* *W: **www.hmgamerica.com <http://www.google.com/url?q=http%3A%2F%2Fwww.hmgamerica.com&sa=D&sntz=1&usg=AFQjCNF42xF1LAsW8PGbBgid9tQ5MPzSYw>* -- You received this message because you are subscribed to the Google Groups "CorptoCorp" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/corptocorp. For more options, visit https://groups.google.com/d/optout.
