MS SQL Developer – SSIS / SSRS

Overview

Deloitte is one of the leading professional services organizations in the United States, specializing in audit, tax,consulting, and financial advisory services with clients in more than 20 industries. We provide powerful business solutions to some of the world’s most well-known and respected companies, including more than 75 percent of theFortune 100.

At Deloitte, in addition to challenging and meaningful work, you’ll have the chance to give back to your community and make a positive impact on your peers. Our commitment to individual choice lets you customize aspects of your development. Finally, our culture of innovation means your ideas on how to improve our business and your clients’ will be heard.

Visit http://www.deloitte.com/us/careersto learn more about our culture, benefits and opportunities.

Deloitte Consulting LLP is one of the world’s leading management consulting firms for executable strategy, operations, technology, and human capital advisory services. The consulting practice is built around integrated core capabilities – people, process and technology and industry expertise – the capabilities needed to help our clients to tackle their most complex challenges.

MS SQL Developer – SSIS/SSRS Solution Developer

Required Skills/Experience/Duties:

• In depth SQL Server Database Administration
• Experience in database/application tuning
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, etc.
• Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space, and other resource contention issues
• Experience with Microsoft SQL Server 2005/2008, SQL Server Profiler, SQL Reporting Services
• Resolve application T-SQL related issues
• Create periodic Disaster Recovery testing plan and enable the capability for all SQL Server environments
• Create process and procedure for periodic restore and recovery for all databases in multiple environments
• Install Microsoft SQL Server 2005/2008 Enterprise software
• Apply Microsoft SQL Server 2005/2008 patches
• Install and configure third party products/tools required for SQL Server 2005/2008
• Perform database administration and database maintenance tasks
• Plan, coordinate, and execute data conversion activities such as data mapping and data conversion programming to support data migrations between systems
• Conduct data mapping: defines data elements, entity relationships, input and output sources, and how data will be transmitted through a proposed system; estimates the type of information to be entered, computed, updated or otherwise used in the system; estimates data volumes
• Create, or support creation of, required reports and queries in response to business user needs
• Experience with SSIS, SSAS, and SSRS
• Experience with Data analysis, data modeling, data warehouse
• Able to provide a working model of transaction processing environment for capacity assessment and planning
• Able to prioritize and execute tasks in a high-pressure environment
• Good interpersonal, written, and oral communication skills

Education:

• Bachelor of Science in Computer Science, Engineering, MIS or equivalent work experience