Oracle Database Engineer

Job Description:

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.

Requirements:

• 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.