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

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

Fresh Thyme Farmers Markets

Meat Manager Job at Fresh Thyme Farmers Markets

 ...the grocery market. Careers have been blooming at Fresh Thyme since our inception in 2012 - yours should be no different!The Meat Manager is responsible for managing all aspects of the Meat Department including staff, sales, margin, and labor. They are required to assist... 

OpusLex Partners

Affordable Housing Senior Associate / Counsel Attorney - ATL or DC Job at OpusLex Partners

 ...Am Law 200 Firm Affordable Housing & Commercial Real Estate Opportunity A highly respected Am Law 200 firm with 200+ attorneys and offices in Atlanta and Washington, D.C., is expanding its nationally recognized Affordable Housing and Real Estate practice. We are seeking... 

Outlaw Trucking Group

CDL A Driver Lease A Pete Train Drivers 1.50 all miles Job at Outlaw Trucking Group

 ...New program for drivers who want to train drivers while leasing their truck We lease a Pete 579 Cummins engine Zero down No credit check ~ Only 2 deductions truck payment, and 1 deduction for insurance You get paid 1.50 for all the miles you drive plus... 

Providence

CNA - Med Surg *Per Diem, Nights* Job at Providence

 ...Description Under the supervision of an RN or LVN, the CNA/Care Partner will provide direct patient care within the scope of practice...  ..., physician groups and clinics, numerous outreach programs, and hospice and home care. Providence is proud to be an Equal... 

Salina Regional Health Center

Midwest Nocturnist Hospitalist - 7 Days On / 7 Off with Vacation Job at Salina Regional Health Center

 ...in Salina, KS, is now seeking one BE/BC Internal Medicine, Med/Peds or Family Medicine physician to join our hospitalist team! Work as a designated nocturnist 7 pm to 7 am Enjoy the balance of community, family & career with a schedule of 7 days on/ 7 days off Team...