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

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

LeadStack Inc.

Senior Project Manager Job at LeadStack Inc.

 ...Place to Work, we're proud to partner with some of the most admired Fortune 500 brands in the world. Job Title: Senior Project Manager Location: Hybrid (required onsite Wednesdays and Thursdays) -Westminster, CA 92683 Duration: 18+ months Pay Rate: $50/hr... 

Lovelace Women's Hospital

Patient Care Tech / PCT Post Partum Job at Lovelace Women's Hospital

 ...patient care. Get to Know Your Team: ~ Lovelace Womens Hospital is a 53-bed advanced neonatal intensive care unit, family care...  ...specimens for lab tests. Provide basic patient transport and housekeeping duties. Qualifications Job Requirements: High... 

Uber

Cash in hand: Uber Driver: You Could Earn $20.84 Per Hour In Newberry Job at Uber

 ...offers flexible, independent work allowing individuals to earn cash quickly by providing rides using their own or rented vehicles. Drivers...  ...of licensed driving experience in the US (3 years if you are under 25 years old) Use an eligible 4-door vehicle You consent to... 

Tata Consultancy Service Limited

Games QA Tester/Engineer Job at Tata Consultancy Service Limited

Job Background: Test games across multiple product lines. Work with QA leads to understand test areas and design test plan. Execute tests across multiple games from various development studios and across multiple devices Job Description: Passionate about games... 

The Henry M. Jackson Foundation for the Advancement of Milit...

Molecular Biology Researcher Job at The Henry M. Jackson Foundation for the Advancement of Milit...

OverviewJoin the HJF Team!HJF is seeking a Molecular Biology Researcher to interdisciplinary research, combining physical,...  ...conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)Any qualifications...