Job Description for Oracle Developer
Kavi India Software Technologies is seeking an experienced Oracle Developer to lead the strategies and design of our information architecture. This role is critical to ensuring our data is efficiently collected securely stored seamlessly integrated and readily consumable across the organization. The ideal candidate will have strong technical expertise in Oracle technologies coupled with excellent business acumen and communication skills to collaborate with stakeholders analysts and data scientists.
Responsibilities:
Database Design and Development: Design and implement scalable and secure Oracle database solutions ensuring high availability and performance. Create and optimize database objects including tables indexes views sequences and materialised views.
Information Architecture Strategy: Develop and maintain guidelines models and standards for data collection storage transformation integration and consumption. Define and document the organization s data architecture strategy ensuring alignment with business goals.
Data Integration and ETL Processes: Design and implement ETL processes to integrate data from multiple sources into the Oracle ecosystem. Ensure data pipelines are efficient reliable and compliant with data governance policies.
Data Governance and Quality: Define and enforce data quality standards ensuring data accuracy integrity and security. Develop and implement data security measures including access control encryption and backup policies.
Performance Tuning and Optimization: Monitor and optimize database performance using tools like AWR TKPROF and Oracle Enterprise Manager. Troubleshoot and resolve complex database issues to ensure seamless operations.
Documentation and Training: Create comprehensive documentation for database designs processes and standards. Train team members and stakeholders on the use of Oracle tools and data architecture guidelines. Stay current with modern information architecture principles and emerging Oracle technologies.
Required Skills and Qualifications:
Bachelor s/master s degree in computer science Information Systems or a related field.
810 yrs of total experience with minimum 2 5 yrs of proven experience as an Oracle Developer with a strong focus on database architecture and strategy.
3 years of experience with Big Data technologies and cloud solutions.
Expertise in SQL and PL/SQL programming.
Deep understanding of Oracle database technologies including RAC Data Guard partitioning and implementing enterprise level data solutions on Oracle platform.
Strong knowledge of data modelling normalisation and schema design.
Familiarity with data governance compliance and security best practices.
Excellent problemsolving and analytical skills.
Exceptional communication and interpersonal skills to engage with stakeholders and crossfunctional teams.
Preferred Qualifications:
Experience with Oracle Cloud Infrastructure (OCI) and cloudbased data solutions.
Familiarity with BI tools such as Oracle BI Publisher or thirdparty reporting platforms.
Certification in Oracle Database or related technologies (e.g. Oracle Certified Professional).
Additional Qualifications:
Strong coding skills in at least one modern programming language.