SQL Developer/Architect

Our client currently requires a SQL Developer/Architect for a 6 month contract to carry out database design in SQL 2010/2012, troubleshoot performance issues and develop stored procedures, functions, views, triggers etc.

Client :-

Global FTSE 500 Consultancy

Keywords: SQL Developer, SQL Architect, SQL Server, SQL Replication, SQL Service Broker, SQL 2010, SQL 2012

Role:-

Development & Support

Develops reusable frameworks/components and POCs to accelerate development on projects
create best practices/approaches to be leveraged by the team,
Troubleshoots performance issues
Troubleshoots complex technical issues on projects (act as a consultant to the project)
Maintains current knowledge of relevant technologies.

Architecture & Design

Participates in architecture and design reviews for projects that require complex technical solutions
Performs the gap analysis between business requirements and design the configuration, customizations, extensions, interfaces required to meet the requirements

Planning Tracking & Estimation

Estimates the implementation and deployment of the various modules
Architect upcoming work with the overall estimates for the project along with any key risks and issues and their mitigation
Reports progress and issues to the management
Manager in a timely manner. In particular, to relay issues that might impact on quality or the ability to deliver to timescales or estimates
Works with team on the development of standards, processes and procedures related to application security, upgrade management, capacity planning, application deployment

Skills Required:-

Must have:-

Should have worked on gathering/understanding business requirement & design database accordingly from scratch or understand the existing database and enhance on SQL 2010/2012
Should have very good skills in developing stored procedures, functions, views, triggers etc.
Should have knowledge on SQL Service broker
Should have knowledge on SQL Replication
Should have worked with tools like SQL profiler etc.
Should have worked on indexing tables & enhancing performance by other means.

Nice to have:-

Should know how to develop a SQL Server unit testing framework
Having C# knowledge is added advantage
Knowledge on SSIS is added advantage

Please forward your CV for immediate interview/start