SQL Server Database Engineer (SQL Database 1) Pleasanton, California
Job Title: SQL Server Database Engineer
Location: Pleasanton, CA
Duration: 6 - 12 Months
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.
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.
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.