About the role
Mandatory skills- plsql,posgressql
- Experience – 5+years
- Location – BLR/HYD/Chennai
- Notice period – Immediate
- Budget-18 LPA
- Njoyn id-J1125-0400
Role Overview
The Oracle PL/SQL Developer is responsible for designing, developing, and maintaining robust database solutions using Oracle PL/SQL. This role involves writing complex queries, stored procedures, functions, triggers, and packages, as well as optimizing existing code for performance and scalability. The developer will collaborate with cross-functional teams to ensure database systems meet business requirements and adhere to best practices.
Key Responsibilities
- Database Development
- Design, develop, and maintain PL/SQL code including procedures, functions, triggers, and packages.
- Implement database changes, enhancements, and new functionalities.
- Performance Optimization
- Tune and optimize PL/SQL queries for high performance and scalability.
- Conduct performance analysis and troubleshoot bottlenecks.
- Data Management
- Perform data migration and ETL (Extract, Transform, Load) processes.
- Ensure data integrity, accuracy, and security across systems.
- Collaboration
- Work closely with application developers, business analysts, and DBAs to define requirements.
- Participate in Agile ceremonies such as sprint planning and daily stand-ups.
- Compliance
- Ensure adherence to database security standards and organizational policies.
Technical Skills
- Core Expertise
- Oracle Database architecture and PL/SQL programming.
- Advanced SQL and query optimization techniques.
- Tools & Technologies
- Oracle SQL Developer, TOAD, ERWIN.
- Familiarity with Oracle 12c/19c features.
- Additional Skills
- Data modeling and database design principles.
- ETL processes and data warehousing concepts.
- Knowledge of partitioning, indexing, and archival strategies.
- Performance Tuning
- Use of tools and techniques for query optimization and workload management.
- Security
- Understanding of database security best practices.
Preferred Experience
- Exposure to Java or other programming languages for integration.
- Familiarity with reporting and BI tools.
- Experience in healthcare, finance, or similar data-intensive domains.