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

Capital One Careers

Senior Manager, Finance, Bank Tech Job at Capital One Careers

Senior Manager, Finance, Bank Tech Provide financial leadership to client groups, including managing the processes of the quarterly...  ...: ~ Masters Degree in Business Administration (MBA) or Masters Degree in Finance ~ Chartered Financial Analyst (... 

Mount Carmel Rehabilitation & Nursing Center

Assistant Director of Nursing Services (ADNS) Job at Mount Carmel Rehabilitation & Nursing Center

Description: Mount Carmel Rehabilitation and Nursing Center, in Manchester, NH is looking for an experienced, full-time Assistant Director of Nursing Services (ADNS) to join our nursing management team. Because of our team, we are a 5-star facility and a proud recipient...

Confidential

Vice President, Controllership, TV Networks - SpinCo Job at Confidential

 ...Vice President, Controllership, TV Networks - SpinCo About the Company Top-tier media, entertainment, & broadcasting company Industry Entertainment Type Subsidiary of a Public Company Founded 2004 Employees 10,001+ Categories Curated Web... 

ChenMed

Chief Clinical Officer Job at ChenMed

 ...facilitator, and care coordinator for patients able to come to the office. For patients that are unable to come to the officein...  .... Available and Accessible for patients in order to build trust. It is expected that the Lead PCP will make themselves as accessible... 

Pantomath

Customer Success Co-op (Graduate Intern) Job at Pantomath

 ...Description Pantomath is seeking a motivated and detail-oriented graduate student to join our Customer Experience team as a Customer...  ...is ideal for someone pursuing a Master's in Information Systems, MBA, or a related field with a strong interest in SaaS solutions and...