Accessibility Links
  • Job reference: RMS0227174

z/OS Db2 DBA

  • Sector: Recruitment
  • Location: Saudi Arabia
  • Job type: Contract
  • Date posted: 10/09/2020
  • Duration: 12 month
This vacancy has now been filled.

Click one of the boxes below to view similar jobs or send us your CV.
Send jobs like this to my email    What's this?

The Role:
Fircroft Arabia is looking for *z/OS Db2 DBA* for one of our client (IT & Telecom) located in Riyadh, KSA.

Job Description - z/OS Db2 DBA/System Programmer Specialist
* Expert in performing day to day DBA functions for large database installations and very good understanding of sysplex and Db2 Data Sharing Groups.
* Expert understanding of installing new versions and maintain existing versions using standard SMP/E processes and rolling the changes out non-disruptively without impacting any hosted business.
* Support the Performance and Capacity Team for Db2 Database performance metrics and have a good understanding of dealing with performance related issues for hosted applications when transactions or application components exploiting Db2 are showing anomalies.
* Expected in-depth understanding of Db2 system components such as Catalog, Directory, BSDS, Active Logs, work databases, memory areas such as DSC, EDM pool, Buffer Pools, Group Buffer Pools and Db2 address space management.
* Expected full understanding and knowledge of DBA activities including Database, tablespace, table, indexes, foreign keys, views, sequences, plans and packages.
* Very good understanding of Db2 Data Sharing and z/OS High and Continuous Availability and performing planned activities without impacting services.
* Very good understanding of DBMS Replication technologies and proven ability to install and configure and support started tasks supporting SQL, CDC and Q-REP replications to other z/OS Db2 environments as well as other DBMS' on different platforms and architecture.
* Expert and proven knowledge of using SQL and tooling to identify and resolve performance degradation issues including Explain and Adviser tools, adding and altering indexes, analyzing complex SQL queries, Data Modelling Analysis, different types of Db2 tables, BLOB and compression.
* Good understanding of security protocols for Db2 and table accesses using z/OS Security Server as well as products supporting auditing of Db2 SQL activities and database encryption facilities would be useful.
* Full understanding of Db2 commands and utilities as well as z/OS JCL and utilities to manage, maintain and administer the Db2 environments. Strong familiarity of IBM and CA Database management tools and capabilities as well as monitoring products.
* Very good hands on experience of Always-On, HA and CA environments as well as Business Continuity solutions for supporting environments with large databases including Availability Management solutions (Backup, Restore and Replication tools)
* Some knowledge of CICS, MQ as well as Db2 LUW and MS SQL along with networking protocols would be advantageous.

Key Requirements:-

* Hands on experience of DB2 V12 and FL500 onwards
* Expert hands-on knowledge of Db2 replication technologies
* Hands-on experience in Business Continuity, Always-On, High and Continuous Availability environment with aggressive SLA targets
* Good understanding of z/OS 2.4, SMP/E, JCL, TSO, ISPF, SDSF, USS/zFS, VSAM and non-VSAM datasets along with extended format datasets, Utilities as well as ability to write and correct REXX procedures.
* Essential and good problem determination skills using standard Db2 problem determination tools as well as z/OS tracing and diagnostic tooling.
* Very good experience of DB2 Utilities and programs including REORG, COPY, REBUILD, RUNSTATS, RESTORE, LOAD, CHECK, UNLOAD and system related tooling.
* Good understanding of data Encryption, auditing tools and security protocols
* Very good experience in SQL coding and writing efficient DB2 batch processes
* Good written and verbal communication skills
* Honest, hardworking, loyal, patient, diligent, knowledge sharing and essential team player. Adaptable, approachable, reliable, helpful and trustworthy.
* Able to work in a pressured demanding environment especially when there are high severity incidents to resolve.
* Excellent skills in Microsoft Office tools including Visio, Powerpoint, Exel and Email

About Fircroft:
Fircroft has been placing people in specialist technical industries for over 50 years, focusing on mid to senior level engineers for contract and permanent roles worldwide. By applying for this job you give consent for Fircroft to contact you, via email & telephone, to discuss your application along with future positions and Fircroft's services.

Fircroft is registered as a Data Controller with the Information Commissioner as required under the General Data Protection Regulation 2016/679. Fircroft will only process your personal data for the specific purposes of managing your application.

Back to Top

By clicking "Save" you consent to
receiving matching jobs based on the
job/page you are viewing by email from
Fircroft, as detailed in our privacy policy
Fircroft would like to keep you up to date with our latest company updates via email. Occasionally Fircrofts marketing may contain 3rd party or affiliate information, however we will not share your personal data with any 3rd parties without your consent. From time to time, we might contact you to get your views on the service you have received. To help you get the best out of Fircroft, we may personalise them based on your location and how you use
Fircroft would like to keep you up to date with the latest company updates and vacancies via SMS / Text messages
Your consent options above means that Fircroft cannot contact you about any new or alternative career vacancies. If you want Fircroft to only contact you about the role(s) you have applied for please continue, however if you would like to be considered for other positions please allow us to contact you by changing one or more of the above consent.