This site uses cookies. To find out more, see our Cookies Policy

Oracle Application SQL Tuning in Raleigh, NC at Advance Auto Parts

Date Posted: 3/12/2019

Career Snapshot

  • Employee Type:
  • Location:
    Raleigh, NC
  • Career Type:
  • Experience:
    Not Specified
  • Date Posted:

Career Description

Job Description

Looking for Sr. Oracle Application SQL Tuning / DBA with strong background in application development database support. He / She will work with a team of DBAs responsible for supporting our database infrastructure 24x7. The position is highly technical in nature, requires excellent technical skills in a variety of competencies, and the ability to learn and adopt new technologies. This is a senior level technical contributor who is able to perform all aspects of complex application query optimization, tuning and some database management in a multi-platform enterprise scale environment.

Main Responsibilities and Accountabilities

  • Troubleshoot and tune complex application SQL and PL/SQL queries, triggers, functions and stored procedures
  • Perform database tuning (OS/DB Level) and performance optimization -- troubleshoots and resolves database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues, index management and statistics, SQL joins, DB hints
  • Provide expert level support and advanced troubleshooting to end user issues / concerns; Level 3 technical support: After hours and weekend support as needed.
  • Review / analyze Oracle reports (AWR, ASH, ADDM etc..) and provide solution to isolate bottlenecks / issues across environments
  • Support Application Development team to identify and recommend changes for SQL performance improvement as required
  • Under the implication of misconfigurations at Architecture, Storage, Network and Unix Systems levels and ability to engage various teams for the resolutions.
  • Provide maintenance, code review including DDL / Schema changes implementation in development, test, and production systems
  • Analyze and recommend on the optimum use of database technologies within the application stack
  • Identify and leverage appropriate tools to monitor all database environments for optimal performance and availability
  • Provide support for multiple applications using Oracle RDBMS Platforms – Oracle 10g to Oracle 12c, Oracle RAC, Oracle Data Guard
  • Implement security for the Databases

Required Qualifications

  • Minimum 10 years of experience with combination of Oracle Database Administration, Oracle database development, and software development in Linux Environment
  • Strong knowledge in database problem identification, problem diagnosis and resolution
  • Experience in data modeling and data relationship analysis for the large scale of business applications
  • Hands-on skills on Oracle High Availability and Disaster Recovery techniques such as RAC, Data Guard
  • Bachelor’s degree from an accredited college or university or equivalent experience

Preferred Skills

  • Certification in Oracle database administration
  • Experience with PL/SQL, Java or other object-oriented languages
  • Highly organized, ability to multitask and manage projects effectively
  • Ability to strategically organize and plan enterprise scale solutions to meet the business needs
  • Ability to handle project execution from vision through implementation
  • Ability to collaborate with business users and to develop business knowledge and acumen                                                                   
  • Strong teamwork and interpersonal skills with the ability to communicate and persuade to all levels of management
  • Diverse level of knowledge with industry standard server hardware, operating systems, storage, virtualization and networking technologies
  • Good written and verbal communication skills and professionalism
  • Ability to provide senior technical leadership and mentor lower-level Database Administrators