Oracle PL/SQL Developer (Contract-to-Hire – Onsite – Irving, TX)

A client is actively seeking a highly skilled Oracle PL/SQL Developer (Contract-to-Hire – Onsite – Irving, TX) to join their team. This contract-to-hire opportunity, based onsite at 6460 Las Colinas Blvd, Irving, TX 75039, offers the potential for long-term career growth in a dynamic and collaborative environment. The ideal candidate will have extensive experience in Oracle database development, PL/SQL programming, and performance tuning. Please note: an onsite interview is required on 03/21 for immediate hiring consideration.

Oracle PL/SQL Developer (Contract-to-Hire – Onsite – Irving, TX)

Location: 6460 Las Colinas Blvd, Irving, TX 75039 – This is an Onsite role, requiring daily presence at the designated facility.

Employment Type: Contract-to-Hire (W2 Only)

Pay Range: Not Specified

Industry: Engineering / Computer and Mathematical

What’s the Job? Engineering Robust Oracle Database Solutions

As an Oracle PL/SQL Developer, you’ll play a crucial role in designing, developing, and optimizing high-performance database solutions that underpin critical business applications. Your work will ensure data integrity, system efficiency, and seamless integration across the enterprise.

• Design, Develop, and Maintain Oracle Database Solutions: You will be responsible for the full lifecycle of designing, developing, and maintaining Oracle database solutions that provide robust support for various business applications. This involves understanding business requirements, translating them into efficient database designs, implementing the necessary structures, and ensuring their ongoing health and performance. Your work will directly impact how applications store, retrieve, and process essential data.
• Develop and Optimize Complex PL/SQL Components: A core responsibility will be to meticulously develop and optimize complex PL/SQL queries, stored procedures, triggers, and functions. This requires deep proficiency in PL/SQL programming, ensuring that database logic is efficient, secure, and performs optimally even under heavy loads. Your expertise in crafting high-performance PL/SQL code will be vital for application responsiveness and data processing speed.
• Conduct Performance Tuning, Query Optimization, and Database Troubleshooting: You will regularly conduct performance tuning, query optimization, and comprehensive database troubleshooting. This involves analyzing database performance metrics, identifying bottlenecks in slow-running queries or PL/SQL code, and implementing solutions (e.g., indexing, query rewrites, code refactoring) to enhance speed and efficiency. Your troubleshooting skills will be crucial for quickly resolving database-related issues and preventing recurrence.
• Collaborate for Seamless Application Integration: You will work in close collaboration with application developers to ensure seamless integration between Oracle databases and various enterprise applications. This involves understanding application data access patterns, assisting with API design related to database interactions, and troubleshooting connectivity or data consistency issues between the database layer and application code. Your teamwork ensures a cohesive and high-performing system.
• Implement and Maintain ETL Processes: You will be instrumental in the implementation and ongoing maintenance of ETL (Extract, Transform, Load) processes for efficient data movement. This involves designing and building solutions for extracting data from source systems, transforming it to meet target requirements, and loading it into data warehouses, data marts, or other analytical platforms. Your efforts will ensure timely and accurate data availability for reporting and analysis.
• Develop Database Objects: You will systematically develop various database objects essential for data storage and management. This includes creating tables to store data, defining views for simplified data access and security, designing indexes to improve query performance, and implementing constraints (e.g., primary keys, foreign keys, unique constraints) to ensure data integrity and enforce business rules within the database schema.
• Ensure Database Security, Integrity, and Compliance: You will play a critical role in ensuring database security, integrity, and compliance with best practices. This involves implementing access controls, managing user permissions, configuring encryption, regularly auditing database activity, and adhering to internal security policies and industry standards. Your vigilance safeguards sensitive data and maintains the trustworthiness of the database environment.
• Provide Production Support and Resolve Database Issues: You will provide essential production support for Oracle databases, and be responsible for resolving database-related issues in a timely manner. This includes responding to critical alerts, diagnosing database outages or performance degradation, performing emergency fixes, and working under pressure to restore normal operations, ensuring high availability of critical data services.

What’s Needed? Your Qualifications for Oracle Database Mastery

To excel as an Oracle PL/SQL Developer, you’ll need extensive experience with Oracle databases, advanced PL/SQL skills, and a strong understanding of database performance and design.

