Job Description :
Hello,
Greetings from Avance.
Hope you are doing Good !!
We are looking for SQL Server Developer with one of our Clients, below is the Job Description. If you are available and interested then, please reply me with your updated resume. For more details please reach me at Ext: 376.
Role: SQL Server Developer
Location: Torrance, CA
Duration: Full time
GENERAL RESPONSIBILITIES
Provide Database development for Client public websites
Troubleshoot and correct bugs/defects related to Database objects
Optimize queries and identify bottlenecks in OLTP, warehouse and SSIS
Analyze, design and code Database enhancements
Perform unit, system and integration testing of Database objects as appropriate
Assist the QA analyst, programmers and architects
Assist the other DBA’s and programmers as necessary
SKILLS & EXPERIENCE
Microsoft SQL Server:
MUST (5+ years’ experience with Microsoft SQL Server 2008)
2+ years of experience in and SQL Report Services
5+ experience in SSIS ETL development
5+ years of experience developing Stored Procedures using XML as input and output
Qualifiers
(Note to Bidder - Please submit CVs if the candidate matches all of the criteria mentioned in this section)
Must be expert in T-SQL, FOR XML, Spatial, SSIS
Must be proficient in C# as it applies to CLR stored procedures and SSIS development
Good understanding of Microsoft Web and Commerce Technologies
Must have ability to quickly grasp complex jobs and routines
Must have ability to multitask production/team support and development demands
Ability to optimize routines from a few seconds to milliseconds
Should have demonstrated ability to Analyze, design, develop and evaluate complex databases and stored procedures
Must have excellent background in producing high quality, structured, and production ready code
Should have demonstrated ability to work with Indexed Views, Data Dictionaries, UDF, UDT,
Ability to analyze, evaluate and optimize data structure
Must have excellent background in producing high quality, structured, and production ready code, including workflow and data driven applications
Must have experience in Powershell and VBScript (legacy support)
Knowledge of various Database Architectures (transactional vs. Reporting, etc
Experience working with Agile Methodologies
OTHER REQUIREMENTS
Experience working in a team environment
Must be highly motivated self starter
Willingness to work outside of normal working hours when required