P

Publicis Groupe

Runs advertising and digital transformation services

Senior/Lead SQL Production Support Engineer

IT OperationsConfirmed live in the last 24 hours
Full-timeMexico City, CDMX, MexicoNo salary listed

About the Job

Requirements

  • Advanced SQL development using complex queries, multi-table joins, nested subqueries, common table expressions, window functions, temporary tables and set operators on large datasets.
  • Experience investigating data discrepancies, missing transactions, reconciliation breaks and data-quality issues through root-cause analysis in SQL.
  • Experience validating business reports and dashboards against source data, building ad hoc SQL reports for business users, and applying data-reconciliation techniques.
  • Experience with database performance tuning, query optimization, execution-plan analysis, clustered and non-clustered indexing strategies, database statistics, and troubleshooting slow-running queries.
  • Experience developing and maintaining stored procedures, functions, triggers and views, and modifying database objects to support production enhancements.
  • Production-support experience handling application and database incidents, impact analysis, and defect resolution for critical business processes and reporting cycles; availability for odd hours and weekends as project requirements demand.
  • Hands-on experience with one or more of MS SQL Server, Oracle, PostgreSQL or Sybase.

Responsibilities

  • Write and troubleshoot complex SQL queries to analyze data discrepancies, reconciliation breaks, missing transactions and application data errors, and validate data integrity across source and target systems.
  • Investigate database failures, data issues and report discrepancies, perform root-cause analysis, and implement preventive actions.
  • Provide database-level troubleshooting support during major incident calls.
  • Monitor database jobs, ETL processes and scheduled batch executions; investigate job failures and data-processing issues to support critical business and reporting cycles and overnight processing.
  • Validate business reports and dashboards against source data, build ad hoc SQL queries and reports for business users, and support reconciliation and audit activities.
  • Optimize slow-running queries through execution-plan analysis and tuning, working with DBAs and development teams on performance improvements.

Desired Qualifications

  • Hands-on experience in Asset Management or Financial Services.
  • Experience with ETL tools such as Informatica, SSIS or dbt.
  • Experience with scheduling tools such as Autosys, Control-M or HCL Workload Automation/TWS.
  • Experience with Unix/Linux, shell scripting and Python.
  • Experience with ServiceNow, Splunk, AppDynamics and ITIL.
  • Experience with DAM administration, Apex/Flows, SaaS administration, SCIM and SSO.

About the Company

Publicis Groupe

Runs advertising and digital transformation services

Publicis Groupe runs advertising, media buying and digital transformation services for companies that want to reach consumers, coordinate campaigns and improve their business systems. Its agency network includes creative and media specialists, while Publicis Sapient builds and modernizes the technology behind clients' operations. Epsilon adds customer data and marketing technology that connect brands with audiences and measure campaign results. Clients pay for consulting, campaign creation and execution, with production and media costs billed through alongside the group's service work. Founded in 1926, Publicis Groupe is headquartered in Paris, France.

Company size
10,001+
Company stage
IPO
Headquarters
Paris, France
Founded
1926

Recently Posted Jobs

Explore more opportunities at Publicis Groupe

See more jobs