Prepin
Log in
Photon

engineering opportunity

Data Engineer -Dallas, TX

Design, develop, and maintain complex Oracle SQL and PL/SQL solutions while performing data analysis and database design for enterprise applications. Collaborate with cross-functional teams to optimize database performance and deliver scalable data integration solutions.

Dallas, Texas, United StateshybridFULL_TIME

Posted

About the role

What will you do at Photon?

Senior Software Engineer – Oracle SQL/PLSQL Developer Location

Hybrid / Onsite

Job Summary

We are seeking a highly skilled Senior Software Engineer – Oracle SQL/PLSQL

Developer to join our technology team. The ideal candidate will have deep

expertise in Oracle database technologies, data modeling, performance tuning,

ETL processes, and enterprise application development. This role requires strong

analytical and problem-solving skills, the ability to design scalable data

solutions, and experience working in Agile environments.

The successful candidate will contribute to the design, development, and

optimization of mission-critical applications while collaborating with

cross-functional teams to deliver high-quality, scalable, and maintainable

software solutions.

Key Responsibilities

  • * Design, develop, and maintain complex Oracle SQL and PL/SQL solutions.
  • * Perform data analysis, data modeling, and database design for enterprise
  • applications.
  • * Design and implement scalable data APIs and data integration solutions.
  • * Optimize database performance through query tuning, indexing, and performance
  • monitoring.
  • * Develop, maintain, and support batch processing jobs using ETL technologies
  • and scheduling tools.
  • * Collaborate with developers, architects, product owners, and business
  • stakeholders to deliver end-to-end solutions.
  • * Translate business requirements, use cases, and user stories into technical
  • designs and implementations.
  • * Participate in application architecture discussions, design reviews, and code
  • reviews.
  • * Ensure software quality through automated testing, validation, and continuous
  • integration practices.
  • * Mentor team members and promote engineering best practices across development
  • teams.
  • * Support production deployments, troubleshooting, and ongoing system
  • enhancements.
  • * Document technical designs, implementation details, and operational
  • procedures.
  • Required Qualifications
  • * Bachelor's or Master's degree in Computer Science, Information Technology,
  • Engineering, or a related field.
  • * 7+ years of experience in database development and enterprise software
  • engineering.
  • * Expert-level knowledge of Oracle SQL and PL/SQL programming.
  • * Strong experience in data analysis, data modeling, and database design.
  • * Expertise in database performance tuning and optimization.
  • * Experience developing and managing ETL processes and batch jobs.
  • * Strong understanding of scalable application design principles.
  • * Experience implementing automated testing for database applications.
  • * Knowledge of CI/CD methodologies and software delivery practices.
  • * Excellent analytical, troubleshooting, and problem-solving abilities.
  • * Strong verbal and written communication skills.
  • Technical Skills Database Technologies
  • * Oracle SQL
  • * Oracle PL/SQL
  • * Database Design
  • * Data Modeling
  • * Performance Tuning
  • * Query Optimization
  • * Data Analysis
  • Data Integration & ETL
  • * Informatica
  • * ETL Development
  • * Batch Processing
  • * Autosys
  • * Data APIs
  • Programming & Middleware
  • * Java (Working Knowledge)
  • * Messaging Technologies
  • * Distributed Systems
  • * Web/Application Servers
  • Cloud Technologies
  • * Snowflake
  • * Amazon S3
  • * Cloud-Based Data Platforms
  • DevOps & Quality Engineering
  • * CI/CD Pipelines
  • * Automated Testing
  • * Acceptance Test Driven Development (ATDD)
  • * Continuous Integration
  • * Continuous Delivery
  • Development Methodologies
  • * Agile
  • * Scrum
  • * Test-Driven Development Practices
  • * Code Reviews
  • * Design Reviews

Preferred Qualifications

  • * Experience working with cloud-enabled enterprise data platforms.
  • * Exposure to Snowflake and modern cloud data warehouse technologies.
  • * Experience building distributed and high-availability systems.
  • * Understanding of enterprise integration patterns and event-driven
  • architectures.
  • * Experience in financial services, asset management, banking, insurance, or
  • other highly regulated industries.
  • * Experience leading small to mid-sized technical teams.
  • Leadership Expectations
  • * Provide technical leadership and guidance during solution design and
  • implementation.
  • * Mentor and coach engineers to improve technical capabilities and delivery
  • excellence.
  • * Drive engineering best practices, coding standards, and quality initiatives.
  • * Promote collaboration across globally distributed teams.
  • * Influence architectural decisions and technology strategy.
  • Core Competencies
  • * Database Architecture & Design
  • * Data Engineering
  • * Technical Leadership
  • * Performance Optimization
  • * Problem Solving & Critical Thinking
  • * Agile Delivery
  • * Collaboration & Teamwork
  • * Communication & Documentation
  • * Continuous Learning & Innovation
  • * Customer-Focused Solution Delivery
  • What Success Looks Like
  • * Delivering scalable, high-performance database solutions.
  • * Improving application reliability, efficiency, and maintainability.
  • * Driving automation across testing, deployment, and operational processes.
  • * Leading successful implementation of data-driven initiatives and
  • modernization efforts.
  • * Contributing to a culture of engineering excellence, collaboration, and
  • continuous improvement.
  • This role is ideal for an experienced Oracle SQL/PLSQL professional who enjoys
  • solving complex data challenges, building enterprise-scale solutions, and
  • leading technical initiatives in a fast-paced environment.
  • Compensation, Benefits and Duration
  • Minimum

Compensation

USD 35,000

Maximum

Compensation

USD 123,000

Compensation

is based on actual experience and qualifications of the candidate.

The above is a reasonable and a good faith estimate for the role.

Medical, vision, and dental benefits, 401k retirement plan, variable

pay/incentives, paid time off, and paid holidays are available for full-time

employees.

This position is not available for independent contractors

No applications will be considered if received more than 120 days after the date

of this post

Which skills does this role require?

Oracle SQLPL/SQLData modelingPerformance tuningETLDatabase designInformaticaAutosysJavaAmazon S3CI/CDScrumData analysisDistributed systemsData ModelingPerformance TuningData AnalysisDistributed SystemsDatabase DesignBatch ProcessingData APIsSoftware EngineeringEnterprise ApplicationsQuery OptimizationAutomated TestingTest-Driven DevelopmentEvent-Driven ArchitectureMentorshipSystem EnhancementsDeploymentSQL

Make your next move

Build a shortlist and prepare

Identify the requirements you can demonstrate, then choose examples from your work to discuss with the hiring team.

Review the responsibilities and requirements before adding an opening to your shortlist.

Role information can change. Confirm current details on the original application page.

Product

AI Candidate AgentCompaniesBrowse JobsDeep ProfileSkill AssessmentOpportunity Matching
Prepin.ai

© 2026 Prepin | All rights reserved.