2x/wk onsite in San Diego only USC or GC holders What are the top 4 technical skills needed to be successful? 1. Experience with Performance Tuning - We need to look at exp. with database schema design, normalization, and monitoring Oracle database performance issues, including query performance, indexing, & partitioning. 1. Experience with big datasets - candidate needs to have worked in environments where they were exposed to "big data", handling large, diverse, and complex datasets. 1. Oracle AND/OR PostgreSQL databases - which versions did the candidate work with? 1. 5+ years of professional experience as a Data Engineer/Database Engineer QUESTIONS TO ASK CANDIDATES - please include 1. How much experience do you have as an Oracle/Postgres Database Engineer or similar role? Tell me about your day to day in your most recent role. (looking for 5+ years of professional experience) 1. How strong are you in SQL (1-10)? When did you last use SQL? To what extent/what can you do with SQL? (looking for performance optimization, query tuning, advanced joins and set operations, window or analytic functions, complex data transformations, stored procedures, functions, triggers) 1. What is your experience with performance tuning? How do you optimize queries? When did you last do these? 1. How do you optimize query performance on large tables (100 million+ rows)? (indexing strategies, partitioning, query optimization, materialized views, parallel execution, memory/statistics management, data compression, result caching) Qualifications: • Experience: 5+ years of experience as an Oracle Database Engineer or similar role. • SQL & PL/SQL Expertise: Strong proficiency in SQL, PL/SQL development, query optimization, and performance tuning. • Performance Tuning: Proven experience with Oracle database performance issue investigation and tuning, including query optimization and indexing. • Scripting: Experience with shell scripting or other automation tools. • Communication and collaboration: Demonstrated capabilities in collaborating with others, articulating and documenting problem solving process, sharing knowledge and providing training for teammates to help team grow. • Education: Bachelor's degree in Computer Science, Information Technology, or a similar field. Job Description Essential Duties and Responsibilities include the following. Other duties may be assigned. The Database Engineer III is responsible for key areas which includes Database programming, application/operations support, rotational on-call service, issue resolution, documentation and departmental support. Additionally, this position: • Supports database management activities including production data modification requests • Gains a thorough understanding of functional requirements for new software requests. • Works with Business Systems Analysts to understand and clarify data change requests, reporting requirements, and new database development requirements. • Designs, develops and performs testing of software to meet functional requirements. • Performs process analysis and recommends data and structural changes to improve application performance. • Practices good software engineering techniques and standards to reduce coding errors and ensures robustness and efficiency of work products. • Partners with software team in the development of the software engineering processes. • Works to identify and resolves technical or product problems. • Participates in software project meetings and provides status reports. • Translates technical designs into working software. • Maintains up-to-date documentation for all supported data management processes, gathers and reports data related system statistics. • Collaborates with team members and partners with others as needed to ensure successful completion of assigned database development tasks. • Participates in code reviews and incorporates recommendations. • Applies software engineering and Object Oriented Design principles in creating UML diagrams and technical design documents for software components. • Partners with team members and technical project lead to ensure component design fits in with the overall solution. • Adopts new techniques and technologies. • Initiates attendance at job related training to keep skills current; maintains current understanding of the industry’s best practices. • Assists with mentoring and training of less experienced IT staff members. • Participates in after-hours on-call support rotation; responds to monitoring alerts; implements resolution to avoid or reduce duration of an outage; escalates issues per policy to higher tier support resources and management as necessary.