Oracle Database Developer

LTM; Irving (TX); On-site; USD 135,000 - 180,000; Full time

Benefits offered by this job

Medical, dental, vision

Disability insurance

401(k) plan with company match

Life insurance

Paid vacation and holidays

Paid paternity/maternity leave

Job summary

LTIMindtree is seeking a Senior Oracle Developer to design, develop, test, and implement Oracle-based solutions. You will work with cross-functional teams to analyze requirements, develop specs, and deliver high-quality database applications.

The role emphasizes PL/SQL programming, performance tuning, data modeling, and Oracle admin tasks. You will mentor junior developers and contribute to continuous improvement in an Agile environment.

Qualifications

• Bachelor's degree in Computer Science, IT, or related field.
• 7+ years of experience designing and implementing Oracle database solutions.
• Proficient in Oracle PL/SQL with performance tuning experience.
• Experience with Oracle admin tasks like backup, recovery, user mgmt and security.
• Strong data modeling, normalisation, and relational design skills.
• Familiar with Agile software development and CI/CD pipelines.
• Excellent problem solving and communication abilities.

Responsibilities

• Design, develop, and maintain Oracle database applications and packages.
• Perform data modeling, schema design, and optimization for performance and scalability.
• Collaborate with analysts to translate requirements into technical specs.
• Develop and maintain data integration between Oracle and other systems.
• Troubleshoot issues and conduct code reviews for quality.
• Tune performance using Oracle Optimizer, EXPLAIN plans, and AWR/ASH.
• Mentor junior developers and provide guidance as needed.

Skills

PL/SQL

Performance tuning

Data modeling

Oracle security

Agile

Git

CI/CD

Education

Bachelor's degree in Computer Science or related field

Tools

Git

Tableau

Oracle Enterprise Manager

Job description

Overview

We are seeking a highly skilled Senior Oracle Developer to join our dynamic team. As a Senior Oracle Developer you will be responsible for designing, developing, testing, and implementing Oracle-based solutions to meet our business needs. You will work closely with cross‑functional teams to analyze requirements, develop technical specifications, and deliver high‑quality solutions.

Responsibilities

• Design, develop and maintain Oracle database applications, including stored procedures, triggers, functions, and packages.
• Perform data modeling, schema design, and database optimization to ensure optimal performance and scalability.
• Collaborate with business analysts and stakeholders to gather requirements and translate them into technical specifications.
• Develop and maintain data integration processes between Oracle and other systems.
• Troubleshoot and debug issues.
• Conduct code reviews, performance tuning, and optimization to ensure code quality and efficiency.
• Stay up to date with the latest Oracle technologies and practices and make recommendations for continuous improvement.
• Mentor junior developers and provide technical guidance and support as needed.
• Operate with limited supervision.

Requirements

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Minimum of 7 years of experience as an Oracle developer with a proven track record of designing and implementing complex database solutions.
• Proficiency in Oracle PL/SQL programming with experience in Oracle database performance tuning and optimization.
• Experience with Oracle database administration tasks such as backup and recovery, user management, and security.
• Strong understanding and advocacy of good database design principles, data modeling techniques, and relational database concepts.
• Experience working in an Agile environment and familiarity with Agile methodologies.
• Excellent problem‑solving skills and attention to detail.
• Strong communication and interpersonal skills with the ability to effectively collaborate with cross‑functional teams.
• Experience with Git and continuous integration/continuous deployment pipelines.

Mandatory Experience

• Total years of experience in PL/SQL + performance tuning (Preferred: 7+ years).
• Oracle version used in the most recent project (Oracle 19c preferred or higher).
• Experience handling large datasets/tables (50 GB+), including knowledge of table size and information stored.
• Experience with table partitioning strategies—range, list, and hash—and the rationale behind their use.
• Hands‑on performance tuning experience, including Oracle Optimizer, EXPLAIN plans, and AWR/ASH.
• Experience with PL/SQL bulk operations (BULK COLLECT, FORALL) on large datasets.
• Advanced SQL using window functions (ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD).

Nice to Have

• Oracle certification.
• Knowledge of other database technologies (e.g., MongoDB, SQL Server).
• Experience using Tableau with Oracle.
• Experience with Starburst or other data virtualization technology.
• Python development experience.
• Experience using MagicDraw.

Benefits and Perks

• Comprehensive medical plan covering medical, dental, and 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.

Actual compensation within the range will be dependent upon the individual's skills, experience, performance, and internal equity. The range displayed on this posting reflects the minimum and maximum salary target for the position across all U.S. locations. Within the range, individual pay is determined by work location, job level, and additional factors including job‑related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation such as an annual performance‑based bonus, sales incentive pay, and other bonus or variable compensation may be provided.

Disclaimer

The compensation and benefits information provided herein is accurate as of the date of this posting.

Equal Employment Opportunity Statement

LTIMindtree is an equal‑opportunity employer that is committed to diversity in the workplace. Our employment decisions are made without regard to race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family‑care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectionate or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.