Senior Database Developer

Publicis Groupe - Saratoga, CA

Full-time - Mid Level

Saratoga, CA

5,001-10,000 employees

Professional, Scientific, and Technical Services

About the position

The Senior Database Developer role at Publicis Groupe focuses on enhancing a complex rule-based multi-channel marketing campaign platform that supports Fortune 100 companies in the automotive industry. The position requires strong Oracle database expertise and involves collaboration with various teams to deliver new features, troubleshoot issues, and automate operational tasks. The developer will work in a fast-paced environment, contributing to innovative digital marketing solutions that cater to a significant portion of automotive dealers in the US.

Responsibilities

• Setup/configuration of the development environment
• Analysis and design of new and enhanced features for the marketing platform as per business requirements
• Communication with QA, product and production support teams to deliver new or enhanced features and address issues/concerns
• Development of features as per design provided
• Assistance of Production Support team for troubleshooting issues
• Development work for automation of operational tasks
• Support system patch or version upgrade
• Assist with reporting tasks
• Collaborate with developers, project managers, business analysts and business users in conceptualizing, estimating and developing new software applications and enhancements
• Assist in defining software development project plans, including scoping, scheduling, providing time estimates for programming tasks and implementation plans
• Develop technical documentation to define the system components, development environment and implementation planning/strategies
• Prepare and dispense work assignments, provide guidance, and/or review the work of other team members
• Collaborate with QA team to define test cases, metrics, and resolve questions about test results
• Recommend business process flow improvements and clearly communicate problem/resolution process to project management
• Facilitate the design and implementation process for new products/projects, informing senior executive of alternatives
• Administer full project documentation efforts in accordance with policy and procedure
• Perform root cause analysis (RCA)
• Work with cross-functional teams during crisis to address and resolve complex incidents and problems
• Update/create Knowledge Base Articles and case studies as necessary.

Requirements

• 5-9 years of experience as a developer
• Excellent skills in Oracle databases and PL/SQL
• Strong in Unix environment and capable of Unix Shell scripting
• Ability to design and implement reliable, scalable solutions for mission-critical Oracle-based systems
• Knowledge of database architecture and best practices for Oracle SQL and PL/SQL coding style and application tuning
• Experience designing and developing complex enterprise applications (ERP, CRM, etc.) on large Oracle databases using SDLC methodologies (agile, waterfall)
• Excellent in impact-analysis and root cause analysis
• Proven analytical and problem-solving abilities
• Experience in performance tuning, application monitoring and support of production applications
• Ability to define and implement migration strategies from legacy systems to new architecture and technologies
• Strong communication skills (verbal and written)
• Ability to design and build flexible and extensible systems with focus on code reuse and generation
• Experience with writing detailed technical specifications for developers; design, validate and execute software test plans
• Familiar with Application Development Life Cycle.

Nice-to-haves

• Working knowledge of SQL Server
• Experience in automotive marketing and/or CRM applications
• Experience with Informatica or some ETL tool, and TFS
• Good analytical and problem-solving skills
• Motivated to learn new applications and domain
• Strong time management skills
• Ability to take full ownership of tasks and projects.

Benefits

• Comprehensive portfolio of capabilities across digital media, messaging and loyalty solutions
• Innovative team environment
• Focus on employee growth and wellbeing
• People-centric workspace
• Diversity and inclusion initiatives