Blue Spire Inc→

Sr SQL DateBase Developer at Blue Spire Inc in San Francisco, CA

ExperiencedOn-siteSan Francisco, CA

Skills

ms sql serversql server 2005sql server 2008sql server 2012sql developmentstored proceduresfunctionstablesviewstriggersindexesconstraintsintegration services (bids)performance tuningquery performance tuningperformance monitorsql profilerdatabase administrationdatabase integrityblockingdeadlockingreplicationlog shippingsecuritydocumentationcommunicationcollaborationproblem solvingattention to detailproactive support

Job Description

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.