Specialist - Data Engineering

LTM

$100K — $120K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Understanding of Relational Database concepts.
  • Strong SQL analytical skills.
  • Good understanding of Data modelling and Performance Optimization.
  • Experience with database design and implementation.
  • Hands-on experience with stored procedures, functions, packages, triggers, and views.
  • Proficient in indexing and partition strategies for query performance.
  • Familiarity with Oracle Database AWR/ADDM reports.

Responsibilities

  • Develop and optimize SQL queries and PL/SQL routines.
  • Identify and resolve data quality issues and root causes.
  • Conduct performance tuning and optimization of database objects.
  • Assist with integration, user acceptance, and performance testing executions.
  • Review and analyze test case results to ensure requirements are met.
  • Collaborate with the team on database design and architecture.
  • Utilize Jira and Bitbucket for project management and CI/CD processes.

Benefits

  • Work in a dynamic team environment in Irving, TX.
  • Opportunity for professional development with ongoing training.
  • Gain experience working with advanced database technologies.
  • Exposure to cutting-edge CI/CD pipeline practices.
  • Flexible work arrangements potentially available.
Full Job Description
Role description

Job Title: Sr. PL/SQL Developer

Work Location:

Irving, TX

Required Skills:
  • 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

Similar Jobs

More Jobs at LTM

More Information Technology Jobs

Find similar Specialist - Data Engineering jobs: