Database Developer

Position Title: Oracle Developer - PL/SQL Specialist Experience Required: 10+years Location: Bangalore Employment Type: Full-Time Job Summary: The role requires a highly skilled Oracle Developer with 5-7 years of experience in developing and optimizing complex database solutions. The primary responsibility will be creating and maintaining extensive stored procedures that efficiently populate data into a target table from multiple source tables (6-7). The ideal candidate should have a strong understanding of Oracle database architecture, advanced PL/SQL programming, and data optimization techniques. Technical Skills: 5-7 years of hands-on experience in Oracle PL/SQL development. Proficient in designing and optimizing stored procedures, views, and materialized views. Strong knowledge of database indexing, partitioning, and performance tuning techniques. Experience in working with large datasets and integrating data from multiple tables. Hands-on experience with Oracle SQL Plus (CLI) Familiarity with Oracle Database 19c/21c. Knowledge of ETL processes and tools. Strong analytical skills to interpret data requirements and build database solutions. Ability to troubleshoot complex database issues efficiently. Preferred: Oracle Certification (e.g., Oracle Database SQL Certified Associate or higher) is a plus. Familiarity with data migration, data warehousing, or similar projects is an advantage. Experience with database administration and monitoring tools. Knowledge of cloud database platforms (e.g., Oracle Cloud, AWS RDS). Key Responsibilities: Design, develop, and maintain complex stored procedures to handle data integration from 6-7 tables into a consolidated table. Ensure high performance and efficiency of all database operations Analyze and optimize database queries and structures to improve performance. Create indexes, partitions, and other database optimizations as necessary Implement data validation, transformation, and cleansing logic within stored procedures. Collaborate with business analysts and data teams to understand requirements and ensure accurate data mapping. Identify and resolve performance bottlenecks and errors in SQL code. Conduct root cause analysis for production issues and provide fixes. Work closely with cross-functional teams to deliver database solutions aligned with business goals. Clearly communicate technical concepts and project progress to stakeholders.