Current jobs related to Sr Oracle PL/SQL Developer/Administrator with Performance Tuning - Irving - Five Cubes, Inc.


  • Irving, Texas, United States Five Cubes, Inc. Full time

    Job Title: Senior Oracle PL/SQL Developer/Administrator with Performance Tuning ExpertLocation: HybridDuration: Long TermVisa - AnyFive Cubes, Inc. seeks a seasoned Oracle PL/SQL developer with expertise in performance tuning. The ideal candidate will have 6+ years of experience in complex query performance analysis and tuning, as well as proficiency in AWR,...


  • Irving, Texas, United States Resource Informatics Group Full time

    Job Title: Oracle PL/SQL DeveloperLocation: Hybrid (Ashburn, VA, Basking Ridge, NJ, Silver Spring, MD, or Irving, TX)Duration: Long TermClient: TelecommunicationDescription:We are seeking a senior Oracle PL/SQL developer with strong coding experience in a production environment. The ideal candidate will have expertise in analyzing AWR reports and performing...

  • PL/SQL Developer

    2 months ago


    Irving, United States Tata Consultancy Services Full time

    Position:.PL SQL Developer Location: Irving ,TX/Tampa ,FL/Jersey city Duration: FTE(Onsite) Job Description: 1. PL/SQL hands on experience with Oracle 19c features 2. Advance SQL knowledge 3. Design of conceptual, logical and physical data model using modeling tools like Erwin, magic draw etc. 4. Experience on different slow changing diagram 5. Experience...

  • PL/SQL Developer

    2 months ago


    Irving, United States Tata Consultancy Services Full time

    Position:.PL SQL Developer Location: Irving ,TX/Tampa ,FL/Jersey city Duration: FTE(Onsite) Job Description: 1. PL/SQL hands on experience with Oracle 19c features 2. Advance SQL knowledge 3. Design of conceptual, logical and physical data model using modeling tools like Erwin, magic draw etc. 4. Experience on different slow changing diagram 5. Experience...


  • Irving, Texas, United States Tata Consultancy Services Full time

    Job DescriptionJob Title: Oracle PL/SQL DeveloperWe are seeking an experienced Oracle PL/SQL Developer to join our team at Tata Consultancy Services. The ideal candidate will have a strong background in Oracle PL/SQL programming, packages, procedures, and functions, as well as experience with SQL, SQL*PLUS, and SQL/PLSQL Development Tools (SQL Developer).Key...


  • Irving, Texas, United States Tata Consultancy Services Full time

    Job DescriptionAs a seasoned Oracle developer at Tata Consultancy Services, you will be responsible for designing, developing, and implementing high-quality Oracle PL/SQL applications.Key Responsibilities:Develop and maintain Oracle PL/SQL packages, procedures, and functionsDesign and implement efficient SQL queries and stored proceduresWork on ETL...


  • Irving, Texas, United States Novalink Solutions LLC Full time

    Job DescriptionWe are seeking a highly skilled Senior Oracle PL/SQL Developer to join our team at Novalink Solutions LLC.About the Role:Develop and maintain complex PL/SQL codebases for our clients in the Oil and Gas industry.Collaborate with UI teams to design and implement database solutions that meet business requirements.Design and implement efficient...


  • Irving, Texas, United States Citi Full time

    Job DescriptionWe are seeking a skilled Oracle PL/SQL Developer to join our Functions Technology Team at Citi. As a key member of our team, you will be responsible for designing, implementing, and maintaining high-quality database applications using Oracle PL/SQL.Responsibilities:Work in an agile environment, following best practices of agile Scrum.Analyze...


  • Irving, Texas, United States Citi Full time

    Job Title: Oracle PL/SQL DeveloperCiti's Functions Technology Team is seeking a skilled Oracle PL/SQL Developer to join our team. As a key member of our team, you will be responsible for designing, developing, and implementing new or revised application systems and programs in coordination with the Technology team.Responsibilities:Work in an agile...


  • Irving, Texas, United States Resource Informatics Group Full time

    Job Title: Senior Oracle PL/SQL DeveloperWe are seeking a highly skilled Senior Oracle PL/SQL Developer to join our team at Resource Informatics Group. The ideal candidate will have a strong background in Oracle database development, with a minimum of 8 years of experience in designing, implementing, and maintaining complex database systems.**Key...


  • Irving, Texas, United States Resource Informatics Group Full time

    Job Title: Senior Oracle PL/SQL DeveloperJob Summary:We are seeking a highly skilled Senior Oracle PL/SQL Developer to join our team at Resource Informatics Group. The successful candidate will be responsible for designing and implementing database systems, creating complex SQL queries, and working with Agile teams.Key Responsibilities:* Design and implement...

  • Oracle / SQL Developer

    3 months ago


    Irving, United States The Dignify Solutions LLC Full time

    Job Duties/Responsibilities: Read & understand existing Oracle PL/SQL packages, stored procedures, and functions and apply enhancements based on new requirements and programming standards. Ability to develop UNIX/LINUX shell scripts and execute them based on requirements Develop, unit test, system test, schedule, and create deployment scripts for these...


  • Irving, Texas, United States Novalink Solutions LLC Full time

    Job Title: Oracle PL/SQL DeveloperWe are seeking an experienced Oracle PL/SQL Developer to join our team at Novalink Solutions LLC. The ideal candidate will have a strong background in database development, with a focus on Oracle PL/SQL.Key Responsibilities:Design, develop, and implement database solutions using Oracle PL/SQL.Work with cross-functional teams...

  • PL/SQL Developer

    2 months ago


    Irving, United States Tata Consultancy Services Full time

    Job Description (Must have 8+ experience) Role: Oracle developer• Strong programming/development skills with 6+ years of experience ina. Oracle PL/SQL programming, Packages, Procedures and Functionsb. SQL, SQL*PLUS and SQL/PLSQL Development Tools (SQL Developer)c. Strong SQL*Loader Knowledge and Experiencec. Application Development in Oracle DB• Strong...

  • Database Developer

    2 days ago


    Irving, Texas, United States Capgemini Full time

    Job Title: Database Developer - Oracle and SQL Server ExpertJob Description:Capgemini is seeking a highly skilled Database Developer with expertise in Oracle and SQL Server to join our team. As a Database Developer, you will be responsible for designing, implementing, and maintaining databases to meet the needs of our clients.Key Responsibilities:Design and...

  • Oracle Developer

    4 weeks ago


    Irving, Texas, United States Iris Software Inc. Full time

    Job Title: Oracle DeveloperWe are seeking an experienced Oracle Developer to join our team at Iris Software Inc. in Irving, TX. As a key member of our development team, you will be responsible for designing and developing large-scale projects using Oracle SQL, PL/SQL, and Oracle Forms.Key Responsibilities:Design and develop high-quality Oracle database...


  • Irving, Texas, United States Synechron Full time

    About SynechronSynechron is a global consulting firm that combines creativity and innovative technology to deliver industry-leading digital solutions. Our progressive technologies and optimization strategies span end-to-end consulting, design, cloud, data, and engineering, servicing an array of noteworthy financial services and technology firms.We develop...


  • Irving, Texas, United States The Dignify Solutions LLC Full time

    Job Summary:As a skilled Oracle Database Developer at The Dignify Solutions LLC, you will be responsible for enhancing existing Oracle PL/SQL packages, stored procedures, and functions to meet new requirements and programming standards. Your expertise in UNIX/LINUX shell scripting will enable you to develop and execute scripts based on project needs....


  • Irving, Texas, United States The Dignify Solutions LLC Full time

    Job Summary:As a skilled Oracle Database Developer at The Dignify Solutions LLC, you will be responsible for enhancing existing Oracle PL/SQL packages, stored procedures, and functions to meet new requirements and programming standards. Your expertise in UNIX/LINUX shell scripting will enable you to develop and execute scripts based on project needs....


  • Irving, Texas, United States The Dignify Solutions LLC Full time

    Job SummaryWe are seeking a highly skilled Oracle PL/SQL developer to join our team at The Dignify Solutions LLC. The ideal candidate will have a strong background in Oracle database development, Unix/Linux shell scripting, and experience with job scheduling tools.Key ResponsibilitiesDevelop and enhance Oracle PL/SQL packages, stored procedures, and...

Sr Oracle PL/SQL Developer/Administrator with Performance Tuning

3 months ago


Irving, United States Five Cubes, Inc. Full time
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