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

Method Recruiting, a 3x Inc. 5000 company

Performance Marketing Copywriter Job at Method Recruiting, a 3x Inc. 5000 company

 ...Our fast-growing d2c tech/wellness client is looking for a full-time Growth/Performance Copywriter to join their team. KEY RESPONSIBILITIES: Write high-converting ad copy for Meta, TikTok, Google, and more Craft email marketing campaigns and flows that engage... 

Cannonball Recruiting LLC

HR Intern Job at Cannonball Recruiting LLC

 ...top employers across various industries, ensuring the right talent is matched with the right opportunity. Description: As a HR Intern , you will work closely with the business owner, assisting with the operations of running a small business and learn the... 

Specialty Medical Staffing

Recruitment Specialist Job at Specialty Medical Staffing

 ...and employee. Role Description This is a full-time virtual role. We are based out of Everett, WA but our team works from home. The Recruitment Specialist will be responsible for tasks such as hiring, interviewing, communication, recruiting, and training on a day... 

Crown Acura

Car Washer Job at Crown Acura

Crown Acura needs Car Washers / Valets due to our continued business growth! Duties Include:* Keeping service drive clear by moving / parking cars * Washing customers cars and vacuuming Crown Automotive Group is GROWING and there is NO BETTER TIME than... 

Milwaukee Division

Detailer Job at Milwaukee Division

The International Autos Group is a family owned and operated group of dealerships serving customers in the Milwaukee, Sheboygan, Chicago, Northwest markets and Minnesota. The owner of the organization is Ralph Mauro, the son of Frank Mauro, who purchased his original dealership...