| urgent need Oracle SQL PLSQL Developer at Auburn, Pennsylvania, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=2035844&uid= From: abhisek.k, source Infotech Inc [email protected] Reply to: [email protected] Title: Oracle SQL/PLSQL Developer Location: Auburn, PA Duration: 12 Months Video interview Need LinkedIn and Passport number Job Summary: We are seeking a highly skilled Oracle SQL/PLSQL Developer to join our dynamic team. The ideal candidate will have extensive experience in writing complex SQL queries, functions, procedures, and packages, along with strong knowledge in performance tuning, DBMS jobs and schedulers, collection, bulk collect and forall concepts, exception handling, indexing, and partitioning. This role requires a proactive individual who can contribute effectively to our database management and application development projects. Key Responsibilities: SQL & PLSQL Development: Write, optimize, and maintain complex SQL queries, functions, procedures, and packages. Develop and implement database triggers for automation of database processes. Analyse the existing code and make changes as needed. Performance Tuning: Conduct performance tuning of SQL queries to ensure optimal execution. Ability to identify bottleneck using various techniques like AWR report , SQL Plan, DBMS Profiler etc., Monitor and improve database performance and efficiency. Database Management: Create and manage DBMS jobs and schedulers for automated tasks. Implement and maintain indexes and partitions to improve query performance. Ensure proper exception handling within PL/SQL code to manage errors effectively. Advanced PL/SQL Features: Utilize collections, bulk collect, and for all concepts to optimize data processing and improve performance. Apply advanced PL/SQL features to develop efficient and scalable database solutions. Documentation & Best Practices: Document database designs, coding standards, and procedures. Follow best practices in database development, ensuring high-quality and maintainable code. Collaboration & Support: Work closely with application developers to design and optimize database structures. Provide support and troubleshooting assistance for database-related issues. Collaborate with the DBA team to ensure database integrity, security, and availability. Technical Skills: Proficient in Oracle SQL and PL/SQL development. In-depth understanding of indexing, partitioning, and their impact on database performance. Experience with exception handling and error management in PL/SQL. Familiarity with Oracle database architecture and best practices. Soft Skills: Strong analytical and problem-solving skills. Excellent communication and teamwork abilities. Ability to work independently and manage multiple tasks effectively. Preferred Qualifications: Oracle certification (OCA, OCP) is a plus. Experience with Oracle APEX or other Oracle development tools. Knowledge of other database management systems (e.g., MySQL, PostgreSQL) is advantageous. Abhishek kumar IT Recruiter Desk No : 6062299047 , Ext- 124 Email: [email protected] Hangout: abhishekchoudhary0948 Source InfoTech Inc. 3840 Park Avenue, Suite C-205, Edison, NJ-08820 Keywords: cprogramm information technology procedural language New Jersey Pennsylvania urgent need Oracle SQL PLSQL Developer [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=2035844&uid= |
| [email protected] View All |
| 10:58 PM 23-Dec-24 |