Oracle Developer (SE3) Job at Apex Systems, San Francisco, CA

VmdZd2MzNmsxSHFUMWd1Tmppb2F6WWVWRFE9PQ==
  • Apex Systems
  • San Francisco, CA

Job Description

Join to apply for the Oracle Developer (SE3) role at Apex Systems . Get AI-powered advice on this job and more exclusive features. Job Description / Responsibilities Responsible for designing and developing complex database and data integration (ETL) code for Customer Relationship View (CRV) application and its databases. Leads and/or performs analysis of CRV business requirements, designs and writes technical specifications to design or redesign database solutions. Develops complex PL/SQL Procedures, packages, Functions, Triggers, Views, and Materialized Views. Designs logical partitioned tables. Leads or participates in data modeling, simulations, and analysis for CRV database development. Optimizes performance of existing solutions and supports production issues. Creates complex ETL code to interface Oracle with other databases like SQL Server and text files. Builds frameworks for ETL processes. Verifies program logic through testing and debugging; participates in system testing. Provides application support and technical troubleshooting for database and server issues. Develops documentation, technical procedures, and user guides. Acts as escalation point for support issues, guiding less experienced staff. Ensures quality, security, and compliance of databases and servers. Partners with business teams to produce functional design documents and supports QA testing. Minimum Qualifications 4+ years experience with Oracle database design and development, including Oracle 19c. 2+ years in ETL, Data Modeling, and Data Migration. 1+ years administering Oracle databases. Knowledge of real-time replication and database tuning. Experience with database optimization, partitioning, and large data management. Desired Skills Leading small development teams. Experience with Agile methodologies and Oracle/Informatica ETL environments. Database performance tuning and monitoring. Interfacing Oracle with other databases and replication knowledge. Financial services experience, especially in collections and PL/SQL advanced features. Understanding of Oracle RAC and large data warehousing. Strong interpersonal and problem-solving skills. Additional Information Apex Systems is an equal opportunity employer. We consider qualified applicants with criminal histories in accordance with applicable law. We offer comprehensive benefits, professional development, and a supportive work environment. For accommodations, contact our Employee Services Department. #J-18808-Ljbffr Apex Systems

Job Tags

Similar Jobs

Maimonides Medical Center

Director of Private and Corporate Foundations Job at Maimonides Medical Center

 ...Maimonides clinical programs rank among the best in the country for patient outcomes, including its Heart and Vascular Institute, Neurosciences Institute, Bone and Joint Center, and Cancer Center. Maimonides is an affiliate of Northwell Health and a major clinical... 

HouseWhisper

Growth Marketing MBA Summer Internship Job at HouseWhisper

 ...Location: Seattle, WA (In-Person) Type: 12 weeks Full-Time Summer Internship (JuneAugust) About HouseWhisper HouseWhisper is an AI-...  ...key marketing and sales enablement assets. This is a hands-on, high-impact execution role for someone who thrives in fast-paced... 

Insight Global

Aircraft Mechanic Job at Insight Global

 ...Insight Global is seeking over 100 Aircraft Assemblers to work onsite in Charleston, SC for a large aviaition client of ours! This is a long term contract opportunity and will need to be comfortable working 1st, 2nd, or 3rd shift. Day to Day: Ability to select correct... 

AgPro

Parts Counter Sales Job at AgPro

Parts Counter Sales Location Brunswick, GA : Responsible for selling, receiving, and delivery of parts and accessories. In addition performs in-store customer service, overall organizational promotion, and stocking duties. Job Duties Promotes and sells products and... 

Relanto

Senior Salesforce QA Job at Relanto

We are looking for a candidate who has good experience in QA.Nice to have:Salesforce Service Cloud or Sales Cloud experience.Qualifications and skills:Good understanding of the QA process and experience across all phases.Knowledge of the defect lifecycle....