SQL Developer Mid level

Position: Senior SQL Server Developer

Location: Washington DC (OnSite)

Duration: 12 Months Contract

Function and Scope:

The Senior SQL Server Developer will work as part of the Application Development team and other SQL Server Developers that are part of the DBA/Development team. The main responsibilities include developing

custom SQL Server Applications/Code (using TSQL) creating and supporting robust ETL applications (using both TSQL and SSIS) and rootcause analysis for various development related problems (bugs in code performance and locking/blocking). The ideal candidate will have experience in database design and the capability of understanding and implementing business requirements from Business Analysts and other interested parties. Additionally the understanding of other components of Microsofts BI stack (SSAS and SSRS) and IBM Cognos is a plus. The Sr. SQL Server Developer must have a proven record of excellent results be a great communicator and a team player.

Major Duties and Responsibilities:

Perform all aspect of database development under the direction of the DBA manager including:

Thorough code review of current and past development efforts

Code optimization and performance tuning

Design develop enhance and support database applications

Development of complex SQL Code (stored procedures triggers views and functions)

Security assessment and compliance

Through understanding of indexing (Clustered/NonClustered)

Modify/Create/maintain and optimize ETL processes using SSIS

Create Data extraction and Import programs using SSIS

Conduct research on emerging database and data warehouse technologies

Interact with all stake holders not limiting to the IT to ensure accurate and comprehensive understanding of business requirements

Liaise with network administrators systems analysts and software engineers to assist in resolving problems and provide issue escalation in a timely fashion

Other duties as needed

Required Qualifications:

Bachelors degree in Information Systems/Technology Computer Science or a related field.

4 years of experience working with databases preferably SQL Server.

4 years of experience in developing ETL Processes including the use of SSIS packages in a Microsoft SQL Server database environment.

4 years of extensive experience working in the MS SQL Server 2005 andR2 environments.

Understanding and knowledge of Data Warehousing (Inmon & Kimball) and Business Intelligence.

Working technical knowledge in Relational and Dimensional Database design.

Understanding of database security and knowledge of applicable data privacy practices and laws.

Understanding and experience in Database/Metadata analysis and design.

Strong written and oral communication skills.

Strong interpersonal skills.

Selfdirected and proactive; thinks beyond the immediate problem.

Flexibility ability to change priorities quickly and capacity to handle multiple tasks.

Work directly with both internal and external resources to insure timely completion of assigned deliverables.

Ability to effectively prioritize and execute tasks in a highpressure environment. Keen attention to detail.

Proven analytical and problemsolving abilities.

Experience working both independently and in a teamoriented collaborative environment.

Thanks & Regards

Raja Chandra Business Development Manager

Email: