Senior/Lead SQL Production Support Engineer

UNAVAILABLE

Ciudad de México

Remote

MXN 2,213,000 - 2,950,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health benefits
Flexible work model
Generous leave and holidays
Wellness program
Learning & development opportunities

Job summary

Publicis Sapient is seeking a Senior or Senior Lead SQL Application Support Engineer for a client in investment management in the United States. The role centers on advanced SQL and production databases across MS SQL Server, Oracle, PostgreSQL, and Sybase, with flexibility for remote or hybrid work and long-term full-time engagement.

You will investigate data discrepancies, troubleshoot incidents, and keep critical batch jobs and ETL processes running, delivering data quality, reports, and

Qualifications

  • Advanced SQL development with complex queries and window functions.
  • Experience with MS SQL Server, Oracle, PostgreSQL or Sybase.
  • Experience in production support and incident management.
  • Ability to work odd hours and weekends as needed.
  • Experience with data reconciliation and reporting.

Responsibilities

  • Write and troubleshoot complex SQL queries to analyze data discrepancies and validate data integrity.
  • Investigate incidents, perform root cause analysis and implement preventive actions.
  • Provide database-level troubleshooting in major incident calls.
  • Monitor ETL processes and batch jobs to support critical cycles and overnight processing.
  • Validate reports against source data and support audits.
  • Collaborate with DBAs and development teams on performance improvements.

Skills

Advanced SQL
Data investigation
Reporting & validation
Performance tuning
DB programming
Production support
RDBMS experience

Tools

Informatica
SSIS
dbt
Autosys
Control-M
HCL Workload Automation
Unix/Linux
Python
ServiceNow
Splunk
AppDynamics
ITIL
DAM admin
Apex/Flows
SaaS admin
SCIM/SSO

Job description

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.

Job Description

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.

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 hiring@publicis.sapient.com

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior/Lead SQL Production Support Engineer
Senior/Lead SQL Production Support Engineer

Publicis Groupe • Mexico

Hybrid
MXN 2,020,000 - 2,938,000
Inclusive workplace
Learning and development opportunities
Competitive compensation and benefits
+4
Senior SQL Production Support Engineer - Remote/Hybrid
Senior SQL Production Support Engineer - Remote/Hybrid

UNAVAILABLE • Ciudad de México

Remote
MXN 2,213,000 - 2,950,000
Health benefits
Flexible work model
Generous leave and holidays
+2
Senior SQL Production Lead - Remote/Hybrid Support
Senior SQL Production Lead - Remote/Hybrid Support

Publicis Sapient • Ciudad de México

Hybrid
MXN 480,000 - 720,000
Flexible work model
Health benefits
Paid time off
Senior Salesforce Marketing Cloud Application Support Engineer
Senior Salesforce Marketing Cloud Application Support Engineer

UNAVAILABLE • Ciudad de México

Hybrid
MXN 900,000 - 1,350,000
Senior ETL Developer – Informatica PowerCenter
Senior ETL Developer – Informatica PowerCenter

UNAVAILABLE • Ciudad de México

On-site
MXN 900,000 - 1,300,000
Health benefits
Paid leave
Wellness program
+2
Senior AI Engineer
Senior AI Engineer

Publicis Groupe • Ciudad de México

On-site
MXN 900,000 - 1,300,000
Inclusive workplace
Learning opportunities
Competitive compensation
+3
Postgres Administration , MSSQL Server Admin
Postgres Administration , MSSQL Server Admin

Infosys • Monterrey

On-site
MXN 550,000 - 900,000
Senior AI Engineer
Senior AI Engineer

UNAVAILABLE • Ciudad de México

On-site
MXN 2,028,000 - 2,766,000
Health benefits
Wellness program
Learning & development opportunities
+1
Senior Data Engineer
Senior Data Engineer

Siemens • Región Centro

Hybrid
MXN 900,000 - 1,200,000
L2.5 Production Support
L2.5 Production Support

Infosys Limited • Región Centro, Ciudad de México, Monterrey, Santiago de Querétaro

Remote
MXN 1,117,000 - 1,676,000