Apex W2 -- 100% Remote Role -- Senior Oracle PL/SQL Developer - Apex W2 / LucyRX Job at Sumeru Solutions, Remote

Y3ZJMzVRSElHbHVzNXMrVWRoYXU5UExjTEE9PQ==
  • Sumeru Solutions
  • Remote

Job Description

  • Primary goal is to maintain existing environment/code (top focus)
  • Migrating DB to cloud (Azure)
  • Future will create a layer that connects to DB to have a standalone application
  • Working to keep up with increased workload with acquisitions in general code, security, reporting, etc. not up to standards Shubh wants. Needs these resources to come in with best practices and help to improve the current state
  • All roles need to be Senior resources, will help teach domain knowledge, but otherwise need to come in and contribute immediately

Senior SQL Developer Overview:

  • Working with inherited code from acquisitions, it is messy so working to maintain, manage, and refactor PL/SQL in their Oracle SQL DB
  • First focus is to maintain/manage existing code; includes complex packages, stored procedures, functions, views, etc.
  • Performance tuning and maintenance to ensure operations stay functional and smooth; handle partner files and run eligibility comparisons
  • ETL process is currently script driven
  • Will help generate business focused reporting and working towards a self-service reporting tool for the business (via Oracle apex)
  • Working towards a cloud migration (Azure); will be part lift and shift of current DB and some refactoring
  • Refactoring for cloud migration will be focused on optimizing table structures and connections and removing duplicate properties
  • During migration will take opportunity to enhance current security protocols

Must Have

  • Strong experience with PL/SQL
  • Oracle DB
  • Large-scale data processing and reporting
  • SQL complex queries, stored procedures, performance tuning
  • Cloud migration concepts Azure SQL Database preferred (Oracle Cloud, AWS RDS)

Job Tags

Immediate start, Remote job, Work alone, Shift work,

Similar Jobs

United Site Services

Tech Helper-Fence Job at United Site Services

 ...organization that values continuous improvement, teamwork, and excellence in every aspect of our business. Overview: The Tech Helper-Fence (Fence Helper) assists with the unloading and installing fence panels, poles and other materials at designated work sites.... 

Floyd Lee Locums

Locum Tenens CRNA - Anesthesia Job at Floyd Lee Locums

 ...Job Description Floyd Lee Locums is seeking a CRNA Anesthesia for a locum tenens job in High Point, North Carolina. Job Description & Requirements ~ Specialty: Anesthesia ~ Discipline: CRNA ~ Start Date: 07/28/2025~ Duration: 26 weeks ~40 hours per week... 

National Indian Health Board

Senior Director of Government Relations Job at National Indian Health Board

Join to apply for the Senior Director of Government Relations role at National Indian Health BoardContinue with Google Continue with GoogleJoin to apply for the Senior Director of Government Relations role at National Indian Health BoardNational Indian Health Board... 

Marriott

Spa Massage Therapist Job at Marriott

 ...InformationJob Number 25064266Job Category SpaLocation W Atlanta Downtown, 45 Ivan...  ...-ManagementPOSITION SUMMARYProvide massage services to guests using props and/or products...  ...for Inappropriate conduct for guests and therapists, leading up to and including stopping a... 

Transdev

Bus Driver Job at Transdev

 ...smooth boarding, comfortable rides, and timely disembarkation for all. \n \n Vehicle...  ...not required)\n \n ~ Minimum 3 years of driving experience (personal or professional)\n \...  ...physical if applicable. DOT Regulation 49 CFR Part 40 does not authorize the use of Schedule...