Culver, City, CA
Support database design, development and implementation for SaaS products
Support storage and retrieval activities along with data flow and analysis
Support development of long and short term requirements for database administration and design
Support development of database structures that fit into the overall architecture of the system
Support the analysis and evaluation of system improvements, optimization, development and/or maintenance efforts
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
Write efficient T-SQL for 20+TB of data
Communicate well and work closely with cross functional teams including local and geographically-distributed teams
Work in an agile, collaborative environment to implement solutions for short term as well as long term projects.
Interact with Chief Architect to standardize application frameworks, and other critical product related initiatives
Establish and champion best practices for database development and follow existing standards
Support deployment and troubleshooting activities that may include night and weekend hours and being on-call based on the need
5+ years' experience as a Database Engineer in a fast-paced MS SQL 2008/2012/2014 environment
Advance expertise in T-SQL, SSRS, SQL Clustering, SQL2012, SQL 2014, SQL Profiler, Dynamic Management Views usage
Strong knowledge in database design
Experience with very large databases and distributed database environment
Familiarity with database performance optimization concepts including optimizing query plans, index maintenances and other administration related activities
Previous hands-on experience in NoSQL is a plus
Experience with Team Foundation Server desired
Previous experience with profiling tools required
Capable of independently solving simple to moderately complex problems
Comprehensive verbal and written communication skills including mentoring junior staff
Strong organizational skills and the ability to manage a diversified workload
Duties and responsibilities can vary; a positive attitude and ability to acquire and apply knowledge rapidly is required
College degree in computer science or related field, and 5 or more years of experience as a database engineer
¿Te interesa este puesto?