Database Developer 2

This is a Hybrid position and requires 3-4 days per week in the office in Irving, TX

The Oracle Developer serves as a technical liaison between client business requirements and marketing campaign execution. This role is responsible for translating campaign specifications into effective data processes and solutions. Key responsibilities include analyzing requirements, designing and developing data-driven applications, performing quality assurance, and providing ongoing support for software applications that enable the agency to meet client business objectives.

The Oracle Developer will translate marketing campaign requirements into technical guidelines. They will find the solution that balances functionality, performance, and ease of maintenance.

The candidate must have the ability to self-direct, set goals, and meet aggressive deadlines. This is a key factor in the overall success of the automotive team organization.

• Translate client marketing requirements into technical data specifications and executable processes
• Design and implement data streams that incorporate data hygiene, merge/purge, and transformations
• Write and modify SQL queries, stored procedures, and scripts to support campaign data extraction, transformation, and loading
• Support implementation of business intelligence and marketing automation solutions
• Adhere to production standards in all work products and participating in the refinement of standards to improve quality and productivity
• Document all work and facilitate support of ongoing operational responsibilities
• Participate in code review and acceptance process in order to improve methodology and delivery
• Develop quality control (QC) reports to validate data accuracy, identify issues, and ensure the work meets client specifications
• Collaborate with account teams and project managers to clarify requirements and communicate technical constraints or data availability

• The candidate must be able to develop and implement solutions that are reliable, scalable, and high-performing. These solutions must satisfy the service requirements for critical PL/SQL-based solutions.
• Proven analytical and problem-solving abilities. Ability to quickly discern the most relevant facts and recommend the quickest, most practical and safest approach to resolving an issue with a program or database.
• Able to decompose and solve problems at the appropriate level within the system, keeping in mind the higher-level structures and their requirements and dependencies with adjoining subsystems.
• Strong logical/analytical skills with a keen ability to anticipate and avoid problems.
• Ability to work within tight deadlines and effectively prioritize and implement tasks in a high-pressure environment.
• Attention to detail and the ability to manage several tasks at once.
• Excellent understanding of coding methods and best practices.
• Recognizes good opportunities for code reuse and ensures that the code is designed and implemented accordingly.
• Strong listening skills; ability to capture requirements expressed in design meetings.
• Flexible and adaptable in regard to learning and understanding new technologies.
• Highly self-motivated and directed.

Technical Requirements

• 5+ years development experience
• Experience with extract, transformation, and load (ETL)
• Knowledge of relational database concepts, SQL, and data modeling techniques
• Experience developing marketing applications desirable
• Oracle PL/SQL experience
• Ability to leverage AI tools (Amazon Q, MS Copilot) to enhance productivity in code development, debugging, and documentation
• Data hygiene and merge/purge applications is a plus, * Experience in Marketing industry a plus
• Demonstrated experience working on teams in a matrix organization structure
• Familiarity with Oracle Database or Databricks