Oracle PL/SQL Developer

Contractual | - | PL/SQL , PL/SQL DEVELOPMENT , ORACLE PL/SQL , DATABASE SECURITY
Irving, TX, Texas, USA
quick apply

Currently, we are looking for talented resources for one of our listed clients. If interested please reply to me with your updated resume or feel free to reach out to me for more details at (949) 889-0336

Hybrid role - 2 days On-site and 3 days Remote

Please note:
The Hiring Event will take place for this role on March 21st, 2025. Candidates who are interested and available to attend this Hiring Event only need to apply for this role.
Must be available to attend In-Person Interviews on March 21st, 2025

Job Description:

  • We are seeking a skilled Oracle PL/SQL Developer with hands-on experience in PL/SQL coding, table creation, performance tuning, and some DBA administrative tasks.
  • The ideal candidate will focus primarily (80%) on PL/SQL development, query optimization, and database performance tuning, with secondary (20%) responsibilities related to DBA administration tasks such as user management and basic database maintenance.

Key Responsibilities:

  • PL/SQL Development (80%)
  • Develop, optimize, and maintain PL/SQL stored procedures, triggers, functions, and packages.
  • Design and implement database tables, indexes, constraints, and relationships based on business requirements.
  • Write complex SQL queries and optimize query performance for large datasets.
  • Collaborate with application developers to design efficient database structures and schemas.
  • Analyze, troubleshoot, and resolve database-related performance issues.
  • Implement best practices for SQL coding, query optimization, and indexing.
  • Conduct code reviews to ensure database standards and performance guidelines are met.
  • Database Administration (20%)
  • Perform basic DBA tasks, including user access control, privileges management, and database security.
  • Assist in database backup and recovery strategies.
  • Monitor database performance, resource utilization, and storage management.
  • Support database tuning, partitioning, and indexing strategies for improved performance.
  • Work closely with DBA teams for database upgrades, patches, and maintenance activities.

Required Skills & Qualifications:

  • 5+ years of experience in Oracle PL/SQL development.
  • Strong expertise in writing and optimizing PL/SQL procedures, functions, and triggers.
  • Experience with SQL query performance tuning and execution plan analysis.
  • Knowledge of database design principles, indexing strategies, and normalization techniques.
  • Basic experience in Oracle DBA tasks such as user management, storage management, and backup/recovery.
  • Hands-on experience with Oracle versions (12c, 19c, or newer).
  • Familiarity with Oracle Enterprise Manager (OEM) and database monitoring tools.
  • Strong problem-solving and debugging skills.
  • Ability to work independently and collaborate with development and DBA teams.

About us:
At our organization, we take our mission and values to heart! We are on a mission to offer more and better jobs all over the world! Our goal is to care for you while you care for our clients and get you paid the highest pay possible. All our associates working with us are expected to embrace our RACE values: R - Results Matter, A- Approachable, C - Care, and E - Emergency i.e. work with a sense of urgency.

For more relevant job opportunities please visit our website: Denken Solutions Careers