Oracle PLSQL Developer

Job description

**Roles and Responsibilities :** - Design, develop, test, and deploy PL/SQL code for complex database applications. - Optimize database performance by implementing indexing strategies, creating efficient queries, and tuning stored procedures. - Collaborate with cross-functional teams to identify business requirements and design solutions that meet those needs. - Troubleshoot issues related to database performance, data integrity, and security. **Job Requirements :** - 7-10 years of experience in Oracle PL/SQL development. - Strong understanding of triggers (e.g., SQL functions), packages (e.g., BIP), stored procedures (e.g., DBMS\\_STOREDPROCEDURE). - Experience with indexing techniques (e.g., partitioning) for improved query performance. - Proven track record of optimizing database performance through tuning stored procedures. We are looking for an experienced Oracle Technical Specialist with strong expertise in design, development, and advanced Oracle technologies. The ideal candidate will be responsible for building scalable database solutions, optimizing performance, and implementing advanced Oracle features to meet business requirements. Design robust, scalable, and high-performance Oracle database solutions. Develop data models, database schemas, and architecture aligned with business needs. Collaborate with functional teams to translate business requirements into technical solutions. Development Develop, test, and maintain PL/SQL procedures, packages, triggers, and functions. Design and implement complex SQL queries and performance-optimized data processing logic. Develop integrations using Oracle APIs, web services, and middleware tools. Advanced Oracle Technologies Implement and manage advanced Oracle features such as Oracle RAC (Real Application Clusters) Data Guard / GoldenGate Partitioning, Indexing, and Performance Tuning Advanced Queuing (AQ) Apply best practices for database performance tuning, security, and scalability. Performance Optimization Monitor database performance and identify bottlenecks. Optimize queries, indexing strategies, and execution plans. Conduct capacity planning and database health checks.