What are the responsibilities and job description for the Sr SQL DateBase Developer position at Blue Spire Inc?
Company Description
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
Job Description
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
Additional Information
All your information will be kept confidential according to EEO guidelines.