- Need Local under 50 miles from Westlake, TX …H1B/H4/L2 Visa
- Please mention your Visa status and Current location while sharing your resume
Position: Senior Oracle PL/SQL Developer
Location: Westlake, TX (Onsite)
Type: Contract
Job Description:
Job Summary: We are seeking a Senior Oracle Developer with extensive experience in performance tuning of Oracle PL/SQL packages, procedures, and queries. The ideal candidate will be responsible for designing, developing, and optimizing complex Oracle-based solutions to support high-volume enterprise applications. This role requires deep knowledge of Oracle architecture and hands-on expertise in identifying and resolving performance bottlenecks.
Key Responsibilities:
- Design, develop, and maintain complex PL/SQL packages, procedures, functions, and triggers.
- Perform advanced performance tuning of PL/SQL code, queries, and database structures.
- Analyze and refactor poorly performing database code and provide recommendations for improvements.
- Collaborate with DBAs, application developers, and system architects to implement best practices for performance and scalability.
- Utilize tools like AWR, ASH, SQL Trace, and SQL Plan Baselines to monitor and enhance performance.
- Hands on with Informatica ETL workflows
- Work closely with business and technical teams to understand data requirements and deliver efficient data solutions.
- Troubleshoot production issues related to Oracle performance and provide timely resolutions.
- Document database designs, tuning results, and development standards.
- Support code reviews and mentor junior developers on Oracle best practices.
Required Skills and Qualifications:
- Bachelor’s degree in Computer Science, Information Systems, or a related field.
- 10+ years of experience in Oracle PL/SQL development.
- 5+ years of experience in Informatica ETL workflows
- Deep expertise in performance tuning Oracle packages and SQL queries (Oracle 12c/19c/21c).
- Strong understanding of Oracle internals, execution plans, indexing, partitioning, and optimizer behavior.
- Hands-on experience with tools such as SQL Developer, TOAD, AWR, ASH, TKPROF, SQL Trace, and Oracle Enterprise Manager.
- Familiarity with high-volume OLTP and/or data warehouse environments.
- Ability to write efficient and reusable PL/SQL code.
- Strong debugging and analytical skills.
- Excellent communication and teamwork skills.
Preferred Qualifications:
- Oracle Certified Professional (OCP) certification.
- Exposure to Agile or DevOps environments.
- Experience with performance tuning in cloud-based Oracle environments
Regards,
Priyanka
Lead Recruiter
Net2Source Inc. | Address: 270 Davidson Ave, Suite 704, Somerset, NJ 08873, USA
Office: 201-221-8131 | Email: Priyanka.j@net2source.com | Web: www.net2source.com
—
You received this message because you are subscribed to the Google Groups “Exclusive C2C Requirements” group.
To unsubscribe from this group and stop receiving emails from it, send an email to hot-requirements-2022+unsubscribe@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/hot-requirements-2022/f59e7b7b-339c-4cef-af09-18f6b25776c8n%40googlegroups.com.