Principal Member of Technical Staff-Bay Area

Principal Member of Technical Staff-Bay Area Oracle - 3.8 Redwood City, CA Job Details Full-time 1 day ago Qualifications C Full Job Description Design, develop, troubleshoot and debug software programs for databases and cloud services with emphasis on new extensions to SQL. Implement data structures and algorithms to accelerate query performance. Work on Machine Learning algorithms that improve automation of query processing like automated result cache, automated partitioning, automated clustering and zonemaps. As a member of the software engineering division, you will take an active role in the definition, design, implementation, and evangelization of new database execution features. You will also be analyzing the performance and scalability of the features and improve them. Work is complex and research-centric, involving application of advanced technical and problem-solving skills in area efficient execution of sql queries. As a leading individual contributor, you will be providing direction and mentorship as well. Many of our algorithms have been patented and our work has been published in major conferences. We are responsible for providing scalability of sql operators for parallel queries and for memory usage. A most recent area of interest is vectorized and columnar processing. We extended the SQL language to identify data that is closest match to query vector. We generate optimal query plans for retrieve data fast. We take advantage of new on-disk and in-memory storage formats and hardware caching characteristics to improve jo BS, MS or PhD degree in Computer Science, or related field Data Structure, Algorithms, Systems Programming, Computer Architecture and SQL C programming and debugging skills Knowledge of parallel processing, thread programming, concurrency control and scalability Strong communication skills, both written and oral Strong personal initiative (go-getter and proactive) and critical reasoning Background in database internals Additional skills we would like see in the candidate: Knowledge of database systems & SQL query execution: joins, aggregation, transactions, re-partitioning and fragmentation Knowledge of database systems theory including SQL query optimization (join ordering, query transformations) Knowledge of internal components of a database system like buffer cache, heap manager, B-Tree indexes, Columnar storage, latches & locks Knowledge of operating systems: concurrency control, multi-threading, inter-process communication