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
#LI-MH14
Disclaimer:
Certain US customer or client-facing roles may be required to comply with applicable requirements, such as immunization and occupational health mandates.
Range and benefit information provided in this posting are specific to the stated locations only
US: Hiring Range in USD from: $96,800 to $223,400 per annum. May be eligible for bonus and equity.
Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle's differing products, industries and lines of business. Candidates are typically placed into the range based on the preceding factors as well as internal peer equity.
Oracle US offers a comprehensive benefits package which includes the following:
- Medical, dental, and vision insurance, including expert medical opinion
- Short term disability and long term disability
- Life insurance and AD&D
- Supplemental life insurance (Employee/Spouse/Child)
- Health care and dependent care Flexible Spending Accounts
- Pre-tax commuter and parking benefits
- 401(k) Savings and Investment Plan with company match
- Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation.
- 11 paid holidays
- Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours.
- Paid parental leave
- Adoption assistance
- Employee Stock Purchase Plan
- Financial planning and group legal
- Voluntary benefits including auto, homeowner and pet insurance
The role will generally accept applications for at least three calendar days from the posting date or as long as the job remains posted.
Career Level - IC4