Software Developer 4

Company: Morgan Stanley
Location: Richmond
Posted on: May 7, 2022

Job Description:

Design, develop, troubleshoot and debug software programs for databases and cloud services with emphasis on improving SQL query performance through enhanced query optimization techniques. Implement data structures and algorithms to accelerate query performance. Work on Machine Learning algorithms and SQL workload based analytical modeling to implement and improve the automation of query processing like automated indexes, automated zone maps, automated materialized views, automated partitioning, and automated clustering. 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 areas of efficient execution of SQL statements. As a leading individual contributor, you will be providing direction and mentorship as well. Preferred Qualifications: BS, MS or PhD degree in Computer Science, or related field 5 years of software engineering or related experience Thorough knowledge of computer science algorithms C programming and debugging skills 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 to 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 and query equivalence) Prior knowledge of Oracle Materialized Views, SQL Access Advisor and Online Redefinition will be an asset. Knowledge of PL/SQL (a programming language for Oracle Database) is an asset. Knowledge of operating systems: concurrency control, multi-threading, inter-process communication. Group Description: We, the optimizer group, are responsible with developing Oracle's state of the art query optimizer. The query optimizer is often referred to as the brain of the database management system, because it is the layer that decides how to process SQL queries. Some of the optimizer areas include automatic statistics gathering, query transformation techniques, algorithms and cost formulas to select access paths, join methods, and join order to produce the best performing execution plan for a SQL statement. The group is also involved in designing features related to SQL extensions like Data Partitioning or algorithms for efficient query processing. These encompass applications and areas like data warehousing, OLTP and non-traditional data processing (e.g., Text and Spatial). Most recently the team has been involved in creation the Autonomous Data Warehouse Cloud Service announced by Larry Ellison at the Open-World in Oct 2017. Our vision is to make Oracle's query optimizer the smartest, yet easiest to use in the industry, and most importantly, continue to have fun doing so. The Optimizer group has contributed major enhancements to the Oracle RDBMS over the years, including but not limited to Making query transformations fully cost-based, Fully automating the statistics gathering process, Automatic SQL Tuning component as part of the SQL Manageability effort in 10g. SQL Repair Advisor and SQL Test Case Builder components as part of the SQL Diagnosability effort in 11g. Dynamic Query Optimization (aka Adaptive Query Processing) Optimization of SQL running on data outside the database (HDFS, etc) Approximate Query Processing Cloud deployment of database services (Autonomous Data Warehouse and OLTP) Develop features to make the Database Autonomous and Self-Driving, e.g. automated indexing, workload intelligence, workload prediction, etc. The group actively participates in customer and standard industry benchmark efforts. It also has a large patent portfolio reflecting the many state-of-the-art innovations over many years. The members have a strong research background and strive to bring the most advanced ideas to market in the latest version of the Oracle RDBMS. The group contributes papers on a regular basis to international conferences in the database area. Design, develop, troubleshoot and debug software programs for databases, applications, tools, networks etc. As a member of the software engineering division, you will take an active role in the definition and evolution of standard practices and procedures. You will be responsible for defining and developing software for tasks associated with the developing, designing and debugging of software applications or operating systems. Work is non-routine and very complex, involving the application of advanced technical/business skills in area of specialization. Leading contributor individually and as a team member, providing direction and mentoring to others. BS or MS degree or equivalent experience relevant to functional area. 5+ years of software engineering or related experience.by Jobble

Keywords: Morgan Stanley, Richmond , Software Developer 4, IT / Software / Systems , Richmond, California