Job Description
Job Description
Must Have :
- Advanced experience in PL/SQL development, including Stored Procedures, Functions, Packages, and Triggers.
- Strong expertise in writing and optimizing complex SQL queries for high-performance applications.
- Hands-on experience with BULK COLLECT, FORALL, and PL/SQL Collections for large-volume data processing.
- Proven experience in SQL Performance Tuning using Explain Plan, DBMS_XPLAN, SQL Trace, and TKPROF.
- Strong understanding of Database Design, including schema design, tables, constraints, views, and data modeling.
- Hands-on experience with Indexing strategies (B-Tree, Bitmap, Function-Based Indexes).
- Experience implementing and managing Table Partitioning for large datasets.
- Strong knowledge of ETL processes, Data Migration, and Data Transformation methodologies.
- Proficiency with Oracle development tools such as SQL Developer, TOAD, or PL/SQL Developer.
- Experience using Git or other Version Control Systems for database code management.
- Strong analytical and troubleshooting skills with the ability to debug complex database and performance issues.
Pay Range : $65 - $75 per hour
The Company offers the following benefits for this position, subject to applicable eligibility requirements: medical insurance, dental insurance, vision insurance, 401(k) retirement plan, life insurance, long-term disability insurance, short-term disability insurance, paid parking/public transportation, (paid time , paid sick and safe time , hours of paid vacation time, weeks of paid parental leave, paid holidays annually - AS Applicable)