PL/SQL Developer - Consultant

Company: Guidehouse
Location: Sacramento
Posted on: May 28, 2023

Job Description:

Job Family :
Database Administration
Travel Required :
Up to 10%
Clearance Required :
Ability to Obtain Public Trust
What You Will Do :

• 
  
• 
  Serve as a Subject Matter Expert technical consultant for a public sector financial services loan application project
  
  
• 
  Review technical requirements in a migration from COBOL to Oracle
  
  
• 
  Support loan application programs in Oracle PL/SQL
  
  
• 
  Develop new functionality
  
  
  What You Will Need :
  
  • 
    
  • 
    Bachelor's degree or equivalent combination of education, training and work experience
    
    
  • 
    At least 2years of experience with Oracle PL/SQL development
    
    
  • 
    Experience with Oracle 11g/12c/19c in Unix/Linux
    
    
  • 
    Extensive PL/SQL experience (stored procedures, functions, packages, triggers)
    
    
  • 
    Demonstrated ability to write advanced business logic with PL/SQL
    
    
  • 
    Advanced use of query refactoring and tuning techniques
    
    
  • 
    Solid understanding of Oracle database architecture
    
    
  • 
    SQL, PL/SQL
    
    
  • 
    GitHub
    
    
  • 
    Agile methodologies
    
    
    What Would Be Nice To Have :
    
    • 
      
    • 
      Familiar with loan and secondary mortgage processing
      
      
    • 
      Exposure to commercial banking (loans)
      
      
      The annual salary range for this position is $76,700.00-$115,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.
      What We Offer :
      Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.
      Benefits include:
      
      • 
        
      • 
        Medical, Rx, Dental & Vision Insurance
        
        
      • 
        Personal and Family Sick Time & Company Paid Holidays
        
        
      • 
        Position may be eligible for a discretionary variable incentive bonus
        
        
      • 
        Parental Leave and Adoption Assistance
        
        
      • 
        401(k) Retirement Plan
        
        
      • 
        Basic Life & Supplemental Life
        
        
      • 
        Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
        
        
      • 
        Short-Term & Long-Term Disability
        
        
      • 
        Student Loan PayDown
        
        
      • 
        Tuition Reimbursement, Personal Development & Learning Opportunities
        
        
      • 
        Skills Development & Certifications
        
        
      • 
        Employee Referral Program
        
        
      • 
        Corporate Sponsored Events & Community Outreach
        
        
      • 
        Emergency Back-Up Childcare Program
        
        
      • 
        Mobility Stipend
        
        
        About Guidehouse
        Guidehouse is an Equal Employment Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, citizenship status, military status, protected veteran status, religion, creed, physical or mental disability, medical condition, marital status, sex, sexual orientation, gender, gender identity or expression, age, genetic information, or any other basis protected by law, ordinance, or regulation.
        Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.
        If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at RecruitingAccommodation@guidehouse.com . All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.
        Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.

Keywords: Guidehouse, Sacramento , PL/SQL Developer - Consultant, IT / Software / Systems , Sacramento, California