Senior Oracle PL/SQL DeveloperSenior Oracle PL/SQL Developer
Job TitleSenior Oracle PL/SQL Developer | Oracle Database | SQL | Performance Tuning | Data IntegrationProfessional SummaryHighly experienced Senior Oracle PL/SQL Developer with 11+ years of expertise in designing, developing, optimizing, and maintaining enterprise-grade database solutions using Oracle technologies. Extensive experience in developing complex PL/SQL packages, stored procedures, functions, triggers, views, materialized views, and advanced SQL queries for high-volume transactional and data warehouse environments.Strong expertise in Oracle Database Administration support, performance tuning, query optimization, data migration, ETL processes, database security, and production support. Proven ability to collaborate with cross-functional teams, understand complex business requirements, and deliver scalable, high-performance database solutions across Finance, Banking, Insurance, Healthcare, Retail, Telecom, and Government domains.Experienced in the complete Software Development Life Cycle (SDLC) including requirement analysis, design, development, testing, deployment, production support, and performance optimization. Adept at troubleshooting critical production issues and implementing reliable, secure, and maintainable database solutions.Key ResponsibilitiesDesign, develop, test, deploy, and maintain complex Oracle PL/SQL applications.Develop high-performance Stored Procedures, Packages, Functions, Triggers, Cursors, Views, Materialized Views, and Sequences.Write efficient SQL queries for large-scale enterprise applications.Perform SQL and PL/SQL performance tuning using Explain Plan, SQL Trace, TKPROF, AWR, and Oracle tuning techniques.Optimize database performance through indexing strategies, partitioning, and query rewriting.Develop and maintain ETL processes for data migration and transformation.Build reusable database components following coding standards and best practices.Work with Oracle Forms, Reports, and Oracle APEX applications when required.Design normalized and denormalized database models.Develop data validation, auditing, logging, and exception-handling mechanisms.Implement database security using roles, privileges, encryption, and auditing.Participate in database release management and deployment activities.Support production issues, perform root cause analysis, and provide timely resolutions.Collaborate with Business Analysts, Architects, QA teams, and application developers.Participate in Agile/Scrum ceremonies and sprint planning.Perform code reviews and mentor junior developers.Create technical design documents and database documentation.Ensure data integrity, consistency, and high availability of Oracle databases.Work with version control systems such as Git, SVN, or Azure DevOps.Support cloud-based Oracle database environments when applicable.Required Technical SkillsOracle DatabaseOracle 11gOracle 12cOracle 18cOracle 19cOracle 21cSQL & PL/SQLAdvanced SQLComplex JoinsSubqueriesCTEAnalytical FunctionsWindow FunctionsMERGEDynamic SQLBulk CollectFORALLCollectionsRef CursorException HandlingPackagesProceduresFunctionsTriggersMaterialized ViewsViewsSequencesPerformance TuningExplain PlanSQL TraceTKPROFAWR ReportsASH ReportsSQL Tuning AdvisorIndex OptimizationQuery OptimizationPartitioningParallel ProcessingDatabase DesignData ModelingER ModelingNormalizationDenormalizationConstraintsReferential IntegrityETL & Data IntegrationOracle SQL LoaderExternal TablesOracle Data PumpShell ScriptingInformatica (Preferred)ODI (Preferred)Oracle DevelopmentOracle FormsOracle ReportsOracle APEX (Preferred)XMLJSONREST APIsDevOps & Version ControlGitSVNAzure DevOpsJenkinsCI/CDOperating SystemsLinuxUNIXWindows ServerCloud (Preferred)Oracle Cloud (OCI)AWS RDS OracleAzure Oracle SolutionsCore CompetenciesOracle PL/SQL DevelopmentAdvanced SQL ProgrammingDatabase Performance TuningQuery OptimizationData MigrationETL DevelopmentProduction SupportDatabase DesignData WarehousingRoot Cause AnalysisRelease ManagementSDLCAgile ScrumCode ReviewTechnical LeadershipStakeholder CommunicationProblem SolvingAnalytical ThinkingPreferred QualificationsBachelor''s or Master''s degree in Computer Science, Information Technology, or a related field.Oracle Certified Professional (OCP) certification is a plus.Experience working with Banking, Finance, Insurance, Healthcare, Retail, Telecom, or Government projects.Experience with Oracle Cloud Infrastructure (OCI) is preferred.Knowledge of DevOps and CI/CD practices is an advantage.