- Audit, analyze, and refactor legacy PL/SQL packages, stored procedures, functions, and triggers into modular, maintainable, and optimized database components.

- Rewrite and optimize complex SQL queries using Oracle 19c Cost-Based Optimizer (CBO) best practices.

- Transform cursor-based and row-by-row processing logic into high-performance set-based SQL using BULK COLLECT and FORALL techniques.

- Perform comprehensive database performance assessments and recommend optimization strategies.

- Design and implement structured logging, tracing, monitoring, auditing, and error-handling frameworks.

- Lead schema redesign initiatives, including normalization, denormalization, and optimization of large-scale enterprise databases.

- Develop advanced partitioning, indexing, compression, and storage strategies for Oracle 19c environments.

- Identify and eliminate technical debt, including obsolete database objects, redundant indexes, inefficient code, and unnecessary data access patterns.





- Perform deep execution plan analysis using Oracle SQL Monitor, SQLTXPLAIN, AWR, ASH, and other diagnostic tools.

- Optimize Azure-hosted applications and services interacting with Oracle databases through enhanced connection pooling, batch processing, and integration patterns.

- Design scalable data integration frameworks leveraging Azure Data Factory and cloud-native technologies.

- Improve database availability, scalability, reliability, and disaster recovery capabilities.

- Collaborate with application developers to embed database performance best practices within software development lifecycles.

- Lead database modernization and migration initiatives across cloud and hybrid environments.

- Establish database governance standards, performance benchmarks, and architectural best practices.

- Provide technical leadership and mentorship to database administrators, developers, and technical teams.

📌 Database Administrator (Ahmedabad)
🏢 Persistent
📍 Ahmedabad