{"schemaVersion":"jobsearcher.job.v1","id":"1532a6c0b5460b77e3f8c6be","url":"https://jobsearcher.com/jobs/1532a6c0b5460b77e3f8c6be","canonicalUrl":"https://jobsearcher.com/jobs/1532a6c0b5460b77e3f8c6be","title":"PL/SQL Developer","description":"Overview\nAs a Senior Developer, you will design and optimize Oracle-based solutions for a CRM analytics repository, bridging data warehousing with production support. You join the ECRM team to enhance analytics and campaign operations at scale, tackling performance and data integration challenges on Unix/AIX systems. You will shape data flows, implement robust PL/SQL solutions, and ensure 24/7 reliability of critical production processes. This role offers the chance to influence CRM analytics strategies and work with cross-functional teams to drive data-driven campaigns.\n\nResponsibilitiesAnalyze, design and develop solutions for the analytical CRM repository on OracleProvide 24/7 support for production processes and applicationsWork under the ECRM team lead and collaborate on CRM analytics and campaign operationsDesign end-to-end data solutions and optimize performance for large datasetsDevelop and tune PL/SQL procedures, packages, triggers and dynamic SQLImplement ETL design and development with Informatica knowledge as a plusUtilize SQL analytic functions (RANK, DENSE_RANK) and advanced indexing/partitioning techniquesEngage in data modeling, data warehousing design and data loading from multiple sourcesTune queries, apply Oracle hints, and leverage parallel execution for VLDBsFamiliarity with Unix/AIX environments and shell scripting\nKey requirementsOracle Database expertiseStrong PL/SQL including procedures, triggers, and packagesSQL with analytical capabilities and performance tuningDynamic SQL, Oracle hints, and advanced indexing/partitioningVLDB handling, data partitioning and parallel executionUnix/AIX experience and shell scriptingInformatica knowledge a plusExperience with data warehousing and ETL development5+ years in DBMS and software development methodologiesAbility to work in fast-paced, team environment and lead minor tasksMotivated self-starterTeam player that can participate in design reviewsAbility to lead minor tasks and monitor progressOracle DatabasePL/SQLSQL","company":"Sonsoft","rawCompany":"sonsoft","city":"Los Angeles","state":"CA","isRemote":false,"isActive":false,"createdAt":"2026-09-15T03:38:40.636Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"}],"industries":[{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"PL/SQL Developer","description":"Overview\nAs a Senior Developer, you will design and optimize Oracle-based solutions for a CRM analytics repository, bridging data warehousing with production support. You join the ECRM team to enhance analytics and campaign operations at scale, tackling performance and data integration challenges on Unix/AIX systems. You will shape data flows, implement robust PL/SQL solutions, and ensure 24/7 reliability of critical production processes. This role offers the chance to influence CRM analytics strategies and work with cross-functional teams to drive data-driven campaigns.\n\nResponsibilitiesAnalyze, design and develop solutions for the analytical CRM repository on OracleProvide 24/7 support for production processes and applicationsWork under the ECRM team lead and collaborate on CRM analytics and campaign operationsDesign end-to-end data solutions and optimize performance for large datasetsDevelop and tune PL/SQL procedures, packages, triggers and dynamic SQLImplement ETL design and development with Informatica knowledge as a plusUtilize SQL analytic functions (RANK, DENSE_RANK) and advanced indexing/partitioning techniquesEngage in data modeling, data warehousing design and data loading from multiple sourcesTune queries, apply Oracle hints, and leverage parallel execution for VLDBsFamiliarity with Unix/AIX environments and shell scripting\nKey requirementsOracle Database expertiseStrong PL/SQL including procedures, triggers, and packagesSQL with analytical capabilities and performance tuningDynamic SQL, Oracle hints, and advanced indexing/partitioningVLDB handling, data partitioning and parallel executionUnix/AIX experience and shell scriptingInformatica knowledge a plusExperience with data warehousing and ETL development5+ years in DBMS and software development methodologiesAbility to work in fast-paced, team environment and lead minor tasksMotivated self-starterTeam player that can participate in design reviewsAbility to lead minor tasks and monitor progressOracle DatabasePL/SQLSQL","datePosted":"2026-09-15T03:38:40.636Z","dateModified":"2026-09-15T03:38:40.636Z","hiringOrganization":{"@type":"Organization","name":"Sonsoft","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Los Angeles","addressRegion":"CA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"1532a6c0b5460b77e3f8c6be"},"url":"https://jobsearcher.com/jobs/1532a6c0b5460b77e3f8c6be"}}