Design, develop, and optimize Oracle SQL queries, views, materialized views, indexes, and PL/SQL packages, procedures, and functions.
Analyze execution plans, troubleshoot slow queries, and perform performance tuning (statistics, partitioning, indexing, hints where appropriate).
Develop and maintain Python scripts for data pipelines, Excel automation, and system integrations.
Schedule and monitor batch jobs using Oracle Scheduler (DBMS_SCHEDULER) and Windows Task Scheduler.
Collaborate with business stakeholders (Actuarial, Policy Service, Claims, Finance) to translate requirements into scalable data solutions and reports.
Implement data quality checks, logging, alerting, and reconciliation processes.
Provide production support including root cause analysis, issue resolution, and post-mortem documentation while ensuring SLA adherence and data accuracy.
Required Qualifications
35 years of hands-on experience with Oracle Database (11g/12c/19c+) and PL/SQL development.
Strong SQL fundamentals including joins, CTEs, window/analytic functions, and partitioning.
Experience in performance tuning (Explain Plan, AWR/ASH basics, indexing strategies).
Practical experience with Python for data engineering and automation (pandas, file handling, virtualenv/conda).
Experience building and managing scheduled jobs and batch processes in Windows and/or Linux environments.
Strong understanding of software development best practices (testing, documentation, version control, code reviews).
Excellent communication skills with the ability to work closely with non-technical stakeholders.