• Extensive Oracle Developer Experience (5+ years): You must possess 5+ years of verifiable experience as an Oracle Developer. This extensive background indicates a seasoned professional capable of handling diverse database development and management challenges in an enterprise environment.
• Strong Expertise in Oracle 12c/19c Databases: You must have strong expertise in Oracle 12c/19c databases. This includes hands-on experience with these specific versions, demonstrating your familiarity with their features, functionalities, and best practices for development, administration, and troubleshooting.
• Advanced PL/SQL Development Skills: You are required to have advanced PL/SQL development skills. This encompasses creating and optimizing complex procedures, packages, and triggers, demonstrating your ability to implement sophisticated business logic and automate database operations using PL/SQL.
• Experience with Performance Tuning and Query Optimization: You must have proven experience with performance tuning and query optimization techniques in Oracle databases. This includes identifying inefficient queries, analyzing execution plans, applying appropriate indexing strategies, and refactoring SQL/PL/SQL code to significantly enhance database performance and application responsiveness.
• Familiarity with ETL Processes and Data Migration: You should have strong familiarity with ETL (Extract, Transform, Load) processes and data migration methodologies. This indicates your understanding of how data is moved between systems, transformed for integration, and loaded into target databases, along with the challenges of ensuring data integrity during migrations.
• Experience with Oracle SQL Loader, Bulk Processing, and Materialized Views: You must have practical experience with Oracle SQL Loader for bulk data loading, understanding and implementing Bulk Processing techniques (e.g., FORALL, BULK COLLECT) in PL/SQL for improved performance, and utilizing Materialized Views for query rewrite and data warehousing optimization. These skills are critical for handling large volumes of data efficiently.
• Exposure to Unix/Linux Shell Scripting (Plus): While not mandatory, exposure to Unix/Linux shell scripting is a significant plus. This indicates familiarity with automating tasks, managing files, and interacting with the operating system in a server environment, which can be highly beneficial for database operations and automation.

What’s in it for me? Growth, Collaboration, and Long-Term Potential

This contract-to-hire Oracle PL/SQL Developer position in Irving, TX, offers a compelling environment for professional growth and the potential for a long-term career path within a dynamic and collaborative organization.

• Opportunity for Long-Term Career Growth: This is a contract-to-hire opportunity, offering a clear pathway for long-term career growth within the organization based on your performance and contributions. This provides stability and the chance to become a permanent member of a vital team.
• Dynamic and Collaborative Environment: You’ll work within a dynamic and collaborative environment where teamwork is valued, and mutual support is encouraged. This fosters open communication and provides opportunities to learn from experienced professionals.
• Extensive Oracle Development Experience: You’ll gain extensive experience in Oracle database development, PL/SQL programming, and performance tuning on critical business applications. This hands-on involvement will deepen your expertise in highly sought-after database skills.
• Hands-on with Critical Database Technologies: You’ll work directly with Oracle 12c/19c databases, focusing on advanced PL/SQL, ETL processes, and optimization techniques, ensuring your skills are current with industry standards.
• Impactful Project Contributions: Your role directly impacts the reliability and performance of business applications, giving you the chance to contribute to meaningful projects that drive organizational success.

Upon successful completion of predefined waiting periods, consultants are typically eligible for a comprehensive suite of benefits designed to support their well-being and financial security. These include:

• Medical and Prescription Drug Plans: Comprehensive healthcare coverage for medical services and necessary prescription medications.
• Dental Plan: Benefits covering routine dental care and essential treatments.
• Vision Plan: Coverage for eye examinations, prescription glasses, and contact lenses.
• Health Savings Account (HSA): A tax-advantaged savings account to help pay for qualified medical expenses.
• Health Flexible Spending Account (HFSA): Allows pre-tax contributions for eligible healthcare costs.
• Dependent Care Flexible Spending Account (DCFSA): Provides tax advantages for dependent care expenses.
• Supplemental Life Insurance: Options for additional life insurance coverage for enhanced financial protection.
• Short Term and Long Term Disability Insurance: Income replacement benefits during periods of temporary or prolonged incapacitation due to illness or injury.
• Business Travel Insurance: Coverage for unforeseen events or emergencies that may occur during authorized business travel.
• 401(k), Plus Match: An opportunity to save for retirement with the added benefit of employer matching contributions, enhancing your long-term financial growth.
• Weekly Pay: Consistent and regular compensation provided on a weekly basis, ensuring stable financial flow throughout your contract engagement.

If this Oracle PL/SQL Developer role in Irving, TX, aligns with your extensive Oracle database development experience, your expertise in PL/SQL and performance tuning, and your desire for long-term career growth, we encourage you to learn more about this exciting onsite contract-to-hire opportunity. This is a fantastic chance to build robust database solutions and contribute to critical business applications.

Are you ready to bring your Oracle development skills to a dynamic and collaborative team?