Skip to content

Open nowPosted 12 days ago

Senior/Lead SQL Production Support Engineer

Publicis Groupe Holdings B.V3,068 open roles

Where
Mexico City, Mexico
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowSenior/Lead SQL Production Support EngineerPublicis Groupe Holdings B.V · Mexico City, Mexico
  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Publicis Groupe Holdings B.V's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

12.3% of postings close within 7 days. Measured by our own scanner across the market. Publicis Groupe Holdings B.V postings stay open a median of 2 days.

Share of postings closed within
  1. 2.1%1 day
  2. 4.5%3 days
  3. 12.3%7 days
  4. 19.3%14 days
  5. 35.6%30 days
  6. 57.8%60 days
This job: posted 12 days ago

Publicis Groupe Holdings B.V median: 2 days open

The posting

Company description Publicis Sapient is a digital transformation partner helping established organizations get to their future, digitally enabled state, both in the way they work and the way they serve their customers. We help unlock value through a start-up mindset and modern methods, fusing strategy, consulting, and customer experience with agile engineering and problem-solving creativity. United by our core values and our purpose of helping people thrive in the brave pursuit of next, our 20,000+ people in 53 offices around the world combine experience across technology, data sciences, consulting, and customer obsession to accelerate our clients’ businesses through designing the products and services their customers truly value. Overview We’re seeking a Senior or Senior Lead SQL Application Support Engineer for a client specialized in investment management in the United States, to keep its business-critical applications and databases stable in production. You will investigate data discrepancies, reconciliation breaks and missing transactions, troubleshoot incidents at the database level, and keep batch jobs, ETL processes and overnight processing running for critical business and reporting cycles. The work centers on advanced SQL and production database objects such as stored procedures, functions, triggers and views, on platforms such as MS SQL Server, Oracle, PostgreSQL and Sybase. The role is open at Senior or Senior Lead level. Responsibilities Your Impact 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 incidents involving database failures, data issues and report discrepancies, performing root cause analysis and implementing preventive actions. Provide database-level troubleshooting support in major incident calls. Monitor database jobs, ETL processes and scheduled batch executions, investigating 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. Qualifications Skills & Experience Advanced SQL development: complex queries with multi-table joins, nested subqueries, CTEs, window functions (ROW_NUMBER, RANK, DENSE_RANK, LEAD, LAG), temporary tables and set operators (UNION, INTERSECT, EXCEPT), applied to large datasets. Data investigation: root cause analysis in SQL of data discrepancies, missing transactions, reconciliation breaks and data quality issues. Reporting and data validation: validating business reports and dashboards against source data, building ad hoc SQL reports for business users, and applying data reconciliation techniques. Database performance tuning: query optimization, execution plan analysis, clustered and non-clustered indexing strategies, database statistics, and troubleshooting slow-running queries. Database programming: developing and maintaining stored procedures, functions, triggers and views, and modifying existing database objects to support production enhancements. Production support: handling application and database incidents, impact analysis and defect resolution for critical business processes and reporting cycles, with availability for odd hours and weekends as the project requires. Hands-on experience with one or more of MS SQL Server, Oracle, PostgreSQL or Sybase. Set Yourself Apart With Hands-on experience in Asset Management or Financial Services. ETL tools such as Informatica, SSIS or dbt Scheduling tools such as Autosys, Control-M or HCL Workload Automation/TWS Unix/Linux, shell scripting and Python ServiceNow, Splunk, AppDynamics and ITIL DAM administration, Apex/Flows, SaaS administration, SCIM and SSO This is a long-term, full-time (Indefinite) contract with a flexible work model. The team is open to considering each candidate’s preferences and circumstances. We can consider a fully remote setup, or a hybrid arrangement where you would come into the office only when needed based on business requirements. Additional information An inclusive workplace that promotes diversity and collaboration. Access to ongoing learning and development opportunities. Competitive compensation and benefits package. Flexibility to support work-life balance. Comprehensive health benefits for you and your family. Generous paid leave and holidays. Wellness program and employee assistance. As part of our dedication to an inclusive and diverse workforce, Publicis Sapient is committed to Equal Employment Opportunity without regard for race, color, national origin, ethnicity, gender, protected veteran status, disability, sexual orientation, gender identity, or religion. We are also committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, you may contact us at [email protected]

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Publicis Groupe Holdings B.V's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.
  3. We apply on Publicis Groupe Holdings B.V's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.
  4. Every reply, sorted

    Publicis Groupe Holdings B.V's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.
  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.