Sr SQL DateBase Developer

Blue Spire Inc is a leading provider of information technology, consulting and business-process outsourcing services. We are dedicated to helping clients grow through our combined business-IT knowledge, thoughtful innovation and dedicated workforce. 

Who we are: We are a company of diverse, talented people with a passion for pursuing excellence. 

• Our Core Values

• Excellence

• Leadership by example
• Integrity & Transparency
• Fairness
• Client Value

What we offer: It is not a job. It is a journey. An experience. A challenging and enjoyable work environment.

Come grow with us

• Learn

• Ideate
• Execute
• Work
• Inspire

Execute development projects independently;

· Deliver programming results that meet specs and functional requirements on time;

· Stay aligned with project team and client as requirements change;

· Use Saama methods and IP to effectively contribute high quality work to Client projects and Saama Solutions.

· Database development, administration and support in MS SQL Server environments.

· Capture business requirements and translate them to data requirements and recommended solution(s). Produce documentation for these requirements and solutions.

· SQL Development – ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints).

· Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, Query Performance Tuning & Optimization using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

Requirement:

Must Have:

· SQL MDM / DQS experience.

· Experience in creating knowledge base, troubleshoot DQS issues.

· Performance tuning DQS issues.

· 6+ years’ experience in database development, administration and support in MS SQL Server environments

· Capture business requirements and translate them to data requirements and recommended solution(s). Produce documentation for these requirements and solutions.

· SQL Development – ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints).

· Create & maintain Integration services (BIDS) Packages, and write complex SQL statements for large scale databases.

· Code optimization and performance tuning

· Design, develop, enhance and support database applications

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

· Good experience in Database Administration in SQL Server (2005 and 2008 and 2012).

· Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, Query Performance Tuning & Optimization using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

· Ability to work on multiple projects to provide adequate and proactive support for various business initiatives and applications

All your information will be kept confidential according to EEO guidelines.