{"schemaVersion":"jobsearcher.job.v1","id":"59a9c770cc626f816c5cd58b","url":"https://jobsearcher.com/jobs/59a9c770cc626f816c5cd58b","canonicalUrl":"https://jobsearcher.com/jobs/59a9c770cc626f816c5cd58b","title":"Senior Oracle PL/SQL Developer","description":"Senior Oracle PL/SQL DeveloperAbout Innovya Technologies\nInnovya Technologies is seeking an experienced Senior Oracle PL/SQL Developer to join our engineering team and support the development, modernization, and integration of enterprise-scale applications. The ideal candidate will have strong expertise in Oracle PL/SQL, advanced SQL development, database performance tuning, data integration, and enterprise application development.\nThis role will work closely with application developers, database administrators, data engineers, architects, QA teams, and business stakeholders to deliver scalable and reliable database solutions. The candidate should be comfortable working in complex enterprise environments with high-volume transactional systems and business-critical applications.\nRole Overview\nThe Senior Oracle PL/SQL Developer will be responsible for designing, developing, optimizing, and supporting Oracle database solutions. The role requires hands-on experience with complex PL/SQL programming, SQL performance optimization, database objects, batch processing, data integration, and production troubleshooting.\nThe successful candidate will contribute to application modernization, database migration, data integration, and cloud transformation initiatives while ensuring strong performance, data integrity, security, and maintainability.\nKey Responsibilities\nDesign, develop, enhance, and maintain complex PL/SQL packages, stored procedures, functions, triggers, cursors, collections, and database objects.\nDevelop complex and highly optimized SQL queries for large-volume transactional and enterprise databases.\nAnalyze SQL execution plans and identify opportunities for query and database performance optimization.\nDesign and implement appropriate indexing, partitioning, materialized views, and other Oracle performance-tuning strategies.\nDevelop database solutions supporting enterprise applications, APIs, reporting platforms, and data integration processes.\nBuild and maintain ETL processes, batch jobs, database jobs, and automated data processing workflows.\nDevelop database scripts for data migration, transformation, reconciliation, and system integration.\nTroubleshoot complex production issues involving SQL, PL/SQL, data integrity, performance, and application/database interactions.\nCollaborate with Java and other application development teams to design efficient database access patterns and integration solutions.\nWork with DBAs and architects to support database architecture, capacity, performance, availability, and scalability requirements.\nParticipate in database code reviews and establish development standards and best practices.\nDevelop and maintain database deployment scripts using Git, Azure DevOps, Jenkins, or other CI/CD tools.\nSupport application and database modernization initiatives, including migration from legacy/on-premises environments to cloud platforms.\nPerform root-cause analysis for production defects and implement permanent corrective solutions.\nParticipate in Agile/Scrum ceremonies, technical discussions, design reviews, and release activities.\nProvide technical guidance and mentorship to junior and mid-level developers when required.\nRequired Qualifications & Technical Skills\n6+ years of professional experience in Oracle PL/SQL development in enterprise environments.\nStrong hands-on expertise in Oracle PL/SQL, including:\nPackages\nStored procedures\nFunctions\nCursors\nTriggers\nCollections\nException handling\nDynamic SQL\nAdvanced SQL development skills, including complex joins, subqueries, CTEs, analytical/window functions, aggregations, and query optimization.\nStrong experience with Oracle Database 12c, 19c, or newer.\nHands-on experience with Oracle database performance tuning and troubleshooting.\nStrong understanding of:\nIndexing\nPartitioning\nMaterialized views\nExecution plans\nOptimizer statistics\nDatabase locking and concurrency\nExperience supporting high-volume OLTP and enterprise database workloads.\nExperience with Oracle development tools such as SQL Developer, TOAD, SQL*Plus, or equivalent.\nExperience developing database-driven ETL and data integration solutions.\nExperience with Oracle Scheduler, database jobs, Data Pump, and database migration processes.\nExperience integrating Oracle databases with Java, .NET, Python, REST APIs, or other enterprise applications.\nStrong understanding of relational database concepts, normalization, data modeling, and database design.\nExperience with Git and CI/CD-based database deployment processes.\nStrong debugging, troubleshooting, root-cause analysis, and performance-tuning capabilities.\nExperience working in an Agile/Scrum development environment.\nStrong communication and collaboration skills.\nPreferred Qualifications\nExperience with Oracle Cloud Infrastructure (OCI) and Oracle Cloud Database services.\nExperience with Oracle Autonomous Database.\nHands-on experience with Oracle RAC, Exadata, or Data Guard.\nExperience with Oracle GoldenGate, Oracle Integration Cloud (OIC), or Oracle SOA.\nExperience supporting cloud database migration and modernization initiatives.\nExperience with Azure or AWS cloud environments.\nKnowledge of enterprise data warehousing and dimensional modeling.\nExperience with shell scripting, Python, or PowerShell for database automation.\nExperience with Oracle APEX.\nExperience in healthcare, insurance, financial services, retail, or other large-scale enterprise environments.\nExperience working with highly regulated systems requiring data security, auditability, compliance, and data governance.\nIdeal Candidate Profile\nThe ideal candidate is a hands-on senior developer who can independently analyze complex database problems, develop high-quality PL/SQL solutions, optimize database performance, and collaborate effectively with cross-functional engineering teams.\nCandidates should demonstrate strong problem-solving skills, ownership, attention to detail, and the ability to work in large enterprise environments with complex data, integration, and application requirements.\nPay: $55.00 - $80.00 per hour\nWork Location: In person","company":"Innovya Technologies","rawCompany":"innovya technologies","city":"Phoenix","state":"AZ","isRemote":false,"isActive":false,"createdAt":"2026-08-13T15:21:12.399Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"}],"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":"Senior Oracle PL/SQL Developer","description":"Senior Oracle PL/SQL DeveloperAbout Innovya Technologies\nInnovya Technologies is seeking an experienced Senior Oracle PL/SQL Developer to join our engineering team and support the development, modernization, and integration of enterprise-scale applications. The ideal candidate will have strong expertise in Oracle PL/SQL, advanced SQL development, database performance tuning, data integration, and enterprise application development.\nThis role will work closely with application developers, database administrators, data engineers, architects, QA teams, and business stakeholders to deliver scalable and reliable database solutions. The candidate should be comfortable working in complex enterprise environments with high-volume transactional systems and business-critical applications.\nRole Overview\nThe Senior Oracle PL/SQL Developer will be responsible for designing, developing, optimizing, and supporting Oracle database solutions. The role requires hands-on experience with complex PL/SQL programming, SQL performance optimization, database objects, batch processing, data integration, and production troubleshooting.\nThe successful candidate will contribute to application modernization, database migration, data integration, and cloud transformation initiatives while ensuring strong performance, data integrity, security, and maintainability.\nKey Responsibilities\nDesign, develop, enhance, and maintain complex PL/SQL packages, stored procedures, functions, triggers, cursors, collections, and database objects.\nDevelop complex and highly optimized SQL queries for large-volume transactional and enterprise databases.\nAnalyze SQL execution plans and identify opportunities for query and database performance optimization.\nDesign and implement appropriate indexing, partitioning, materialized views, and other Oracle performance-tuning strategies.\nDevelop database solutions supporting enterprise applications, APIs, reporting platforms, and data integration processes.\nBuild and maintain ETL processes, batch jobs, database jobs, and automated data processing workflows.\nDevelop database scripts for data migration, transformation, reconciliation, and system integration.\nTroubleshoot complex production issues involving SQL, PL/SQL, data integrity, performance, and application/database interactions.\nCollaborate with Java and other application development teams to design efficient database access patterns and integration solutions.\nWork with DBAs and architects to support database architecture, capacity, performance, availability, and scalability requirements.\nParticipate in database code reviews and establish development standards and best practices.\nDevelop and maintain database deployment scripts using Git, Azure DevOps, Jenkins, or other CI/CD tools.\nSupport application and database modernization initiatives, including migration from legacy/on-premises environments to cloud platforms.\nPerform root-cause analysis for production defects and implement permanent corrective solutions.\nParticipate in Agile/Scrum ceremonies, technical discussions, design reviews, and release activities.\nProvide technical guidance and mentorship to junior and mid-level developers when required.\nRequired Qualifications & Technical Skills\n6+ years of professional experience in Oracle PL/SQL development in enterprise environments.\nStrong hands-on expertise in Oracle PL/SQL, including:\nPackages\nStored procedures\nFunctions\nCursors\nTriggers\nCollections\nException handling\nDynamic SQL\nAdvanced SQL development skills, including complex joins, subqueries, CTEs, analytical/window functions, aggregations, and query optimization.\nStrong experience with Oracle Database 12c, 19c, or newer.\nHands-on experience with Oracle database performance tuning and troubleshooting.\nStrong understanding of:\nIndexing\nPartitioning\nMaterialized views\nExecution plans\nOptimizer statistics\nDatabase locking and concurrency\nExperience supporting high-volume OLTP and enterprise database workloads.\nExperience with Oracle development tools such as SQL Developer, TOAD, SQL*Plus, or equivalent.\nExperience developing database-driven ETL and data integration solutions.\nExperience with Oracle Scheduler, database jobs, Data Pump, and database migration processes.\nExperience integrating Oracle databases with Java, .NET, Python, REST APIs, or other enterprise applications.\nStrong understanding of relational database concepts, normalization, data modeling, and database design.\nExperience with Git and CI/CD-based database deployment processes.\nStrong debugging, troubleshooting, root-cause analysis, and performance-tuning capabilities.\nExperience working in an Agile/Scrum development environment.\nStrong communication and collaboration skills.\nPreferred Qualifications\nExperience with Oracle Cloud Infrastructure (OCI) and Oracle Cloud Database services.\nExperience with Oracle Autonomous Database.\nHands-on experience with Oracle RAC, Exadata, or Data Guard.\nExperience with Oracle GoldenGate, Oracle Integration Cloud (OIC), or Oracle SOA.\nExperience supporting cloud database migration and modernization initiatives.\nExperience with Azure or AWS cloud environments.\nKnowledge of enterprise data warehousing and dimensional modeling.\nExperience with shell scripting, Python, or PowerShell for database automation.\nExperience with Oracle APEX.\nExperience in healthcare, insurance, financial services, retail, or other large-scale enterprise environments.\nExperience working with highly regulated systems requiring data security, auditability, compliance, and data governance.\nIdeal Candidate Profile\nThe ideal candidate is a hands-on senior developer who can independently analyze complex database problems, develop high-quality PL/SQL solutions, optimize database performance, and collaborate effectively with cross-functional engineering teams.\nCandidates should demonstrate strong problem-solving skills, ownership, attention to detail, and the ability to work in large enterprise environments with complex data, integration, and application requirements.\nPay: $55.00 - $80.00 per hour\nWork Location: In person","datePosted":"2026-08-13T15:21:12.399Z","dateModified":"2026-08-13T15:21:12.399Z","hiringOrganization":{"@type":"Organization","name":"Innovya Technologies","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Phoenix","addressRegion":"AZ","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"59a9c770cc626f816c5cd58b"},"url":"https://jobsearcher.com/jobs/59a9c770cc626f816c5cd58b"}}