SENIOR DATABASE ENGINEER

Location: CA

o Support storage and retrieval activities along with data flow and analysis

o Support development of long and short term requirements for database administration and design

o Support development of database structures that fit into the overall architecture of the system

o Support the analysis and evaluation of system improvements, optimization, development and/or maintenance efforts

o Translate a set of requirements and data into a usable database schema by creating or recreating adhoc queries, scripts and macros, update existing queries, and create new queries to manipulate data

o Write efficient T-SQL for 20+TB of data

o Optimize database performance

o Communicate well and work closely with cross functional teams including local and geographically-distributed teams

o Work in an agile, collaborative environment to implement solutions for short term as well as long term projects.

o Interact with Chief Architect to standardize application frameworks, and other critical product related initiatives

o Establish and champion best practices for database development and follow existing standards

o Support deployment and troubleshooting activities that may include night and weekend hours and being on-call based on the need

SKILLS:

o Strong knowledge in database design

o 5+ years’ experience as a Database Engineer in a fast-paced MS SQL 2008/2012/2014 environment

o Advance expertise in T-SQL, SSRS, SQL Clustering, SQL2012, SQL 2014, SQL Profiler, Dynamic Management Views usage

o Good experience in C#

o Experience with very large databases and distributed database environment

o Familiarity with database performance optimization concepts including optimizing query plans, index maintenances and other administration related activities

o Previous hands-on experience in NoSQL is a plus

o Experience with Team Foundation Server desired