Jobs
>
Irving

    Oracle pl/sql Developer - Irving, United States - Resource Informatics Group

    Resource Informatics Group
    Resource Informatics Group Irving, United States

    2 weeks ago

    Default job background
    Description
    Job 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 (let's start small max 3) with 12+ 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
    Quickly understand and come up to speed with existing application.
    Understand new requirements and translate them into functional specifications.
    Analyze and design solutions for the new requirements.
    Implement and test the changes in various stages and environments and all the way into production.
    Develop adequate documentation of the design and changes, socialize/review changes with peers.
    Provide the daily and weekly status updates of the tasks and projects assigned.
    Troubleshoot and fix any production and non-production issues.
    Provides expert advice where needed and mentor other developers.

    Ideally, the candidate will also have:
    Teamwork & collaboration skills to work across organizations and lead cross-functional teams.
    Communication & stakeholder management skills.
    Problem solving skills to develop quick yet sound solutions to resolve complex issues.

    EDUCATION/CERTIFICATIONS:
    4 years of Bachelor's degree in Computer Science or equivalent degree

    Expectation Need from Candidate :-
    • Understand Business Requirement.
    • Candidate need to know where code need to change.
    • He also need to tell where schema need to change .
    • Database Inspection , find bad code and rewrite and put it into system. Check if new code working fine.
    • On call and off-hour work
    • Proactive Monitoring and quick Mitigation
    • Candidate able to provide quick solution on the spot for all performance issue.
    Main Topics Relate to Performance Tuning - day to day work with them
    • How to find out slow query in DB.
    • methodologies you use when query is slow.
    • Autonomous Transaction
    • PLSQL Profiler.
    • Reset Cash- what is it
    • Hash Partitioning
    • Local Prefix and Local Non Prefix
    • ADDM reports must, AWR and ASH report
    • how to check execution Plan in Database Report
    • Candidate able to find out where code is wrong , they will show 2 different code . 1 is big confusing code, candidate need to figure out what is happing in code. 2nd one is small code, where candidate need to find out what wrong in code and how optimize the code.
    • Candidate need to find from ADDM report where tuning required
  • Virtusa

    PL/SQL developer

    2 weeks ago

    Virtusa Irving, United States

    Job Description: · Responsibilities: · Required Skills: 8-10 yrs of very good PL/ SQL hands on experience. · Hands - on professional who has experience in writing complex DBview, Stored procedures, Analytical functions etc. · Good Experience Cursors, Ref Cursors, · Good know ...

  • Pioneer IT Systems

    PL/SQL Developer

    4 days ago

    Pioneer IT Systems Irving, United States

    Job title : - PL SQL Database Developer · Looking W2 · Long Term project - Multi Year · Location : Irving Texas · Need 10+ Years experience · ************************************* · *********Sure shot position******** · ************************************************ · ********* ...

  • VirtusaPolaris - Virtusa Corporation

    Pl/SQL developer

    3 weeks ago

    VirtusaPolaris - Virtusa Corporation Irving, United States

    Job Description: · Responsibilities: Good experience in requirement gathering/ analysis, DB design, coding, Unit testing, SIT Support · As a US resource the expectation would be beyond their primary skill as DB Engineer. · Engineers would need to be hands on and are capable of co ...

  • LTIMindtree

    PL/SQL Developer

    2 weeks ago

    LTIMindtree Irving, United States

    About US: · LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to m ...

  • LTIMindtree

    PL/SQL Developer

    3 weeks ago

    LTIMindtree Irving, United States

    About US: · LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to ...

  • LTIMindtree

    PL/SQL Developer

    2 weeks ago

    LTIMindtree Irving, United States

    About US: · LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to m ...

  • Ask Staffing

    Oracle PL/SQL Developer

    2 weeks ago

    Ask Staffing Irving, United States

    Client: Sedgwick · Job ID: · Job Title: Oralce PL/SQL Developer · Location: Irving, TX (100% Remote) · Duration: 12 months (Contract to Hire) · Pay Rate: $50.00 an hour on W2 · Position Overview: · To develop, maintain, test and debug software to meet generally defined requ ...

  • Diverse Lynx

    PL/SQL developer

    3 weeks ago

    Diverse Lynx Dallas, United States

    PL/SQL developer · Dallas, TX · Contract · JD: · PL/SQL developer · Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on th ...

  • Cognizant Technology Solutions

    Senior Oracle PL SQL Developer

    2 weeks ago

    Cognizant Technology Solutions Irving, United States OTHER

    About 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. · Cog ...

  • NJTECH INC.

    Oracle PL/SQL Developer

    3 weeks ago

    NJTECH INC. Coppell, TX, United States

    Hello, · We at NJTech are focused on hiring highly skilled professionals who are excited by the opportunity to make a true impact on their careers as well as on our clients' businesses. We power our clients success and drive our consultants career growth. · We are seeking an expe ...

  • Proven Recruiting

    Oracle PL/SQL Developer

    1 week ago

    Proven Recruiting Plano, United States

    Oracle PL/SQL Developer · Remote opportunity, prefer you are local to TN or TX · Who you are: · 4-10 years experience doing Oracle PL/SQL development · Exceptional Performance Tuning skills · PL/SQL - must have version 12C or 19C + · What you'll do: Designing databases and ens ...

  • ICONMA

    Oracle PL/SQL Developer

    1 week ago

    ICONMA Plano, United States

    :The candidate would perform development using Oracle as backend and some basic front end on .Net and browser-based platforms to develop and deliver complex software requirements to accomplish business goals and ensure software is developed to meet functional, non-functional, and ...

  • LTIMindtree

    Big Data Developer- Oracle, PL/SQL programming

    2 weeks ago

    LTIMindtree Irving, United States

    About Us: · LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to m ...

  • SoftPathTechnologies

    Oracle PL/SQL Developer

    4 days ago

    SoftPathTechnologies Plano, United States

    Job Description · Job DescriptionAllowed Work AuthorizationUS Citizen,Greencard Holder,TN Visa,EAD,H4-EADWe are hiring below skills you can reach me @ with with suitable profiles.@ Oracle PL/SQL Developer · Plano TX (Hybrid Role) · Look for 10+ nearby candidates · Key Responsib ...

  • Infosys

    Oracle PL/SQL Developer

    3 weeks ago

    Infosys Richardson, United States

    Job Description · Infosys is seeking a Oracle Pl/SQL Developer- This position's primary responsibility will be to provide technical expertise and coordinate for day-to-day deliverables for the team. The chosen candidate will assist in the technical design of large business syste ...

  • LTIMindtree

    Big Data Developer- Oracle, PL/SQL programming

    2 weeks ago

    LTIMindtree Irving, United States

    About Us: · LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to ...

  • PamTen

    PL/SQL Apps Developer

    3 weeks ago

    PamTen Plano, United States

    JD: Should have 8+ years of experience in writing interfaces, conversions. · Should have 8+ years of experience in SQL, PL/SQL · Should have 8+ years of experience writing triggers, views, packages, procedures, functions · Must have worked in Agile work culture · Should have 8+ y ...

  • Saxon Global

    Oracle PL/SQL Developer

    2 days ago

    Saxon Global Fort Worth, United States

    Technical Skills and Competencies Required · 4+ years PL/SQL development experience including experience in each of the following areas: · • Creating and maintaining large packages, stored procedures, functions, record structures, tables, views, indexes and triggers · • PL/SQL ...

  • Siri InfoSolutions Inc

    PL/ SQL Developer at Dallas TX

    2 weeks ago

    Siri InfoSolutions Inc Dallas, United States

    Job Description · Job DescriptionPosition: PL SQL Developer · Location: Dallas TX Onsite · Responsibilities: · Technical/Functional Skills: · Development with 4 to 6years of experience in PL/SQl · Help team with modernizing database code by porting the code to AWS Aurora postgres ...

  • Yoh, A Day & Zimmermann Company

    SQL Developer

    3 weeks ago

    Yoh, A Day & Zimmermann Company Irving, United States

    SQL Developer · 6 month+ contract · Irving, TX (Hybrid) · We are seeking a skilled SQL Developer to join our dynamic team. The ideal candidate will have a strong background in T-SQL, stored procedures, and triggers, with a passion for database development and optimization. Thi ...