DB2 Mainframe & Oracle PL/SQL Reporting Specialist

Jobtailor; Lisboa; Presencial; EUR 42 000 - 65 000; Tempo integral

Resumo da oferta

Jobtailor in Lisbon is seeking a seasoned DB2 Mainframe and Oracle PL/SQL specialist to design, optimize, and maintain enterprise reporting solutions. You will build management reports, KPIs, and dashboards while ensuring data availability and system reliability.

The role emphasizes high-volume batch processing, troubleshooting, and adherence to batch scheduling practices using tools like Control-M in a complex enterprise environment.

Qualificações

• Strong experience with DB2 Mainframe, including SQL development, stored procedures, and query optimization.
• Solid knowledge of Oracle PL/SQL, with experience developing and maintaining reporting solutions directly within the database.
• Experience designing and developing management reports, KPIs, dashboards, and complex SQL queries.
• Experience with high-volume batch processing in enterprise environments.
• Knowledge of JCL (Job Control Language) and batch scheduling/monitoring tools such as Control-M (or equivalent).
• Strong analytical and troubleshooting skills to identify and resolve batch processing issues, ensuring data availability and system reliability.

Responsabilidades

• Develop and optimize DB2 Mainframe solutions.
• Design and maintain Oracle PL/SQL reporting solutions.
• Create management reports, KPIs, and dashboards.
• Manage high-volume batch processes and troubleshoot issues.

Conhecimentos

DB2 Mainframe

SQL Development

Stored Procedures

Query Optimization

Oracle PL/SQL

Management Reporting

KPI Development

Complex SQL Queries

Batch Processing

Troubleshooting

Ferramentas

Control-M

Batch Scheduling Tools

Descrição da oferta de emprego

Jobtailor in Lisbon is seeking a seasoned DB2 Mainframe and Oracle PL/SQL specialist to design, optimize, and maintain enterprise reporting solutions. You will build management reports, KPIs, and dashboards while ensuring data availability and system reliability.

The role emphasizes high-volume batch processing, troubleshooting, and adherence to batch scheduling practices using tools like Control-M in a complex enterprise environment.