freiberufler Mainframe z/OS DB2 Database Administrator (DBA) auf freelance.de

Mainframe z/OS DB2 Database Administrator (DBA)

offline
  • auf Anfrage
  • D14 CN13 Dublin
  • auf Anfrage
  • pt  |  en  |  it
  • 22.09.2017

Kurzvorstellung

Mainframe z/OS DB2 Database Administrator (DBA) with 23 years of experience in IT industry being the last 11 of them as a Mainframe platform professional.

Qualifikationen

  • Datenbankadministration
  • DB2
  • z/OS

Projekt‐ & Berufserfahrung

Mainframe DB2 DBA (Festanstellung)
AIB (Allied Irish Banks), Dublin
5/2013 – offen (10 Jahre, 11 Monate)
Banken
Tätigkeitszeitraum

5/2013 – offen

Tätigkeitsbeschreibung

- Support to Production DB2 systems and applications (maintenance, security, stability, performance etc.);
- Responsible for designing the physical structure and maintaining the operational performance of the DB2 databases that support business applications;
- Support to Application/Development teams and physical database model implementation like Application Releases in Production;
- Review DDL requests for Tables and Indexes from design and performance point of view;
- Design and creation of relational databases for all environments (Test, System Test, Homologation, QA and Production). Databases, Tablespaces, Tables, Indexes, Stored Procedures, Materialized Query Tables, Temporal Tables, Views, Collections-Plans-Packages etc;
- DB2 DBA support for v9, v10 and v11 Migration;
- Responsible for the implementation of new databases and the management of existing ones, as well as database-related softwares like ChangeMan or CoolGen;
- Meeting quality criteria in terms of integrity, security and availability and providing technical support and advice to the development and operational areas within Information Systems;
- Responsible for test, system test, homologation, QA and production environments;
- DB2 administration utilities: Copy, Recover, Check Data, Reorg, Runstats, Rebuild, Load/Unload, DSN1COPY etc;
- Maintenance of Plans and Packages directly or through Changeman;
- Performing/monitoring database backup and recovery, management of the backup and restore process;
- Design and implementation of data synchronization routines and cross-loads among systems and platforms;
- DB2 performance monitoring and tuning (Access Paths, DB2 Traces, SQL optimization, Omegamon and EzDB2 tool);
- Maintenance of authorizations, permissions and accesses to DB2 Objects (Databases, Tables, Plans, Packages, Schemas, Stored Procedures etc.);
- Binds – Plans, Packages, Access Paths, Plan Table, PLANMGMT;
- Investigation of Problems and Incidents, including Root Cause Analysis, Log Analyzer;
- Recoverability and availability assurance activities associated with high availability design, disaster recovery testing;
- Creation of PMRs (Problem Management Record) to IBM related to issues with DB2;
- Problem and Change Management process (Remedy);
- On-call support, 24x7;

Eingesetzte Qualifikationen

DB2, z/OS

Über mich

- Strong interpersonal skills, team player;
- Customer focused, analytical mind;
- High sense of responsibility, commitment;
- Ability to deal well with adverse and stressful situations;
- Great flexibility to learn new techniques and technologies;
- Focus on solutions;
- Constant search for learning, technical and general subjects;
- Negotiation skills;
- Transparency and capacity to assume mistakes and responsibilities;
- Planning skills and conscience of its importance;
- Ability to work with different tasks at the same time;
- Good observer;
- Aims the best with the available tools in hands;

Weitere Kenntnisse

- IBM Mainframe Applications and Tools: TSO, ISPF, SDSF, RACF, JCL, SPUFI, DB2 Automation Tool, QMF, OPC, Omegamon, Changeman;
- DB2 and IMS Utilities: Copy, Recovery, Check Data, Reorg, Runstats, Rebuild, Load/Unload, Pointer Checker;
- IBM utilities, DB2 Admin Tool, DB2 Log Analyzer, CA/Platinum tools, EzDB2, Data Studio;
- DB2 V9 System Administration for z/OS elementary and fundamental knowledge;
- Websphere MQ V7 System Administration for z/OS basic knowledge;
- Good concepts of Oracle Database Administration. Installation, configuration (Windows and Unix) and maintenance (datafiles, tablespaces, tables, indexes);

Persönliche Daten

Sprache
  • Portugiesisch (Muttersprache)
  • Englisch (Fließend)
  • Italienisch (Grundkenntnisse)
  • Spanisch (Grundkenntnisse)
Reisebereitschaft
auf Anfrage
Arbeitserlaubnis
  • Europäische Union
Profilaufrufe
2084
Alter
48
Berufserfahrung
30 Jahre und 1 Monat (seit 02/1994)
Projektleitung
1 Jahr

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden