Tuesday, September 29, 2009
SQL Developer - TSQL - Stored Procedures - Triggers - eCommerce in Dallas, TX
SQL Developer - TSQL - Stored Procedures - Triggers - eCommerce SQL Developer - TSQL - Stored Procedures - Triggers - Functions - eCommerce - - Skills Required - TSQL, Stored Procedures, Triggers, Function, SQL Developer, eCommerce, T-SQL, Transact-SQL , Business Objects, Reporting Services, Query Plans, Indexes, Sybase, PowerDesign, Star Schema, Data Wearhousing, Data Wearhouse, ETL, Complex, profiler, trace flags, rollback scripts, performance, production, data, integration, reports, trends, utilization, SSIS SQL Developer - TSQL - Stored Procedures - Triggers - Functions - eCommerce If you are a SQL Developer with TSQL and Stored Procedures experience, please read on!What you need for this position:- 4+ Years of Database Development Experience - Working Experience developing with MS SQL Server- Working experience developing stored procedures, triggers and functions - Experience working on eCommerce Websites - Strong working experience with Transact SQL (TSQL/T-SQL) - Working experience with debugging, optimization and tuning - Working experience with documentation and implementation of standards and procedures - Experience with ETL process using SSIS, stored procedures and reporting services - Understanding of data and database normalization - Working experience building reports with Business Objects and Reporting Services 2005- Working experience Testing Code and designing database structures using Sybase PowerDesigner - Bachelors degree or related and recent work experience - Candidates must be local and authorized to work for any employer (No relocation or visa transfer or sponsorship available at this time). What you'll be doing:- Developing stored procedures, triggers and functions for an E-commerce website- Implementing error handling and transaction based processing within stored procedures- Creating ETL processes using SSIS and stored procedures- Building reports using Business Objects and Reporting Services 2005- Performance tuning transact-SQL using Query plans and Indexes- Designing new database structures using Sybase PowerDesigner- Design star schema Datawarehouse and procedure based ETL process to provide simple reporting using Business Objects- Redesigned complex procedure- Design and create tables and procedures- Creating and managing transactional replication - Troubleshooting database locks and deadlocks using SQL profiler and trace flags- Create database design and T-SQL coding policies- Test SQL code in development and QA environments- Create rollback scripts and performing code pushes to production- Participate in On-Call rotations- Script new SQL account access - Mining data to identify anomalies and providing support as necessary to resolve the anomalies- Work with internal business partners to create reports and to verify data and integrate data other software packagesWhat's in it for you:- Competitive Base Salary- Full Benefits - Room for Growth- Candidates must be local and authorized to work for any employer (No relocation or visa transfer or sponsorship available at this time). So, if you are a SQL Developer with TSQL and Stored Procedures experience, please apply today!Connect with me ------- Vahid Behzadi, Executive RecruiterTwitter: @vbehzadiLinkedIn: Blog: vahidbehzadi.wordpress.com - VBB-SQLDev-DFW-MSSQL - , , , , , CyberCoders CyberScientific To Apply to this job go to http://www.GadBall.com or click here