112612-01 TWSS - SQL Server Database Engineer @ Pleasanton, CA PDF  | Print |  E-mail
Written by Harish   
Monday, 26 November 2012 14:35

Dear partner,

Please go through the below requirement and send me the suitable profiles with best rate and contact details to -- This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Submit Resume
First Name (*)
Invalid Input
Last Name
Invalid Input
Email (*)
Invalid Input
Job Position (*)
Invalid Input
Contact Number (*)
Invalid Input
Submit Resume (*)
Invalid Input
Submit

Job Title: SQL Server Database Engineer

Location: Pleasanton, CA 

Duration: 6 - 12 Months

Rate: Open

Description:

Consultant will perform high-level professional services in support of client’s systems providing expert database engineering services for all databases related IT projects as needed.  Services include, but are not limited to project planning, systems development, systems design, systems maintenance, helpdesk/user support, documenting system requirements and changes, and Mentoring/Skills Enhancement to client employees.

Responsibilities:

  •  Provide database development support to the entire system development lifecycle of IT projects using Microsoft SQL server database.
  •  Review database schema changes, stored procedures, SQLs and other database related objects by software developers.
  •  Work with development team and data modelers to design and develop conceptual data models, logical data models and implement them in physical database schemas using ERwin data modeling tool.
  •  Work with development team to develop, troubleshoot and optimize SQLs and Transact-SQL stored procedures.
  •  Establish database design conventions in best practice, and assure that design conventions and standards are complied and documented fully.
  •  Support database change management and deployment processes.
  •  Support the MS SQL Server non-production and production databases administration as needed, including daily operations, backup and recovery, performance tuning, and after hours on-call support.
  •  Develop and implement Transact-SQL Stored Procedure verification tools that assist developers in troubleshooting and performance improvement
  •  Develop and implement procedures for the synchronization between different database environments.
  •  Develop and implement proactive tools for MS SQL Server environments.
  •  Provide advice/recommendations on database architecture, design and implementation.
  •  Provide training, documentation for knowledge transfer to other database team members, and communicate both to non-technical users and to technical personnel on Database team and Applications teams.
  •  Provide Internet Web and Document Support.
  •  Provide technical coverage for all MS SQL Server databases when the primary DBA unavailable including after hours support on weekends.

Required Skills:

Database Engineer Consultant shall possess 5+ years technical knowledge and experience with most of the following systems, platforms, applications skills:

  •  Experience in database development and administration in a Microsoft SQL Server environment.
  •  Expert hand-on experience in data modeling with focus on developing database logical and physical models for large scale, highly available and mission critical application systems.
  •  Programming experience with emphasis on designing complex Transact-SQL and .NET procedures that scale well and are optimized for use in a high volume environment.
  •  Experience with complex SQL and Transact-SQL writing and performance tuning.
  •  Ability to perform moderately complex DBA tasks including data migrations, ETL operations, replication, troubleshooting, and performance optimization. Microsoft SQL Server 2008 R2/2012 experience is desired.
  •  Experience in data modeling tools such as Erwin is desired.
  •  Experience with Microsoft Entity Framework and/or other Object-Relations Mapping framework are a plus.
  •  Experience with Analysis Services, SSIS, Service Broker, Reporting services is a plus.
  •  Good writing skills to provide documentation for DBA and other teams.
  •  Ability to communicate and prepare management reports to IT management and end users.

Thanks,


Mike Smith | Director - Resources 

Thoughtwave Software & Solutions, Inc.

E-mail | Web URL| Linked-in 

Ph: 630-448-6681 Ext # 112 | Fax: 630-689-5746

Last Updated on Monday, 26 November 2012 14:50