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

Six Flags Darien Lake

Warehouse Worker- Starting at $15.50 per hour Job at Six Flags Darien Lake

 ...throughout Six Flags Darien Lake. Must be available to work varying hours including nights, weekends and holidays based on business needs....  .... Must be able to sit and/stand/and walk for long periods of time throughout the day Must be able to work outdoors at various... 

LVI Associates

Chief Mechanical Engineer Job at LVI Associates

 ...About the Role Are you seeking variety and technical challenges in your career? We're looking for a forward-thinking Chief Mechanical Engineer to lead quality control for mechanical design projects across diverse sectors including life sciences, mission-critical, commercial... 

Campbell Property Management

Property Manager Job at Campbell Property Management

 ...Responsibilities include, but are not limited to: ~ Oversee the management of the community, including but not limited to: ~ o Ensure...  ...the board, residents and others. The primary role of a property manager is to serve the board in helping them achieve their... 

Red Points

Customer Onboarding Manager Job at Red Points

 ...City, Red Points has disrupted an industry traditionally led by service providers with a scalable, cost-effective solution. Be...  ...to make the Internet a safer place Job Description As a Customer Onboarding Manager you will be responsible for the onboarding of... 

zTrip STX

Call Taker Job at zTrip STX

Join Our Team as a CALL TAKER at zTrip! Are you passionate, dedicated, and self-motivated? zTrip is seeking a CALL TAKER who brings fresh ideas, strong communication skills, and a collaborative spirit to our growing operation. Were looking for someone eager to learn...