Data Engineer -Dallas, TX

Photon Interactive UK Ltd
  • Dallas, TX
    9 days ago

    Job Description

    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

    Numbers & Facts

    LocationDallas, TX

    Skills

    • Acceptance Testingunmatched
    • Agile Programming Methodologiesunmatched
    • Amazon Simple Storage Service (S3)unmatched
    • Analysis Skillsunmatched
    • Application Programming Interface (API)unmatched
    • Architectural Servicesunmatched
    • Asset Managementunmatched
    • Bank Managementunmatched
    • Best Practicesunmatched
    • CA Workload Automation AE (AutoSys Edition)unmatched
    • Cloud Computingunmatched
    • Coachingunmatched
    • Code Reviewsunmatched
    • Coding Standardsunmatched
    • Communication Skillsunmatched
    • Computer Scienceunmatched
    • Continuous Deployment/Deliveryunmatched
    • Continuous Improvementunmatched
    • Continuous Integrationunmatched
    • Cross-Functionalunmatched
    • Customer Relationsunmatched
    • Data Analysisunmatched
    • Data Modelingunmatched
    • Data Warehousingunmatched
    • Database Architectureunmatched
    • Database Designunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Database Optimizationunmatched
    • Database Programmingunmatched
    • Database Technologyunmatched
    • Distributed Computingunmatched
    • Documentationunmatched
    • Enterprise Applicationsunmatched
    • Financial Servicesunmatched
    • High Availabilityunmatched
    • Identify Issuesunmatched
    • Informaticaunmatched
    • Information Technology & Information Systemsunmatched
    • Insuranceunmatched
    • Javaunmatched
    • Leadershipunmatched
    • Mentoringunmatched
    • Messaging Technologyunmatched
    • Middlewareunmatched
    • Operations Processesunmatched
    • Oracle Databaseunmatched
    • Oracle PL-SQLunmatched
    • Performance Analysisunmatched
    • Performance Modelingunmatched
    • Performance Tuning/Optimizationunmatched
    • Presentation/Verbal Skillsunmatched
    • Problem Solving Skillsunmatched
    • Process Managementunmatched
    • Production Supportunmatched
    • Quality Assuranceunmatched
    • Query Optimizationunmatched
    • Reliability Engineeringunmatched
    • Requirements Managementunmatched
    • SQL (Structured Query Language)unmatched
    • Scrum Project Management and Software Developmentunmatched
    • Snowflake Schemaunmatched
    • Software Designunmatched
    • Software Developmentunmatched
    • Software Engineeringunmatched
    • Team Playerunmatched
    • Technical Deliveryunmatched
    • Technical Leadershipunmatched
    • Technical Strategyunmatched
    • Technical Writingunmatched
    • Technical/Engineering Designunmatched
    • Test Automationunmatched
    • Test Driven Development (TDD)unmatched
    • Use Casesunmatched
    • Validation Testingunmatched
    • Writing Skillsunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder