DB2, Oracle Consultant

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

Key Responsibilities

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.

Requirements

• 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.

Core Competencies

Demonstrates expertise in developing and optimizing DB2 Mainframe solutions and Oracle PL/SQL reporting solutions, with a strong focus on management reporting, KPIs, and high-volume batch processing. Proficient in troubleshooting and ensuring data availability and system reliability in enterprise environments.

Highest-signal resume keywords

• DB2 Mainframe SQL Development
• Oracle PL/SQL Reporting Solutions
• Management Reports and KPIs
• High-Volume Batch Processing
• JCL and Control-M

ATS Optimization Keywords

Hard Skills

• DB2 Mainframe
• SQL Development
• Stored Procedures
• Query Optimization
• Oracle PL/SQL
• Management Reporting
• KPI Development
• Complex SQL Queries
• Batch Processing
• Troubleshooting

Soft Skills

• Analytical Skills
• Problem-Solving

Industry Keywords

• Enterprise Environments
• Data Availability
• System Reliability

Tools & Technologies

• Control-M
• Batch Scheduling Tools