Job Title : Sr Oracle PL / SQL Developer / Administrator with Performance Tuning (AWR Report)
Location : Irving, TX / / Silver Spring, MD / / Ashburn, VA / / Bedminster, NJ (Hybrid)
Duration : Long Term
Visa - Any
Need senior solid candidate, Strong PLSQL coding exp in production environment.
ble to Analyze AWR report and do performance tuning by PLSQL Query.
Development
PL / SQL expert - collections, bulk collect and DML, exception handling, best practices for performance and scalability
Data modelling - basic ER creation / maintenance, strong data modelling principles, strong physical modelling (indexes global vs.
local, partitions, mat views)
Performance Tuning
AWR analysis - identify system bottlenecks, poorly performing SQL / DML, misuse of DB resources, and provide solutions incl communicating with and educating development teams on best practices
Query tuning - nalysis of why a query is slow and provide recommendations for indexing, rewrites, hints, etc.
Complex query tuning - ble to analyze very large and complex queries to isolate the trouble spots and provide solutions as above.
Proficiency with other tools such as ASH, ADDM, TKPROF, DBMS PROFILE, SQLT
Ideally the candidate should have a deep knowledge of Oracle DB internals and be able to communicate / educate on how to best take advantage of the database for business needs.
Top must have Skills :
- Experienced SQL & PL / SQL developers (let's start small max 3) with 6+ years relevant hands-on experience including complex query performance analysis and tuning.
- Experience using AWR, ADDM, ASH for application / database tuning is also required.
- Experience using Toad and / or SQL Developer for tuning / coding. Candidates should be detail oriented and have good written and oral communication skills.
- They should have worked (hands on) Oracle 19c and previous Oracle versions for the above requirements
Oracle PL SQL Developer
A company is looking for a 100% Remote Oracle PL/SQL Developer. ...
Oracle pl/sql Developer
Experienced SQL & PL/SQL developers (let's start small max 3) with 12+ years relevant hands-on experience including complex query performance analysis and tuning. Able to Analyze AWR report and do performance tuning by PLSQL Query. Job Title: Oracle PL/SQL Developer. Experience using AWR, ADDM, ASH ...
Oracle PL/SQL Developer
Irving, TX company is seeking a Oracle PL/SQL Developer to join their team for a contract opportunity. Responsible for implementing business logic in Oracle DB packages, functions and procedures that support the development, deployment and support of large mission critical enterprise Web application...
Sr Oracle Developer
...
Java Developer with SQL and Kafka
Java Developer with SQL and Kafka. We are seeking a highly skilled Java Developer with experience in SQL and Kafka to join our dynamic team. Design and implement data solutions using SQL and Kafka. Ensure the performance, quality, and responsiveness of applications. ...
Sr. Python Developer with Angular or AI/ML
The company places a strong emphasis on employee training and development. Develop & deploy applications on AWS Serverless services (Lambda, Step Functions, APIGateway). Build features and applications with a mobile responsive design. As a member of the ApTask team, you will have the chance to conne...
Sr. POS Tester (with Oracle xStore)
POS platform, so anyone with Oracle retail suite hands-on experience and working in a lab environment. POS Tester (with Oracle xStore). Oracle xStore – that’s the POS system they use. ...
Sr. Python Developer with AI/ML
The company places a strong emphasis on employee training and development. Develop & deploy applications on AWS Serverless services (Lambda, Step Functions, APIGateway). Build features and applications with a mobile responsive design. As a member of the ApTask team, you will have the chance to conne...
Sr. Oracle plsql Developer
Years of Strong SQL and PL/SQL Tuning skills. Years of Strong SQL and PL/SQL Development skills. Familiarity with AWS Aurora, No-SQL DBS and Big data technologies is a big plus. Oracle PL/SQL, Unix, Control M, ETL, Data warehousing, Triage, Debugging Skill. ...
Team Lead/Sr Database Administrator (SQL)
Eligible employees may enroll in the Company’s 401(k) retirement savings plan, and an Employee Stock Purchase Plan is also available for eligible employees. Ensures that all technology decisions are in compliance with standards for hardware and software integrity, are not disruptive and are supporti...