Description
Description- Sr. SQL Database Developer will use technical knowledge and background to take ownership of software development projects to support business objectives.
- Developer has the ability to work in a high paced and challenging environment and use analytical skills.
- Developer will work closely with internal staff and follow software development life cycle process to achieve server level agreements.
Minimum Required Skills/Competencies:
- Experience with Microsoft SQL Server 2008 database development
- Experience in Implementing data models and database designs
- Experience writing complex T-SQL scripts.
- Experienced with Stored procedure creation/debugging/optimization/tuning
- Experienced with functions, triggers, Views as well as clustering and T-SQL
- Design and Develop SQL Server Integration packages using SSIS
- Writing and creating data load scripts and stored procedures; ensuring that data is loaded in a timely manner daily
- Working with application developers to assist in database design, query tuning, index assignment, and trigger and procedure creation
- Ability to research and troubleshoot application problems using SQL programming skills
- Monitoring and troubleshooting SQL jobs, DTS, and integration services
- Ensuring that the integrity of company databases is maintained
- Actively helping our Data Integrity team reconcile data
- Excellent communication skills; works well in a team environment
- 5-8+ years Software Development experience
- 5-8+ years Professional experience using Microsoft SQL Server database development )
- 3-5+ years Designing and developing applications on Oracle RDBMS
- 5+ years of experience in complex stored procedure creation and using performance tuning techniques
- 4+ years of experience in creating and maintaining SQL code for medium to large OLTP applications