PL/SQL Developer

LTM Inc
Irving, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Irving, United States of America

Tech stack

Query Performance
Continuous Integration
Relational Databases
Database Design
Database Schema
DevOps
Oracle
Performance Tuning
SQL Stored Procedures
PL-SQL
Test Case Design
Sql Loader
Performance Testing
Database Performance
Indexer
Bitbucket

Requirements

  • Understanding of Relational Database concepts.
  • Strong SQL analytical skills.
  • Good understanding of Data modelling concepts and Performance Optimization.
  • Working knowledge on Database design.
  • Identify data quality issues and root causes.
  • Experience in database objects like Stored Procedures functions packages triggers views and Materialized views.
  • Hands on with indexing and partition strategies that helps in query performance.
  • Experience in Advanced PLSQL bulk Operations and SQL Loader.
  • Exposure to analysis of Oracle Database AWRADDM reports and troubleshooting of database performance issues.
  • Assist in the execution analysis of integration user acceptance and performance testing.
  • Review Analyze test case results to ensure functionality meets the documented requirement.
  • Working knowledge of Jira Bitbucket DevOps exposure for CICD pipelines and RLM process.
  • Ability to work independently and as part of a team and strong communication skills verbal and written.

Mandatory Certification: Karat Assessment

Benefits & conditions

Benefits and Perks:

  • Comprehensive Medical Plan Covering Medical, Dental, Vision
  • Short Term and Long-Term Disability Coverage
  • 401(k) Plan with Company match
  • Life Insurance
  • Vacation Time, Sick Leave, Paid Holidays
  • Paid Paternity and Maternity Leave

The range displayed on each job posting reflects the minimum and maximum salary target for the position across all US locations. Within the range, individual pay is determined by work location and job level and additional factors including job-related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance-based bonus, sales incentive pay and other forms of bonus or variable compensation.

Apply for this position