Oracle Database Engineer

1 Days Old

Get AI-powered advice on this job and more exclusive features. This range is provided by Sibitalent Corp. Your actual pay will be based on your skills and experience talk with your recruiter to learn more. Base pay range $60.00/hr - $60.00/hr Direct message the job poster from Sibitalent Corp Sr. Talent Acquisition:- (Help many clients to find a perfect candidate- Work with "US Citizen, GC, EAD") only USC or GC holders What are the top 4 technical skills needed to be successful? 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. Experience with big datasets - candidate needs to have worked in environments where they were exposed to "big data", handling large, diverse, and complex datasets. Oracle AND/OR PostgreSQL databases - which versions did the candidate work with? 5+ years of professional experience as a Data Engineer/Database Engineer QUESTIONS TO ASK CANDIDATES - please include 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) 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) What is your experience with performance tuning? How do you optimize queries? When did you last do these? 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: 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 industrys 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. Seniority level Seniority level Mid-Senior level Employment type Employment type Contract Job function Job function Engineering and Information Technology Industries IT Services and IT Consulting Referrals increase your chances of interviewing at Sibitalent Corp by 2x Sign in to set job alerts for Database Engineer roles. Software Security Engineer (Multiple Levels) Software Development Engineer in Test II Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
Location:
San Diego, CA, United States
Category:
Computer And Mathematical Occupations