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

T240MldTVzU0Vjcvd1kzbk0wTDE1QzE2UlE9PQ==
  • 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

COMMUNITY HEALTH PARTNERSHIP OF ILLINOIS

Community Health Worker Job at COMMUNITY HEALTH PARTNERSHIP OF ILLINOIS

 ...Position: Community Health Worker Location: Harvard, IL Community Health Partnership of Illinois is a is a non-profit organization that provides primary health care to migrant farmworkers and other medically underserved populations throughout northern and central Illinois... 

McNerney Medical

Gastroenterology Job at McNerney Medical

(Physician/MD qualifications required) Gastroenterology - Opportunity to join this award-winning, Medical Center. Well-established practice offers an Outpatient only GI Clinic and outpatient procedures. General GI opportunity, but IBD training or experience is strongly... 

Hatch Global Search

Copy #2 of Recruiter/Sourcer-HealthCare-North America... Job at Hatch Global Search

 ...COMMISSION, GREAT PAY STRUCTURE This is a Start up, with a Top Recruiting Team whom have worked with the top teams across Silicon Valley...  ...for recruiters with vision and a great work ethic. FULLY REMOTE FROM ANYWHERE IN THE US Recruiter responsibilities include:... 

Texas Muslim Women's Foundation

Family Law Attorney - Part Time Job at Texas Muslim Women's Foundation

 ...Position Summary: Provides legal representation on family law matters (i.e. protective orders, custody issues, property settlements...  ...to representing clients. Network with the civil and criminal justice officials and law enforcement to facilitate client and community... 

W. R. Grace & Co.

Loader/Unloader Job at W. R. Grace & Co.

 ...Columbia, MD and locations worldwide. For more information, visit Grace.com . Job Description We are in search of a Loader/Unloader who will report to our Loader Supervisor in our Lake Charles plant. This person will be accountable for unloading all raw materials...