Senior Oracle Database Engineer / PL/SQL Developer

Senior Oracle Database Engineer / PL/SQL DeveloperLocation: MA, CA, FL (Relocation is fine)We are seeking a highly experienced Senior Oracle Database Engineer / PL/SQL Developer with 18+ years of hands-on experience in Oracle database development, SQL, and PL/SQL programming. The ideal candidate must possess deep expertise in designing, developing, optimizing, and supporting large-scale, mission-critical Oracle database applications. This role requires an Oracle expert with exceptional skills in complex PL/SQL programming, SQL optimization, database performance tuning, data modeling, and enterprise database architecture. The candidate should have extensive experience building high-performance database solutions capable of handling large data volumes while ensuring scalability, reliability, security, and maintainability. The ideal professional will have a proven track record of designing enterprise-grade database solutions, optimizing complex SQL queries, troubleshooting performance bottlenecks, and mentoring development teams on Oracle best practices.Key ResponsibilitiesDesign, develop, and maintain enterprise-scale Oracle database applications.Develop highly optimized and reusable PL/SQL Packages, Procedures, Functions, Triggers, Views, Materialized Views, Sequences, and Indexes.Build scalable and maintainable database solutions for high-volume transactional systems.Develop robust database utilities, reusable components, and automation scripts.Advanced PL/SQL DevelopmentDevelop complex PL/SQL programs for enterprise business applications.Write efficient and optimized SQL and PL/SQL code following Oracle best practices.Implement advanced PL/SQL concepts including:Bulk CollectFORALLCollectionsDynamic SQLRef CursorsException HandlingAutonomous TransactionsPipelined FunctionsObject TypesPackagesCompound TriggersSQL Performance OptimizationAnalyze and optimize complex SQL queries for maximum performance.Perform advanced query tuning using:Execution PlansExplain PlanSQL TraceTKPROFAWR ReportsASH ReportsSQL Tuning AdvisorOptimize joins, indexes, partitioning strategies, and database access paths.Eliminate performance bottlenecks in high-volume production systems.Oracle Database EngineeringDesign logical and physical database models.Develop scalable database architecture for enterprise applications.Implement database normalization and denormalization strategies where appropriate.Design high-performance data structures for OLTP and reporting applications.Database Performance TuningMonitor and improve Oracle database performance.Tune memory structures, indexing strategies, partitioning, and storage optimization.Identify locking, blocking, deadlocks, and concurrency issues.Optimize batch processing and ETL performance.Data Migration & IntegrationDesign and support large-scale data migration initiatives.Develop high-performance ETL processes and database interfaces.Support data conversion, transformation, and synchronization projects.Integrate Oracle databases with enterprise applications and external systems.Production SupportTroubleshoot production database issues.Resolve SQL and PL/SQL performance problems.Support critical production releases and deployments.Participate in root cause analysis and performance improvement initiatives.Technical LeadershipProvide technical leadership for Oracle database development initiatives.Mentor junior developers on Oracle architecture, SQL optimization, and PL/SQL best practices.Conduct code reviews and establish database development standards.Collaborate with Architects, Application Developers, DBAs, QA teams, and Business Analysts.Required Qualifications18+ years of hands-on experience in Oracle Database Development.Extensive expertise in Oracle SQL and PL/SQL programming.Expert-level knowledge of:PL/SQL PackagesStored ProceduresFunctionsTriggersViewsMaterialized ViewsSequencesSynonymsIndexesStrong expertise in advanced SQL optimization and database performance tuning.Experience designing enterprise-scale Oracle database applications.Deep understanding of Oracle database internals and architecture.Experience with Oracle 11g, 12c, 19c, or later versions.Strong knowledge of relational database concepts and data modeling.Experience with database security, transactions, locking mechanisms, and concurrency control.Excellent debugging, analytical, and problem-solving skills.Preferred SkillsExperience with Oracle RAC, ASM, Data Guard, and RMAN.Experience with Oracle Exadata environments.Knowledge of ETL tools and data warehouse concepts.Experience with Shell Scripting, Python, or PowerShell for automation.Familiarity with cloud database platforms such as Oracle Cloud Infrastructure (OCI), AWS RDS for Oracle, or Azure Oracle Database solutions.Experience working in Banking, Finance, Insurance, Healthcare, or other enterprise environments.Exposure to Agile/Scrum development methodologies.Technical Skills Oracle TechnologiesOracle DatabaseOracle SQLOracle PL/SQLOracle 19cOracle 12cOracle 11gOracle RACOracle ASMOracle Data GuardRMANOracle SQL DeveloperAdvanced PL/SQLPackagesProceduresFunctionsTriggersRef CursorsDynamic SQLBulk CollectFORALLCollectionsException HandlingPipelined FunctionsMaterialized ViewsPerformance TuningSQL OptimizationExplain PlanExecution PlansSQL TraceTKPROFAWRASHSQL Tuning AdvisorIndex OptimizationPartitioningDatabase DesignData ModelingDatabase ArchitectureNormalizationDenormalizationOLTPData WarehousingAdditional SkillsETLShell ScriptingGitCI