As a Senior Developer, you will operate with limited supervision, taking ownership of the full software development lifecycle for critical database applications.

- Your primary focus will be on delivering high-quality, high-performance Oracle solutions.

- Software Deliverables : Produce high-quality, production-ready software deliverables, ensuring timely completion and compliance with all organizational standards and security policies.

- Full Lifecycle Ownership : Proactively analyze, design, code, unit-test, document, and implement application releases within the database layer.

- Performance & Optimization : Conduct unit tests on large datasets and consistently produce highly optimized solutions to maintain system responsiveness and efficiency.

- Risk Management : Proactively notify managers of potential risks, technical bottlenecks, and implementation issues.

- Quality Assurance : Collaborate closely with Quality Analysts (QAs) to ensure all developed solutions meet defined acceptance criteria and quality standards.

- Mentorship & Review : Act as a mentor for junior developers and actively participate in peer code reviews to maintain code integrity and enforce best practices.

- Agile Environment : Thrive and contribute effectively within a dynamic, fast-paced Agile development methodology.

Essential Experience & Technical Competencies :

The ideal candidate will have extensive, hands-on experience across the entire data lifecycle in enterprise-grade Oracle environments.

Advanced Oracle Development :

- Database Expertise : Full life cycle development experience with Oracle Database (10g and above), specifically managing and optimizing databases with very high volumes ($\ge 5 \text{ TB}$).

- Core PL/SQL Mastery : Strong, demonstrable expertise in SQL/PLSQL development, including advanced performance tuning techniques and robust transaction management.

- PL/SQL Object Development : Hands-on, expert-level development of complex packages, procedures, functions, triggers, advanced SQL, and effective use of bulk DML/DDL operations.

- Advanced Structures : Experience utilizing advanced Oracle structures such as cursors, dynamic SQL, nested tables, and V-arrays.

- Database Fundamentals : Maintain data integrity by ensuring ACID properties, implementing robust exception handling, and advanced debugging of database code.

- Schema Objects : Deep working knowledge of building and maintaining various schema objects, including tables, indexes, views, sequences, and synonyms.

Data Ingestion and Performance Tuning :

- Data Loading : Practical experience with high-volume data ingestion techniques utilizing tools like SQL Loader, external tables, and message queuing systems like Oracle AQs (Advanced Queuing).

- Performance Tuning Tools : Expert-level proficiency in performance tuning using standard Oracle utilities, including interpreting Explain Plans and analyzing AWR reports to effectively identify and resolve issues with long-running jobs.

- Job Orchestration : Experience with job scheduling and management using the native Oracle Job Scheduler or equivalent enterprise scheduling tools.

Development Operations & Environment :

- Source Code Management : Proficiency in using modern source code management systems such as SVN, Git, and Bitbucket.

- CI/CD Integration : Experience with pipeline creation and automation using tools like Jenkins for continuous integration and deployment processes.

- Operating System : Working knowledge of Unix/Linux environments and practical experience with shell scripting for automation and environment management.