Oracle Performance Tuner SME (DBA)
5707 Peachtree Parkway Atlanta, GA 30346 US
Job Description
***This role will be hybrid onsite 4 days per week***
Senior Oracle SME (8+ years' experience), who will provide high quality technology solutions that address business needs by supporting application development team for SQL tuning, Guidance on best practices for SQL coding and perform reviews and documentation. This role will participate in software development and support efforts for large Data Warehouse and financial applications using Oracle 11g / 12c / 19c databases.
Oracle Performance Tuner SME Required Skills:
- Must have extensive experience working closely with the Application Development teams.
- Strong PL/SQL experience, targeting Oracle versions 11g, 12c, 19c
- "SUPERIOR" level Performance Tuning & Troubleshooting skills.
- Strong understanding of Oracle Cost Based Optimizer
- Proven development of Statistics and Index strategies
- Proficiency in diagnosing performance issues across application tiers
- PL/SQL development experience of all types of SQL DML statements – functions, stored procs, triggers etc.
- Proactive Code Reviews and follow-ups to communicate best practices.
- Will be a part of the Oracle Team supporting a wide array of application development teams developing custom applications.
- Should have experience & ability to work with various teams to resolve performance issues
- Understand and recommend industry best practices and standards
- GoldenGate is HUGE PLUS but not a disqualifying skill.
- Experience with developing ETL solutions
- Very Strong database development experience using Oracle 19c/12c/11g
- Expert: How to interpret and utilize the following
- SQL Plan Management, Incremental Stats collection, Synopsis, histograms, SQL Access Advisor, Tuning Advisor, Segment Advisor, SQL Plan Baselines, SQL Profiles, Column Groups, Optimizer Statistics Advisor,
- Expert in SQL & PL/SQL modules such as packages, procedures, functions and other database objects.
- Expert in Performance Tuning of application code at the database level.
- Experience in Unix/Linux and Shell scripting.
- Excellent oral/written communication.
- Should have Undergraduate Degree or possess extensive experience in related field
- Soft skills such as "team player" "collaborative mentality" etc.
- Excellent Communication and collaboration skills required
- Comfortable leading and presenting during discussions
- Huge Plus – Not mandatory – Any experience in PostgreSQL, Data Guard Replication Configuration & Troubleshooting and Working closely with Global Support DBA teams in addressing the data issues.
- Data Stage, added advantage
#RT
#DICEJOBS
Meet Your Recruiter
Sam Slonkosky
Technical Recruiter
I'm happy to connect with you on your next career challenge. Whatever your needs are, we at Resolution Technologies promise to provide unrivaled quality and service. Please don't hesitate to contact me if you have any questions about this position.