06 Sep
|
CosMicIT
|
Kozhikode
06 Sep
CosMicIT
Kozhikode
About the Company
We are seeking an experienced and highly skilled PL/SQL Developer with a strong emphasis on hands-on backend database coding, performance tuning, and complex business logic implementation.
About the Role
In this role, you will design, write, optimize, and maintain database components (procedures, functions, packages, triggers, and analytical queries) for large-scale enterprise applications.
Responsibilities
- Core PL/SQL Development: Write clean, scalable, and highly effective PL/SQL code, including complex Stored Procedures, Functions, Packages, Database Triggers, and Views.
- Database Design & Architecture: Design relational database schemas, tables, constraints, sequences, and indexes while maintaining data integrity and normalization standards.
- Performance Tuning & Optimization: Identify and resolve SQL/PL/SQL performance bottlenecks using Execution Plans, EXPLAIN PLAN, TKPROF, AWR/ASH reports, dynamic performance views, and hint optimization.
- Complex Data Processing: Develop advanced ETL pipelines and batch processing scripts utilizing BULK COLLECT,
FORALL, collections, cursors, and table functions to handle high volumes of data efficiently.
- Business Logic Implementation: Translate complex business requirements into robust database-level logic and automated workflows.
- Data Migration & Integration: Write scripts for database maintenance, data transformations, standardizations, and migrations across different environments.
- Troubleshooting & Maintenance: Debug production issue logs, handle database exceptions, implement fault-tolerant error handling mechanisms, and ensure zero data loss.
- Collaboration & Code Reviews: Conduct rigorous peer code reviews to enforce Oracle best practices, SQL standards, and continuous integration workflows.
Qualifications
- Education: Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field (or equivalent practical experience).
- Experience: 3 to 7 years of pure
📌 PL/SQL Developer (Kozhikode)
🏢 CosMicIT
📍 Kozhikode