Senior Member of Technical Staff

Implements end-to-end features across application and data layers with growing autonomy. Designs data models for common patterns (including star/snowflake for analytics), optimizes queries, and debugs performance issues. Leverages Oracle Application Express and PL/SQL where appropriate; adds telemetry to track usage, conversion, and latency. Applies secure coding practices, reviews peer code, and improves documentation of service contracts.

Key Responsibilities

Data Systems Software Development:

• Deliver end-to-end features spanning application services and Oracle Database data models (including star/snowflake patterns).

• Diagnose and improve query and API performance affecting user experience and service-level agreements.

• Introduce controlled experiments (A/B tests) with clear success metrics and data collection plans.

• Designs existing and new services.

Software Development and Coding – Design, Testing, and Optimization: 

• Designs software solutions and analyzes and helps identify requirements to achieve business and operational goals, independently.

• Adheres to and suggests improvements to all phases of the software development lifecycle.

• Utilizes working knowledge to develop new software features and enhancements following design specifications and develops documents to clarify software design and code.

• Leads code reviews in designated areas to help drive improvements.

• Conducts debugging and troubleshooting to identify and fix moderately complex software issues. Develops fixes for identified issues.

• Implements software testing (e.g., functional and non-functional testing), quality assurance processes, software error logging, monitoring, and observability for effective debugging, ensuring review by manager and/or lead throughout the process.

• Exercises judgment and discretion to conduct performance profiling and optimization of coding.

• Troubleshoots and resolves moderately complex issues related to application programming interface (API) functionality and integration.

• Implements moderately complex API versioning, lifecycle, and interoperability strategies.

Software Architecture – Software System Structural Design: 

• Designs and develops software, systems, and services aligned to pre-defined system architecture.

• Develops working knowledge of software architecture decisions and best practices.

• Collaborates with team leads to review work to ensure alignment with software architecture.

• Implements moderately complex performance optimization and scalability strategies in software design.

Issue/Defect Collaboration – Software Products Support: 

• Collaborates within and beyond immediate team to understand customer issues and align solutions.

• May provide technical guidance and support to customers regarding customer-reported issues, independently.

• Coaches, mentors, and guides others to advocate for customers' interests and suggests product enhancements based on feedback.

• Influences team to ensure customer satisfaction through timely resolution of issues and effective communication.

• Implements customer issue and/or defect handling and training processes, independently.

• Investigates and troubleshoots complex product maintenance issues to ensure customer agreement on short- and long-term solutions (e.g., future enhancements).

Practices and Standards Compliance – Security and Compliance: 

• Collaborates with the team to establish and follow development practices and coding standards.

• Exercises judgment and discretion to ensure code quality and adherence to broad acceptance criteria during development.

• Keeps up-to-date with industry best practices and applies them to software development processes.

• Implements secure coding practices to prevent security vulnerabilities.

Development Operations – System Maintenance:

• Performs periodic maintenance and testing operations for systems that require upgrading or patching (e.g., for critical vulnerabilities).

• <