![Five Cubes Inc](https://media.trabajo.org/img/noimg.jpg)
Sr Oracle PL/SQL Developer/Administrator with Performance Tuning
4 weeks ago
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.
Able 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 - analysis of why a query is slow and provide recommendations for indexing, rewrites, hints, etc.
Complex query tuning - able 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
2 weeks ago
Irving, United States Collabera Full timeDescription Home Search Jobs Job Description Oracle PL/SQL Developer Contract: Irving, Texas, US Salary: $65.00 Per Hour Job Code: 350791 End Date: 2024-07-18 Days Left: 29 days, 3 hours left Apply Industry: AirlinesJob Title: Oracle PL/SQL DeveloperDuration: 12 Months of contract (possibility of extension of 24 months or conversion) Location: Irving,...
-
Oracle pl/sql Developer
3 weeks ago
Irving, United States Resource Informatics Group Full timeJob Title: Oracle PL/SQL Developer Location: Ashburn, VA/ Basking Ridge, NJ / Silver Spring, MD or Irving, TX (Hybrid) Duration: Long Term Client: Telecommunication Description: Need senior solid candidate, Strong PLSQL coding exp in production environment Able to Analyze AWR report and do performance tuning by PLSQL Query Experienced SQL & PL/SQL developers...
-
Oracle PL/SQL Developer
2 weeks ago
Irving, United States Collabera Full timeResponsibilities: Responsible for implementing business logic in Oracle Database packages, functions, and procedures that support the development, deployment, and support of large mission-critical enterprise Web applications Involved in all phases of the software lifecycle with an emphasis on database logic implementation and design Assisting in the...
-
PL/SQL Developer
6 days ago
Irving, United States Tata Consultancy Services Full timeJob title : PL/SQL DeveloperLocation : Irving, TX/Rutherford, NJJob type : Full time/ PermanentExp Req : 8+ yearsJob Description:PL/SQL hands on experience with Oracle 19c featuresAdvance SQL knowledgeDesign of conceptual, logical and physical data model using modeling tools like Erwin, magic draw etc.Experience on different slow changing diagramExperience...
-
PL/SQL Developer
1 week ago
Irving, United States Tata Consultancy Services Full timeJob title : PL/SQL DeveloperLocation : Irving, TX/Rutherford, NJJob type : Full time/ PermanentExp Req : 8+ yearsJob Description:PL/SQL hands on experience with Oracle 19c featuresAdvance SQL knowledgeDesign of conceptual, logical and physical data model using modeling tools like Erwin, magic draw etc.Experience on different slow changing diagramExperience...
-
Oracle PL/SQL Developer
3 weeks ago
Irving, United States Motion Recruitment Partners LLC Full timeOracle PL/SQL Developer Irving, TX Hybrid Contract $56.67/hr - $66.67/hr Irving, TX company is seeking a Oracle PL/SQL Developer to join their team for a contract opportunity. Leverage the latest technology to solve business problems in a collaborative environment at this Fortune 500 transportation giant. Top technical resources are retained on...
-
Oracle PL/SQL Developer
1 week ago
Irving, United States Motion Recruitment Full timeIrving, TX company is seeking a Oracle PL/SQL Developer to join their team for a contract opportunity. Leverage the latest technology to solve business problems in a collaborative environment at this Fortune 500 transportation giant. Top technical resources are retained on long-term contract engagements. Responsible for leveraging cutting edge technology...
-
Oracle PL/SQL Developer
3 weeks ago
Irving, United States Hire Talent Full time4+ years Oracle PL/SQL development experience in each of the following software programming areas: • Creating and maintaining complex packages, stored procedures, functions, record structures, tables, views, indexes and triggers, Oracle JSON • PL/SQL development, unit testing, code troubleshooting and debugging • High performance query development •...
-
Senior Oracle PL SQL Developer
1 month ago
Irving, Texas, United States Cognizant Technology Solutions Full timeAbout Us:Cognizant (Nasdaq: CTSH) engineers' modern businesses. We help our clients modernize technology, reimagine processes and transform experiences so they can stay ahead in our fast-changing world. Together, we're improving everyday life. See how at or @cognizant. Cognizant Technology Solutions is looking for "Senior Oracle PL SQL Developer" to join in...
-
Oracle PL/SQL Developer
2 weeks ago
Irving, United States INSPYR Solutions Full timeTitle: Oracle PL/SQL Developer Location: Fort Worth, TX Duration: 12 months with extension Work Requirements: US Citizen, GC Holders or Authorized to Work in the U.S. Skillset / Experience: 4+ years Oracle PL/SQL development experience in each of the following software programming areas: •Creating and maintaining complex packages, stored procedures,...
-
PL/SQL Developer with ETL Experience
3 weeks ago
Irving, United States Tata Consultancy Services Full timeJob Title PL/SQL Developer with ETL Experience Relevant Experience(in Yrs) 812 Years Technical/FunctionalSkills Experience in Telecom billing Expert knowledge of and experience in PL/SQL programming Experience in Oracle database 10g and above Experience in performance tuning of SQL statements Experience in ETL Tools, especially with PLSQL. Experience with...
-
Pl/SQL developer
1 day ago
Irving, United States Virtusa Full timeDescription Job Description: Responsibilities: Required Skills: 8+ years of experience in Oracle PL/SQL Knowledge of Bigdata Understanding of standard SDLC and Agile processes Good experience in the coding standards and code quality Ability to understand requirements and develop code individually. Strong writing, communication, time-management skills and...
-
Pl/SQL developer
2 weeks ago
Irving, Texas, United States Virtusa Full timeExciting Job Opportunity:Key Responsibilities:- 8+ years of solid experience in Oracle PL/SQL - Proficiency in Bigdata technologies - Familiarity with standard SDLC and Agile methodologies - Strong adherence to coding standards and code quality - Independent development of code based on requirements - Excellent written and verbal communication skills,...
-
Oracle Tech lead
2 weeks ago
Irving, Texas, United States Photon Full timeJob DescriptionJob Duties/Responsibilities:Hands on tech lead who can drive design and coding, code review with vendor developers. Minimum of 8 years of experience in Oracle PL/SQL development.Proven experience in database design, development, and optimization.Strong knowledge of Oracle database architecture, SQL, and PL/SQL programming.Experience with...
-
Oracle Tech lead
1 month ago
Irving, Texas, United States Photon Full timeJob DescriptionJob Duties/Responsibilities:Hands on tech lead who can drive design and coding, code review with vendor developers. Minimum of 8 years of experience in Oracle PL/SQL development.Proven experience in database design, development, and optimization.Strong knowledge of Oracle database architecture, SQL, and PL/SQL programming.Experience with...
-
Oracle PL/SQL Developer @ Irving, TX
3 weeks ago
Irving, United States CBase Inc Full timeONLY ON W2Hybrid Role Onsite InterviewsVISA: NO CPT,OPT,H1-BPosition : Oracle PL/SQL Developer Location : Irving, TXDuration : 6 Months with EXT Top 3 to 5 skillsets / years of experience 3-5 years experience in: · Creating and maintaining complex packages, stored procedures, functions, record structures, tables, views, indexes and triggers, Oracle JSON ·...
-
Manager, Oracle Apps DBA
4 weeks ago
Irving, United States 7-Eleven Full timeWho we are Imagine working in a place where continuous improvement and innovation is celebrated and rewarded; where fast-paced, high-impact teams come together to positively drive results for one of the largest & most iconic brands in the world. As the only rapidly growing retailer, you may know us as your friendly neighborhood store. You probably know our...
-
Application Oracle APEX Administrator
3 weeks ago
Irving, United States Resource Informatics Group Full timeThe position provides daily support of our Human Resources and Financial systems using Ellucian's Banner product. The role provides Developer support in the design, build and testing of Oracle/APEX applications. The applications are built using the database technical and Banner Application administration functions. PL/SQL is the underlying language, and the...
-
Application Oracle APEX Administrator
1 month ago
Irving, United States Resource Informatics Group Full timeThe position provides daily support of our Human Resources and Financial systems using Ellucian's Banner product. The role provides Developer support in the design, build and testing of Oracle/APEX applications. The applications are built using the database technical and Banner Application administration functions. PL/SQL is the underlying language, and the...
-
Manager, Oracle Apps DBA
1 month ago
Irving, United States 7-Eleven Full timeOverview: ? Who we are Imagine working in a place where continuous improvement and innovation is celebrated and rewarded; where fast-paced, high-impact teams come together to positively drive results for one of the largest & most iconic brands in the world. As the only rapidly growing retailer, you may know us as your friendly neighborhood store. You...